Instructions:
Part 1: Formatting

1. Adjust the column width of:    B and C to 19
                                                    D to I to 15

2. Adjust the row height of row 8 to a height of 33 and rows 9 to 15 to a height of 27

3. Select the cells A8 to I8 and make the text Bold. Use the fill bucket to change the colour to White background, darker 15%

4. Select the cells B9 to I15 and give these a Centre Alignment

5. Adjust the row height of row 17 to a height of 30

6. Select the cells H17 to I17 and place a Thick Outside border around them

Part 2: Formulas

You tell Excel that you want it to do a calculation or to use a function by starting with an equals symbol (=) before typing the formula. The basic mathematical operators in Excel are:

Add                        +
Subtract               -
Multiply               *
Divide                   /

7. Calculate the number of items sold. Click in cell D9 and type in the following formula     =B9-C9   and press return. Now click back in cell D9, left click on the fill handle and drag down to D15. The formula is replicated down the cells.

8. Calculate the % Sales for each item.

As a mathematical sum, this would be                    Number sold    x 100
                                                                                Number of Original Stock

In Excel, this becomes a very simple formula to write if we change the format of the cells from General to Percentage first. By doing this Excel automatically multiplies the division result by 100.

So, select the cells E9 to E15. On the Ribbon in the Number group, click on the drop down beside the box with the title General in it and choose Percentage.

9. Now, click back into cell E9 and type the formula    =D9/B9   and press return. Now click back in cell E9, left click on the fill handle and drag down to D15. The formula is replicated down the cells.

10. Reduce the number of decimal places from 2 to zero.  Select the cells from E9 to E15. On the Ribbon in the Number group, click on the decrease decimal button TWICE.

11. Calculate the difference in sales between 2019 and 2018. Click in cell G9 and type the formula
      =E9-F9  and press return. Now click back in cell G9, left click on the fill handle and drag down to G15. The formula is replicated down the cells.

12. Calculate the total income from the sales. Click in cell I9 and type the formula    =D9*H9   and press return. Now click back in cell I9, left click on the fill handle and drag down to I15. The formula is replicated down the cells.

13 Calculate the total sales income for 2019. Click in cell I17 and type in the formula   =SUM(I9:I15) and press return.

 Part 3: Conditional Formatting

We now want to the sales data to be highlighted in green if the % sales in 2019 is greater (better) than in 2018 and to highlight in red if the % Sales in 2019 is less than (worse) than in 2018. To do this we tell Excel to use Conditional Formatting.

14. Select the cells G9 to G15. On the Ribbon in the Styles group, click on the drop down beside the Conditional Formatting button. Click on Highlight Cell Rules and from the menu that appears choose Less Than. Type in 0 in the box, do not change the formatting suggestion (light red fill with dark red text) and click OK.

15. With cell G9 to G15 still selected, click again on the drop down beside the Conditional Formatting button. Click again on Highlight Cell rules but this time choose Greater Than. Type in 0 in the box, but now change the formatting suggestion to Green fill with Dark Green text (click the drop down to see the choices) and click OK.