What is a macro? Explain the benefit of using a macro.
Answers
Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day.
hope it helps
pls mark me as brainlist
Answer:
Herebis your answer! Please mark me as brainliest
Explanation:
A macro (which stands for "macroinstruction") is a programmable pattern which translates a certain sequence of input into a preset sequence of output. Macros can make tasks less repetitive by representing a complicated sequence of keystrokes, mouse movements, commands, or other types of input.
In computer programming, macros are a tool that allows a developer to re-use code. For instance, in the C programming language, this is an example of a simple macro definition which incorporates arguments:
After being defined like this, our macro is used in the code body to find the square of a number. When the code is preprocessed before compilation, the macro will be expanded each time it occurs.
A macro is a name given to a block of the code which can be substituted where the code snippet is to be used for more than once.
- The speed of the execution of the program is the major advantage of using a macro.
- It saves a lot of time that is spent by the compiler for invoking / calling the functions.
- It reduces the length of the program.