Quiz: Built-in Functions (IF, COUNTIF, VLOOKUP)
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 11 steps including 9 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (11)
Building on what you've learned about formulae and operators, let's test your knowledge of built-in functions: IF, COUNTIF, and VLOOKUP!
What does the IF function primarily do in a spreadsheet?
Start the lesson to answer this multiple choice question
Which of the following are valid uses of the COUNTIF function? (Select all that apply)
Start the lesson to answer this multi-select question
The VLOOKUP function is used to {{blank0}} data from one column based on a {{blank1}} value.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
In the formula =IF(A1>10, "Yes", "No"), what will be returned if the value in A1 is 8?
Start the lesson to answer this multiple choice question
Which of the following are true about the VLOOKUP function? (Select all that apply)
Start the lesson to answer this multi-select question
What will be the result of =COUNTIF(A1:A10, ">5") if the range contains 3 values greater than 5?
Start the lesson to answer this math equation question
Match the items on the left with their correct pairs on the right
Which argument in VLOOKUP specifies the column number to retrieve data from?
Start the lesson to answer this multiple choice question
COUNTIF evaluates cells based on a {{blank0}} and counts those that {{blank1}}.
Start the lesson to answer this fill in the blank question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics