Assignment: Navigating within an Excel Workbook

/in /by

Read this tutorial (Links to an external site.)Links to an external site. that shows how to work with multiple worksheets in an Excel workbook.

Then download the workbook data file (“practice workbook” on tutorial page) and complete the assignment:

  1. Open the workbook.
  2. Insert a new worksheet and rename it Q1 Summary.
  3. Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so it is between March and April.
  4. Create a copy of the Expenses Summary worksheet by right-clicking the tab. Do not just copy and paste the content of the worksheet into a new worksheet.
  5. Change the color of the January tab to blue and the color of the February tab to red.
  6. Group the worksheets September, October, and November.
  7. Save the workbook with your last name, first name, and file name as follows: last_first_excelmultipleworksheet