Basic Formulas In Excel Review

Basic Formulas In Excel Review

9th - 12th Grade

26 Qs

quiz-placeholder

Similar activities

Project Methodology Quiz

Project Methodology Quiz

12th Grade

22 Qs

For you

For you

2nd - 12th Grade

22 Qs

Computers For Fun

Computers For Fun

9th - 10th Grade

23 Qs

Y9 Creative iMedia RO81 Quiz Part 1

Y9 Creative iMedia RO81 Quiz Part 1

9th Grade

21 Qs

Intro - ICT - EPS Class 9 & 10

Intro - ICT - EPS Class 9 & 10

9th - 10th Grade

21 Qs

GEMATMW - Coding Theory

GEMATMW - Coding Theory

6th Grade - University

21 Qs

Cybersecurity Checkpoint 1

Cybersecurity Checkpoint 1

10th - 12th Grade

23 Qs

ĐỀ CƯƠNG ÔN TẬP TIN GK2 12

ĐỀ CƯƠNG ÔN TẬP TIN GK2 12

12th Grade

22 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

Create a free account and access millions of resources

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?