Microsoft Office Tutorials and References

In Depth Information

**Using your spreadsheet to plan your holiday**

•
Check that your formula starts with an equals sign.

•
Check that your cell references are logical, especially if you’ve copied the

formula. If you edit the formula, you can see that the cells it uses are outlined

in colour (as in Figure 5.7).

•
Check that you’re using the right maths symbols, including a full stop for

a decimal point (it’s easy to mistype a comma instead), an asterisk for

multiplication and a slash (/) for division.

•
Check that you have meaningful numbers in the cells you’re referencing.

Pay particular attention to any cells that contain zero, because you can’t

divide by zero.

•
Check that every opening bracket has a closing bracket, and vice versa.

•
Check that you have the cells in the right order, so that you’re subtracting the

right number from the right number and haven’t got them reversed. The same

applies to formulae with division.

Using your spreadsheet to plan your holiday

Now you can start using your spreadsheet to plan your holiday. It’s not just a

calculating machine – it can help you to make decisions by telling you what will

happen if some of your assumptions change. Figure 5.8 shows the complete

planning spreadsheet.

Using this spreadsheet, you can:

•
Enter different trip lengths to see how this changes the total cost of your holiday.

•
Experiment with different exchange rates to see how ﬂ uctuating currency

might affect the cost of your holiday in pounds.

•
See what happens if you decide to rent a car for your whole holiday, instead

of just half of it.

•
See what effect it has if you change your estimate for the taxi cost, or for the

amount of petrol you use per day, based on a friend’s advice.

•
Check what happens if you go during high season when the hotel rates are higher.

•
Write a formula to calculate the cost per day, so you can see how this holiday

compares with other holidays you’ve planned.