Spreadsheet Basics Quiz

What are the four main mathematical operators on a spreadsheet?

• Addition, Subtraction, Multiplication, Division

• Addition, Subtraction, Exponentiation, Modulus

• Addition, Subtraction, Concatenation, Division

• Addition, Subtraction, Multiplication, Concatenation

What is a cell reference?

• A unique identifier for a cell, which is formed by combining the column letter and row number

• A formula used to calculate values in a spreadsheet

• A type of data validation rule

• A method to format cells in a spreadsheet

Which of the following symbols is used for addition in a spreadsheet?

• -

• *

• /

• +

What identifies a cell on a spreadsheet?

• The color of the cell

• The letter and number that identifies a cell

• The size of the cell

• The font used in the cell

What can spreadsheets be used to display?

• Text, dates, and numbers

• Images and videos

• Only text

• Only numbers

Why would you use a spreadsheet rather than a database or a table on a word processed document?

• Because it looks better

• Because it can perform calculations for you

• Because it is easier to use

• Because it is more secure

What must all formulae in a spreadsheet start with?

• +

• -

• =

• *

What can you use to perform calculations in a spreadsheet?

• Only numbers

• Only cell references

• Either numbers or cell references

• Only text

What must all formulae start with in a spreadsheet?

• +

• -

• =

• *

What will you see when you enter a formula into a cell?

• The formula itself

• The result/answer

• An error message

• A blank cell