Microsoft Excel Workbook and Worksheet Management 3

Question 1

What is a macro-enabled workbook (.xlsm)?

Accepted Answer

A workbook that stores and runs VBA macros

Answer

.xlsm supports VBA macros; needed when workbook contains macro code.

Question 2

How does Consolidate help across multiple worksheets?

Accepted Answer

Creates summary aggregating matching data from multiple sheets

Answer

Consolidate combines data from multiple ranges using aggregate functions.

Question 3

How do you encrypt an Excel workbook?

Accepted Answer

File > Info > Protect Workbook > Encrypt with Password (AES-256)

Answer

Encrypt with Password applies AES-256 encryption to the entire file.

Question 4

How do you manage External Links to other workbooks?

Accepted Answer

Data > Edit Links shows all external references with update, change, break options

Answer

Edit Links displays all external references with options to update, change source, or break links.

Question 5

What is the Inquire add-in used for?

Accepted Answer

Analyzing workbook structure, comparing workbooks, tracing relationships

Answer

Inquire provides advanced analysis: workbook comparison, cell relationship diagrams, and structure analysis.

Excel Practice Test