COUNTIFS AND SUMIFS (EXCEL)
Authored by Deon Strydom
Computers
Professional Development
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.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the SUMIFS function in Excel?
a. =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)
b. =SUMIF(sum_range, criteria_range, criteria)
c. =SUMIF(range, criteria)
d. =SUM(range)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the SUMIFS function?
a. To count the number of cells that meet one or more criteria
b. To sum the values in a range that meet one or more criteria
c. To find the average of values in a range that meet one or more criteria
d. To lookup a value in a table based on one or more criteria
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the COUNTIFS function in Excel?
a. =COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, ...)
b. =COUNTIF(range, criteria)
c. =COUNT(range)
d. =COUNTIF(criteria_range, criteria)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the COUNTIFS function?
a. To sum the values in a range that meet one or more criteria
b. To count the number of cells that meet one or more criteria
c. To find the average of values in a range that meet one or more criteria
d. To lookup a value in a table based on one or more criteria
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SUMIFS function, what is the purpose of the sum_range argument?
a. To specify the range of cells to be summed
b. To specify the criteria range
c. To specify the criteria
d. None of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the SUMIFS function, how many criteria ranges and criteria can be specified?
a. One criteria range and one criteria
b. One criteria range and multiple criteria
c. Multiple criteria ranges and one criteria
d. Multiple criteria ranges and multiple criteria
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the maximum number of criteria ranges and criteria that can be used in a single SUMIFS formula in Excel?
10
120
125
127
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?
