Transcript Powerpoint - introduction to the basics

Let’s Learn
About
Spreadsheets
Start
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.
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
2
3
Put
Scooby in
cell B4
4
5
6
7
8
9
10
Check
Answer
A
B
C
D
E
F
G
H
I
1
2
B4
3
4
5
6
7
8
9
10
Next
Question
A
B
C
D
E
F
G
H
I
1
2
Put Bart in
cell G9
3
4
5
6
7
8
9
10
Check
Answer
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
G9
Next
Question
A
B
C
D
E
F
G
H
I
1
2
Put Bugs
in cell H6
3
4
5
6
7
8
9
10
Check
Answer
A
B
C
D
E
F
G
H
I
1
2
3
4
H6
5
6
7
8
9
10
Next
Question
A
B
C
D
E
F
G
H
I
1
2
Put Homer
in cell C9
3
4
5
6
7
8
9
10
Check
Answer
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
C9
Next
Question
A
B
C
D
E
F
G
H
I
1
2
Put Buzz
in cell I3
3
4
5
6
7
8
9
10
Check
Answer
A
B
C
D
E
F
G
H
1
I3
2
3
4
5
6
7
8
9
10
I
Using Functions in Spreadsheets
A
B
5
6
1
2
3
Let’s add the numbers in cells A3 and B3
C
Using Functions in Spreadsheets
A
B
5
6
C
1
2
3
=
Let’s add the numbers in cells A3 and B3
All functions start with an = sign
Using Functions in Spreadsheets
A
B
5
6
C
1
2
3
= A3
Let’s add the numbers in cells A3 and B3
All functions start with an = sign
Then put the cell reference of the first cell
Using Functions in Spreadsheets
A
B
C
5
6
= A3 +
1
2
3
Let’s add the numbers in cells A3 and B3
All functions start with an = sign
Then put the cell reference of the first cell
+
Using Functions in Spreadsheets
A
B
C
5
6
= A3 + B3
1
2
3
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
Using Functions in Spreadsheets
A
B
C
5
6
11
1
2
3
The correct answer will now be displayed when you
press ENTER
Using Functions in Spreadsheets
A
B
C
5
10
6
11
1
2
3
If you change one of the numbers used in the
calculation
Using Functions in Spreadsheets
A
B
C
5
10
6
11
16
1
2
3
If you change one of the numbers used in the
calculation
The answer is automatically updated
Using Functions in Spreadsheets
Sum
Symbol Used in a
Spreadsheet
Example
Adding
+
= A1 + B2
Using Functions in Spreadsheets
Sum
Symbol Used in a
Spreadsheet
Example
Adding
+
= A1 + B2
Subtracting
-
= A1 – B2
Using Functions in Spreadsheets
Sum
Symbol Used in a
Spreadsheet
Example
Adding
+
= A1 + B2
Subtracting
-
= A1 – B2
Multiplying
* (star)
= A1 * B2
Using Functions in Spreadsheets
Sum
Symbol Used in a
Spreadsheet
Example
Adding
+
= A1 + B2
Subtracting
-
= A1 – B2
Multiplying
* (star)
= A1 * B2
Dividing
/
= A1 / B2
Quiz on
Functions
Start
A
B
12
8
C
D
1
2
3
4
5
6
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell C4
/
- + = *
B3 A1 B3 A4 C4 D6 B4 B5
Check
Answer
A
B
C
D
1
2
A4
3
4
B4
+
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
/
- + = *
B3 A1 B3 A4 C4 D6 B4 B5
Next
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
/
- +
*
B3 A2 D5 A4 C4 D6 B4 D6
=
Check
Answer
A
1
2
3
4
B
C
D
A2
20
+
C4
15
5
=A2+C4
6
Create the formula to ADD the two numbers in the spreadsheet and
put the answer in cell D5
/
- + = *
B3 A2 D5 A4 C4 D6 B4 D6
Next
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
/
- + = *
B2 A2 D5 A4 D4 D6 B4 A6
Check
Answer
A
1
B
C
D
B2
2
100
3
-
4
10
5
6
=B2-D4
D4
Create the formula to SUBTRACT the lowest number in the
spreadsheet from the higher number and put the answer in cell A6
/
- + = *
B2 A2 D5 A4 D4 D6 B4 A6
Next
Question
A
B
C
D
1
2
3
4
23
10
5
6
Create the formula to MULTIPLY the two numbers in the spreadsheet
and put the answer in cell D6
/
- + = *
B2 A2 A3 A4 D4 D6 C4 A6
Check
Answer
A
1
4
C
D
A3
2
3
B
*
C4
23
10
5
6
=A3*C4
Create the formula to MULTIPLY the two numbers in the spreadsheet
and put the answer in cell D6
/
- + = *
B2 A2 A3 A4 D4 D6 C4 A6
Next
Question
A
1
2
B
C
D
30
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
/
- + = *
B2 A1 A3 A4 D4 D6 C3 A6
Check
Answer
A1
1
2
3
A
30
B
C
D
B2
/
10
=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
/
- + = *
B2 A1 A3 A4 D4 D6 C3 A6
Next
Question
A
B
C
D
1
2
3
4
5
6
5
7
6
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
Check
Answer
A
B
C
D
=B3+C4+D5
1
2
3
4
B3
C4
5
+
6
5
6
+
7
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