Spreadsheets

Spreadsheets_1

Introducing the 1st part of Spreadsheets

Multiple Choice

What are the individual rectangles on a worksheet called?

• Rows

• Columns

• Cells

• Formulae

Multiple Select

This is a whole collection of cells going down the way

• Cell

• Column

• Formula bar

• Row

Multiple Select

This is where you type the formula

• Formula bar

• Row

• Cell

• Column

Multiple Select

What application do we use for spreadsheets?

• Microsoft Powerpoint

• Microsoft Word

• Microsoft Excel

• Microsoft Publisher

Multiple Select

This is one box in the spreadsheet

• Cell

• Column

• Formula Bar

• Row

Multiple Select

This is a whole collection of cells going along in a straight line

• Cell

• Column

• Formula Bar

• Row

Multiple Choice

Which cell contains the HIGHEST number?

• A1

• A2

• A3

• B1

• B2

The highest number is 100 and it is located in cell A2.

​

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below?

=A2*B3

• 15

• 18

• 20

• 50

A2 = 5

B3 = 10

5 * 10 = 50

​

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below? 

=A3/A1 

• 3

• 4

• 8

• 12

A3 = 6

A1 = 2

6/2 = 3

"6/2" means "6 divided by 2".

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below?

=SUM(B1:B3)

• 11

• 13

• 14

• 30

=SUM(B1:B3)

1 + 3 + 10 = 14

=SUM(B1:B3) tells the computer to add all of the values from B1 to B3.

Spreadsheet Formatting