
Excel COUNT Functions and Criteria

Interactive Video
•
Computers, Education, Instructional Technology
•
7th - 10th Grade
•
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
Create a free account and access millions of resources
Similar Resources on Wayground
11 questions
Understanding the OFFSET Function in Excel

Interactive video
•
9th - 10th Grade
11 questions
Kuis Microsoft Excel: Rumus dan Fungsi

Interactive video
•
7th - 10th Grade
11 questions
Excel Functions for Counting and Summing

Interactive video
•
6th - 10th Grade
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Counting Values and Blanks

Interactive video
•
9th - 10th Grade
11 questions
Excel Functions and Their Uses

Interactive video
•
7th - 12th Grade
9 questions
Understanding Sumproduct in Excel

Interactive video
•
9th - 10th Grade
11 questions
Kuis Microsoft Excel

Interactive video
•
7th - 12th Grade
11 questions
Excel Functions and Formulas

Interactive video
•
9th - 10th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade
Discover more resources for Computers
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
20 questions
Guess The Cartoon!

Quiz
•
7th Grade