Data Lookup in Excel
Authored by Boon Wee Low
Information Technology (IT)
9th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do in Excel?
The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.
The VLOOKUP function sorts data in a table.
The VLOOKUP function calculates the sum of a column.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you specify the table_array range for the HLOOKUP function?
Use a single cell reference like A1.
Use a range reference like A1:D10 for the table array.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the MATCH function in indexing?
To find the position of a value in a range.
To calculate the average of a range.
To sort values in ascending order.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Can VLOOKUP search for values to the left of the lookup column?
Yes, VLOOKUP can search for values to the left of the lookup column.
VLOOKUP can search both left and right of the lookup column.
No, VLOOKUP cannot search for values to the left of the lookup column.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the difference between VLOOKUP and HLOOKUP?
VLOOKUP is for vertical lookups, while HLOOKUP is for horizontal lookups.
VLOOKUP is used for searching in databases, while HLOOKUP is for spreadsheets.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
