Microsoft Office Tutorials and References
In Depth Information
1.4.4 Naming a Range of Cells
Objective: To name the range of data for the weight scores with the name:
Weight
Highlight cells B4: B11 by left-clicking your mouse pointer on B4 and dragging it
down to B11
Formulas (top left of your screen)
Define Name (top center of your screen)
Weight (type this name in the top box; see Fig. 1.7 )
Fig. 1.7
Dialogue box for ‘‘naming a range of cells’’ with the name: Weight
OK
Then, click on any cell of your spreadsheet that does not have any information
in it (i.e., it is an ‘‘empty cell’’) to deselect cells B4:B11
Now, add the following terms to your spreadsheet:
E6:
n
E9:
Mean
E12:
STDEV
E15:
s.e. (see Fig. 1.8 )
Search JabSto ::




Custom Search