Excel Functions Quiz

Excel Functions Quiz

9th - 12th Grade

20 Qs

quiz-placeholder

Similar activities

Quiz Aplikasi Pengolah Angka

Quiz Aplikasi Pengolah Angka

10th Grade - University

15 Qs

QUIZ TIK EXCEL

QUIZ TIK EXCEL

10th Grade - University

25 Qs

Microsoft Excel Review Quiz

Microsoft Excel Review Quiz

10th Grade

20 Qs

Konversi Bilangan

Konversi Bilangan

10th Grade - University

15 Qs

COMPUTERIZED ACCOUNTING

COMPUTERIZED ACCOUNTING

12th Grade

20 Qs

SUMATIF INFORMATIKA KELAS 9 SEM 1

SUMATIF INFORMATIKA KELAS 9 SEM 1

9th Grade

20 Qs

Quiz Microsoft Office

Quiz Microsoft Office

10th Grade

15 Qs

Grade 12D Excel Midterm Exam

Grade 12D Excel Midterm Exam

12th Grade

17 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

Information Technology (IT)

9th - 12th Grade

Practice Problem

Hard

Created by

Fadi Fadi

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do in Excel?

Adds all numbers in a selected range

Finds the largest number in a range

Finds the smallest number in a range

Counts the number of cells

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to find the highest value in a range?

AVERAGE()

MAX()

MIN()

COUNT()

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the MIN function return?

The total of all numbers in a range

The highest number in a range

The lowest number in a range

The average of a range

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the AVERAGE function in Excel?

Finds the highest value in a range

Finds the lowest value in a range

Finds the sum of numbers in a range

Finds the mean of numbers in a range

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a correct formula to get the sum of cells A1 to A10?

=ADD(A1:A10)

=SUM(A1:A10)

=TOTAL(A1:A10)

=COUNT(A1:A10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you enter =MAX(4, 8, 2, 10, 5), what will be the result?

2

4

10

8

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will =MIN(12, 7, 19, 5, 10) return?

12

7

5

10

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?