Microsoft Office Tutorials and References
In Depth Information
Correcting Errors
To Use the AutoCalculate Area to Determine a Maximum
The following steps display the largest amounts of funds raised for any city for the Fun Runs fundraising activity.
1
Select the range B6:G6
and then right-click
the AutoCalculate area
on the status bar to
display the Customize
Status Bar shortcut
menu (Figure 1– 72).
Customize Status Bar
shortcut menu
What is displayed on
the Customize Status
Bar shortcut menu?
This shortcut menu
includes several
commands that allow
you to control the
items displayed on the
Customize Status Bar
shortcut menu. The
AutoCalculate area
includes six commands
as well as the result of
the associated calculation
on the right side of the menu.
selected range
is B6:G6
calculated
values appear
on shortcut
menu
AutoCalculate area
Maximum command
Figure 1– 72
AutoCalculate area
on status bar
2
on the shortcut
menu to display the
Maximum value in
the range B6:G6 in the
AutoCalculate area of
the status bar.
Click Maximum
AutoCalculate area
displays maximum
value in range B6:G6
(66,934.67)
Figure 1– 73
Click anywhere on the worksheet to cause the shortcut menu to disappear (Figure 1– 73).
3
Right-click the AutoCalculate area and then click Maximum on the shortcut menu to cause
the Maximum value to no longer appear in the AutoCalculate area.
Click anywhere on the worksheet to cause the shortcut menu to disappear.
Correcting Errors
You can correct errors on a worksheet using one of several methods. The method you
choose will depend on the extent of the error and whether you notice it while typing the
data or after you have entered the incorrect data into the cell.
Correcting Errors While You Are Typing Data into a Cell
If you notice an error while you are typing data into a cell, press the backspace
key to erase the incorrect characters and then type the correct characters. If the error is a
major one, click the Cancel box in the formula bar or press the esc key to erase the entire
entry and then reenter the data from the beginning.
 
Search JabSto ::




Custom Search