Microsoft Excel: Spell Check

1
Microsoft Excel Spell Check
When using a computer there isnt any excuse for
spelling errors. However, if you look closely,
you might find a misspelled word in this list of
animals
2
Microsoft Excel Spell Check
Spell check is launched from the Tools menu
To run spell check go to the Tools menu and
choose Spelling. Checking will begin from the
selected cell and will bring up a dialog box if
it finds a misspelled word
3
Microsoft Excel Spell Check
Verify it is the word you want
Select Change to correct the error
Generally, the suggested word is the correct
word, but it doesnt hurt to check before
clicking the change button
4
Microsoft Excel Spell Check
All the words in the list are now spelled
correctly
5
Microsoft Excel Formulas
Totals
Percents
Convert a percentage to a letter grade (although
somewhat complicated)
Averages
Formulas enable mathematical operations to be
performed within the spreadsheet. Totals,
percentages, averages, and grade calculations are
just a few of the operations available.
6
Microsoft Excel Formulas
Cell F3 is selected
The formula is in the formula bar while the total
is in Cell F3
Formulas start with the symbol. Typing
(B3C3D3E3) into the cell F3 results in the
total points for Wolfgang. Another way to do this
is to use the sum function sum(B3E3)
7
Microsoft Excel Formulas
Cell G3 is selected and shows the percentage
The formula is displayed in the formula bar
Typing F3/F2 into Cell G3 and formatting the
cell to be a percentage with 0 decimal places)
calculates Wolfgangs percentage.
8
Microsoft Excel Formulas
Notice the dollar signs in the formula
They force the divisor to always be Cell F2
F3/F2 The dollar signs in the formula mandate
that the divisor always be taken from column F
and row 2 which is the location of the total
possible points.
9
Microsoft Excel Formulas
Calculate the average in Cell B23 with formula in
the formula bar
AVERAGE(B3B22) is the formula used in Cell B23
to calculate the average points scored by the
class on the first spelling assignment.
10
Microsoft Excel Formulas
((IF(G3gt89,"A",(IF(G3gt79,"B",(IF(G3gt69,"C",(IF
(G3gt59,"D","F"))))))))) is the formula typed
into Cell H3 to convert the percentage into a
letter grade
11
Microsoft Excel Formulas
Insert Menu
Many other formulas are available and can be
found by going to the Insert Menu and choosing
Function
12
Microsoft Excel Attention to a Cell
Insert Menu to Comment
Select a cell
Comments can be associated with any cell. To
insert a comment select the cell and go to the
Insert Menu and choose Comment. A box will appear
into which you type the message.
13
Microsoft Excel Attention to a Cell
Notice the red triangle in the upper right corner
and with the mouse over the cell the comment pops
up
A little red triangle in the upper right corner
of a cell indicates there is a comment. Placing
the mouse pointer over the cell reveals the
comment.
14
Microsoft Excel Attention to a Cell
Format Menu to Cells
Choose the patterns tab
Select cell or range of cells to shade
Cells can be shaded. Select the cell or range you
wish to shade. Go to the Format Menu to Cells. A
dialog box will pop up. Choose the Patterns tab
and select a color.
15
Microsoft Excel Attention to a Cell
Format Menu to Cells
Border Tab
Configure the borders as you want them
Select the range of cells
Borders can be added to outline cells. Select the
cell or range of cells. Go to the Format Menu and
choose Cells. A dialog box will pop up. Choose
the Border Tab and select the borders you want.
16
Microsoft Excel Attention to a Cell
Tools Menu to Options
View Tab
Uncheck the Gridlines checkbox
The light gray gridlines can be turned off by
going to the Tools menu and selecting Options.
Click the View Tab. Uncheck the gridlines
checkbox.
17
Microsoft Excel Attention to a Cell
The light gray gridlines can be turned off by
going to the Tools menu and selecting Options.
Click the View Tab. Uncheck the gridlines
checkbox.
18
Microsoft Excel Final Item
Many of these operations can be performed by
right clicking on the selected cell or range
instead of using the menu bar. Give it a try and
have fun.
19
Microsoft Excel
Return to AESD Staff Development Page