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

The Answer is in the image, click to view ...

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

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)

Product Store. It depicts the amount of sales (in dollar value) that

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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 we have an example of a spreadsheet for a Jason's Cleaning Product Store. It depicts the amount of sales (in dollar value) that we have pe Type of cleaning item Jason's Cleaning Product Store D...

Snyder Company manufactures large metal widgets. The standard direct materials quantity required to produce one widget is 3 pounds at a cost of $5 per pound. Every widget requires 8 direct labor...

Hey I have an audit case that I was wondering if you can help me with. You have helped me in the past. I was hoping if 25 would be fine. Please let me know. I have uploaded the files that are...

here is the example please answer Question 1 & 2 and here is the example mentioned Perform allocation of flows to co-products from unallocated data. 1. Using the fruit truck allocation example from...

Can someone do 5-11 in the Internal Audit program file( some parts may have errors) to do this you will need to use the case appendix D to answer the questions also please answer one of the questions...

I think its only fair to write up all the alternatives youve considered, says Lou Cite, a personnel supervisor for Day-Glow Paints. After all, youve been working on this systems thing for a while...

Explain the nature of hunger in the world today. How much should we worry about hunger increasing? Why?

1. Consider the two options in the following table, both of which have random outcomes: (LO1) Option 1 Option 2 Probability of Outcome Possible Outcomes ($) Probability of Outcome Possible Outcomes...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

years, obesity rates have increased sharply for high-school dropouts and for people with only high-school degrees. Rates for college graduates, however, have remained flat.

Over the past

While obesity generally results in higher per-year medical costs, obese individuals do not typically have higher average lifetime medical costs than non-obese individuals because they do not live as...