Create a Summary Sheet

1. Make a copy of the “Eggs” spreadsheet

Right Click the Eggs Tab.

Select Move or Copy.

When the little Options window pops up,

Check to Create a copy.

 

2. Rename the Spreadsheet

Double click the tab.

Type: Summary


3. Edit the Data

Select Cell B2 and type: All Products.

AutoFill Cell B2.

 

Keep going, please...

 

Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

 4.1. Create and format worksheets: Copy and Rename Worksheets