Review for Conditional Functions
6th Grade
•10 Qs
Similar activities
Mirosoft Excel Quiz- Mamta
6th - 8th Grade
•10 Qs
Year 7 - L1/L2 - Basic Spreadsheets Recall
6th Grade
•14 Qs
Evaluating Web Resources
4th - 12th Grade
•10 Qs
Types of Software (Week 2)
6th - 11th Grade
•12 Qs
认识电脑（2011~2018年）
6th - 8th Grade
•15 Qs
Python Graphics
6th - 8th Grade
•10 Qs
3.4 Pengalamatan IP pada jaringan komputer (KOMJARDAS)
1st Grade - University
•15 Qs
Python Niveau 1
6th - 8th 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
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
10 questions
Subnetting IPv4
Quiz
•
6th Grade - Professio...
15 questions
Cloud Computing Basics 1
Quiz
•
6th Grade
10 questions
Python
Quiz
•
5th - 8th Grade
10 questions
Transmission Media
Quiz
•
1st Grade - University
12 questions
Databases
Quiz
•
6th - 10th Grade
12 questions
Engineering Design Process
Quiz
•
6th - 8th Grade
10 questions
Программирование алгоритма 8 класс
Quiz
•
1st - 10th Grade
10 questions
6th grade Code.org Quiz
Quiz
•
6th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
