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
20 questions
Pemrograman Blokly

Quiz
•
9th Grade - University
20 questions
YEAR 7 MID-TERM ASSESSMENT

Quiz
•
7th Grade - University
22 questions
Informatika Kelas 6

Quiz
•
6th Grade - University
16 questions
Mastering Excel Functions

Quiz
•
9th Grade
20 questions
Quiz Administrasi Perkantoran

Quiz
•
9th Grade - University
20 questions
Class 9 Viva Questions 9B mideterm

Quiz
•
9th Grade
20 questions
PTS INFORMATIKA SEMESTER GENAP

Quiz
•
8th Grade - University
18 questions
File Management, Operating Systems and More

Quiz
•
9th - 12th Grade
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