Excel Functions Quiz
Authored by Neil Raymundo
Other
11th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to sum a range of cells?
AVERAGE()
SUM()
COUNT()
MAX()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the FILTER function?
To sort data alphabetically.
To extract specific data based on criteria.
To calculate the average of a range.
To create charts.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use for getting the Max number in data cell?
AVERAGE()
SUM()
COUNT()
MAX()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The first step in creating a chart is:
Selecting a chart type.
Selecting the data range.
Formatting the chart.
Entering the data.
5.
OPEN ENDED QUESTION
3 mins • 1 pt
Once the chart is created, you cannot modify its appearance. Is it true or false?
Evaluate responses using AI:
OFF
6.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
After selecting the data, you should go to the (a) tab to access chart creation tools.
7.
OPEN ENDED QUESTION
3 mins • 4 pts
What are the types of functions give at least 4
Evaluate responses using AI:
OFF
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?
