Macros in Spreadsheet Class 10 MCQ
Macros in Spreadsheet Class 10 MCQ
Q1. A _____________ is a saved sequence of commands or keystrokes that are stored for later use
a. Solver
b. Autosum
c. Consolidate
d. Macro
Q2. Macros are especially useful to ___________ a task.
a. do
b. repeat
c. simplify
d. complicate
Q3. Use ___________ option to start the macro recorder.
a. Tools > Macros > Record Macro
b. Tools > Record > Record Macro
c. Data > Macros > Record
d. None of the above
Q4. Click _____________ to stop the macro recorder
a. Close Recording
b. End Recording
c. Stop Recording
d. None of the above
Q5. To edit macro, go to
a. Tools –> Macros — > Edit Macros
b. Edit –> Macros — > Edit Macros
c. View –> Macros — > Edit Macros
d. None of the above
Q6. Aman wants to repeat a task, such as applying the same formula to a particular cell in different sheets of a workbook, again and again in the same way. Which tool will help Aman to do this?
a. Style
b. Macro
c. Table of content
d. Multiple Operation
Q7. _______________ is a single instruction that executes a set of instructions.
a. Style
b. Multiple Operations
c. Macro
d. Goal Seek
Q8. In LibreOffice, by default, the macro recording feature is OFF when it is installed. (True/False)
a. True
b. False
Q9. From which menu Macro recording option can be enabled in Calc?
a. Tool
b. Edit
c. Format
d. Data
Q10. Anshu wants to record a Macro in Calc. She found that Macro recording feature is OFF in Calc. She wants to turned ON this feature. Help her to identify the correct option to turned ON this feature.
a. Tools–>Options–>Advanced
b. Tools–>Options–>LibreOffice–>Advanced
c. Edit–>Options–>LibreOffice–>Advanced
d. Tools–>Options–>LibreOffice–>Optional
Q11. Which of the following actions can be recorded by Macro in Calc?
a. Opening of Windows
b. Window switching
c. Actions that are not related to the spreadsheet contents.
d. All the keyboard and mouse actions.
Q12. In LibreOffice macro recorder works in _________________
a. Calc
b. Writer
c. Both of the above
d. None of the above
Q13. _____________________ is used to save the macro.
a. Record Macro dialog window
b. Basic Macros dialog window
c. Advanced Macro dialog window
d. Save Macro dialog window
Q14. Basic Macros dialog window can be opened by clicking on _______________
a. Tools → Macros → Edit Macro
b. Tools → Macros → Record Macro
c. When we click on Stop Recording alert
d. None of the above
Q15. By default the name of the macro is _______________ and it is saved in ______________ library.
a. Macro1, My Macro
b. Main, Standard
c. Untitled1, Standard
d. Main, My Macro
Q16. Anshuman created a macro and saved it with the name “MyTitle” in the Standard Library. He understands macros and how they work, but he is not aware of the term “Library.” Being his friend, explain the meaning of Library to him.
a. Library is a collection of Predefined Macros
b. Library is a collection of User defined Macros
c. Library is a collection of Application Macros
d. Library is a collection of Modules
Q17. Match the following:
| 1. Library | A. Contains Macros |
| 2. Macro | B. Contains Modules |
| 3. Module | C. Set of instructions |
a. 1 –> A, 2–>B, 3–> C
b. 1 –> B, 2–>B, 3–> A
c. 1 –> B, 2–>C, 3–> A
d. 1 –> A, 2–>C, 3–> B
Q18. Aman created a macro named “MyTitle.” Suman also created another macro and tried to save it with the same name “MyTitle.” What will happen in this situation?
a. Both the macro will be saved.
b. An confirmation message will appear.
c. None of the macro will be saved.
d. Macro created later will overwrite automatically the previous macro without any message.
Q19. Identify the invalid macro name from the following:
a. Macro1
b. Macro 1
c. Macro@1
d. 1Macro
Q20. What are the rules for naming a module, macro or library?
a. Begin with letter
b. Should not contain spaces
c. Should not contain special character except underscore
d. All of the above
Q21. ______________ dialog box can be opened by clicking on Tools>Macros>Run Macro.
a. Macro Selector
b. Basic Macro
c. Standard Macro
d. Run Macro
Q22. Which of the following library contains pre-recorded macros and should not be changed?
a. My Macros
b. LibreOffice Macros
c. Standard Library
d. Untitled Library
Q23. Which of the following library contains macros that we write or add to LibreOffice?
a. My Macros
b. LibreOffice Macros
c. Standard Library
d. Untitled Library
Q24. The action recorded by a macro is recorded as instructions in a programming language called _________________
a. Python
b. C++
c. BASIC
d. LOGO
Q25. Suman wants to see the code of a macro created by her in Calc. Which of the following option will help her to see the code?
a. Tools>Macros>Edit Macros
b. Tools>Macros>Run Macros
c. Data>Macros>Modify Macros
d. Data>Macros>Edit Macros
Q26. The code of a macro begins with _____________ followed by the __________ of the macro and ends with __________________
a. End Sub, Name, Sub
b. Sub, End Sub, Name
c. Sub, Name, End Sub
d. End Sub, Sub, Name
Q27. LibreOffice Basic Macro dialog window help us to _________ the macro.
a. Modify
b. Delete
c. Organise
d. All of the above
Q28. Anju wants to create a new library in Calc to store the Macros, so she wrote the following steps but skipped few words by mistake. Help her to complete the steps given below.
- Click on Tools > Macro > Organize Macro > Basic
- Click on Organiser and LibreOffice Basic Macro Organiser window will open
- Click on ______________ tab to create library.
- Click on _________________ button.
- Give the name of new library and click OK.
a. Library, Library
b. Library, OK
c. Organiser, OK
d. Library, New
Q29. Manisha wants to create a macro that can display “Thanks” in a dialog box. She has written the following code but the macro was not working.
Sub Main
Print("Thanks)
end Sub
Identify the correct code from the following.
a.
Sub Main
Print("Thanks")
End Su
b.
sub Main
Print("Thanks"
end
c.
Sub Main
print("Thanks")
End Sub
d.
Sub Main
Print("Thanks")
end
Q30. IDE stands for _______________________
a. Internal Development Environment
b. Integrated Dialog Environment
c. Integral Development Environment
d. Integrated Development Environment
Q31. ___________________________ is a text editor that allows us to create and edit macros.
a. LDE
b. UDE
c. IDE
d. KDE
Q32. The module created in Integrated Development Environment can be executed by __________________
a. Clicking the Run button
b. Pressing F5 from keyboard
c. Both of the above
d. None of the above
Q33. A function is capable of accepting arguments. (T/F)
a. True
b. False
Q34. A macro can be used as a function. (T/F)
a. True
b. False
Q35. Which of the following task can be done when a macro is used as a function?
a. It can perform operations on the arguments
b. Perform calculations
c. Return the result
d. All of the above
Q36. Anuj is writing code in the IDE to create a macro that can be used as a function. By mistake, he put a single quote ( ‘ ) at the beginning of a line and found that the line became inactive and turned grey. What is this called?
a. Style
b. Macro function
c. Comment
d. Inactive statement
Q37. Which of the following statement is not correct about Macro?
a. It starts with Sub
b. It ends with End Sub
c. It does not return a value
d. It is used to perform calculations
Q38. Instruction in macro are written in ________________ language.
a. BASIC
b. COBOL
c. Python
d. Java
Q39. Which of the following symbol is used to write comment in writing code of macro?
a. //
b. #
c. *
d. ‘
Q40. Non executable lines in IDE is called ___________________
a. Statement
b. Comment
c. Line without execution
d. Inactive line
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
Unit 3: Database Management system using LibreOffice Base
Chapter 8. Introduction to DBMS – NOTES
Chapter 8. Introduction to DBMS – Question Answers
Chapter 9. Starting with LibreOffice Base – NOTES
Chapter 9. Starting with LibreOffice Base – Question Answers
Chapter 10. Working with Multiples Tables – NOTES
Chapter 10. Working with Multiples Tables – Question Answers
Chapter 11. Queries in LibreOffice Base – NOTES
Chapter 11. Queries in LibreOffice Base – Question Answers
Chapter 12. Forms and Reports – NOTES
Chapter 12. Forms and Reports – Question Answers
Unit 4: Prevent Accident and Emergencies
Chapter 13. Health, Safety and Security at Workplace – NOTES
Chapter 13. Health, Safety and Security at Workplace – Question Answers
Chapter 14. Workplace Safety Measures – NOTES
Chapter 14. Workplace Safety Measures – Question Answers
Chapter 15. Prevent Accidents and Emergencies – NOTES
Chapter 15. Prevent Accidents and Emergencies – Question Answers
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you practice of Macros in Spreadsheet Class 10 MCQ. This way you can find out your weak areas of Ch-5 Macros in Spreadsheet Class 10 MCQ . All the questions given above of Macros in Spreadsheet Class 10 MCQ are designed from NCERT book. If you find any mistake in the above questions of Macros in Spreadsheet Class 10 MCQ, you can directly contact me at csiplearninghub@gmail.com