Knowledge Check: Absolute vs. Relative References, Putting Formulas into Action Questions with Correct Answers

Knowledge Check: Absolute vs.
Relative References, Putting Formulas
into Action Questions with Correct
Answers

What is the main difference between a relative cell reference and an absolute cell
reference?

Absolute references change when a formula is copied to another cell, Relative
references remain constant, no matter where they are copied.
Absolute references change vary from cell to cell, Relative references vary from column
to column.
Relative references change when a formula is copied to another cell, Absolute
references remain constant, no matter where they are copied.
Relative references change vary from cell to cell, Absolute references vary from column
to column. - ANSWERSRelative references change when a formula is copied to another
cell, Absolute references remain constant, no matter where they are copied.

What set of symbols do Smartsheet formulas use to denote what information is a
column name?

Use two : : colons
Use two { } curly brackets
Use two < > angled brackets
Use two [ ] square brackets - ANSWERSUse two [ ] square brackets

If you want to prevent Smartsheet from automatically updating cell references when a
formula is moved or copied, you should create:

Relative Reference
Absolute Reference - ANSWERSAbsolute Reference

If you want to create a formula in Smartsheet that changes when it is copied to another
cell, you should create:

Relative Reference
Absolute Reference - ANSWERSRelative Reference

To create an absolute reference, what symbol would you add in front of the column
name or row number in the cell reference of your formula?