Excel Assignment 1
Create the spreadsheet below. Use Cell Style Accent 1 for the column month headings. All of the column headings in Row 3 should be centered. 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 Highest Monthly Sales 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.
MS Office 2010 Grading Criteria Use specified application features 60% Entered all the information 20% No errors in the information 20%
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. Do not paste your work in the Message area.