In Excel, which function is used to perform a vertical lookup with approximate match? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to perform a vertical lookup with approximate match?

A. XLOOKUP

B. INDEX MATCH

C. VLOOKUP(lookup_value, table_array, col_index, TRUE)

D. HLOOKUP

Answer: Option C

Solution (By JKSSB Mock Tests)

VLOOKUP with TRUE (or omitted) performs approximate match.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS Word, to insert an index, go to:

A. Layout -> Index

B. Review -> Index

C. References -> Insert Index

D. Insert -> Index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Index is under References tab.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Row Source' property of a combo box determines:

A. The field where the selected value is stored

B. The SQL query to update records

C. The default value

D. The list of values displayed for selection

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Row Source provides the data for the list.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, what does the formula =TRIM(A1) do?

A. Removes all extra spaces from text except single spaces between words

B. Deletes non-printable characters

C. Removes all spaces from the text

D. Converts text to proper case

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TRIM removes leading, trailing, and repeated spaces. CLEAN removes non-printable characters.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs