How well do you know your LOOKUPs?
How well do you know your LOOKUPs?
Quizsummary
0 of 10 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
Information
So you think you know the LOOKUP functions well? Take this test to prove…
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
 Not categorized 0%

Here is how you fare…
Pos.  Name  Entered on  Points  Result 

Table is loading  
No data available  
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 Answered
 Review

Question 1 of 10
1. Question
When would you use FALSE as 4th parameter in VLOOKUP?
CorrectIncorrect 
Question 2 of 10
2. Question
Which of below formulas can be used to find if a value is available in a list of values?
CorrectIncorrect 
Question 3 of 10
3. Question
You have a list of invoice numbers & amounts in a range A1:B100. Some of the invoice numbers are duplicated. You wrote VLOOKUP to find amount corresponding to an invoice number. If that invoice has 2 entries, then VLOOKUP will,
CorrectIncorrect 
Question 4 of 10
4. Question
To trap errors in VLOOKUP, you can use this formula…
CorrectIncorrect 
Question 5 of 10
5. Question
You have a list with below columns
Invoice ID, Customer ID, Amount, Due Date
Now, you want to lookup the invoice ID for a given Customer ID. Which of below formulas you would use? Assume that your list is not in any particular order and there are no duplicate customer IDs.
CorrectIncorrect 
Question 6 of 10
6. Question
You have a list of invoice numbers & amounts in the range A1:B100. Some of the invoice numbers are duplicated. You want to find the last invoice amount for a given invoice number. Which formulas you would use?
CorrectIncorrect 
Question 7 of 10
7. Question
If the value you are looking up is not found, VLOOKUP will return #VALUE! error
CorrectIncorrect 
Question 8 of 10
8. Question
You have a list of employee names & their salary details.
Employee name, Salary, Special Allowance, Travel Allowance, Bonus
in 5 columns – A1:E100.
Your friend gave you below VLOOKUP formula
=SUMPRODUCT(VLOOKUP("Joyce", A1:E100, {2,3,4,5}, FALSE))
What would be the output of this?

Question 9 of 10
9. Question
You have a lot of customer data in range A1:Z1000. Col A has unique customer ID & rest of the 25 columns have data about that customer. You want to create a lookup sheet to show customer information. But you are too lazy to write 25 different VLOOKUPs. Which formula you will use along with VLOOKUP…
(Just type the formula name, no need to write ()s)
CorrectIncorrect 
Question 10 of 10
10. Question
You have 3 columns of data – Customer ID, Invoice ID & amount. You want to lookup by a combination of customer ID & invoice ID and fetch the corresponding amount. Which formula will help you?
CorrectIncorrect
Click here for Answers & Discussion.
Current leaders:
Leaderboard: How well do you know your LOOKUPs?
Pos.  Name  Entered on  Points  Result 

Table is loading  
No data available  