In Excel, what does the 'HLOOKUP' function stand for? MCQ with Answer and Explanation

In Excel, what does the 'HLOOKUP' function stand for?
A. Horizontal Lookup
B. High Lookup
C. Height Lookup
D. Hierarchical Lookup
Answer: Option A
Solution (By JKSSB Mock Tests)
HLOOKUP stands for Horizontal Lookup, used to search for a value in the top row of a table and return a value from a specified row.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, which of the following is not a valid field property?
A. Format
B. Caption
C. Sort Order
D. Field Size

Correct Answer: Option C


Explanation:
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option is used to insert a video from a file?
A. Insert > Video > This Device
B. Both A and B
C. Insert > Media > Video
D. Insert > Object

Correct Answer: Option B


Explanation:
You can insert video from file via Insert > Video > This Device (or Similar).

This question belongs to: Computer Microsoft Office
Question #3
In MS PowerPoint, what is the purpose of the 'Slide Show' tab?
A. To design slides
B. To set up and run the presentation
C. To add animations
D. To insert media

Correct Answer: Option B


Explanation:
The Slide Show tab contains options to start the slideshow, set up the show, rehearse timings, etc. Animations are on the Animations tab, Insert is for media, Design is for design.

This question belongs to: Computer Microsoft Office