Using the SUM Function in Excel

Using the SUM Function in Excel

Assessment

Interactive Video

Computers

6th - 8th Grade

Practice Problem

Hard

Created by

Medina James

FREE Resource

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary purpose of the SUM function in Excel?

To subtract numbers

To multiply numbers

To quickly add up numbers

To divide numbers

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In what orientations can the SUM function be used to subtotal numbers?

Only vertically in a column

Only horizontally in a row

Vertically in a column or horizontally in a row

Diagonally across cells

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the total sum of the values 10.5, 7.2, 200, 5.4, and 8.1?

221.2

231.2

211.2

241.2

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the most efficient way to use the SUM function to add a range of cells from A2 to A6?

=A2+A3+A4+A5+A6

=SUM(A2,A3,A4,A5,A6)

=SUM(A2:A6)

=ADD(A2:A6)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To sum numbers horizontally in a row from cell A2 to E2, what is the correct syntax for the SUM function?

=SUM(A2+E2)

=SUM(A2;E2)

=SUM(A2-E2)

=SUM(A2:E2)

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?