Using the Spreadsheet

Worksheet

Please follow the directions below to make a spreadsheet file, enter number data, and create cells that calculate.

1. Log in and choose Excel.

2. Begin a new spreadsheet file (choose FILE, then NEW if you need to).

3. Type the column headings into the cells (see the example):

            A1:  test 1
            B1:  test 2
            C1:  test 3                                                                    
            D1:  total
            E1:  average

                            EXAMPLE

4. Type formulas into cells:

D2 :     =A2+B2+C2   (will add numbers together)
            E2 :      =D2/3   (will average numbers)

NOTE – All Excel formulas begin with the = sign.

5. Type numbers into cells A2, B2, and C2. (see the example above)

- cells D2 and E2 should calculate automatically
            - if cells D2 and E2 don’t calculate, press key F9

6. Try changing the numbers in cells A2, B2, and C2.

            - the numbers in cells D2 and E2 should change – the computer recalculates the answers

7. Type the shortcut formula into E2:    =average(A2:C2)

            - the same answer should be in E2 that you had before

8. Try typing different formulas into cell F2.

- the computer should calculate the answers automatically (if not, press key F9)
- some formulas to try:

     =A2-B2-C2   (will subtract the second number from the first, then subtract the third number)
=A2*B2*C2   (will multiply all three numbers together)
=(A2+B2)*C2   (will add the first two numbers, then multiply by the third number)
=(A2+B2)/C2   (will add the first two numbers, then divide by the third number)
=D2+200   (will add 200 to the total in D2)

9. Starting in cell A4, make-up and type in 10 or more test scores.  (Go across.)

- In the next cell, use the shortcut to find the average of those numbers (see step 7 for help)
- try changing some of the numbers – the average should change.  The computer recalculates the average.

8. Save your Spreadsheet file before you log out.