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
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.
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