Microsoft Office Tutorials and References
In Depth Information
What-If Analysis
EX 223
Click the Split button to divide the
window into four panes.
Use the scroll arrows to show the
four corners of the worksheet at
the same time (Figure 3–77).
What is shown in the four panes?
The four panes in Figure 3–77 are
used to show the following:
(1) range A1:C6 in the
upper-left pane;
(2) range G1:I6
in the
upperright pane;
(3) range A14:C26
in the lower-left
pane; and (4) range G14:I26 in
the lower-right pane. The
vertical split bar is the vertical bar
going up and down the middle of
the window. The horizontal split
bar is the horizontal bar going
across the middle of the window.
If you use the scroll bars below
the window and to the right of
the window to scroll the window,
you will see that the panes split by
the horizontal split bar scroll together
vertically. The panes split by the vertical split bar scroll together horizontally. To resize the
panes, drag either split bar to the desired location in the window.
vertical split bar
split bar
scroll bars
for top and
bottom panes
upper panes
move in vertical
lower panes
move in vertical
scroll bars
for left and
right panes
left panes move
in horizontal
right panes move
in horizontal
Figure 3–77
Other Ways
1. Drag horizontal split
box and vertical split
box to desired locations
To Remove the Panes from the Window
1 Position the mouse pointer at the intersection of the horizontal and vertical split bars.
2 When the mouse pointer changes to a four-headed arrow, double-click to remove the four
panes from the window.
Window Panes
If you want to split the
window into two panes,
rather than four, drag the
vertical split box to the
far left of the window or
horizontal split box to the
top of the window (Figure
3-78 on the next page).
You also can drag the
center of the four panes
in any direction to change
the size of the panes.
What-If Analysis
The automatic recalculation feature of Excel is a powerful tool that can be used to analyze
worksheet data. Using Excel to scrutinize the impact of changing values in cells that are
referenced by a formula in another cell is called what-if analysis or sensitivity analysis .
When new data is entered, Excel not only recalculates all formulas in a worksheet, but
also redraws any associated charts.
Search JabSto ::

Custom Search