Excel Quiz 13  LOOKUPs Quiz  Part I
By eforexcel20160105T17:35:09+00:00Saturday, May 30th, 2015Categories: QuizzesTags: Assessment, CHOOSE, Exam, HLOOKUP, LOOKUP, Quiz, Test, VLOOKUP3 Comments
Quizsummary
0 of 10 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
Information
The thirteenth quiz in the series to test your knowledge on Lookups in Excel. After you hit Finish Quiz, you can click on View Questions to compare your answers to correct answers.
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%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 Answered
 Review

Question 1 of 10
1. Question
What would be the answer for
=LOOKUP(48,{0,40,70,80,90},{"F","D","C","B","A"})Correct
Incorrect

Question 2 of 10
2. Question
Correct
Incorrect

Question 3 of 10
3. Question
What would be the answer for
=LOOKUP(1000,{0,40,70,80,90},{"F","D","C","B","A"})
Correct
Incorrect

Question 4 of 10
4. Question
Correct
Incorrect

Question 5 of 10
5. Question
Correct
Incorrect

Question 6 of 10
6. Question
What would be the answer for
=CHOOSE(3,0,8,11,3,12,56,9)
Correct
Incorrect

Question 7 of 10
7. Question
The syntax of VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). If range_lookup is either TRUE or omitted, the first column of table_array must be sorted in ascending order.
Correct
Incorrect

Question 8 of 10
8. Question
Correct
Incorrect

Question 9 of 10
9. Question
Correct
Incorrect

Question 10 of 10
10. Question
Correct
Incorrect