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. Looks up a value in the top row of a table and returns a value from a specified row below it

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

C. Performs a case-sensitive search

D. Searches horizontally for the maximum value

Answer: Option A

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, to delete a word to the left of the cursor, press:

A. Delete

B. Ctrl + Delete

C. Backspace

D. Ctrl + Backspace

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Backspace deletes the previous word.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, what is the shortcut to apply single line spacing?

A. Ctrl + 1

B. Ctrl + 2

C. Ctrl + 5

D. Ctrl + 0

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+1 single, Ctrl+2 double, Ctrl+5 1.5 line spacing. Ctrl+0 adds/removes space before paragraph.

This question belongs to: Computer Microsoft Office

Question #3

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

A. Both A and B

B. F5

C. Ctrl + F

D. Ctrl + G

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+G or F5 opens Go To.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs