Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab continued
Payroll Totals. Change the absolute cell reference $C$11 in the formula bar to the relative cell
reference C11 by deleting the dollar signs. Click immediately after C11 in the formula bar and
then press the COMMA key.
c. Click the Switch Windows button on the View tab on the Ribbon and then click Lab 6-2 Emp
Quarter 2 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
Payroll Totals. Change the absolute cell reference $C$11 in the formula bar to the relative cell
reference C11 by deleting the dollar signs. Click immediately after C11 in the formula bar and
then press the COMMA key.
d. Click the Switch Windows button on the View tab on the Ribbon and then click Lab 6-2 Emp
Quarter 3 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
Payroll Totals. Change the absolute cell reference $C$11 in the formula bar to the relative cell
reference C11 by deleting the dollar signs. Click immediately after C11 in the formula bar and
then press the COMMA key.
e. Click the Switch Windows button on the View tab on the Ribbon and then click Lab 6-2 Emp
Quarter 4 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
Payroll Totals. Change the absolute cell reference $C$11 in the formula bar to the relative cell
reference C11 by deleting the dollar signs. Press the ENTER key to sum the four quarter hours
worked. You should end up with an annual total of 653.75 hours worked in cell B11.
f. With the workbook Lab 6-2 Part 1 Emp Annual Payroll Totals window active, select cell B11.
Drag the fi ll handle through cell C11 to display the annual gross pay in cell C11. Select the
range B11:C11. Drag the fi ll handle down to cell C14. When the Auto Fill Options button is
displayed next to cell C14, click the Auto Fill Options button and then click the Fill Without
Formatting option. The totals in row 15 should be exactly the same as the totals in row 15 in the
lower fi gure of Figure 6–90 on page EX 493.
6. Change the document properties as specifi ed by your instructor. Change the worksheet header
with your name, course number, and other information requested by your instructor. Preview and
print the annual payroll totals. Save the workbook using the fi le name, Lab 6-2 Part 1 Emp Annual
Payroll Totals. Close all workbooks. Submit the assignment as specifi ed by your instructor.
Instructions Part 2: Perform the following tasks to update the hours worked for Quarter 2 and Quarter 4.
1. Start Excel. Open Lab 6-2 Emp Quarter 2 Payroll Totals from the Data Files for Students. Change
the hours worked for employee K457 in row 12 from 123.00 to 223.25. Save the workbook using
the fi le name, Lab 6-2 Emp Quarter 2 Payroll Totals. Close the workbook.
2. Open Lab 6-2 Emp Quarter 4 Payroll Totals. Change the hours worked for employee M235 in row
13 from 189.00 to 211.00. Save the workbook using the fi le name, Lab 6-2 Emp Quarter 4 Payroll
Totals. Close the workbook.
3. Open Lab 6-2 Part 1 Emp Annual Payroll Totals workbook saved earlier in Part 1 of this exercise.
Save the workbook using the fi le name, Lab 6-2 Part 2 Emp Annual Payroll Totals. Click the Data
tab on the Ribbon. Click the Edit Links button in the Connections group on the Data tab. Select
each fi le in the Edit Links dialog box and then click the Update Values button to instruct Excel to
apply the current values in the four source workbooks to the consolidated workbook (Figure 6–95).
4. Preview and print the consolidated workbook. Save the workbook. Submit the assignment as
specifi ed by your instructor.
 
Search JabSto ::




Custom Search