
Excel - Conditional Functions
Authored by Ivy Professional School
Professional Development
Professional Development
Used 61+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
OPEN ENDED QUESTION
2 mins • Ungraded
Full Name
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
2 mins • Ungraded
Student Id (ID No.)
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
2 mins • Ungraded
Email ID
Evaluate responses using AI:
OFF
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
CountA function can count on the following:
Numbers
Text
Blank Cells
Non-blank Cell
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the syntax for Averageifs?
Average_range, criteria_range1, criteria,...
Criteria_range1, Criteria, Average_range,....
Criteria, Criteria_range1, Average_range,...
Criteria_range1, Average_range, Criteria,..
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
John wishes to count all the products that have been marked with a Yes in the Expired column B5:B9) AND under the Stored column (C5:C9) is marked as Refrigerator. Which of the functions below will permit him to calculate this when entered into cell B11 (the highlighted cell in the screenshot alongside)?
=COUNTIF(B5:B9,”Yes”,C5:C9,”Refrigerator”)
=SUMIFS(B5:B9,”Yes”,C5:C9,”Refrigerator”)
=IFS(B5:B9,”Yes”,C5:C9,”Refrigerator”)
=COUNTIFS(B5:B9,”Yes”,C5:C9,”Refrigerator”)
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which formula shall yield us the average income of employees in Ohio?
=averageif(C2:C10, "OHIO", C2:C10)
=averageif("Ohio", C2:C10, A2:A10)
=averageif(A2:A10, "Ohio", C2:C10)
=averageifs(A2:A10, "Ohio", C2:C10)
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
13 questions
Tax Invoice, Debit & Credit Note & E-Way Bill
Quiz
•
Professional Development
10 questions
Sales Course- Module 5 Quiz
Quiz
•
Professional Development
11 questions
Certification
Quiz
•
Professional Development
10 questions
Project Management Master Class 1
Quiz
•
Professional Development
10 questions
Selling Skills
Quiz
•
Professional Development
10 questions
Know Your Rubrics!
Quiz
•
Professional Development
9 questions
5S
Quiz
•
Professional Development
10 questions
Icetex
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade