7
AssignmentMultiple Choice

Automating Workbook Functionality

Question 7 • Computer Applications - Office 2019 - S1

What is the purpose of saving a macro to your Personal Macro Workbook?

Answer
A
The saved macros are automatically added to all workbooks you open.
B
The saved macros are available to be added to any workbook.
C
This is the only place you can save macros.
D
Macros saved here are copyrighted by you for your use only.

Explanation

The Personal Macro Workbook is loaded when Excel starts, so macros saved there are available for use in any workbook you open. They are not automatically added to each workbook, which makes A incorrect. The purpose is to keep your macros accessible across workbooks.

AI-written and checked against the verified answer.