EX_Count()
Authored by Yousra Abdelhamed
Computers
12th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
The COUNT function counts all the cells that contain numbers in a specified range.
Try typing =COUNT() to get a return value of 4!
(a)
2.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
COUNT only counts the cells that contain numbers.
What would =COUNT(A1:A5) return?
(a)
3.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Write a COUNT function that counts how many students have at least one pet.
(a)
4.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
The following table contains Q1 sales. Write a COUNT function to count how many sales people made at least one sale in January.
(a)
5.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Write a COUNT function that would count the number of months that Chuck made at least one sale in Q1 (January through March).
(a)
6.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
Management must calculate a monthly bonus each time an employee makes at least one sale during a given month.
Write a COUNT function to determine how many monthly bonuses must be calculated for Q1.
(a)
7.
FILL IN THE BLANK QUESTION
2 mins • 1 pt
What would =COUNT(A:B) return?
(a)
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?
