NEW
Font size
WorksheetsIF and Vlookup Function
Total questions: 15
Worksheet time: 8mins
If function allows to choose between two actions based on whether the condition is true or ..................
false
1
Yes
-1
IF function makes use of something called
functional operators
relational operators
relational database
absolute reference
Fill the missing
=IF(....................., value_if_true,value_if_false)
lookup_value
criteria
condition
logical_test
Function inside another function
vlookup function
nested function
nest function
if function
..................search for an item of data in a table and then extract the rest of information relating to that item
lookup ()
if ()
count()
sumif()
An example of a range address
A1;B3
A1:B3
A1-B3
A1.B3
What is the Keyboard shortcut to make a cell absolute reference?
F1
F2
F3
F4
Which of these is an absolute reference?
A3
A13
A$3$
A*3
Which of these Vlookup functions is searching for an exact match?
=VLOOKUP (True, A2:B6, 2, C16)
= VLOOKUP (C16, A2:B6,3, TRUE)
=VLOOKUP (C16, A2:B6, 3, FALSE)
=VLOOKUP (C16, A2:B6,1, $C$4:$D$15)
We want to make a Payment Type Column as a drop-down list. Which feature should we use?
Conditional formatting
Data validation
Bulleted list
Absolute cell reference
The first argument in a VLOOKUP function tells the function.................
What to look for
Where to look
To use an approximate or exact match
The column index number
Put "yes" if paid atleast $20 and "no" if paid less than $20 . What to put in cell C2?
=CONDITIONAL(B2>=20, "No","Yes")
=IF(B2>=20, "Yes","No")
=IF(B2=20, "Yes","No")
=CONDITIONAL(B2>20, "No", "Yes")
What value would excel return for this formula? =(82-32)5+8*2
30
21
26
37
VLOOKUP formula to be used to get result in the highlighted cell
=VLOOKUP(A2:B9,2,FALSE)
=VLOOKUP(D3,A2:B9,FALSE)
=VLOOKUP(D3,A2,2,FALSE)
=VLOOKUP(D3,A2:B9,2,FALSE)
Which of the formula below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, value)
=VLOOKUP(lookup_value, table_array, range_lookup)
