Excel_Performance_Test_Updated_Instructions.docx - Office 2016 \u2013 myitlab:grader \u2013 Instructions Excel Project Excel Performance Test Updated Project

Excel_Performance_Test_Updated_Instructions.docx - Office...

This preview shows page 1 - 2 out of 2 pages.

Office 2016 – myitlab:grader – InstructionsExcel ProjectExcel Performance Test UpdatedProject Description: In this project, you will work with grouped worksheets, insert and rename worksheets, insert summary, statistical, and Date functions, and refer to cells in other worksheets. Instructions: For the purpose of grading the project you are required to perform the following tasks: StepInstructionsPointsPossible1Start Excel 2016. Download and open the file sk16_xl_ch1-4_grader_cap_as.xlsx. Save the file as Last_First_sk16_xl_ch1-4_grader_cap_as.02Group the worksheets. Adjust the column width of B:E to 8.5. Center and Wrap the text in the range B3:F3.3.753Ungroup the worksheets, and then group the four location sheets, except for Inventory. In the Item Total column, insert a function that will sum Quarters 1 - 4. Insert a function in Row 13 to total each column. Apply the Total Cell style to the Quarter Total results.
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture