Now you are going to find out how to control the way numbers are displayed, and make Excel automatically calculate columns totals. You are going to create a spread to hold data about the height, weight and foot size of people in a group.
*** Open a new Excel workbook. Select File and the click on New.
*** Select Blank workbook and click on Create.
*** Type the word Measurements in cell A1. It will overflow the cell, but that’s OK.
*** Press Enter
*** Select Cell A1 again and make it bold by clicking the BOLD button on Font section of the
*** Position the pointer with your mouse so that it is on the line between column headers A
and B. The pointer will change to a double-headed arrow.
*** Use the left mouse button and hold it down while you drag to the right. The column will
widen. Make it wide enough to fit the heading.
*** Now type the other headings in the top row, use your own name. Make up a group name for
the title in C1.
*** Highlight the whole row 1
*** Now we are going to widen the column a second way. Position the pointer between the
column headers F and G containing your name.
*** Double click. The column automatically widens so that the name will fit the cell.
Save your workbook, call it Measurements.
*** Fill in the rest of your workbook like this
*** You will need to make the columns wider to fit the headings. Use the double click on the
header to make the column width change automatically.
Notice that the cells that have numbers are on the right of the cell, this is called right justified. The
text you enter is always left justified.
The measurements would look much easier to read if they were all shown to 1 decimal place. Excel
will ignore if you enter 127.0 and display 127.
*** Select the cells B4 to D17 by clicking in B4 and holding down your left mouse button and
dragging down to D17
*** Click on the home tab and look for the section called number.
*** Select the Increase decimal button
t will now look like this.
*** Now click on the decrease decimal button. To show the numbers to 1 decimal place.
*** Now your work book should look like this.
*** Save your workbook again.
Try holding down Ctrl and the letter S.
Adding a column of numbers together
We want to add up the heights of everyone in the group and put the total in cell B11. To do this we use
the Autosum button.
The sign ∑ (pronounced Sigma) on the Autosum button is the Greek letter S. Greek letters are used a
lot in maths. π is the Greek letter p. The area of a circle = πr²
*** Click in cell B11 to make it the active cell.
*** Click on the formula tab
*** Click on the Autosum button
*** Excel will guess which cells you want to sum. Your screen will look like the one below.
*** Press Enter. You will now see the answer.
*** Now do the same in cell C11 to find out the total weight.
*** Now do the same in cell D11.
This time Excell thinks you want to find the sum total of the cells to the left.
*** Select cells D4 to D9 by click in D4 and dragging your mouse down to D9.
*** Press Enter and your answer will apear.
*** Save your worksheet