Spreadsheet Exercise 2

 

  1. Open your file named lastname ss01.
  2. Save a copy of this file as lastname ss02.
  3. Enter a formula (not a function) in cell A4 to add the three values in column A.
  4. Copy cells A1-A3 and paste them in cells B1-B3.
  5. Now, use a function in cell B4 to sum the values in B1-B3. Remember to use Paste Function.
  6. 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.
  7. Delete column A, shifting column B to the left.
  8. 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      
  9. Select cells A4-D4 and use the Fill Right command to copy the formula from A4 into B4-D4.
  10. Save and close this file.

Show Me


List of Exercises
Next: Exercise 3

Back to Introduction to Infopro