| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Excel Lookup & Text Functions Quiz
Excel Lookup & Text Functions Quiz
Question 1
What does the VLOOKUP function primarily do?
Looks for a value in a row and returns a value from the same row
Looks for a value in a column and returns a value from the same row
Searches horizontally only
Returns the maximum value in a range
Question 2
In =VLOOKUP(50, A2:D10, 3, FALSE), what does the number 3 represent?
Row number to return
Column number in the table array
Number of results to return
Number of rows to skip
Question 3
In a VLOOKUP function, when should the last argument be TRUE?
When an exact match is required
When an approximate match is acceptable
When using text values
When using HLOOKUP instead
Question 4
What is the difference between VLOOKUP and HLOOKUP?
VLOOKUP searches vertically, HLOOKUP searches horizontally
VLOOKUP is faster than HLOOKUP
HLOOKUP works only with text
Both are identical
Question 5
What does the formula =INDEX(A1:C5, 2, 3) return?
The value at column 2, row 3
The value at row 2, column 3
The sum of row 2 and column 3
An error
Question 6
Which formula returns the position of value 50 in the range A1:A10?
=MATCH(50,A1:A10,0)
=INDEX(A1:A10,50)
=VLOOKUP(50,A1:A10,1,FALSE)
=SEARCH(50,A1:A10)
Question 7
Why is INDEX with MATCH often preferred over VLOOKUP?
It can search both horizontally and vertically
It is faster than VLOOKUP
It doesn’t require the lookup column to be the first column
All of the above
Question 9
Which formula returns the last 2 characters of the word "Training"?
=LEFT("Training",2)
=MID("Training",2,2)
=RIGHT("Training",2)
=TRIM("Training",2)
Question 10
Which formula correctly joins the first name in A1 and last name in B1 with a space in between?
=CONCATENATE(A1,B1)
=A1+B1
=A1&" "&B1
=JOIN(A1,B1)
There are 10 questions to complete.
