NEW
Font size
WorksheetsChapter 6: Spreadsheet
Total questions: 13
Worksheet time: 12mins
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)
What is the formula you should write at G18 to display Raju’s grade? Use HLOOKUP
=HLOOKUP(F18, L13:P14, 2)
=HLOOKUP(L13:P14, F18, 2)
=HLOOKUP(F18, L13:P14, 1)
=HLOOKUP(L13:P14, F18, 1)
What is a Pivot Table?
A table containing data that is organized horizontally
A table used to calculate financial pivot values
A tool used to summarize data
A table containing only black, grey and white formatting
In order to directly report the data, what must a Pivot Chart always be associated with?
Table
Range
Pivot Table
Worksheet
