PERMANENT SANDBOX
Lesson 8 - Working with multiple worksheets
Skip To Content
Dashboard
  • Login
  • Dashboard
  • Calendar
  • Inbox
  • History
  • Help
Close
  • My Dashboard
  • PERMANENT SANDBOX
  • Assignments
  • Lesson 8 - Working with multiple worksheets
Teacher Sandbox
  • Home
  • Modules
  • Google Drive
  • Office 365
  • Class Notebook
  • Lucid (Whiteboard)

Lesson 8 - Working with multiple worksheets

  • Due No Due Date
  • Points 100
  • Submitting a file upload

Watch the following video:

Excel: Working with Multiple Worksheets Links to an external site.Excel: Working with Multiple Worksheets

Excel Quick Tip: Jump to Any Sheet with a Shortcut Links to an external site.Excel Quick Tip: Jump to Any Sheet with a Shortcut

 

Complete and submit the following assignment:

1. Open the following document: excel2016_multiplesheets_practice_L8.xlsx Download excel2016_multiplesheets_practice_L8.xlsx


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 that 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.
When you're finished, your workbook should look something like this:

0
Please include a description
Additional Comments:
Rating max score to > pts
Please include a rating title

Rubric

Find Rubric
Please include a title
Find a Rubric
Title
You've already rated students with this rubric. Any major changes could affect their assessment results.
 
 
 
 
 
 
 
     
Can't change a rubric once you've started using it.  
Title
Criteria Ratings Pts
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
Total Points: 5 out of 5