A macro in Microsoft Excel is a set of instructions or a recorded sequence of user actions (such as keystrokes, mouse clicks, and commands) that can be saved and executed repeatedly. The primary purpose is to automate repetitive or complex tasks, thereby saving time, reducing the potential for human error, and improving efficiency. By recording a series of steps, a user can perform that entire sequence with a single command, such as a button click or a keyboard shortcut.

A. Inserting a hyperlink is a specific, singular action that can be done without a macro; it is not the fundamental purpose of the macro feature.

B. Sorting data is a built-in Excel function. While a macro can include a sorting step, its core purpose is to automate a sequence of tasks, not just one.

C. Illustrating data with charts is a primary function of Excel's charting tools, not the macro feature itself, which is designed for automation.

1. Microsoft Corporation. (n.d.). Automate tasks with the Macro Recorder. Microsoft Support. Retrieved from support.microsoft.com. In the introductory paragraph

it states

"If you have tasks in Microsoft Excel that you do repeatedly

you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want."

2. University of Washington

Foster School of Business. (n.d.). Introduction to Macros. In the section "What is a Macro?"

it is defined as: "A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task."

3. University of Wisconsin-Madison. (n.d.). Excel - Getting Started with Macros. DoIT Academic Technology. In the "What is a macro?" section

it states

"A macro is a tool that allows you to automate tasks... You can record a sequence of actions in Excel to create a macro."