ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Excel Lesson 1: Cell Referencing
3
4
Practice Scenario #1a
5
6
2
7
4
8
9
Add cells C6 and C7 together.
10
11
12
Practice Scenario #1b
13
14
Change the number in cell C7 to 10 and watch how your cell-referenced output in cell C9 changes.
15
16
17
Practice Scenario #1c
18
19
5
20
1
21
22
Subtract cell C20 from cell C19.
23
24
25
Practice Scenario #1d
26
27
8
28
7
29
30
Multiply cells C27 and C28 together.
31
32
33
Practice Scenario #1e
34
35
10
36
6
37
38
Divide cell C35 by cell C36.
39
40
41
Practice Scenario #1f
42
43
Reformat cell C38 to two decimal places.
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100