Excel Assignment 1 Create the spreadsheet below. Use Cell Style Accent 1 for the

ID: 3641306 • Letter: E

Question

Excel Assignment 1

Create the spreadsheet below.
Use Cell Style Accent 1 for the column month headings.
All of the column headings except Customer are centered within the cell.
Use Heading 4 style for the row labels.
Use Heading 3 style for the headings:
Total Customer Sales
Percentage of Total Semiannual Sales
Total Semiannual Sales
Use the appropriate functions to get:
Total Monthly Sales
Monthly Average
Lowest Monthly Sales
Total Customer Sales
Total Semiannual Sales
Use a formula to calculate the percentage; you will need to use an absolute cell reference for the formula.
Format the percentages as percentages.
Change the name on the spreadsheet tab to Grade Book.
Save the file.

Change the March sales of Genesis Productions from 79,334 to 62.105, the May sales of Gresham Machines from 40,390 to 52,128, and the February sales of Landower Company from 19,355 to 21,210. Save you work again using a slightly different file name. If you use the same file name as you used the first time, you will save over it and lose the original file. Submit both files.