Excel Functions Quiz
Quiz
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Medium
Elvis Ramcee Razote
Used 7+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the SUM function do in Excel?
It computes the total average of a range of cell
It produces the value of the range of cell
it adds the selected range of cells
It adds the cell 1 and Cell 2
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can you use to count the number of cells containing data in a given range?
SUM
Count If
Average
Count
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Describe the steps to sort data in ascending order based on a specific column.
Click on the sort function and choose sort A-Z
Click on the sort function and choose sort Z - A
Click on the sort function and choose 1 – 10
Click on the sort function and choose Z - A
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the best formula to be used when using the sum function for the given set of data
=A2:B2
=SUM (A2+B2)
=SUM (A2:B2)
=A2+B2
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the output of the data below
C
D
A
E
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you name a cell in column E and row 4?
E:4
E4
4E
4:E
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Using the SUM function, what would be the formula to be used?
=SUM(A1+A5)
=SUM(A1:A5)
=SUM(A1-A5)
=SUM(A1*A5)
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
15 questions
KS3 Y8 Kodu Quiz
Quiz
•
5th - 8th Grade
15 questions
Creating Illustrations
Quiz
•
7th - 8th Grade
20 questions
M1_Final_Quiz1_2017
Quiz
•
7th - 8th Grade
20 questions
Unit Test 1 Class 8 Computer
Quiz
•
8th - 9th Grade
20 questions
Web 2.0
Quiz
•
6th - 10th Grade
15 questions
Layers, IP, MAC Addressing and Packets
Quiz
•
2nd - 9th Grade
20 questions
L4 Homework
Quiz
•
8th Grade
20 questions
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
