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.
You've reached the end of your free preview.
Want to read both pages?