Below we have an example of a spreadsheet for a Jasons Cleaning Product Store. It depicts the amount of sales (in dollar value) that we have per type of cleaning item.

Answer The Four Questions Below, Label Each Question Clearly.

1. [4 marks]

a) Write a concise formula for calculating the average displayed in cell F4 in the above spreadsheet. (Hint. Use the pre-defined function). State in words the meaning of the average displayed in cell F4.

b) Write a concise formula for calculating the Total displayed in cell B15 in the above spreadsheet. (Hint. Use the pre-defined function). State in words the meaning of the total displayed in cell B15.

2. [3 marks] Explain how we can fix the cells formatting in the spreadsheet so that the data will be aesthetically pleasing.

3. [4 marks] Below is an incomplete chart for the Average Sales per month. State what labels you would use for the:

a) Chart Title

b) Category(X) axis:

c) Value (Y) axis:

d) Series 1 (Legend)

4. [4 marks] Explain absolute and mixed cell addressing in relation to copying formulas in an MS Excel spreadsheet. Give an example for each of these forms of addressing.

B D E G F Jason's Cleaning Product Store 1 2. 3 January 4 February 5 March 6 April 7 May 8 June 9 July 10 August 11 September 12 October 13 November 14 December 15 Total Dishwashing Multipurp Bug Liquid Average per Bleach ose Spra Toilet Detergent month Cleaner y Cleaner 5763 5200 6512.19 3600 5900 $5,395.04 1695 2900 1915.35 1890 2800 $2,240.07 282.5 600 319.225 320 300 $364.35 1017 1100 1149.21 480 ###### $1,169.24 5085 $ 3,800.00 5746.05 1000 3300 $3,786.21 2486 4200 2809.18 2580 ###### $3,275.04 6441 5100 7278.33 ## 11400 $6,573.87 56.5 120 63.845 120 200 $112.07 678 700 766.14 740 700 $716.83 5085 900 5746.05 450 550 $2,546.21 203.4 280 229.842 180 320 $242.65 150 540 190 80 450 $282.00 28942.4 25440 32725.412 14090 32320 $7,000.00 $6,000.00 Plot Area $5,000.00 $4,000.00 -Series 1 $3,000.00 $2,000.00 $1,000.00 $0.00 1 2 3 4 5 6 7 8 9 10 11 12 13 14