VLOOKUP and COUNTIF Functions in Excel
Interactive Video
•
Computers
•
9th - 10th Grade
•
Practice Problem
•
Hard
Thomas White
FREE Resource
Read more
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the upper range for the first increment if the next range starts at 30?
28
29
30
31
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is F5 minus 1 used when determining the upper range?
To simplify calculations
To avoid errors
To be one number lower than the next highest
To match the lower range
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In which cell is the VLOOKUP formula used to find the letter grade for the first student?
F4
E4
D4
C4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the column index in the VLOOKUP function?
To set the lookup value
To identify the column with the desired data
To determine the table range
To specify the row number
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the range used in the VLOOKUP function for finding letter grades?
F4 through H8
D4 through D223
G1 through H10
A1 through B10
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of copying the VLOOKUP formula down the column?
It alters the column index
It fills in the rest of the grades
It modifies the lookup value
It changes the table range
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if the 'true' parameter is removed from the VLOOKUP function?
The table range will change
The function will not work
The column index will be incorrect
The result will be the same
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
