Microsoft Office Tutorials and References
In Depth Information
Selecting a Cell
AutoCorrect
The AutoCorrect feature of Excel works behind the scenes, correcting
common mistakes when you complete a text entry in a cell. AutoCorrect makes three
types of corrections for you:
1. Corrects two initial uppercase letters by changing the second letter to lowercase.
2. Capitalizes the rst letter in the names of days.
3. Replaces commonly misspelled words with their correct spelling. For example,
it will change the misspelled word recieve to receive when you complete the entry.
AutoCorrect will correct the spelling of hundreds of commonly misspelled
words automatically.
BTW
The Ribbon and
Screen Resolution
Excel may change how the
groups and buttons within
the groups appear on the
ribbon, depending on the
computer’s screen resolution.
Thus, your ribbon may look
different from the ones in
this topic if you are using a
screen resolution other than
1366 3 768.
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Enter Column Titles
The column titles in row 3 shown in Figure 1– 4 (Income, January, February, March, April, May, June,
July, August, September, October, November, December, and Total) identify the numbers in each column in the
rst part of the worksheet. The column titles in row 8 (Expenses, January, February, March, April, May, June,
July, August, September, October, November, December, and Total) identify the numbers in each column in the
second part of the worksheet. In the case of the Personal Budget Worksheet data, the month names identify the
estimates for the budget for each month using the income or expense type, depending on which part you are
reviewing.
To enter the column titles in row 3, select the appropriate cell and then enter the text. The following steps
enter the column titles in row 3. Why? Data entered in columns should be identied using column titles to identify what
the column contains.
1
Tap or click cell A3
to make it the active
cell.
Type Income to
begin entry of a
column title in
the active cell
(Figure 1–9).
active cell
reference in Name
box changes to A3
Income displayed
in formula bar
and cell A3
What is the vertical
line in cell A1?
The text in cell A1
is followed by the
insertion point. The
insertion point is
a blinking vertical
line that indicates
where the next
typed character will
appear.
insertion point
cell A3 is
active cell
Figure 1– 9
 
Search JabSto ::




Custom Search