Excel Functions

Excel Functions

10th Grade

16 Qs

quiz-placeholder

Similar activities

Q1 W1 M1 PRE-TEST

Q1 W1 M1 PRE-TEST

10th Grade

15 Qs

Creative iMedia: Strengths, Weaknesses and Improvements

Creative iMedia: Strengths, Weaknesses and Improvements

10th Grade

11 Qs

Latihan Soal Administrasi Infrastruktur Jaringan XII TKJ

Latihan Soal Administrasi Infrastruktur Jaringan XII TKJ

10th - 12th Grade

20 Qs

Input Device

Input Device

9th - 10th Grade

16 Qs

Conditions

Conditions

8th - 10th Grade

16 Qs

3rd week g9 summative

3rd week g9 summative

7th - 12th Grade

15 Qs

Family Quizz

Family Quizz

5th Grade - Professional Development

15 Qs

Excel Functions

Excel Functions

Assessment

Quiz

Computers

10th Grade

Practice Problem

Medium

Created by

O Hawkridge

Used 12+ times

FREE Resource

AI

Enhance your content in a minute

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

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the MIN function?

Add the numerical values in a range of cells

Find the lowest number in a range of cells

Find the highest number in the range of cells

Finds the average from a range of cells

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

All functions and formulas begin with which symbol?

#

/

:

=

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which are the three essential elements to enter a function?

Equal sign, function name, and cell reference.

Equal sign, cell reference, and formula.

Function name, data, and cell reference.

Function name and cell reference.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?

Count

Count A

If

Sum

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of =C4 + C5

32

12

17

15

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which function is correct for adding up a selection of numbers?

sum(A1+A10)

=sum(A1+A10)

sum(A1:A10)

=sum(A1:A10)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function should be entered to calculate the total budget?

=AVERAGE(B3:B6)

=SUM(B3:B6)

=SUM(B3-B6)

=TOTAL(B3:B6)

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?