Question

What is the use of macro in ms-excel & how it is recorded&executed?

Answer 1

Answer:

Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your keystrokes and thus repeats your actions. This is why macros are great for automating repetitive tasks

Explanation: