WizardWorks - Excel Assignment Chapter 3 Wizard Works...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Assignment Chapter 3 Wizard Works Andrew Howe owns and operates WizardWorks, an online seller of fireworks based in Franklin, Tennessee. Andrew wants you to help him use Excel to develop an order form for his business. The form needs to contain formulas to calculate the charge for each order. The total charge is based on the quantity and type of items ordered plus the shipping charge and the 5% sales tax. Orders can be shipped using standard 3 to 5 day shipping for $4.99 or overnight for $12.99. Andrew is also offering a 3% discount for orders that exceed $200. Both the shipping option and the discount need to be calculated using formulas based on values entered into the worksheet. 1. In A1 Enter Wizard Works 2. In A2 Enter the Address As Shown 3. In B4 Enter Customer, B5 Enter Date, B6 Enter Order No. 4. In B8 Enter Shipping Address 5. In B9 Enter Address1, In B10 Enter Address 2, In B11 Enter City, In B12 Enter State, In B13 Enter Zip 6. In B15 Enter Shipping* 7. In B16 Enter *Enter Standard or Overnight
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/17/2008 for the course MIS 204 taught by Professor Davidp.kitlan,pe during the Spring '08 term at Pennsylvania State University, University Park.

Page1 / 3

WizardWorks - Excel Assignment Chapter 3 Wizard Works...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online