Year 9 Spreadsheets

What is the space within the black border?

• a cell

• a box

• a variable

• a column

When you type a formula, what symbol must it start with?

• !

• *

• +

• =

In a cell reference, for example B2, what does the letter refer to?

• The row the cell is in.

• The worksheet the cell is in

• The column the cell is in.

• The spreadsheet the cell is in.

What would a spreadsheet be best used for?

• Writing a letter

• making a presentation

• keeping track of your savings or money

• searching for information

In a cell reference, such as B2, what does the number stand for?

• the column the cell is in

• the worksheet the cell is in

• the row the cell is in

• the value of the cell

Mathematical calculations in a spreadsheet are called:

• words

• values

• formulas

• labels

What function will add up all the numbers in a column?

• =IF(A1:A6)

• =SUM(E1:E5)

• =AVERAGE(E1:E5)

• =CONCAT(E1:E5)

Which of the following is an example of a multiplication formula?

• A-B

• =C10-B9

• 14 x 10 = 140

• =B2*B3

Which of the following cannot be used to create a spreadsheet?

• Microsoft Excel

• Google Sheets

• Google Docs

• Open Office Calc

Answer explanation

Google Docs is a word processor not a spreadsheet program

Which of the following is an example of an addition formula?

• =B4+D7

• 2+3+6=11

• F3*G7

• =B9/B6