Vlookup Formula in Excel

Vlookup Formula in Excel

Professional Development

10 Qs

quiz-placeholder

Similar activities

Arrays & Strings using C

Arrays & Strings using C

Professional Development

15 Qs

RMM | Javascript (20th March 2020)

RMM | Javascript (20th March 2020)

Professional Development

8 Qs

POP Quiz! Excel - More Than Spreadsheet

POP Quiz! Excel - More Than Spreadsheet

Professional Development

15 Qs

Pre Test Pelatihan M.Excel

Pre Test Pelatihan M.Excel

Professional Development

10 Qs

Excel Training Learning Resources

Excel Training Learning Resources

Professional Development

10 Qs

INTELLISY

INTELLISY

Professional Development

15 Qs

4 - edspert.id

4 - edspert.id

Professional Development

10 Qs

WEEK 2 PART 2/2

WEEK 2 PART 2/2

Professional Development

15 Qs

Vlookup Formula in Excel

Vlookup Formula in Excel

Assessment

Quiz

Computers

Professional Development

Medium

Created by

Sharad Choudhari

Used 92+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Vlookup stand for in Excel?

Variable Lookup

Vertical Lookup

Vertical Loop

Virtual Lookup

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the syntax of the Vlookup formula?

=SUMIF(range, criteria, [sum_range])

=INDEX(lookup_array, MATCH(lookup_value, lookup_array, 0))

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using Vlookup in Excel?

To search for a value in a table and return a corresponding value from another column.

To insert a new row in the spreadsheet

To change the font style of a cell

To calculate the sum of a range of cells

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the four arguments of the Vlookup function?

lookup_value, table_array, row_index_num, and range_lookup

search_value, data_array, col_index_num, and exact_match

value_to_find, array_to_search, index_num, and approximate_match

lookup_value, table_array, col_index_num, and range_lookup

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How does Vlookup search for a value in a table?

It searches for a value in the rightmost column of a table.

It searches for a value in the middle column of a table.

It searches for a value in the leftmost column of a table.

It searches for a value in all columns of a table.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens if the lookup value is not found in the table?

Lookup value becomes zero

#N/A or #VALUE!

Table explodes

Error 404

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Can Vlookup be used to search for values in multiple columns?

No

Only if the columns are adjacent

Yes, but only in specific versions of Excel

Yes, always

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?