Candy Store

When you finish this exercise you should

Entered mixed, absolute and relative references in a computation.
Worked with sums and calculated discounts.

For this exercise we will be creating an order form for a simple candy factory. I started with some data from Dylan's Candy Bar but changed the prices. This is not a standard form. It is designed for this exercise.

Download this file and save it somewhere you can find it.
Start excel and open the file you just saved.
Format the data in the worksheet.
- Adjust column and row widths so that everything is visible.
- Make the labels bold
- Wrap column headings if needed.
- Format the percentages properly in B1:B3
- Format the prices in B6:B16
- Put borders under the column headings and above the totals.
- And anything else I missed to make it look like the picture below.
Compute the discount price for each item.
- This should be based on the item price and the customer discount.
- The customer discount will change, so base it on the value in call B1
- Develop a single formula in C6 which can be copied to C7:C16
- I will look at the formula, it should have a mixed reference.
- DO NOT TYPE IN 11 different formulas.
Compute the Extended price in E6:E16
- This is the discount price multiplied by the quantity.
Compute the amount saved in F6:F16
- This is price * customer discount * quantity
- The customer discount will change, so base it on the value in call B1
- Develop a single formula in F6 which can be copied to F7:F16
- I will look at the formula, it should have a mixed reference.
- DO NOT TYPE IN 11 different formulas.
Compute the tax in G6:G16
- This is Extended price * Tax
- The tax will change, so base it on the value in call B3
- Develop a single formula in G6 which can be copied to G7:G16
- I will look at the formula, it should have a mixed reference.
- DO NOT TYPE IN 11 different formulas.
Calculate the total price n H6:H16
- This is the extended price plus the tax.
Calculate the Commission in I6:I16
- This is Extended price * Salesperson Commission
- The commission will change, so base it on the value in call B2
- Develop a single formula in I6 which can be copied to I7:I16
- I will look at the formula, it should have a mixed reference.
- DO NOT TYPE IN 11 different formulas.
In D17:I17 compute the sum of the column above
- Use the sum function.
Add a new tab.
- Call it multiplication table.
In the new tab, build a multiplication table.
- Create the row and column labels with the fill handle.
- Create a single formula in b3 which you can copy to the entire range b3:k12
  - This will involve mixed reference.
  - Copy the Cell, highlight the range and paste.
  - If it is not right, get help
Save your work
Submit your saved document to the Candy folder in the Assignment section of D2L for this class.