What-If Analysis, Charting, And Working With Large Worksheets Page 69
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
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 205
Perform the following tasks:
1. Enter a formula in cell C7 that multiplies the sum of cells C3 through C6 times cell C2. Write the
formula so that when you copy it to cells D7 and E7, Excel adjusts all the cell references according
to the destination cells. Verify your formula by checking it with the values found in cells C7, D7,
and E7 in Figure 3–84.
2. Enter a formula in cell F3 that multiplies cell B3 times the sum of cells C3 through E3. Write
the formula so that when you copy the formula to cells F4, F5, and F6, Excel adjusts all the cell
references according to the destination cells. Verify your formula by checking it with the values
found in cells F3, F4, F5, and F6 in Figure 3–84.
3. Enter a formula in cell C8 that multiplies the sum of cells C3 through C6 times cell C2. Write the
formula so that when you copy the formula to cells D8 and E8, cell C2 remains absolute. Verify
your formula by checking it with the values found in cells C8, D8, and E8 in Figure 3–84.
4. Enter a formula in cell G3 that multiplies the sum of cells C3, D3, and E3 times cell B3. Write the
formula so that when you copy the formula to cells G4, G5, and G6, cell B3 remains absolute. Verify
your formula by checking it with the values found in cells G3, G4, G5, and G6 in Figure 3–84.
5. Apply the worksheet name, Cell References, to the sheet tab and apply the Red, Accent 2 theme
color to the sheet tab.
6. Change the document properties, as specifi ed by your instructor. Change the worksheet header
with your name, course number, and other information as specifi ed by your instructor. Save the
workbook using the fi le name, Apply 3-1 Absolute Cell References Complete, and submit the
workbook as requested by your instructor.
Figure 3 – 84
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education