Microsoft Office Tutorials and References
In Depth Information
Learn It Online
Learn It Online is a series of online student exercises that test your knowledge of chapter
content and key terms.
Instructions: To complete the Learn It Online exercises, start your browser, click the Address bar, and
then enter the Web address scsite.com/ex2007/learn . When the Excel 2007 Learn It Online
page is displayed, click the link for the exercise you want to complete and then read the instructions.
Chapter Reinforcement TF, MC, and SA
A series of true/false, multiple choice, and short
answer questions that test your knowledge of the
Who Wants To Be a Computer Genius?
An interactive game that challenges your knowledge
of chapter content in the style of a television
An interactive learning environment where
you identify chapter key terms associated with
displayed deﬁ nitions.
Wheel of Terms
An interactive game that challenges your
knowledge of chapter key terms in the style of the
television show Wheel of Fortune .
A series of multiple choice questions that test your
knowledge of chapter content and key terms.
Crossword Puzzle Challenge
A crossword puzzle that challenges your knowledge
of key terms presented in the chapter.
Reinforce the skills and apply the concepts you learned in this chapter.
Consolidating Data in a Workbook
Instructions: Follow the steps below to consolidate the four quarterly payroll sheets on the Annual
Totals sheet in the workbook Apply 6-1 Annual Payroll Totals (Figure 6–90). At the conclusion of the
instructions, the Annual Payroll Totals sheet should display as shown in the lower screen in Figure 6–90.
Perform the following tasks.
1. Start Excel. Open the workbook Apply 6-1 Annual Payroll Totals from the Data Files for Students
and then save the workbook as Apply 6-1 Annual Payroll Totals Complete. 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 ﬁ les required in this topic. One by one, click the ﬁ rst four tabs
and review the quarterly payroll totals. Click the Annual Totals tab.
2. Determine the annual payroll totals on the Annual Totals sheet by using the SUM function and
3-D references to sum the hours worked on the four quarterly sheets in cell B11. Do the same to
determine the annual gross pay in cell C11. Copy the range B11:C11 to the range B12:C14 by
using the Copy button on the Home tab on the Ribbon and the Formulas command on the Paste
button menu on the Home tab on the Ribbon.
3. Change the document properties as speciﬁ ed by your instructor. Select all ﬁ ve worksheets.
Add a worksheet header with your name, course number, and other information requested by your
instructor. Add the page number and total number of pages to the footer. Center all worksheets
horizontally on the page and print without gridlines. Preview and print the ﬁ ve worksheets. Click
the Annual Totals tab to select the sheet.
4. Save the workbook with the new page setup. Close the workbook.
5. Submit the assignment as speciﬁ ed by your instructor.