St. Cronans Hub V9.0 June 2016


Go to content

Main menu:


Information

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






Back to content | Back to main menu