Review for Conditional Functions

Review for Conditional Functions

6th Grade

10 Qs

quiz-placeholder

Similar activities

Mirosoft Excel Quiz- Mamta

Mirosoft Excel Quiz- Mamta

6th - 8th Grade

10 Qs

Year 7 - L1/L2 - Basic Spreadsheets Recall

Year 7 - L1/L2 - Basic Spreadsheets Recall

6th Grade

14 Qs

Evaluating Web Resources

Evaluating Web Resources

4th - 12th Grade

10 Qs

Types of Software (Week 2)

Types of Software (Week 2)

6th - 11th Grade

12 Qs

认识电脑(2011~2018年)

认识电脑(2011~2018年)

6th - 8th Grade

15 Qs

Python Graphics

Python Graphics

6th - 8th Grade

10 Qs

3.4 Pengalamatan IP pada jaringan komputer (KOMJARDAS)

3.4 Pengalamatan IP pada jaringan komputer (KOMJARDAS)

1st Grade - University

15 Qs

Python Niveau 1

Python Niveau 1

6th - 8th Grade

10 Qs

Review for Conditional Functions

Review for Conditional Functions

Assessment

Quiz

Computers

6th Grade

Practice Problem

Medium

Created by

Nikko JESORO

Used 13+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?