CPA 3NT SST 4a

"$A$1:$D$5" What is this type of cell references?

• total cell references

• related cell references

• relative cell references

• absolute cell references

"A1:D5" What is this type of cell references?

• total cell references

• related cell references

• relative cell references

• absolute cell references

What are the two types of cell references? (select all that apply)

• total cell references
• related cell references
• relative cell references
• absolute cell references

By default, which type of cell references are used?

• relative cell references
• absolute cell references

When relative cell referencing is used in a formula, cell references ________ when we copy the formula from one cell to another

• change
• do not change

When absolute cell referencing is used in a formula, cell references ________ when we copy the formula from one cell to another

• change
• do not change

Absolute cell reference to the cell A1 is indicated by

• &A&1
• #A#1
• $A$1
• A1

What type of cell references are used here? Are they used correctly?

• relative cell references; used correctly

• relative cell references; used wrongly

• absolute cell references; used correctly

• absolute cell references; used wrongly