A macro is just a set of tasks stored together under a common name.
A task is anything that you do in Excel, powerpoint, Word, etc.
For example, when you make a text bold, it is a task. So is putting a border around a cell, importing a document, etc. In many cases, we find that we are repeating a series of tasks again and again. Using a macro, we can group these tasks together, and invoke them using a name that we give, using a shortcut key, a button on a toolbar or a Menu Item(only from Office 2002).