Microsoft Office Tutorials and References
In Depth Information
Navigating Between Worksheets
By default, a new Excel workbook contains three worksheets, labeled Sheet1, Sheet2, and
Sheet3. Each sheet can be used to display different information. To move from one sheet
to another, click the sheet tabs at the bottom of each sheet.
To move between worksheets:
1. Click the Sheet2 tab. Sheet2, which is blank, appears in the workbook window. Notice that the
Sheet2 tab is now white with the name “Sheet2” in a bold font. This is a visual indicator
that Sheet2 is the active worksheet.
2. Click the Sheet3 tab to move to the next worksheet in the workbook.
3. Click the Sheet1 tab to make it the active worksheet.
Now that you have some basic skills navigating through a worksheet and a workbook,
you can begin work on Sandra’s worksheet.
Developing a Worksheet
Before you begin to enter data in a worksheet, you should think about the purpose of the
worksheet and what will be needed to meet the challenge of that purpose. Effective work-
sheets are well planned and carefully designed. A well-designed worksheet should clearly
identify its overall goal. It should present information in a clear, well-organized format
and include all the data necessary to produce results that address the goal of the applica-
tion. The process of developing a good worksheet includes the following planning and
• Determine the worksheet’s purpose, what it will include, and how it will be organized.
• Enter the data and formulas into the worksheet.
• Test the worksheet, and then edit the worksheet to correct any errors or to make
• Document the worksheet and format the worksheet’s appearance.
• Save and print the complete worksheet.
To develop a worksheet that records orders made at the co-op, Sandra wants to develop
a planning analysis sheet that will help her answer the following questions:
1. What is the goal of the worksheet? This helps to define its purpose or, in other words,
the problem to solve.
2. What are the desired results? This information describes the output—the information
required to help solve the problem.
3. What data is needed to calculate the results you want to see? This information is the
input—data that must be entered.
4. What calculations are needed to produce the desired output? These calculations
specify the formulas used in the worksheet.
After careful consideration of these questions, Sandra has developed the planning analy-
sis sheet shown in Figure 1-7.