Lets Learn About Spreadsheets Start What is a

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 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 3 Put Scooby in cell B 4 4 5 6 7 8 9 10 Check Answer

A B C D E F G H I 1 2 B 4 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 G 9 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 G 9 Next Question

A B C D E F G H I 1 2 Put Bugs in cell H 6 3 4 5 6 7 8 9 10 Check Answer

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

A B C D E F G H I 1 2 Put Homer in cell C 9 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 C 9 Next Question

A B C D E F G H I 1 2 Put Buzz in cell I 3 3 4 5 6 7 8 9 10 Check Answer

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

Using Formulae in Spreadsheets A B 5 6 1 2 3 Let’s add the numbers in cells A 3 and B 3 C

Using Formulae in Spreadsheets A B 5 6 C 1 2 3 = Let’s add the numbers in cells A 3 and B 3 All formulae start with an = sign

Using Formulae in Spreadsheets A B 5 6 C 1 2 3 = A 3 Let’s add the numbers in cells A 3 and B 3 All formulae start with an = sign Then put the cell reference of the first cell

Using Formulae in Spreadsheets A B C 5 6 = A 3 + 1 2 3 Let’s add the numbers in cells A 3 and B 3 All formulae start with an = sign Then put the cell reference of the first cell +

Using Formulae in Spreadsheets A B C 5 6 = A 3 + B 3 1 2 3 Let’s add the numbers in cells A 3 and B 3 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 5 6 11 1 2 3 The correct answer will now be displayed when you press ENTER

Using Formulae in Spreadsheets A B C 5 10 6 11 1 2 3 If you change one of the numbers used in the calculation

Using Formulae 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 Formulae in Spreadsheets Sum Symbol Used in a Spreadsheet Example Adding + = A 1 + B 2

Using Formulae in Spreadsheets Sum Symbol Used in a Spreadsheet Example Adding + = A 1 + B 2 Subtracting - = A 1 – B 2

Using Formulae in Spreadsheets Sum Symbol Used in a Spreadsheet Example Adding + = A 1 + B 2 Subtracting - = A 1 – B 2 Multiplying * (star) = A 1 * B 2

Using Formulae in Spreadsheets Sum Symbol Used in a Spreadsheet Example Adding + = A 1 + B 2 Subtracting - = A 1 – B 2 Multiplying * (star) = A 1 * B 2 Dividing / = A 1 / B 2

Quiz on Formulae 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 C 4 / - + = * B 3 A 1 B 3 A 4 C 4 D 6 B 4 B 5 Check Answer

A B C D 1 2 3 4 A 4 B 4 + 12 8 =A 4+B 4 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 C 4 / - + = * B 3 A 1 B 3 A 4 C 4 D 6 B 4 B 5 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 D 5 / - + * B 3 A 2 D 5 A 4 C 4 D 6 B 4 D 6 = Check Answer

A 1 2 3 4 B C D A 2 20 + C 4 15 5 =A 2+C 4 6 Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D 5 / - + = * B 3 A 2 D 5 A 4 C 4 D 6 B 4 D 6 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 A 6 / - + = * B 2 A 2 D 5 A 4 D 6 B 4 A 6 Check Answer

A 1 B C D B 2 2 100 3 - 4 10 5 6 =B 2 -D 4 Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A 6 / - + = * B 2 A 2 D 5 A 4 D 6 B 4 A 6 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 D 6 / - + = * B 2 A 3 A 4 D 6 C 4 A 6 Check Answer

A 1 4 C D A 3 2 3 B * C 4 23 10 5 6 =A 3*C 4 Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D 6 / - + = * B 2 A 3 A 4 D 6 C 4 A 6 Next Question

A 1 2 B C D 30 10 3 4 5 6 Create the formula to DIVIDE the number in A 1 by the number in B 2. Put the answer in cell C 3 / - + = * B 2 A 1 A 3 A 4 D 6 C 3 A 6 Check Answer

A 1 1 2 3 A 30 B C D B 2 / 10 =A 1/B 2 4 5 6 Create the formula to DIVIDE the number in A 1 by the number in B 2. Put the answer in cell C 3 / - + = * B 2 A 1 A 3 A 4 D 6 C 3 A 6 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 D 1 / - + = * + B 2 B 3 A 4 C 4 D 6 D 5 D 1 Check Answer

A B C D =B 3+C 4+D 5 1 2 3 4 B 3 5 C 4 + 6 5 6 + 7 D 5 Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D 1 / - + = * + B 2 B 3 A 4 C 4 D 6 D 5 D 1

Quiz Complete