let’s learn about spreadsheets
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
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 ROWRows are labelled
with numbers.
Parts of a Spreadsheet
This is a CELLEach cell has a unique
CELL REFERENCE
Parts of a Spreadsheet
The CELL REFERENCE of this cell is
E 4
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
34
5
6
7
8
9
10
Put Scooby in
cell B4
Check Answer
A B C D E F G H I
1
2
34
5
6
7
8
9
10
B4
Next Question
A B C D E F G H I
1
2
34
5
6
7
8
9
10
Put Bart in cell G9
Check Answer
A B C D E F G H I
1
2
34
5
6
7
8
9
10
G9 Next Question
A B C D E F G H I
1
2
34
5
6
7
8
9
10
Put Bugs in cell H6
Check Answer
A B C D E F G H I
1
2
34
5
6
7
8
9
10
H6
Next Question
A B C D E F G H I
1
2
34
5
6
7
8
9
10
Put Homer in cell C9
Check Answer
A B C D E F G H I
1
2
34
5
6
7
8
9
10
C9Next
Question
A B C D E F G H I
1
2
34
5
6
7
8
9
10
Put Buzz in cell I3
Check Answer
A B C D E F G H I
1
2
34
5
6
7
8
9
10
I3
Using Formulae in SpreadsheetsA B C
1
2
3 5 6
Let’s add the numbers in cells A3 and B3
Using Formulae in SpreadsheetsA B C
1
2
3 5 6 =
Let’s add the numbers in cells A3 and B3
All formulae start with an = sign
Using Formulae in SpreadsheetsA 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
Using Formulae in SpreadsheetsA 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+
Using Formulae in SpreadsheetsA 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+
Using Formulae in SpreadsheetsA B C
1
2
3 5 6 11
The correct answer will now be displayed when you press ENTER
Using Formulae in SpreadsheetsA B C
1
2
3 5 6 11
If you change one of the numbers used in the calculation
10
Using Formulae in SpreadsheetsA B C
1
2
3 5 6 11
If you change one of the numbers used in the calculation
The answer is automatically updated
1610
Using Formulae in Spreadsheets
Sum Symbol Used in a Spreadsheet
Example
Adding + = A1 + B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Spreadsheet
Example
Adding + = A1 + B2
Subtracting - = A1 – B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Spreadsheet
Example
Adding + = A1 + B2
Subtracting - = A1 – B2
Multiplying * (star) = A1 * B2
Using Formulae in Spreadsheets
Sum Symbol Used in a Spreadsheet
Example
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
=+B5B3 B3 C4A4 D6 B4A1
Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell C4
- */Check
Answer
A B C D
1
2
3
4 12 8 =A4+B4
5
6
=+B5B3 B3 C4A4 D6 B4A1
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+
NextQuestion
A B C D
1
2 20
3
4 15
5
6
= +D6B3 D5 C4A4 D6 B4A2
Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5
- */Check
Answer
A B C D
1
2 20
3
4 15
5 =A2+C4
6
=+D6B3 D5 C4A4 D6 B4A2
Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5
- */
A2
C4+
NextQuestion
A B C D
1
2 100
3
4 10
5
6
=+A6B2 D5 D4A4 D6 B4A2
Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6
- */Check
Answer
A B C D
1
2 100
3
4 10
5
6 =B2-D4
=+A6B2 D5 D4A4 D6 B4A2
Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6
- */Next
Question
B2
D4
-
A B C D
1
2
3 23
4 10
5
6
=+A6B2 A3 D4A4 D6 C4A2
Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6
- */Check
Answer
A B C D
1
2
3 23
4 10
5
6 =A3*C4
=+A6B2 A3 D4A4 D6 C4A2
Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6
- */
A3
C4*
NextQuestion
A B C D
1 30
2 10
3
4
5
6
=+A6B2 A3 D4A4 D6 C3A1
Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3
- */Check
Answer
A B C D
1 30
2 10
3 =A1/B2
4
5
6
=+A6B2 A3 D4A4 D6 C3A1
Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3
- */Next
Question
A1
B2/
A B C D
1
2
3 5
4 6
5 7
6
=+D1B2 A3 C4A4 D6 D5B3
Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1
- */Check
Answer
+
A B C D
1 =B3+C4+D5
2
3 5
4 6
5 7
6
=+D1B2 A3 C4A4 D6 D5B3
Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1
- */
B3
C4+
+
D5
+
Quiz Complete