Font size
S
M
L
XL
WorksheetsMS Excel Quiz (Part 3.1) [G6]
Total questions: 5
Worksheet time: 25mins
Name
Class
Date
1.
TRUE or FALSE
SUMIF and AVERAGEIF are basic computations combined with a conditional function.
(a)
2.
TRUE or FALSE
LOOKUP functions are used to find a value from a single row, column, or table.
(a)
3.
=VLOOKUP(E6,A2:B11,2,FALSE)
In the formula given above, what does the word FALSE mean?
a)
The value should be the exact match as in the table.
b)
The cell where the value should base its answer from.
c)
The range where the value should be coming from.
d)
The value is located on the second column of the reference table.
4.
TRUE or FALSE
HLOOKUP is used to get the comparison of values that are located in a column.
(a)
5.
Using the VLOOKUP function, type the formula to get the RANK in cell F2.
(a)
Reset
