Excel Functions and Features Quiz
Authored by Divya Vinoth
Education
6th - 8th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the intersection of a row and a column called?
Table
Cell
Grid
Sheet
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to add a group of numbers in Excel?
AVERAGE
SUM
COUNT
MAX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A cell reference that adjusts when copied is called:
Absolute Reference
Relative Reference
Mixed Reference
Static Reference
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function gives the largest value in a range?
SUM
AVERAGE
MAX
MIN
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used to start a formula in Excel?
@
$
#
=
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNT function do?
Counts text entries
Adds numbers
Counts numeric values
Finds errors
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an Absolute Cell Reference?
B2
B$2
$B2
$B$2
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?
