Question 1
What is the main benefit of a macro?
A macro automates a repeated sequence of actions, saving time and reducing inconsistent manual steps.
What to learn
Record and run macros to automate repeated spreadsheet work. Organise a simple macro, pass arguments where appropriate and use a macro-like function to process or sort data efficiently.
- A macro stores steps that can be repeated.
- The recorder captures a sequence of actions; a macro can also be edited or written.
- Test automation on a copy before applying it to important data.
- Macros can carry security risks, so use only trusted files and code.
Practical activity
On sample data, record a macro that formats a heading row and sorts a table. Run it on a second copy, inspect the result and note which steps depend on fixed cell positions.
Use your school’s prescribed software version and teacher instructions. Keep personal information out of public practice files.
Solved CBSE-style questions
These questions and answers are original practice written for this guide; they are not copied from past papers.
Question 2
Why test a macro on a copy?
An incorrect macro can change or delete many cells quickly. A copy lets the user verify its behaviour without risking the original data.
Question 3
Why should a downloaded macro-enabled file be treated carefully?
Macros can run code. An untrusted macro could alter files or compromise data, so enable macros only when the source is trusted and the file is expected.
Revision checklist
- Can I explain the key terms without memorising a definition alone?
- Can I complete the listed practical task and describe each step?
- Can I apply the idea to a new example and explain why my answer works?
Aligned to the CBSE 2026–27 syllabus outline. Check the official subject curriculum and your school’s textbook/material for the prescribed scope.