Microsoft Office Tutorials and References

In Depth Information

**Calculating the quantities**

other ﬁ gures. I like to put key ﬁ gures like these at the top, so they can be seen

easily and don’t get mixed up with the rest of the information.

Select row 1 by clicking on its heading, and then click the Insert button on the

Home ribbon twice. This will insert two blank lines at the top of the spreadsheet:

one for our trip length value, and the other to add some space and improve

readability.

In cell A1 write ‘Trip length’, and in cell A2, enter the number 10. Add a header

to column D for ‘Quantity’, and enter any known ﬁ xed values into that column (2

taxi trips, 1 treehouse night, 2 concert tickets). Your spreadsheet should now look

like Figure 5.2.

Figure 5.2

Entering your ﬁ rst formula

So far, we have typed in all the information in our spreadsheets. Now we’re going

to try something a little different. We’re going to type a formula into a cell so that

Excel can calculate what should be there for us. Formulae can get quite advanced,

but this project will give you a gentle introduction.

Before we look at how formulae are entered, we should spend a moment thinking

about grid references. As you know, columns have letters to identify them and

numbers have rows to identify them. By using a combination of a column letter

and row number, it’s possible to uniquely identify every cell. The cell in the top