WorksheetsVLOOKUP Function in Excel Quiz
Total questions: 10
Worksheet time: 5mins
What does the VLOOKUP function do in Excel?
It searches down the leftmost column and returns a value from another column.
It adds all the numbers in a column.
It sorts data alphabetically.
It creates a chart from selected data.
What is the first step to use VLOOKUP in the given example?
Type the phone number in cell B12
Type the name "David Beckham" in cell B12
Type "=VLOOKUP" in cell B12
Type the name "David Beckham" in cell C12
How does VLOOKUP help in finding a phone number from a list?
By matching the name and returning the corresponding phone number
By calculating the average of all phone numbers
By deleting the name from the list
By sorting the names alphabetically
What type of data should be entered into the Excel worksheet for the VLOOKUP example?
Names and phone numbers
Names and addresses
Phone numbers and emails
Addresses and emails
If you want to automatically return a phone number by typing a name, which Excel function should you use?
SUM
VLOOKUP
AVERAGE
COUNT
Which number is typed in the Col_index_num box in the VLOOKUP example?
2
1
10
12
What does the VLOOKUP function do in plain English according to the material?
Looks down the leftmost column to find a value, then returns a value from the same row in another column
Adds all the numbers in a column
Sorts the data alphabetically
Deletes duplicate values from a table
After locating "David Beckham" in the leftmost column, what should you do next according to the VLOOKUP process?
Move along the row to the second column and return the value in that cell
Delete the row
Copy the entire row to another sheet
Change the column index number to 1
Why might you use your mouse to click on cell B12 when setting up the VLOOKUP function?
To select the cell for data entry
To delete the cell contents
To change the cell color
To sort the table
Suppose you want to find phone numbers for two other people using VLOOKUP. What information do you need to change in the function for each search?
The Lookup_value
The Table_array
The Col_index_num
The Range_lookup
