Excel Functions Quiz

Excel Functions Quiz

10th Grade

21 Qs

quiz-placeholder

Similar activities

Excel quiz

Excel quiz

10th Grade

20 Qs

INFORMATIKA 2

INFORMATIKA 2

1st - 12th Grade

20 Qs

HKDSE 資訊及通訊科技科 試算表及數據庫

HKDSE 資訊及通訊科技科 試算表及數據庫

10th - 12th Grade

23 Qs

Thor quizz เอ็กเซล

Thor quizz เอ็กเซล

6th Grade - University

16 Qs

Fungsi Program Pengolah Angka

Fungsi Program Pengolah Angka

10th Grade

25 Qs

Kuis Microsoft Excell - Kelas 10/11

Kuis Microsoft Excell - Kelas 10/11

10th Grade

20 Qs

ASESMEN TENGAH SEMESTER 1

ASESMEN TENGAH SEMESTER 1

9th Grade - University

25 Qs

Wochenquiz KW34

Wochenquiz KW34

9th - 12th Grade

17 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

Computers

10th Grade

Hard

Created by

Tak Cheung

Used 2+ times

FREE Resource

21 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is the primary purpose of the `SUMIF` function in Excel?

To count cells that meet a criterion

To sum values based on a single criterion

To calculate the average of a range

To apply formatting to cells

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct syntax for the `SUMIF` function?

=SUMIF(range, criteria, sum_range)

=SUMIF(criteria, sum_range, range)

=SUMIF(range, sum_range, criteria)

=SUMIF(sum_range, range, criteria)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the formula `=SUMIF(A2:A10, ">50", B2:B10)`, what does `A2:A10` represent?

The range of values to sum

The range where the criteria will be applied

The sum range

The result cell

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these functions is used to sum values based on multiple criteria?

SUM

SUMIF

COUNTIF

SUMIFS

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the `SUMIFS` function, the order of criteria ranges and criteria must:

Be in any order

Match exactly

Be reversed

Have only one criteria

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The formula `=SUMIF(B2:B20, "East", C2:C20)` will do what?

Sum values in `B2:B20`

Sum values in `C2:C20` where values in `B2:B20` equal "East"

Count cells in `B2:B20`

Return an error

7.

OPEN ENDED QUESTION

3 mins • 1 pt

Which of these formulas calculates the total sales for “Product A” in the “North” region?

Evaluate responses using AI:

OFF

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?