Microsoft Office Tutorials and References
In Depth Information
Calculating the quantities
other fi gures. I like to put key fi 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 fi 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 fi 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
Search JabSto ::

Custom Search