Spreadsheets Lesson

Spreadsheets Lesson

By Shahbaz Farooq

In this lesson you will:

●Use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /)

●Use the autofill tool to replicate cell data

Multiple Choice

Each box on a spreadsheet is called ....

• A Box

• A Square

• A Cell

• A Cube

Multiple Choice

This is called ....

• A Line

• A Tunnel

• A Strip

• A Row

Multiple Choice

This is called ....

• A Tower

• A Column

• A Row

• A Strip

Multiple Choice

What must every formula start with?

• -

• /

• =

• [

Multiple Choice

What does this symbol mean?

• Star

• Add

• Minus

• Times

Multiple Choice

What does this symbol mean?

• Slash

• Cross

• Times

• Divide

Multiple Choice

The postman dropped his letter what cell is it in?

• E7

• B4

• D7

• A3

Multiple Choice

The dog dropped his bone and ball on his way to the park what cell is it in?

• E12 and C3

• B4 and D1

• C10 and B6

• A4 and C1

Multiple Choice

will the formula work?

• Yes

• No

​Complete this activity on teams

​

Spring 1 Lesson 2​

Multiple Choice

In spreadsheets, columns are marked with _________.

• Letters
• Numbers
• = sign
• Both a letter and a number

Multiple Choice

In spreadsheets, rows are marked with _____.

• Letters
• Numbers
• = sign
• Both a letter and a number

Multiple Choice

Which of the following is an example of a cell reference or cell address?

• C
• 9
• B4
• =A1+A2

Multiple Choice

What are "numbers" classified as in a spreadsheet?

• Labels
• Formulas
• Values
• Cells

Multiple Choice

Which of the following is an example of a "function"?

• =A2 + A5
• =B7 * B9
• =Sum(C4:C15)
• = D3 / D6

Multiple Choice

What are "formulas" classified as in spreadsheets?

• Math problems
• Labels
• Values
• Cells

​Complete this Activity on teams 15 mins