What-If Analysis, Charting, And Working With Large Worksheets Page 72
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 208
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
Make It Right
Analyze a workbook and correct all errors and/or improve the design.
Inserting Rows, Moving a Range, and Correcting Formulas in a Worksheet
Instructions: Start Excel. Open the workbook Make It Right 3-1 SpeedyOffi Annual
Projected Net Income. 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 for this book.
Correct the following design and formula problems (Figure 3–86a) in the worksheet.
Figure 3 – 86 (a) Before
Figure 3 – 86 (b) After
1. The Shipping Cost in cell C8 is computed using the formula =B2*B8 (Shipping % × Sales). Similar
formulas are used in cells C9, C10, and C11. The formula in cell C8 was entered and copied to cells
C9, C10, and C11. Although the result in cell C8 is correct, the results in cells C9, C10, and C11
are incorrect. Edit the formula in cell C8 by changing cell B2 to an absolute cell reference. Copy
the corrected formula in cell C8 to cells C9, C10, and C11. After completing the copy, click the
Auto Fill Options button arrow that is displayed below and to the right of cell C11 and choose Fill
Without Formatting.
2. The Discount amounts in cells D8, D9, D10, and D11 are computed using the IF function. The
Discount amount should equal the amount in cell B3*B8 (Discount % × Sales) if the corresponding
Sales in column B is greater than or equal to $2,500,000. If the corresponding Sales in column B is
less than $2,500,000, then the Discount amount is 5%*B8 (5% × Sales). The IF function in cell D8
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education