Excel Knowledge Quiz
Authored by David Remon
Computers
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best describes an external reference in Excel?
A link to another worksheet in the same workbook
A link to a cell, range, or defined name in a different workbook
A named range that refers to multiple sheets
A formula copied across multiple cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the default calculation option in Excel?
Manual
Automatic Except for Data Tables
Automatic
Semi-automatic
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which macro setting provides the highest level of security?
Enable all macros
Disable all macros with notification
Disable all macros except digitally signed macros
Enable macros only in trusted workbooks
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When creating an external reference to a defined name in another workbook, which key is used to display the list of defined names?
F2
F3
Ctrl + N
Shift + F2
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does protecting a workbook structure prevent?
Editing cell formulas
Viewing hidden worksheets, adding, moving, deleting, or renaming sheets
Entering data into locked cells
Applying conditional formatting
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you mark a workbook as read-only but allow certain ranges to be editable, what must you configure?
Protect Workbook
Track Changes
Allow Edit Ranges
Worksheet View
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which statement about threaded comments is correct?
Only the original author can delete them
They can include @mentions to notify specific people
They cannot be resolved
They cannot be replied to
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
