Chapter 6: Spreadsheet

Which of these shows an example of a relative cell reference?

• A7

• 7

• A

• $A$7

Which of these shows an example of an absolute cell reference?

• $B$2

• B2

• 2

• B

What is the symbol used in a formula to make a cell reference absolute?

• $

• &

• =

• !

Absolute cell reference means the cell is locked and will not update when copied

• True

• False

On Excel, select A1:A10. Rename the cells as A5. Is this allowed?

• Yes

• No

On Excel, select A1:A10. Rename the cells as TEST. Is this allowed?

• Yes

• No

What will be displayed if you write in Excel:

=IF(3 < 10, “Correct”, “Wrong”)

• 3 < 10

• Correct

• Wrong

• Error

What will be displayed if you write in Excel:

=SUBSTITUTE("hello", "h", "H")

• hello

• Hello

• h

• H

SUBSTITUTE("hello", "h", "H")

=SUBSTITUTE("hello", "h", "H")

Do these functions give the same result if you copied each line in Excel?

• Yes

• No

What is the formula you should write at G6 to display Abu’s grade? Use VLOOKUP

• =VLOOKUP(F6, K5:L9, 2)

• =VLOOKUP(K5:L9, F6, 2)

• =VLOOKUP(F6, K5:L9, 1)

• =VLOOKUP(K5:L9, F6, 1)