|
Shopping List
2 jars of Vegemite, 3 bottle of Coke, 1 loaf of
bread, 2 cartons of milk, a packet of frozen beans
and a tube of toothpaste.
- Open a spreadsheet document.
- Notice that a spreadsheet is
made up of rows and columns forming cells which
are named A1, A2, B4 etc.
- To enter data, click in a
cell and type. The data does not appear in the
cell, but in the entry bar, which is above the
cells. Press the Return key or click on the
green tick (the Accept button) and the
information in the entry bar will be placed in
the spreadsheet. Click on the red cross (Cancel
button) to remove the information from the entry
bar.
- To start our personal
shopping list, click in cell A1 and type the
word Item and press Return.
- The word will appear in the
selected cell and cell A2 will be highlighted.
(If you press Enter on the numeric keypad, the
data will appear in the cell but A1 will remain
highlighted.)
- To move to another cell,
either click in the chosen cell or press Return
to move down the column or Tab to move across a
Row.
- For our example, leave cell
A2 empty (press return) and type the name of
each item to be included in a personal shopping
list in Column A and press Return after each
item.
- Some of the words may extend
into column B as they are too long to fit in
column A. To change the width of a column,
either choose Column Width from the Format menu
and enter a larger/smaller point size or
move the cursor to the vertical line between the
column names. It will change to a double sided
arrow. Move the arrows to change the width of
the column.
- In Cell B1 type the word
Amount,
in C1 Cost and in D1 Total.
- Add all the
data in column B and C.
- To change
the numbers in column C to dollars and cents,
highlight all the amounts in column C, then
Select Number from the Format menu.
- Click on the Currency
button, then OK.
- The amounts will have a $
dollar sign.
|
