

Excel COUNT Functions and Criteria
Interactive Video
•
Computers, Education, Instructional Technology
•
7th - 10th Grade
•
Practice Problem
•
Medium
Jackson Turner
Used 1+ times
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary focus of the channel introduced in the video?
Fitness routines
Excel tutorials
Cooking tutorials
Travel vlogs
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to count the number of numerical entries in a dataset without any criteria?
SUM
AVERAGE
COUNT
COUNTA
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the difference between COUNT and COUNTA functions?
COUNT is for numbers, COUNTA is for text and numbers
COUNT is for text data, COUNTA is for numbers
COUNT is for adding numbers, COUNTA is for subtracting
COUNT is for criteria-based counting, COUNTA is not
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count entries based on a single criterion?
COUNT
COUNTA
COUNTIF
SUMIF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of adding 'A' to the COUNT function, as in COUNTA?
To count only cells with formulas
To count all cells, including text
To count only empty cells
To count only numerical cells
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does the COUNTIFS function differ from COUNTIF?
COUNTIFS can handle multiple criteria
COUNTIFS is used for summing data
COUNTIFS is for text data only
COUNTIFS is for numerical data only
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count the number of items that are both 'shampoo' and 'large'?
COUNT
COUNTA
COUNTIF
COUNTIFS
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
7 questions
Identifying Subjects and Verbs in Sentences
Interactive video
•
6th - 10th Grade
11 questions
Satellite Design and Functionality Concepts
Interactive video
•
7th - 10th Grade
6 questions
Public Health Information System Quiz
Interactive video
•
9th - 10th Grade
6 questions
PLC Timers and Counters Quiz
Interactive video
•
9th - 10th Grade
11 questions
Exploring Bohr Models and Lewis Dot Structures
Interactive video
•
6th - 10th Grade
11 questions
Exploring Chapter 8 of The Lightning Thief
Interactive video
•
6th - 10th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Computers
10 questions
Navigating Digital Citizenship and Online Safety
Interactive video
•
6th - 10th Grade
10 questions
Practice Typing
Quiz
•
8th Grade
20 questions
Computer / Internet Companies
Quiz
•
9th Grade
10 questions
Exploring the Basics of Google Sheets
Interactive video
•
9th Grade
10 questions
Exponent Rules
Quiz
•
9th - 12th Grade
20 questions
JavaScript - Karel
Quiz
•
9th - 10th Grade