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 XXXXXXXXXX
Hollywood Trip XXXXXXXXXX
�1