Excel Knowledge Quiz

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

What is the default calculation option in Excel?

• Manual

• Automatic Except for Data Tables

• Automatic

• Semi-automatic

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

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

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

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

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

What is the difference between a comment and a note in Excel?

• Notes can include @mentions, comments cannot

• Comments are for annotation, notes are for threaded conversations

• Comments are for threaded conversations, notes are for simple annotations

• There is no difference

Which of the following is not an option in Excel’s calculation settings?

• Automatic

• Automatic Except for Data Tables

• Manual

• Semi-Automatic

Which feature lets you see previous saved states of a workbook?

• Protect Workbook

• Track Changes

• Version History

• AutoRecover