16.2 Creating a
spreadsheet
Data is entered into a cell as either a label, value or a formula. A formula is an instruction to perform a calculation. A formula usually starts with '='.
Cell references are used in formulas. If the formula refers to itself it is called a 'circular reference' and gives an error message. Functions make calculations easier and arguments are the values on which these functions operate.
Write out the sentence and fill in the missing word
|
Data is entered into a cell as either a label, ????? or a formula. |
|
Most spreadsheets will treat anything they cannot interpret as a value or formula as a ????? |
|
A formula is an instruction to perform a ????? |
|
When entering a ????? it usually starts with a particular symbol, such as the '=' or '+' signs |
|
A ????? is a group of cells in a single row or column , or in several adjacent rows or columns. |
|
If a formula refers to itself, either directly or indirectly, it is called a ????? |
|
????? are used to perform a process and are used to build up required formulae |
|
Operators can be grouped as ?????, relational and text. |
|
????? consist of a function name, a set of parentheses() and arguments |
|
Functions can be grouped as arithmetic, statistical or ????? |