91福利社

Explore the 91福利社
This page has been archived and is no longer updated. Find out more about page archiving.

28 August 2014
Accessibility help
Text only
91福利社 Key Skills Go to ICT 91福利社
Key Skills 91福利社

91福利社 91福利社page

Contact Us


Using a spreadsheet
Putting it Together

First, Alistair needs to create a new spreadsheet.

key pointA spreadsheet consists of a series of rows and columns. Each row is
identified by a number, each column by a letter of the alphabet.

Where a row and column intersect, the cell is given the reference of the row/column. For example, the cell where row 2 and column C meet is called C2. This reference is important, as it is needed when creating formulas.

In this example, cell B3 shows how many pens have been sold.

A B C D
1 10 Dec 02
2 number sold price total
3 Pens 8 拢1 拢8.00
4 Pencils 6 50p 拢3.00

Alistair makes a start on his spreadsheet by typing in the following headings:

  • Artist
  • Title
  • Price



There is lots of information available online
to help you with putting spreadsheets
together. Have a look at:
Please note that the 91福利社 is not responsible
for the content of other websites.

If you are unable to view the Flash movie above, click here for a non-Flash alternative.

Move on to the next screen to take stock.





About the 91福利社 | Help | Terms of Use | Privacy & Cookies Policy