Spreadsheet Assignment #7

You are the manager of a pizza restaurant and is your job to track the sales. On March 4 your store sold $250 in pepperoni pizza, $195.45 in sausage pizza, $467.14 cheese, and$578.38 in other types; on March 13 you sold $345.67 pepperoni, $234.09 in sausage, $341.56 in cheese and $409.56 in other; March 20 you sold $567.89 pepperoni, $432.78sausage, $354.98 cheese,and $688.49 in other; on March 27 you sold $453.28 in pepperoni, $512.88 sausage, $876.39 cheese, and $795.01 in other. What is the total salefor each day, each type of pizza, and total sales? What is the percent each type of pizza sold? Please create a graph to show your percentages.

Your assignment should reflect the understanding of:

• Cell merging

• Adding borders

• Using the alignment buttons

• Creating a chart and graphs

• Manipulating font