Excel Formulas and Function Quiz

Excel Formulas and Function Quiz

9th - 12th Grade

20 Qs

quiz-placeholder

Similar activities

Sourcing Finance 5.2

Sourcing Finance 5.2

10th Grade

15 Qs

Business studies class XII Quiz-2

Business studies class XII Quiz-2

12th Grade

20 Qs

Grade 12 BS Ch1

Grade 12 BS Ch1

12th Grade - University

16 Qs

FORM 5 END OF TERM 2 QUIZ

FORM 5 END OF TERM 2 QUIZ

9th - 12th Grade

20 Qs

Satisfying the Fashion Market Ch5/GW

Satisfying the Fashion Market Ch5/GW

9th - 12th Grade

15 Qs

Grade 10 BS Quiz

Grade 10 BS Quiz

10th Grade - University

20 Qs

How Marketing Influences Business

How Marketing Influences Business

12th Grade - University

16 Qs

MODULE 3 - POST-TEST - BASIC ACCOUNTING

MODULE 3 - POST-TEST - BASIC ACCOUNTING

10th Grade

20 Qs

Excel Formulas and Function Quiz

Excel Formulas and Function Quiz

Assessment

Quiz

Business

9th - 12th Grade

Medium

Created by

Carrie Flynn

Used 3+ times

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

3 mins • 1 pt

A function that returns the largest values in a set of values

MAX function
AVERAGE function
MIN function
SUM function

2.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

A function that determines the minimum value in a range of cells

MIN function
 MAX function
 SUM function
AVERAGE function

3.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

A predefined formula that performs a calculation

Function
AutoSum
Value
Variable

4.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

A function that totals all of the cells in a range

SUM function
MIN function
MAX function 
AVERAGE function

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Write a FORMULA or FUNCTION for the following:


Add cells A1 and B1

A1 + B1

=A1 + B1

=SUM(A1+B1)

SUM(A1+B1)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Write a FORMULA or FUNCTION for the following:


Add a range of cells C4 to C15

=SUM(C4:C15)

SUM(C4:C15)

=SUM C4:C15

=ADD(C4:C15)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Write a FORMULA or FUNCTION for the following:


Multiply cells A1 and B1

A1 * B1

=A1 * B1

MULTIPLY(A1:B1)

=A1 x B1

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?