Microsoft Office Tutorials and References
In Depth Information
Calculating the quantities
left corner, for example, is cell A1. The next one to the right is B1, and the one
underneath A1 is A2. This is similar to the way we use grid references on maps, so I’m sure
it feels familiar, but feel free to refer to Figure 5.2 if it helps to make it clearer.
If you don’t know the reference for a cell, put the cursor on it. The headings of the
row and column for that cell are coloured orange, so you can see at a glance
which column and row it is in. In Figure 5.2, you can see this effect for cell B1.
The ﬁ rst calculation we want Excel to perform is the length of the stay at Hotel
Pierre. This will be the length of the holiday minus the one night spent in the
treehouse. We’ve already entered the length of the holiday into cell B1, so we just
need to give Excel a formula so it can work out the value of cell D5, which stores
the length of our hotel booking.
Click on cell D5 as you normally would if you were going to enter a number into
it. To tell Excel you’re entering a formula, you use the equals sign as the ﬁ rst
character. To tell it to take the value from another cell, you enter that cell’s reference.
Enter the following into cell D5:
It doesn’t matter whether you use upper or lower case. When you type the B, a
menu will pop up on screen, but you can just ignore this. Type the 1 and the menu
will go away again, and Excel will put a blue outline around cell B1 so that you
can check you’ve entered the right reference. You can see this in Figure 5.3.