In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:

A. Descending order

B. Closest match

C. Exact match

D. Approximate match

Answer: Option C

Solution (By JKSSB Mock Tests)

FALSE requires an exact match. TRUE or omitted allows 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

Share Report

In MS Access, which query type can be executed to add brand new rows of records from an external source or table directly into an existing table?

A. Make-Table Query

B. Append Query

C. Update Query

D. Delete Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An Append Query selects records from one or more data sources and adds them to the end of an existing target table.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

To close an active workbook in Excel, you can use:

A. Ctrl + F4

B. Both A and B

C. Alt + F4

D. Ctrl + W

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+W and Ctrl+F4 close the workbook window. Alt+F4 exits Excel.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which of the following is NOT a field data type?

A. Long Text

B. Memo

C. Calculated

D. Lookup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Lookup is not a data type; it's a field property (using Lookup Wizard). Data types include Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs