Basic Formulas In Excel Review

Basic Formulas In Excel Review

9th - 12th Grade

26 Qs

quiz-placeholder

Similar activities

Storage Hardware and Software

Storage Hardware and Software

9th - 10th Grade

25 Qs

Network Threat Prevention 2

Network Threat Prevention 2

8th - 10th Grade

25 Qs

Fun facts about video game design

Fun facts about video game design

4th Grade - Professional Development

21 Qs

1.3.4 Web Technologies

1.3.4 Web Technologies

12th Grade

22 Qs

VisualBasic Level 3

VisualBasic Level 3

10th Grade

23 Qs

IT in Everyday life

IT in Everyday life

10th Grade

23 Qs

Six Weeks Test 5th Form

Six Weeks Test 5th Form

11th Grade

23 Qs

Fourth Grade March Rivision

Fourth Grade March Rivision

4th Grade - University

24 Qs

Basic Formulas In Excel Review

Basic Formulas In Excel Review

Assessment

Quiz

Computers

9th - 12th Grade

Medium

Created by

Kristen Williams

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

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

26 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do in Excel?

Divides the numbers in a range of cells.

Adds up all the numbers in a range of cells.

Subtracts the numbers in a range of cells.

Multiplies all the numbers in a range of cells.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What symbol is used for division in Excel formulas?

//

-

/

:

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, how do you multiply two values using a formula?

Use the '*' operator in a formula.

Use the '/' operator in a formula.

Use the '+' operator in a formula.

Use the '-' operator in a formula.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the MAX function in Excel?

To find the average of a range of numbers

To find the highest number in a range of numbers

To multiply all numbers in a range

To divide all numbers in a range

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to find the sum of cells A1 to A10 in Excel?

=ADD(A1:A10)

=TOTAL(A1:A10)

=SUM(A1:A10)

=SUM(A1,A10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When typing formulas, they must begin with an __ sign.

=

&

~

< >

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the name of this cell?

B10
5B
B5
A5

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?