EA2 Ch4 Cell Reference and Operators Quiz

What is a relative cell reference in a spreadsheet?

• A relative cell reference in a spreadsheet is a reference to a cell that is based on its column position only.

• A relative cell reference in a spreadsheet is a reference to a cell that is based on its row position only.

• A relative cell reference in a spreadsheet is a reference to a cell that is based on its absolute position.

• A relative cell reference in a spreadsheet is a reference to a cell that is based on its relative position to another cell.

What is an absolute cell reference in a spreadsheet?

• A cell reference that is not allowed in a spreadsheet

• A cell reference that is only used once

• A cell reference that changes when copied or filled

• A cell reference that remains constant when copied or filled.

Which symbol is used to represent multiplication in spreadsheet formulas?

• +

• x

• *

• /

Which symbol is used to represent division in spreadsheet formulas?

• :

• *

• -

• /

Which symbol is used to represent addition in spreadsheet formulas?

• +

• /

• *

• -

What is a constant in a spreadsheet?

• A value that changes frequently

• A formula that calculates a result

• A cell that is left blank

• A value that does not change

What does the $ symbol represent in an absolute cell reference?

• $ symbol represents a relative cell reference.

• $ symbol represents a formula in a cell.

• $ symbol represents a locked cell in Spreadsheet.

• $ symbol represents an absolute cell reference.

What is the result of the formula =A1+B1*C1 when A1=2, B1=3, and C1=4?

• 20

• 24

• 14

• 9

Which of the following is an example of a relative cell reference?

• C$3

• $A1

• $D$4

• B2

Which of the following is an example of an absolute cell reference?

• A1

• $A$1

• $A1

• A$1