Cairn Camping Supplies Diane Cho is the oner of Cairn Camping Supplies, a small camping store she runs out of her home in Fort Smith, Arkansas. To help her manage her inventory and orders, she wants to develop an Excel worksheet for recording orders. The worksheet needs to calculate the cost of each order, including the cost of shipping and sales tax. Shipping costs vary based on whether the customer wants to use standard, three-day, two-day, or overnight shipping. Diane will also offer free shipping for orders that are more than $250. The shipping form worksheet will use lookup functions so that Diane can enter each product’s ID code and have the name and price of the product automatically entered into the form. To keep the worksheet clean without distracting error values when no input values have been entered, you’ll use IF functions to test whether the user has entered a required value ﬁrst before applying a formula using that value. Complete the following:
1.Open the Cairn workbook located in the Excel3 > Case4 folder, and then save the workbook as Cairn Campaign in the location speciﬁed by your instructor.
2.In the Documentation worksheet, enter your name in cell B3 and the date in cell B4.