- Open your file named
lastname ss01.
- Save a copy of this file as
lastname ss02.
- Enter a formula (not a function) in
cell A4 to add the three values in column A.
- Copy cells A1-A3 and paste them in
cells B1-B3.
- Now, use a function in cell B4 to
sum the values in B1-B3. Remember to use Paste Function.
- Click in cell A4 and examine the
formula in the data entry field. Then, click in cell B4 and
examine the function in the data entry field.
- Delete column A, shifting column B
to the left.
- Add the following numbers to your
spreadsheet in cells B1-D3.
| |
A |
B |
C |
D |
| 1 |
15 |
42 |
29 |
36 |
| 2 |
20 |
13 |
46 |
42 |
| 3 |
30 |
21 |
87 |
52 |
| 4 |
65 |
|
|
|
- Select cells A4-D4 and use the Fill
Right command to copy the formula from A4 into B4-D4.
- Save and close this file.
Show
Me |