Parts of a Spreadsheet
This is a COLUMN.
Columns are labelled
with letters.
Parts of a Spreadsheet
This is a ROW
Rows are labelled
with numbers.
Parts of a Spreadsheet
This is a CELL
Each cell has a unique
CELL REFERENCE
Parts of a Spreadsheet
The CELL REFERENCE of this cell is
E4
Parts of a Spreadsheet
The cell that you are currently clicked in is called the ACTIVE CELL.
It has a thick black line around it.
Any text you type will go in this cell.
Parts of a Spreadsheet
A LABEL is a piece of TEXT that you add to a spreadsheet
to help describe the numbers.
Parts of a Spreadsheet
These are all LABELS.
Parts of a Spreadsheet
A VALUE is a NUMBER that you type into a spreadsheet.
It is a number that you already know.
Parts of a Spreadsheet
These are all VALUES.
Cell
Referencing
Quiz
Start
A B C D E F G H I
1
Put
2 Scooby in
3 cell B4
4
5
6
Check
7 Answer
8
9
10
A B C D E F G H I
1
2 B4
3
4
5
6
Next
7 Question
8
9
10
A B C D E F G H I
1
Put Bart in
2 cell G9
3
4
5
6
Check
7 Answer
8
9
10
A B C D E F G H I
1
2
3
4
5
6
G9 Next
7 Question
8
9
10
A B C D E F G H I
1
Put Bugs
2 in cell H6
3
4
5
6
Check
7 Answer
8
9
10
A B C D E F G H I
1
2
3
H6
4
5
6
Next
7 Question
8
9
10
A B C D E F G H I
1
Put Homer
2 in cell C9
3
4
5
6
Check
7 Answer
8
9
10
A B C D E F G H I
1
2
3
4
5
6
Next
7 C9 Question
8
9
10
A B C D E F G H I
1
Put Buzz
2 in cell I3
3
4
5
6
Check
7 Answer
8
9
10
A B C D E F G H I
1
I3
2
3
4
5
6
7
8
9
10
Using Formulae in Spreadsheets
A B C
1
2
3 5 6
Lets add the numbers in cells A3 and B3
Using Formulae in Spreadsheets
A B C
1
2
3 5 6 =
Lets add the numbers in cells A3 and B3
All formulae start with an = sign
Using Formulae in Spreadsheets
A B C
1
2
3 5 6 = A3
Lets add the numbers in cells A3 and B3
All formulae start with an = sign
Then put the cell reference of the first cell
Using Formulae in Spreadsheets
A B C
1
2
3 5 6 = A3 +
Lets add the numbers in cells A3 and B3
All formulae start with an = sign
Then put the cell reference of the first cell
+
Using Formulae in Spreadsheets
A B C
1
2
3 5 6 = A3 + B3
Lets add the numbers in cells A3 and B3
All formulae start with an = sign
Then put the cell reference of the first cell
+
The cell reference of the second cell
Using Formulae in Spreadsheets
A B C
1
2
3 5 6 11
The correct answer will now be displayed when you
press ENTER
Using Formulae in Spreadsheets
A B C
1
2
3 5
10 6 11
If you change one of the numbers used in the
calculation
Using Formulae in Spreadsheets
A B C
1
2
3 5
10 6 11
16
If you change one of the numbers used in the
calculation
The answer is automatically updated
Using Formulae in Spreadsheets
Sum Symbol Used in a Example
Spreadsheet
Adding + = A1 + B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Example
Spreadsheet
Adding + = A1 + B2
Subtracting - = A1 B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Example
Spreadsheet
Adding + = A1 + B2
Subtracting - = A1 B2
Multiplying * (star) = A1 * B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Example
Spreadsheet
Adding + = A1 + B2
Subtracting - = A1 B2
Multiplying * (star) = A1 * B2
Dividing / = A1 / B2
Quiz on
Formulae
Start
A B C D
1
2
3
4 12 8
5
6
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell C4
/ - + = * Check
B3 A1 B3 A4 C4 D6 B4 B5 Answer
A B C D
1
2
A4 B4
3 +
4 12 8 =A4+B4
5
6
Drag the correct symbols and cell references onto the spreadsheet.
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell C4
/ - + = * Next
B3 A1 B3 A4 C4 D6 B4 B5 Question
A B C D
1
2 20
3
4 15
5
6
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell D5
/ =- + * Check
B3 A2 D5 A4 C4 D6 B4 D6 Answer
A B C D
A2
1
2 20
+
3 C4
4 15
5 =A2+C4
6
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell D5
/ - + = * Next
B3 A2 D5 A4 C4 D6 B4 D6 Question
A B C D
1
2 100
3
4 10
5
6
Create the formula to SUBTRACT the lowest number in the
spreadsheet from the higher number and put the answer in cell A6
/ - + = * Check
B2 A2 D5 A4 D4 D6 B4 A6 Answer
A B C D
B2
1
2 100
3 -
4 10
5
D4
6 =B2-D4
Create the formula to SUBTRACT the lowest number in the
spreadsheet from the higher number and put the answer in cell A6
/ - + = * Next
B2 A2 D5 A4 D4 D6 B4 A6 Question
A B C D
1
2
3 23
4 10
5
6
Create the formula to MULTIPLY the two numbers in the spreadsheet
and put the answer in cell D6
/ - + = * Check
B2 A2 A3 A4 D4 D6 C4 A6 Answer
A B C D
1
A3
2
*
3 23 C4
4 10
5
6 =A3*C4
Create the formula to MULTIPLY the two numbers in the spreadsheet
and put the answer in cell D6
/ - + = * Next
B2 A2 A3 A4 D4 D6 C4 A6 Question
A B C D
1 30
2 10
3
4
5
6
Create the formula to DIVIDE the number in A1 by the number in B2.
Put the answer in cell C3
/ - + = * Check
B2 A1 A3 A4 D4 D6 C3 A6 Answer
A1 A B C D
1 30 B2
/
2 10
3 =A1/B2
4
5
6
Create the formula to DIVIDE the number in A1 by the number in B2.
Put the answer in cell C3
/ - + = * Next
B2 A1 A3 A4 D4 D6 C3 A6 Question
A B C D
1
2
3 5
4 6
5 7
6
Create the formula to ADD all the numbers in the spreadsheet. Put the
answer in cell D1
/ - + = * + Check
B2 B3 A3 A4 C4 D6 D5 D1 Answer
A B C D
1 =B3+C4+D5
B3
2
C4
3 5 +
4 6 +
5 7
6 D5
Create the formula to ADD all the numbers in the spreadsheet. Put the
answer in cell D1
/ - + = * +
B2 B3 A3 A4 C4 D6 D5 D1
Quiz Complete
