Microsoft Office Tutorials and References
In Depth Information
In the Lab
3. Use the Find & Select button on the Home tab on the Ribbon to list all occurrences of the word,
Sales, in the workbook. Use the Find All button in the Find and Replace dialog box. Write down
the number of occurrences and the cell locations of the word Sales.
4. Repeat Step 3, but fi nd only cells that match exactly the word Sales. If necessary, click the
Options button to display the desired check box. Use the Find & Select button to fi nd all occur-
rences of the word Sales. Write down the number of occurrences and the cell locations that match
exactly with the word Sales.
5. Use the Find & Select button to fi nd all occurrences of the word, sales, in bold white font. For
this fi nd operation, clear the check mark from the Match entire cell contents check box.
6. Use the Replace command to replace the word, Sales, with the word, Revenue, on all four
sheets. Print the four sheets. Close the workbook without saving changes.
7. Submit the assignment as specifi ed by your instructor.
In the Lab
Lab 2: Consolidating Data by Linking Workbooks
Problem: The Apply Your Knowledge exercise in this chapter calls for consolidating the Hours Worked
and Gross Pay from four worksheets on a fi fth worksheet in the same workbook (see Figure 6–90 on
page EX 493). This exercise takes the same data stored in four separate workbooks and consolidates the
Hours Worked and Gross Pay by linking to a fi fth workbook.
Instructions Part 1: Perform the following tasks.
1. Start Excel. Open the following fi ve fi les from the Data Files for Students. See the inside back
cover of this topic for instructions for downloading the Data Files for Students or see your instruc-
tor for information on accessing the fi les required in this topic. You can open them one at a time or
you can open them all at one time by selecting the fi ve fi les and then clicking the Open button.
• Lab 6-2 Emp Annual Payroll Totals
• Lab 6-2 Emp Quarter 1 Payroll Totals
• Lab 6-2 Emp Quarter 2 Payroll Totals
• Lab 6-2 Emp Quarter 3 Payroll Totals
• Lab 6-2 Emp Quarter 4 Payroll Totals
2. Click the Switch Windows button on the View tab on the Ribbon and then click Lab 6-2 Emp
Annual Payroll Totals.
3. Click the Save Workspace button on the View tab on the Ribbon. When the Save Workspace
dialog box is displayed, save the workspace using the fi le name, Lab 6-2 Emp Payroll Workspace.
4. Close all the open workbooks. Open the workspace Lab 6-2 Emp Payroll Workspace. When the
Lab 6-2 Emp Annual Payroll Totals window is displayed, click the Maximize button in the upper-
right corner to maximize the window. Save the workbook using the fi le name, Lab 6-2 Part 1 Emp
Annual Payroll Totals.
5. Consolidate the data in the four quarterly payroll workbooks into the range B11:C14 in the
workbook Lab 6-2 Part 1 Emp Annual Payroll Totals by doing the following:
a. Click cell B11. Click the Home tab on the Ribbon and then click Sum button.
b. Click the Switch Windows button on the View tab on the Ribbon and then click Lab 6-2 Emp
Quarter 1 Payroll Totals. When the workbook is displayed, click cell C11, click the Switch
Windows button on the View tab on the Ribbon, and then click Lab 6-2 Part 1 Emp Annual
Continued >
 
Search JabSto ::




Custom Search