Review for Conditional Functions
6th Grade
•10 Qs
Similar activities
Looping / Conditionals
6th - 8th Grade
•12 Qs
Year 7 - L1/L2 - Basic Spreadsheets Recall
6th Grade
•14 Qs
Google & Google Search
6th Grade
•15 Qs
Цикл For (Python)
5th - 8th Grade
•10 Qs
认识电脑（2011~2018年）
6th - 8th Grade
•15 Qs
3.4 Pengalamatan IP pada jaringan komputer (KOMJARDAS)
1st Grade - University
•15 Qs
Mirosoft Excel Quiz- Mamta
6th - 8th Grade
•10 Qs
Evaluating Web Resources
4th - 12th Grade
•10 Qs
Review for Conditional Functions
Quiz
•
Computers
•
6th Grade
•
Practice Problem
•
Medium
Nikko JESORO
Used 13+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a range of data with some empty cells. You need to count the number of non-empty cells. Which function would you use?
COUNTA
SUMIF
AVERAGEIF
COUNTIF
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the COUNTIF function?
=COUNTIF(range, criteria)
=COUNTIF(criteria,range)
=COUNTA(range, criteria)
COUNTIF(range, criteria)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to calculate the average score for a particular category of data. Which function would you use?
AVERAGEIF
COUNTIF
SUMIF
MAX
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the AVERAGEIF function?
To count the number of cells in a range that meet a certain condition
To sum the values in a range that meet a certain condition
To evaluate a logical test and return a value if the test is true, and another value if the test is false
To calculate the average of a range of cells that meet a certain condition
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the AVERAGEIF function?
=AVERAGEIF(search range,criteria, average range )
AVERAGEIF(range, criteria)=AVERAGEIF(search range,criteria, average range )
=AVARAGEIF(search range,criteria, average range )
=AVERAGE(search range,criteria, average range )
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can be used to sum the values in a range that meet a certain condition?
SUM
SUMIF
SUMA
COUNTA
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Suppose you have a list of students and their scores in different subjects. Which function can you use to count the number of students who passed a particular subject?
COUNTA
SUMIF
AVERAGEIF
COUNTIF
Create a free account and access millions of resources
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
15 questions
认识电脑（2011~2018年）
Quiz
•
6th - 8th Grade
10 questions
Python Graphics
Quiz
•
6th - 8th Grade
15 questions
3.4 Pengalamatan IP pada jaringan komputer (KOMJARDAS)
Quiz
•
1st Grade - University
10 questions
Python Niveau 1
Quiz
•
6th - 8th Grade
10 questions
Evaluating Web Resources
Quiz
•
4th - 12th Grade
15 questions
Google & Google Search
Quiz
•
6th Grade
12 questions
Excel Basics
Quiz
•
5th - 10th Grade
12 questions
Types of Software (Week 2)
Quiz
•
6th - 11th Grade
Popular Resources on Wayground
10 questions
Forest Self-Management
Lesson
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
30 questions
Thanksgiving Trivia
Quiz
•
9th - 12th Grade
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
Discover more resources for Computers
30 questions
Thanksgiving Trivia
Quiz
•
6th Grade
11 questions
Would You Rather - Thanksgiving
Lesson
•
KG - 12th Grade
48 questions
The Eagle Way
Quiz
•
6th Grade
10 questions
Identifying equations
Quiz
•
KG - University
10 questions
Thanksgiving
Lesson
•
5th - 7th Grade
18 questions
Thanksgiving Trivia
Quiz
•
4th - 12th Grade
42 questions
MAP Math Review
Quiz
•
5th - 6th Grade
20 questions
Thanksgiving Trivia!
Quiz
•
6th - 8th Grade