Quiz-summary
0 of 11 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
Information
It’s 15 minutes before The Big Meeting and your co-worker comes to you in a panic. All the VLOOKUP functions in his spreadsheet are broken! Fix them for him before time runs out and save the day.
Instructions: start the challenge, download the attached spreadsheet (requires Excel 2007 or higher), fix the VLOOKUP functions, and answer the challenge questions before time runs out. Time limit is 15 minutes.
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 11 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- Not categorized 0%
-
Congratulations!
You passed the challenge! Click View Questions to see your performance on individual questions. Registered Users – enter the code CAMDEN on the right sidebar to unlock your achievement and add to your Excel Score.
-
Nice try.
You need a score of 70% or higher to pass and unlock the achievement.
Click View Questions to see your performance on individual questions and click Restart Quiz to try again.
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- Answered
- Review
-
Question 1 of 11
1. Question
1. Download and the challenge spreadsheet
2. Fix the VLOOKUPs in Sheet1
3. Click Let’s Move On answer
Correct
Incorrect
-
Question 2 of 11
2. Question
Drag and drop to correctly order these VLOOKUP function arguments.
-
Lookup Value
-
Table Array
-
Column index number
-
Range Lookup
Correct
The correct order is lookup value, table array, column index number, range lookup.
Incorrect
The correct order is lookup value, table array, column index number, range lookup.
-
-
Question 3 of 11
3. Question
What is the problem with the Bank Account VLOOKUP in cell C5?
Correct
VLOOKUP functions cannot look left. Replace with an INDEX MATCH or cut and paste the entire employee ID column to the left of Bank Account.
Incorrect
VLOOKUP functions cannot look left. Replace with an INDEX MATCH or cut and paste the entire employee ID column to the left of Bank Account.
-
Question 4 of 11
4. Question
What is Customer ID #1071’s Bank Account?
Correct
Incorrect
-
Question 5 of 11
5. Question
What is the problem with the Name VLOOKUP in cell D5?
Correct
The lookup value is pointed to cell A5. Instead of a customer ID number the function is looking for a blank cell.
Incorrect
The lookup value is pointed to cell A5. Instead of a customer ID number the function is looking for a blank cell.
-
Question 6 of 11
6. Question
What is the customer’s name for customer ID 1068?
Correct
VLOOKUP functions cannot look left. Replace with an INDEX MATCH or cut and paste the entire employee ID column to the left of Bank Account.
Incorrect
VLOOKUP functions cannot look left. Replace with an INDEX MATCH or cut and paste the entire employee ID column to the left of Bank Account.
-
Question 7 of 11
7. Question
What is the problem with the Phone Number VLOOKUP in cell E5?
Correct
This is a tricky one. The table array is pointed to tab Sheet3 instead of Sheet2.
Incorrect
This is a tricky one. The table array is pointed to tab Sheet3 instead of Sheet2.
-
Question 8 of 11
8. Question
What is the Company Name for customer ID #1054?
Correct
Incorrect
-
Question 9 of 11
9. Question
What is the State for Customer ID #1100?
Correct
Incorrect
-
Question 10 of 11
10. Question
What is the problem with the YTD Sales VLOOKUP in cell H5?
Correct
The column index number is incorrect. It is looking up Last Sale instead of YTD Sales.
Incorrect
The column index number is incorrect. It is looking up Last Sale instead of YTD Sales.
-
Question 11 of 11
11. Question
What is the problem with the Last Sale VLOOKUP in cell I5?
Correct
The #REF error indicates that the function is looking out of range for the answer.
Incorrect
The #REF error indicates that the function is looking out of range for the answer.
