Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Horizontally Using HLOOKUP

This video tutorial explains the difference between VLOOKUP and HLOOKUP in Excel. It demonstrates how to transpose data from a vertical to a horizontal format and perform lookups using the HLOOKUP function. The tutorial includes a practical example using movie data to illustrate how to retrieve information such as the year, rating, and genre using HLOOKUP.

What is the primary difference between VLOOKUP and HLOOKUP?

• VLOOKUP is faster than HLOOKUP.

• VLOOKUP searches horizontally, HLOOKUP searches vertically.

• VLOOKUP searches vertically, HLOOKUP searches horizontally.

• VLOOKUP is used for numbers, HLOOKUP for text.

Which Excel command is used to change data orientation from vertical to horizontal?

• Rotate

• Switch

• Transpose

• Flip

When using HLOOKUP, what do you specify instead of a column index number?

• Cell index number

• Table index number

• Sheet index number

• Row index number

What is the purpose of creating a named range in Excel?

• To format cells

• To easily reference a data set

• To sort data

• To filter data

In the HLOOKUP function, what does the 'FALSE' argument indicate?

• An approximate match

• A case-sensitive match

• An exact match

• A partial match

What information was retrieved using HLOOKUP in the practical example?

• Movie director

• Movie year, rating, and genre

• Movie budget

• Movie cast

What is the main factor that determines whether to use VLOOKUP or HLOOKUP?

• The type of data

• The orientation of the data

• The version of Excel

• The size of the data set