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:

=B1

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.

Figure 5.3