Activity 3

Return Click the "return" button to return to last page

Practice exercise

A Travel Agent wants a worksheet to keep track of the number of city breaks booked for each month. He has collected the following data:

  January February March April May
Paris 1004 2648 2586 3002 4219
Barcelona 2435 3785 3745 4584 4675
Venice 2654 3621 4583 5473 6900
Rome 1254 3125 5379 5463 6431
Amsterdam 1632 2137 3524 4563 5312
  • Create a worksheet to show this information.
  • Make all the text size 14 Courier italic.
  • Widen columns as necessary.
  • Add formulas to work out the totals for each month and for each destination.
  • Change the figure for Venice in March to 4657 and for Amsterdam in January to 1832.
  • Save this worksheet as Holidays and print one copy.