

Understanding the SUM Formula in Excel
Interactive Video
•
Mathematics, Computers
•
5th - 8th Grade
•
Practice Problem
•
Hard
Liam Anderson
FREE Resource
Read more
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main topic discussed in the introduction of the video?
How to create charts in Excel
Formatting cells in Excel
Using pivot tables in Excel
Calculating totals using the SUM formula in Excel
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in using the SUM formula in Excel?
Save the Excel file
Open a new Excel file
Select the cells to be summed
Prepare the data you want to sum
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct syntax for the SUM formula?
=SUM(D6,D15)
=SUM(D6-D15)
=SUM(D6;D15)
=SUM(D6:D15)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if the SUM formula is entered correctly?
The Excel file closes
An error message appears
The cells are highlighted
The total is calculated automatically
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the video encourage viewers to do after learning about the SUM formula?
Read a book on Excel
Watch another video
Try using the formula themselves
Attend a workshop
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?