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...

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...