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

Question

Share Report Error

In Excel, what does the 'HLOOKUP' function stand for?

A. Hierarchical Lookup

B. Height Lookup

C. High Lookup

D. Horizontal Lookup

Answer: Option D

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.

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

Which function in Excel returns the average of cells that meet a given condition?

A. COUNTIF()

B. AVERAGEIF()

C. SUMIF()

D. AVERAGE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AVERAGEIF averages based on a criterion. AVERAGEIFS for multiple criteria.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following field keys in MS Access links a child table record to a primary key in a parent table?

A. Composite Key

B. Foreign Key

C. Candidate Key

D. Super Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Foreign Key matches the primary key field of another table to form relational links between distinct data records.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, a relationship between two tables that requires a third junction table is called:

A. Many-to-Many

B. One-to-Many

C. Self-join

D. One-to-One

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Many-to-many relationships need a junction table with foreign keys to both primary tables.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs