What-If Analysis, Charting, And Working With Large Worksheets Page 68
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 204
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
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 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
Who Wants To Be a Computer Genius?
A series of true/false, multiple choice, and short
An interactive game that challenges your knowledge
answer questions that test your knowledge of the
of chapter content in the style of a television
chapter content.
quiz show.
Flash Cards
Wheel of Terms
An interactive learning environment where
An interactive game that challenges your knowledge
you identify chapter key terms associated with
of chapter key terms in the style of the television
displayed defi nitions.
show Wheel of Fortune.
Practice Test
Crossword Puzzle Challenge
A series of multiple choice questions that test your
A crossword puzzle that challenges your knowledge
knowledge of chapter content and key terms.
of key terms presented in the chapter.
Apply Your Knowledge
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: B4 = 30; W3 = 100; H5 = 32; L2 = 25; and M8 = 15. Enter true or false.
a. M8 > B4
Truth value: ___________________________
b. W3 = L2
Truth value: ___________________________
c. L2 + 15 * B4 / 10 <> W3
Truth value: ___________________________
d. H5 – L2 < B4 / M8
Truth value: ___________________________
e. (M8 + B4) * 2 <> W3 – (M8 / 3) * 2
Truth value: ___________________________
f. M8 + 300 > B4 * H5 + 10
Truth value: ___________________________
g. H5 * L2 >= 2 * (W3 + 25)
Truth value: ___________________________
h. B4 = 10 * (M8 / 5)
Truth value: ___________________________
Instructions Part 2: Write cell J49 as a relative reference, absolute reference, mixed reference with the
column varying, and mixed reference with the row varying.
______________
______________
______________
______________
Instructions Part 3: Start Excel. Open the workbook Apply 3-1 Absolute Cell References. See the
inside back cover of this book for instructions for downloading the Data Files for Students, or see your
instructor for information on accessing the fi les required in this book. You will re-create the numerical
grid pictured in Figure 3–84.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education