What is the purpose of the HLOOKUP function in Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of the HLOOKUP function in Excel?

A. Searches horizontally for the maximum value

B. Looks up a value in the top row of a table and returns a value from a specified row below it

C. Performs a case-sensitive search

D. Looks up a value in the leftmost column and returns from a column to the right

Answer: Option B

Solution (By JKSSB Mock Tests)

HLOOKUP searches for a value in the first row and returns from a specified row. VLOOKUP searches in first column.

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, the 'Watermark' feature is used to:

A. Insert a border around the page

B. Add a background image or text behind the main content

C. Add a header or footer

D. Protect the document from editing

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A watermark is a faded background image or text (like 'Draft' or 'Confidential') that appears behind the document text. It does not protect, border, or header/footer.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key to open the 'Find and Replace' dialog in MS Word with the Go To tab active?

A. Both A and C

B. F5

C. Ctrl + H

D. Ctrl + G

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+G and F5 both open the Go To tab of Find and Replace.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, what feature allows you to display a small floating video panel of the presenter alongside the slides?

A. SmartArt

B. Presenter Coach

C. Screen Recording

D. Cameo

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Cameo feature inserts a live camera feed directly onto a presentation slide, allowing presenters to integrate video into the layout.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs