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 acros