Part 1

Row, Columns, Cells

A spreadsheet is a table of numbers and information, set out in [?] and [?]. go along the way (left to right) and go up and down. The point where each row meets a column is called a . Each of these cells in spreadsheet is identified by its [?] letter and [?] number (e.g. C4).



Values, text & formulae

A cell in spreadsheet can contain text, numbers or [?] . A number entered in a cell is called a value. Values can be whole numbers or decimals.

A allows the calculation of values from other cells in the spreadsheet. All formulae start with an equals sign (=) to show that we are making the cell equal to the value that the formula calculates.

Simple formulae

A cell may have a formula to calculate the total of the numbers in the other cells (e.g. B2+B3+B4) or a formula that multiplies the numbers in two other cells (e.g. D3*G2).

Other formula could use divide (/) or subtract (-).

A special function called [?] adds up all the numbers in the cell references after it, e.g. [?] (B2:B7) will add all the values in cells B2, B3, B4, B5, B6 and B7 together.

Automatic & Manual calculation

You can change the contents of a cell simply by typing a new value into it. If Automatic calculation is being used then all the [?] that refer to the cell will be recalculated with the new value.

If manual calculation is being used then the formulae in the spreadsheet will only be recalculated when a particular command is given by the user.

Charting

Many spreadsheets have facilities for producing graphs. These can be in various forms such as pie, bar and 3D graphs.

To create a chart, rows and columns from the spreadsheet have to be selected and then processed using the spreadsheets graphing tools.