Excel Basic 2(1) 1. Fill in total sales for each product using a function 2. Fill in total sales using a function 3. Figure out each product's % of total sales, using auto fill, don't forget to format...

1 answer below »
i have attached the 4 assignments. They need to be done precisely. All these directions are for the record sales project under the attached excel 1 basic assignment.


Excel Basic 2(1) 1. Fill in total sales for each product using a function 2. Fill in total sales using a function 3. Figure out each product's % of total sales, using auto fill, don't forget to format so it is a percentage 4. Look at the formula in cell E5, which is the relative reference, which is the absolute? Write this answer in Cell E6. 5. Create a pie chart showing the % of total sales for each product 6. Figure out the average total sale 7. Look at the chart and pie graph. Figure out what additional formatting changes you can do to make it more easy to read and present the info (hint $$$) 8. Put pie chart on own sheet - color code it 9. Do you have a header? 10. Do you have columns? �1 Product Quanity Sold Price Bruins Party 54 550 The Taylor Swift Experience 63 2000 Hollywood Trip 32 5600 �1
excel-basic-21-pvkgxv5i.pdf excel-basic-31-k1zmbnrs.pdf excel-basic-41-mlhjgwud.pdf
Answered Same DayApr 21, 2021

Answer To: Excel Basic 2(1) 1. Fill in total sales for each product using a function 2. Fill in total sales...

Nakul answered on Apr 25 2021
150 Votes
Assignment 1
    Record Store- Monthly Sales
    Stock Item    Number Sold    Retail Price    Total Sales    % of Total
    John Mayer    5203    $ 12.99    $ 67,586.97    31.30%
    Dave Matthews Band    5622    $ 11.99    $ 67,407.78    31.22%
    Wu Tang Clan    6230    $ 12.99    $ 80,927.70    37.48%
    Total    17055    $ 37.97    $ 215,922.45    100.00%
Ques 4. Formula in E5 is =D5/$D$6. In this formula D5 is a relative value while $D$6 is an absolute value.
Ques 5. For retail price and total sales, currency i.e. $ should be used to make it look profession. For % of total sales, % should be used for better presentation of the data.
Assignment 2
    Total Sales
    Product     Quantity Sold    Price    Total Sales    % of Total Sales
    Bruins Party    54    $ 550.00    $ 29,700.00    8.87%
    The Taylor Swift Experience    63    $ 2,000.00    $ 126,000.00    37.62%
    Hollywood Trip    32    $ 5,600.00    $ 179,200.00    53.51%
    Total    149    -    $ 334,900.00    100.00%
    Average    $ 49.67    $ 2,716.67    $ 111,633.33
Product Sales        
Ques 4 . Formula in E5 is =D5/$D$6. In this formula D5 is a relative...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?