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 fl 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.
Search JabSto ::

Custom Search