 In cell E5 enter a formula to
display your last name, a comma, and your first name. The formula can
either use the & symbol or the Concatenate
function. Use cell references, not text, for your last name and your first name.

 In cell B10 enter a formula
to find the profit on a single Milky Way candy bar (= price cost.)

 Copy the formula from cell
B10 into cells C10, D10 and E10.

 In cell B14 enter a formula
to find the number of Milky Way candy bars that were sold (Starting
inventory + new inventory  ending inventory.)

 Copy the formula from cell
B14 into cells C14, D14 and E14.

 In cell B15 enter a formula
to show the total profit earned from selling Milky Way candy.

 Copy the formula from cell
B15 into cells C15, D15 and E15.

 In cell F8 enter an AVERAGE
function to find the average sales price. (The average of cells B8, C8,
D8 and E8.)

 Copy the function from cell
F8 into cells F9 and F10.

 In cell F11 enter a SUM
function to find the total number of candy bars on hand at the beginning
of the week. (The sum of cells B11, C11, D11 and E11.)

 Copy the function from cell
F11 into cells F12, F13, F14, and F15.

 In cell B16 enter a formula
to show the profit on Milky Way bars as a percentage of the total
profit. (Divide the profit in cell B15 by the total profit in cell
F15.) Use an absolute cell
reference (using two $ signs as part of the cell reference) for the
denominator.

 Copy the formula from cell
B16 into cells C16, D16 and E16. (If you get the error message #DIV/0,
fix the denominator in the formula in cell B16 and try again.)

 Change the formatting for
cells B16, C16, D16 and E16 to show exactly one decimal place.

 Use the “Merge and Center”
icon to merge cells A18, B18 and C18.

 Apply a thick box border to
the merged cell.

 Add a Green Fill color to the
merged cell.

 Click on cell A20. From the
Data tab on the ribbon, select Data Validation. Add a data validation
list using the items in cells B7, C7, D7 and E7.

 After you have created the
validation list, enter the name of a candy bar into cell A 20.

 In Cell B20, enter an HLOOKUP
function to find the average number of candy bars sold daily for the candy bar selected in cell
A20. The formula will have the syntax =HLOOKUP(Cell,TableRange,RowNumber)/7. (Note replace the
words Cell, TableRange, and RowNumber with values.)

 In cell C20 enter an IF
Function to test if the number of sales in cell B20 is greater than 40.
If the number sold is greater than 40, the function should display
“Good” in cell C20. If the number
sold is not greater than 40, the function should display the word “Bad”
in cell C20.
