Explanation/Reference:
Explanation:
A macro is defined as a tool that permits a user to automate tasks and add several functionalities to forms, reports, and controls. For example, if a user adds a command button to a form, he associates the button's OnClick event to a macro, and the macro consists of the commands that are to be performed by the button each time it is clicked. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order.
Incorrect Answers:
Answer options A, C: The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source whenever the data source is updated with new information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by putting the workbook in a trusted location.
B: Evaluate Formula is a formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result.
References: https://support.office.com/en-us/article/introduction-to-macros-a39c2a26-e745-4957-8d06-
89e0b435aac3