What does the SUM function do?

Excel Chapter 5

Quiz
•
Information Technology (IT)
•
9th Grade
•
Medium
Morgan Hach
Used 2+ times
FREE Resource
21 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
finds the total of the closest four cells
totals all of the cells in the selected range
the sum function adds and subtracts cell values
counts the number of cells selected
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNT function do?
counts the number of cells in a range
counts the numbers in the cell
totals all of the cells in the selected range
counts the number of cells in a range that contain a number
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the AVERAGE function do?
Finds the average of the selected numbers
Finds the average of dollar values only
Finds the average of percentages only
Finds the average of the entire worksheet
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you wanted to find the smallest number in a range of cells what function would you use?
MIN
MAX
AVERAGE
COUNTA
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you wanted to find the largest number in a range of cells what function would you use?
MIN
MAX
AVERAGE
COUNTA
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to add a range of cells and then divide by the number of cell entries, determine the mean value of all values in the range which function should you use?
MIN
MAX
AVERAGE
COUNTA
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to determine the number of non-blank cells in your worksheet which function should you use?
MIN
MAX
AVERAGE
COUNTA
Create a free account and access millions of resources
Similar Resources on Wayground
17 questions
Mastering Spreadsheet Functions Quiz

Quiz
•
9th Grade
17 questions
Mastering Spreadsheet Functions

Quiz
•
9th Grade
17 questions
Operating Systems and Excel Quiz

Quiz
•
9th - 12th Grade
20 questions
Mastering the SUMIF Function

Quiz
•
9th Grade
25 questions
KUIS TIK KELAS 7

Quiz
•
7th Grade - University
22 questions
MS Excel

Quiz
•
4th Grade - University
20 questions
Initial test digitalization

Quiz
•
9th - 12th Grade
20 questions
Informatika

Quiz
•
8th Grade - University
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade