1 of 48

Let’s Learn About Spreadsheets

Start

2 of 48

What is a Spreadsheet?

A spreadsheet is used for storing information and data.

Calculations can be performed on the data in a spreadsheet.

Microsoft Excel is the most common spreadsheet application, although there are other spreadsheets available.

3 of 48

Parts of a Spreadsheet

This is a COLUMN.

Columns are labelled

with letters.

4 of 48

Parts of a Spreadsheet

This is a ROW

Rows are labelled

with numbers.

5 of 48

Parts of a Spreadsheet

This is a CELL

Each cell has a unique

CELL REFERENCE

6 of 48

Parts of a Spreadsheet

The CELL REFERENCE of this cell is

E

4

7 of 48

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.

8 of 48

Parts of a Spreadsheet

A LABEL is a piece of TEXT that you add to a spreadsheet to help describe the numbers.

9 of 48

Parts of a Spreadsheet

These are all LABELS.

10 of 48

Parts of a Spreadsheet

A VALUE is a NUMBER that you type into a spreadsheet.

It is a number that you already know.

11 of 48

Parts of a Spreadsheet

These are all VALUES.

12 of 48

Cell Referencing Quiz

Start

13 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

Put Scooby in cell B4

Check �Answer

14 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

B4

15 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

Put Bart in cell G9

Check �Answer

16 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

G9

17 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

Put Bugs in cell H6

Check �Answer

18 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

H6

19 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

Put Homer in cell C9

Check �Answer

20 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

C9

21 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

Put Buzz in cell I3

Check �Answer

22 of 48

	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6
7
8
9
10

I3

23 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6

Let’s add the numbers in cells A3 and B3

24 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	=

Let’s add the numbers in cells A3 and B3

All formulae start with an = sign

25 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	= A3

Let’s add the numbers in cells A3 and B3

All formulae start with an = sign

Then put the cell reference of the first cell

26 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	= A3 +

Let’s add the numbers in cells A3 and B3

All formulae start with an = sign

Then put the cell reference of the first cell

+

27 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	= A3 + B3

Let’s 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

+

28 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	11

The correct answer will now be displayed when you press ENTER

29 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	11

If you change one of the numbers used in the calculation

10

30 of 48

Using Formulae in Spreadsheets

	A	B	C
1
2
3	5	6	11

If you change one of the numbers used in the calculation

The answer is automatically updated

16

10

31 of 48

Using Formulae in Spreadsheets

Sum	Symbol Used in a Spreadsheet	Example
Adding	+	= A1 + B2

32 of 48

Using Formulae in Spreadsheets

Sum	Symbol Used in a Spreadsheet	Example
Adding	+	= A1 + B2
Subtracting	-	= A1 – B2

33 of 48

Using Formulae in Spreadsheets

Sum	Symbol Used in a Spreadsheet	Example
Adding	+	= A1 + B2
Subtracting	-	= A1 – B2
Multiplying	* (star)	= A1 * B2

34 of 48

Using Formulae in Spreadsheets

Sum	Symbol Used in a Spreadsheet	Example
Adding	+	= A1 + B2
Subtracting	-	= A1 – B2
Multiplying	* (star)	= A1 * B2
Dividing	/	= A1 / B2

35 of 48

Quiz on Formulae

Start

36 of 48

	A	B	C	D
1
2
3
4	12	8
5
6

=

+

B5

B3

C4

A4

D6

B4

A1

Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell C4

-

*

/

Check

Answer

37 of 48

	A	B	C	D
1
2
3
4	12	8	=A4+B4
5
6

=

+

B5

B3

C4

A4

D6

B4

A1

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

-

*

/

A4

B4

+

38 of 48

	A	B	C	D
1
2	20
3
4			15
5
6

=

+

D6

B3

D5

C4

A4

D6

B4

A2

Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5

-

*

/

Check

Answer

39 of 48

	A	B	C	D
1
2	20
3
4			15
5				=A2+C4
6

=

+

D6

B3

D5

C4

A4

D6

B4

A2

Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5

-

*

/

A2

C4

+

40 of 48

	A	B	C	D
1
2		100
3
4				10
5
6

=

+

A6

B2

D5

D4

A4

D6

B4

A2

Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6

-

*

/

Check

Answer

41 of 48

	A	B	C	D
1
2		100
3
4				10
5
6	=B2-D4

=

+

A6

B2

D5

D4

A4

D6

B4

A2

Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6

-

*

/

B2

D4

-

42 of 48

	A	B	C	D
1
2
3	23
4			10
5
6

=

+

A6

B2

A3

D4

A4

D6

C4

A2

Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6

-

*

/

Check

Answer

43 of 48

	A	B	C	D
1
2
3	23
4			10
5
6				=A3*C4

=

+

A6

B2

A3

D4

A4

D6

C4

A2

Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6

-

*

/

A3

C4

*

44 of 48

	A	B	C	D
1	30
2		10
3
4
5
6

=

+

A6

B2

A3

D4

A4

D6

C3

A1

Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3

-

*

/

Check

Answer

45 of 48

	A	B	C	D
1	30
2		10
3			=A1/B2
4
5
6

=

+

A6

B2

A3

D4

A4

D6

C3

A1

Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3

-

*

/

A1

B2

/

46 of 48

	A	B	C	D
1
2
3		5
4			6
5				7
6

=

+

D1

B2

A3

C4

A4

D6

D5

B3

Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1

-

*

/

Check

Answer

+

47 of 48

	A	B	C	D
1				=B3+C4+D5
2
3		5
4			6
5				7
6

=

+

D1

B2

A3

C4

A4

D6

D5

B3

Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1

-

*

/

B3

C4

+

D5

+

48 of 48

Quiz Complete�