Discussion
In MS Excel, what is a macro?
Answer: C
Correct answer: A recorded or written sequence of actions that can be replayed
A macro is a stored sequence of actions that can be replayed on demand. It is recorded with the Macro Recorder, which watches what you do and writes the corresponding code, or written directly in VBA - Visual Basic for Applications - in the editor opened with Alt + F11. Its purpose is to automate anything repetitive: formatting a report the same way each month, cleaning an import, or producing a set of sheets from a template. A workbook containing macros must be saved as .xlsm; the ordinary .xlsx format silently discards them, which is a common cause of lost work. That separation exists for security, since macros can do anything the user can, and have historically been a route for malware. Excel therefore disables them by default and shows a warning bar. Recorded macros are literal and brittle - they repeat exact cell addresses - so recording is often used as a starting point and then edited.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development