What-If Analysis, Charting, And Working With Large Worksheets Page 66
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 202
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
3
•
Click the OK button
(Goal Seek dialog
box) to goal seek
for the sought-after
value in the ‘To value’
Goal Seek Status
box, $3,000,000.00 in
dialog box
cell H25 in this case
(Figure 3 – 83).
What happens when I
click the OK button?
Excel immediately
Cancel button
changes cell H25
from $2,567,592.65
to the desired value
Support, General,
OK button
of $3,000,000.00.
and Administrative
expenses changes from
six-month projected
More importantly,
18.75% to 17.32%
operating income
Excel changes the
changes from
$2,567,592.65 to
Support, General,
$3,000,000.00
and Administrative
assumption in cell
B8 from 18.75% to
17.32% (Figure 3 – 83).
Excel also displays
the Goal Seek Status
Figure 3 – 83
dialog box. If you click
the OK button, Excel
keeps the new values in the worksheet. If you click the Cancel button,
Excel redisplays the original values.
4
•
Click the Cancel button in the Goal Seek Status dialog box to redisplay the original values in
the worksheet.
Certifi cation
Goal Seeking
The Microsoft Offi ce
Specialist (MOS) program
Goal seeking assumes you can change the value of only one cell referenced directly
provides an opportunity for
or indirectly to reach a specifi c goal for a value in another cell. In this example, to change
you to obtain a valuable
the six-month operating income in cell H25 to $3,000,000.00, the Support, General, and
industry credential — proof
Administrative percentage in cell B8 must decrease by 1.43% from 18.75% to 17.32%.
that you have the Excel
You can see from this goal seeking example that the cell to change (cell B8) does
2010 skills required by
employers. For more
not have to be referenced directly in the formula or function. For example, the six-month
information, visit the
operating income in cell H25 is calculated by the function =SUM(B25:G25). Cell B8 is
Excel 2010 Certifi cation
not referenced in this function. Instead, cell B8 is referenced in the formulas in rows 18
Web page (
through 22, on which the monthly operating incomes in row 25 are based. Excel thus is
ex2010/cert).
capable of goal seeking on the six-month operating income by varying the value for the
Support, General, and Administrative assumption.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education