1. A macro in LibreOffice Calc is a set of instructions that automate repetitive tasks. Real-life situations include generating monthly reports and formatting data for presentations.
2. Actions not recorded by a macro include cell formatting changes, manual sorting, and using dialog boxes.
3. The LibreOffice Macros Library contains all available macros, while "My Macros" is a personal space for user-created macros.
4. Predefined functions are