Review Quiz

Review Quiz

1st - 5th Grade

40 Qs

quiz-placeholder

Similar activities

Vocabulary revision

Vocabulary revision

4th - 5th Grade

37 Qs

Excel MCQ

Excel MCQ

1st - 10th Grade

40 Qs

The Lost City - Chapter 5

The Lost City - Chapter 5

4th Grade

39 Qs

Welcome to level 4

Welcome to level 4

3rd Grade

35 Qs

EU4 U4L3

EU4 U4L3

1st - 6th Grade

45 Qs

Fun Trivia

Fun Trivia

5th - 6th Grade

45 Qs

English exam

English exam

1st - 5th Grade

41 Qs

Parts of Speech Grammar Review

Parts of Speech Grammar Review

5th Grade

39 Qs

Review Quiz

Review Quiz

Assessment

Quiz

English

1st - 5th Grade

Medium

Created by

Fadi Fadi

Used 1+ times

FREE Resource

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function should you use to count all non-blank cells in a range?

COUNT

COUNTA

COUNTIF

AVERAGE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the COUNTIF function?

To count cells that meet a specific condition

To count all numbers in a range

To sum a range of numbers

To calculate the average of a range

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the formula =MIN(A1:A10) return?

The largest number in A1 to A10

The sum of A1 to A10

The smallest number in A1 to A10

The average of A1 to A10

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If A1=10, A2=20, A3=30, A4=40, and A5=50, what will the formula =AVERAGE(A1:A5) return?

25

30

35

40

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function should you use to count the number of blank cells in a range?

COUNT

COUNTA

COUNTBLANK

COUNTIF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the formula: =SUMIF(D5:D14, "Pumpkin", E5:E14), which range will be added?

D5:D14

"Pumpkin"

E5:E14

None of the above

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the formula: =SUMIF(D5:D14, "Pumpkin", E5:E14), which part represents the criteria?

D5:D14

"Pumpkin"

E5:E14

None of the above

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?