Microsoft Office Tutorials and References
In Depth Information
EX 70
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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/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
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 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 .
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.
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 Bicycle Shop 3rd Quarter Sales (Figure 1–99a).
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 ﬁ 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–99b. As you edit the values in the cells containing numeric data, watch the totals in
row 8, the totals in column G, 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 G. Use commands in the Font group on the Home tab on the Ribbon to change
the worksheet subtitle in cell A2 to 16-point Corbel red, bold font and then center it across columns A
through G. Use the Accent 1 theme color (column 5, row 1 on the Font palette) for the red font color.
3. Update the document
course number, and name
for the workbook. Save the
workbook using the ﬁ le name,
Apply 1-1 Spoke-Up Bicycle
Shop 3rd Quarter Sales.
Submit the assignment as
Table 1–6 New Worksheet Data
Cell
Change Cell Contents To
A1
Spoke-Up Bicycle Shop
B4
11869.2
E4
9157.83
D6
5217.92
F6
6239.46
B7
3437.64

Search JabSto ::

Custom Search