Explain Macro in MS-Excel?

Macros in MS Excel is an automated input sequence that used to replace a repetitive series of keyboard and mouse actions and is common in spreadsheet and word processing applications like MS Excel and MS Word. A macro is typically used for iterating over a group of the task.