Main menu:
PC Skills > Excel
Information entered in a spreadsheet can be divided into the following types:-
Number
This can be any number on which a calculation can be made, i.e. 456, 0.0004, -5,632.898
Label
Text usually used for headings for example Monday, Tuesday, June, July. A label can also include numbers for example 2007, 2008, 5 Class, 6 Class. You cannot perform any calculations on a label.
Formula
These will perform calculations automatically, using the numbers in a spreadsheet. Formulas contain references to the cells and not the actual value in the cell.
For example if you have the following information:-
Cell A1 contains the value 2
Cell B1 contains the value 3
Cell C1 contains the formula =A1 + B1
and displays the value 5
| A | B | C | |
| 1 | 2 | 3 | 5 |
| 2 | |||
| 3 |
If you change the number in either cell A1 or B1, the formula in C1 will automatically recalculate and display the new answer.
All formulas start with =
Here are some of the mathematical symbols you can use in a formula:-
+ Add
- Subtract
* Multiply
/ Divide
( )Brackets are used whenever necessary