
Microsoft Excel 2019 Advanced Vocabulary Assessment
Authored by Rema Wilson
Business
11th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is an absolute cell reference in Excel?
A cell reference that changes when copied
A reference that includes dollar signs and doesn't change when copied
A reference that combines both relative and absolute elements
A cell reference based on relative position
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel feature automatically updates a web page when changes are saved?
AutoSave
Data Form
AutoRepublish
Auto Update
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of buttons in Excel?
To display date and time
To run macros for specific actions
To show cell references
To create formulas
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a data form used for in Excel?
To create new worksheets
To format cells automatically
To enter one complete row of information without horizontal scrolling
To design custom buttons
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which term describes tests that evaluate whether conditions are true or false?
Data Source
Conditional Formulas
Arguments
Mixed References
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a sparkline in Excel?
A. A type of button control
B. A formula calculation
C. A tiny chart within a worksheet cell
D. A cell reference type
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of check boxes in Excel?
To increase or decrease values
To toggle a value on or off
To display multiple options
To group related controls
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?