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/off2007/learn . When the Ofﬁ ce 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.
Understanding Logical Tests and Absolute Cell Referencing
Instructions Part 1: Determine the truth value (true or false) of the following logical tests, given the
following cell values: X4 = 25; Y3 = 28; K7 = 110; Z2 = 15; and Q9 = 35. Enter true or false.
a. Y3 < X4
Truth value:
b. Q9 = K7
Truth value:
c. X4 + 15 * Z2 / 5 <> K7
Truth value:
d. K7 / Z2 > X4
Y3
Truth value:
e. Q9 * 2
42 < (X4 + Y3
8) / 9
Truth value:
f. K7 + 300 <= X4 * Z2 + 10
Truth value:
g. Q9 + K7 > 2 * (Q9 + 25)
Truth value:
h. Y3 = 4 * (Q9 / 5)
Truth value:
Instructions Part 2: Write cell K23 as a relative reference, absolute reference, mixed reference with the
row varying, and mixed reference with the column varying.
Instructions Part 3: Start Excel. Open the workbook Apply 3-1 Absolute Cell References. See