04x Using Formulae and Functions

Exercises

  1. Open a new Excel book.
  2. In cell A1 type in 'Weekday'.
  3. In cell B1 type in 'Bus fare'.
  4. In the 7 cells below Weekday type in the days of the week from Monday to Sunday.
  5. In the 7 cells below Bus fare type 3, 3, 3, 1.5, 1.5, 3, 0.
  6. Click on 'A' so that column A is highlighted.
  7. Click on 'Format', highlight 'Column', then click on 'AutoFit Selection'.
  8. Repeat step 7. for column B.
  9. Select cells B2 to B8, then click on 'Format', then 'Cell', then select the number category 'Currency' to two decimal places. The numbers you typed in under bus fare should appear with a pound sign, followed by the bus fares in pounds and pence.
  10. Click on cell B9. This is where the total bus fare for the week will appear.
  11. Click on the AutoSum button. The formula =SUM(B2:B8) should appear in cell B9.
  12. Press the return key.
    The amount of £15.00 should appear in cell B9.
  13. Type the word 'Total' in cell A9.
  14. Click on cell B10. This is where the average bus fare for the week will appear.
  15. Use the instructions in the handout to find the average bus fare.
    Ensure that the formula that applies to this cell is =AVERAGE(B2:B8). When you press return the figure £2.14 (or similar) should appear in the cell.
  16. Close Excel.

Back to Excel Home Page