cbse CLASS – X computer SUBJECT – INFORMATION TECHNOLOGY CHAPTER – 5 USING MACROS IN SPREADSHEET1. Multiple Choice

QUESTION BANK

CLASS – X

SUBJECT – INFORMATION TECHNOLOGY

CHAPTER – 5 USING MACROS IN SPREADSHEET

1. Multiple Choice Questions (MCQs)

1. What is the primary purpose of a macro in a spreadsheet?

o a) To insert images

o b) To automate repetitive tasks

o c) To calculate complex formulas

o d) To protect the document from editing

Answer: b) To automate repetitive tasks

2. Which menu option is usually used to start recording a macro in most spreadsheet

software?

o a) File

o b) Home

o c) Developer

o d) Insert

Answer: c) Developer

3. What is the extension of a macro-enabled spreadsheet file in Microsoft Excel?

o a) .xls

o b) .xlsx

o c) .xlsm

o d) .csv

Answer: c) .xlsm

4. To assign a macro to a button in Excel, which option should you select after creating the

button?

o a) Assign Hyperlink

o b) Assign Macro

o c) Format Button

o d) Record Macro

Answer: b) Assign Macro

5. If a macro is saved to "This Workbook" in Excel, it can:

o a) Only be used in the current workbook

o b) Be used across multiple workbooks

o c) Be used by other users without permission

o d) Run only once and then disappear

Answer: a) Only be used in the current workbook

2. True or False

1. True or False: Macros can be used to automate repetitive tasks in a spreadsheet. Answer: True

2. True or False: Once recorded, a macro cannot be edited. Answer: False

3. True or False: Macros are written in a programming language called Visual Basic for

Applications (VBA) in Excel. Answer: True

4. True or False: Macros can only be created by advanced programmers and cannot be

recorded manually. Answer: False

5. True or False: Enabling macros can sometimes pose a security risk if the source of the

macro is unknown. Answer: True

3. Short Answer Questions

1. What is a macro, and why is it useful in a spreadsheet?

Answer: A macro is a sequence of instructions that automate repetitive tasks in a

spreadsheet. It saves time and reduces the possibility of human error in repetitive

processes. 

2. Explain the steps to record a macro in a spreadsheet application like Microsoft

Excel. Answer:

o Go to the Developer tab. o Select Record Macro. o Name the macro, choose where to store it, and provide a description if needed. o Perform the actions you want to automate. o Click Stop Recording once done. 

3. How can you assign a macro to a button in Excel?

Answer:

o Go to the Developer tab and insert a button. o Right-click the button and select Assign Macro. o Choose the macro you want to assign and click OK. 

4. What is the significance of saving a macro-enabled workbook with a .xlsm extension?

Answer: The .xlsm extension signifies that the workbook contains macros, which

enables macros to be saved and used in the file. 

5. What precautions should be taken before enabling macros in a downloaded

spreadsheet?

Answer: Only enable macros from trusted sources because macros can potentially

contain harmful code that may compromise system security.

4. Fill in the Blanks

1. A macro in Excel can be recorded using the _______ tab. Answer: Developer

2. In Excel, macros are stored with the file extension _______. Answer: .xlsm

3. The language used to create and edit macros in Microsoft Excel is called _______. Answer: Visual Basic for Applications (VBA)

4. To end the recording of a macro, click on _______ Recording in the Developer tab. Answer: Stop

5. Macros help in _______ repetitive tasks, saving time and reducing errors. Answer: automating