Excel Functions (AutoSum, Average, Max, Min)
Authored by Arslan Akram
Other
10th Grade
Used 5+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to calculate the total sum of numbers in Excel?
SUM
TOTAL
ADD
COUNT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you find the average of a group of numbers in Excel?
MEAN
SUM/NUMBER
MEDIAN
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the maximum value from a set of numbers in Excel?
UPPER
HIGHEST
MAX
LARGE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function do you use to find the minimum value in a range of numbers in Excel?
MIN
LOWEST
SMALLEST
LESS
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you count the number of entries in a list of numbers in Excel?
LENGTH
COUNT
NUMBER
SUM
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of using the AVERAGE function on the numbers 84, 92, and 78 in Excel?
84
84.6667
85
251.6667
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a function mentioned in the lesson?
SUM
DIVIDE
AVERAGE
MAX
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?
Similar Resources on Wayground
7 questions
TCE, ATAR & VET Tas
Quiz
•
10th Grade
9 questions
PJ MASKS
Quiz
•
KG - 12th Grade
10 questions
Bacteria
Quiz
•
9th - 10th Grade
15 questions
Harry Potter
Quiz
•
KG - Professional Dev...
10 questions
Globalization and Media Quiz
Quiz
•
7th Grade - University
11 questions
Compositors del segle XX
Quiz
•
8th - 12th Grade
12 questions
Food packaging
Quiz
•
10th Grade
15 questions
Sensory Testing
Quiz
•
7th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Other
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
12 questions
Parallel Lines Cut by a Transversal
Quiz
•
10th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University