8
Managing Worksheets
LESSON SKILL MATRIX Skills
Exam Objective
Objective Number
Organizing Worksheets
Copy and move a worksheet Rename a worksheet Change worksheet order Change worksheet tab color Hide or unhide worksheets Add a worksheet to an existing workbook
1.1.4 1.3.2 1.3.3 1.3.1 1.4.1 1.1.3
Using Zoom and Freeze to Change the Onscreen View
Change magnification by using zoom tools Change window views
1.4.7 1.4.5
Finding and Replacing Data
Search for data within a workbook Replace data
1.2.1 2.1.1
SOFTWARE ORIENTATION Worksheet Management Think of an Excel workbook as a collection of the types of things you have previously recorded on paper and stored in a folder that was then filed in a cabinet. A workbook does not have to include the contents of the entire cabinet, just the records that pertain to one subject. Business transactions that take place during a period of time, such as a specific week or month, might make up a workbook. You can divide a workbook into sheets to subcategorize transactions into days, such as the records for a spa. Another option is to have each sheet represent a certain sales department. Excel can also be used for many other purposes besides keeping track of business accounts. In this lesson, you become familiar with how you can manipulate worksheets within a workbook the way you might reorganize the contents of a folder in your desk drawer. You find the commands for this lesson in the Cells group and Editing group, which are both located on the Home tab (Figure 8-1).
115
