What is the primary difference between VLOOKUP and HLOOKUP functions?
The Complete Excel Guide: Beginners to Advanced - Lookup Functions - Part 2

Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
VLOOKUP searches horizontally, HLOOKUP searches vertically.
VLOOKUP searches vertically, HLOOKUP searches horizontally.
VLOOKUP is used for text, HLOOKUP is used for numbers.
VLOOKUP is faster than HLOOKUP.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What information is stored in the catalog used for the invoicing system?
Customer details and order history.
Discount rates and tax information.
Part numbers, descriptions, and prices.
Supplier information and delivery dates.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is it important to use named ranges in VLOOKUP?
To increase the speed of calculations.
To ensure compatibility with older versions of Excel.
To make formulas easier to read and manage.
To automatically update data from external sources.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the 'range lookup' argument in VLOOKUP specify?
The sheet to perform the lookup on.
The number of rows to search.
Whether to find an exact or approximate match.
The column to return data from.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does the IFNA function enhance the VLOOKUP formula?
It allows for multiple lookup values.
It automatically updates the lookup table.
It speeds up the lookup process.
It provides a default value when an error occurs.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What message is displayed if a part number is not found in the catalog?
Error: Invalid Part Number
Part Number Not Found
Please Enter a Valid Part Number
No Description Available
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using the TRIM function in the enhanced VLOOKUP formula?
To remove spaces from the part number.
To convert text to uppercase.
To check if the part number is blank.
To format the part number as a currency.
Similar Resources on Quizizz
5 questions
The Complete Excel Guide: Beginners to Advanced - Lookup Functions - Part 1

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Error Handling Functions

Interactive video
•
University
11 questions
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Exact Match)

Interactive video
•
University
4 questions
Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 2

Interactive video
•
University
2 questions
The Complete Excel Guide: Beginners to Advanced - Lookup Functions - Part 2

Interactive video
•
University
8 questions
The Complete Excel Guide: Beginners to Advanced - VLOOKUPS

Interactive video
•
University
5 questions
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Exact Match)

Interactive video
•
University
2 questions
The Complete Excel Guide: Beginners to Advanced - Lookup Functions - Part 1

Interactive video
•
University
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade