|
Activity 3
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.
|