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. Approximate match

D. Exact match

Answer: Option D

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

In MS Word, what does the 'Gutter Margin' refer to?

A. The footer section containing page counts and file metrics

B. Margin space added to the binding side of a document to prevent text coverage during binding

C. Margin space reserved on the right to accommodate comments

D. The empty gap between two lines of text inside a paragraph

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A gutter margin adds extra buffer space to the side or top margin of a document intended for bookbinding, ensuring text remains fully legible.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the 'Zoom' feature (Summary Zoom, Slide Zoom, Section Zoom) is found under:

A. Slide Show -> Zoom

B. Design -> Zoom

C. Insert -> Zoom

D. View -> Zoom

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Zoom is under Insert tab (available in newer versions).

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to open the 'Spelling' dialog in MS Excel?

A. F7

B. Alt + F7

C. Shift + F7

D. Ctrl + F7

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F7 opens the Spelling dialog in Excel as well as Word.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs