Spreadsheet Lesson Ark

​Complete the worksheet below after you have logged in and joined this quiz.

By Shahbaz Farooq

​L/O: Understand how calculations are used in a spreadsheet.

Multiple Choice

A vertical line of cells in a spreadsheet is a what?

• Row

• Column

Multiple Choice

A horizontal line of cells in a spreadsheet is a what?

• Row

• Column

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

A group of cells in a spreadsheet

• Cell reference
• Cell range
• Active cells
• Formulas

Multiple Choice

a file which contains one or more spreadsheets.

• Workbook
• Spreadsheet
• Cells
• Entry

Multiple Choice

Why do people use spreadsheets?

• To make presentations.

• To build a resume'.

• To write an essay.

• To sort information and calculate numbers.

Multiple Choice

Which of the following would be a reason you could use a spreadsheet?

• To make a presentation

• To organize a list of students

• To write an essay

• To type an email

Fill in the Blank

A _______ is a vertical set of cells named by using a letter.

Fill in the Blank

A _____ is a horizontal set of cells named using numbers.

Multiple Choice

Which of the following do you use to begin a formula?

• =

• X

• *

• +

Multiple Choice

individual locations on a spreadsheet.

• Workbook
• Spreadsheet
• Cell
• Entry

Multiple Choice

A4 is an example of...

• Cell Address
• Cell Range
• Formula
• Function

Multiple Choice

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

• C
• 9
• B4
• =A1+A2

Multiple Choice

What is the name of this cell?

• B10
• 5B
• B5
• you cannot know the name from this picture

Multiple Choice

What is displayed in cell B1?

• 100
• Tickets Sold
• Day
• B1

Multiple Choice

What does cell B6 contain?

• 23
• 0.45
• 0.50
• 23

​L/O: Understand how calculations are used in a spreadsheet.

​Does any one know how calculations are used in a spreadsheet ?

Multiple Choice

Something that automatically calculates something for you using the data in cells is a:

• Formula

• Formatting

Multiple Choice

What do all formulae start with in a spreadsheet?

• +

• /

• *

• =

Multiple Choice

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

• /

• -

• +

• =

Multiple Choice

Which mathematical operator (symbol) would you use to divide the values in two cells?

• /

• -

• *

• =

Multiple Choice

Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?

• /

• -

• *

• =

Open Ended

Looking at the spreadsheet what is the formula for 14 x 7 = ?

Open Ended

Looking at the spreadsheet what is the formula for 179 + 56 = ?

Open Ended

Looking at the spreadsheet what is the formula for 625 – 341 = ?

Open Ended

Looking at the spreadsheet what is the formula for 8 x 77 = ?

Open Ended

Looking at the spreadsheet what is the formula for 764 ÷ 4 = ?

​Check your answers

Poll

How many questions did you get right ?

• < = 1

• 2

• 3

• 4

• 5

Multiple Choice

A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.

• FUNCTION

• FORMULA

• CELL

• ROW

Multiple Choice

Which of the following is a FORMULA that will add cells c9 and c10?

• =c9+c10
• c9+c10
• sum(c9:c10)
• =sum(c9:c10)

Multiple Choice

A4 is an example of...

• Cell Address
• Cell Range
• Formula
• Function