Microsoft Office Tutorials and References
In Depth Information
Learn It Online
Learn It Online
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/ex2010/learn . When the Excel 2010 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
chapter content.
Who Wants To Be a Computer Genius?
An interactive game that challenges your knowledge
of chapter content in the style of a television
quiz show.
Flash Cards
An interactive learning environment where
you identify chapter key terms associated with
displayed dei 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 .
Practice Test
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.
Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.
Changing the Values in a Worksheet
Instructions: Start Excel. Open the workbook Apply 1– 1 Clothes Campus Third Quarter Expenses
(Figure 1– 76a). See the inside back cover of this topic for instructions for downloading the Data Files
for Students, or see your instructor for information on accessing the i les required in this topic.
1. Make the changes to the worksheet described in Table 1– 6 so that the worksheet appears as shown
in Figure 1– 76b. As you edit the values in the cells containing numeric data, watch the totals in
row 7, the totals in column F, and the chart change.
2. Change the worksheet title in cell A1 to the Title cell style and then merge and center it across
columns A through F. Use buttons in the Font group on the Home tab on the Ribbon to change
the worksheet subtitle in cell A2 to 16-point Cambria red, bold font and then center it across
columns A through F. Use the Red, Accent 2
theme color (column 6, row 1 on the Font
gallery) for the red font color.
3. Apply the worksheet name, Third Quarter
Expenses, to the sheet tab and apply the Red,
Accent 2 theme color to the sheet tab.
4. Change the document properties as specii ed
by your instructor. Save the workbook using
the i le name, Apply 1– 1 Clothed for Campus
Third Quarter Expenses. Submit the revised
workbook as specii ed by your instructor.
Table 1– 6 New Worksheet Data
Cell
Change Cell Contents To
A1
Clothed for Campus
B4
7829.50
C4
19057.83
D5
24217.92
E5
25859.62
E6
35140.84
 
Search JabSto ::




Custom Search