Dear students, in this page, you will get Class 10 IT Chapter 5 Using Macros in Spreadsheet questions answers. The questions answers are given according to the syllabus of Domestic Data Entry Operator book published by NCERT.

Check your progress
Using Macros in Spreadsheet MCQ (Multiple Choice Questions)
- Macro recordings can be enabled from the _________ option in the menu bar.
a. Sheet
b. Data
c. Tools
d.Window
Ans: c. Tools
2. Which of the following is a valid Macro Name ?
a. 1formatword
b. format word
c. format “word”
d. Format_word
Ans: d. Format_word
3. Which of the following libraries contains modules with prerecorded macros and should not be changed ?
a. My Macros
b. LibreOfficeMacros
c. Untitled 1
d. Test
Ans: b. LibreOfficeMacros
4. Identify which of the following is a programming Language ?
a. Calc
b. BASIC
c. Writer
d. Macro
Ans: b. BASIC
5. The Module can be executed from the by pressing ___________
a. F3
b. F4
c. F5
d. F6
Ans: c. F5
6. Which of the following is the default name of the Macro ___________________
a. Default
b. Main
c. Macro1
d. Main_Macro
Ans: b. Main
Class 10 IT Chapter 5 questions answers
Fill in the blanks
- _____________ library is automatically loaded when the document is opened.
Ans: Standard
2. IDE stands for _________________
Ans: Integrated Development Environment
3. Macro as a function is capable of accepting __________________
Ans: arguments / values
4. Macro ____________ allows us to add, delete a module.
Ans: Organizer
5. The code of macro begins with _______________ followed by the name of the macro and ends with __________
Ans: Sub, End Sub
6. By default, a macro is saved in the ____________
Ans: Standard Library
Using Macros in Spreadsheet class 10 questions answers
State whether the following statements are True or False
- Macro is a group of instructions executing a single instruction.
Ans: False
2. Once created, Macro can be used any number of times.
Ans: True
3. By default, the Macro recording feature is turned on.
Ans: False
4. It is not possible to stop recording of a Macro.
Ans: False
5. Every Macro should be given a unique name.
Ans: True
6. A macro once created can be edited later.
Ans: True
Class 10 Chapter 5 Using Macros in Spreadsheet questions answers
D. Answer the following questions
- What is a Macro ? List any two real life situations where they can be used.
Ans: A Macro is a single instruction that executes a set of instructions. These set of instructions can be a sequence of commands or keystrokes that can be used for any number of times.
Two real life situations where Macro can be useful are –
i. When all the teachers of a school or a college need to set the question paper for the school or the college having the same format. In that case Macro can be useful.
ii. When an Institute provides certificates to the students, the certificates should have the same format. In that case also Macro can be useful.
2. List the actions that are not recorded by a Macro.
Ans: The actions that are not recorded by a Macro are-
i. Opening of windows.
ii. Actions carried out in another window than where the recording was started.
iii. Window switching.
iv. Actions that are not related to the spreadsheet contents.
3. How is LibreOffice Macros Library different from My Macros ?
Ans: LibreOffice Macros Library is different from My Macros in the following ways-
i. LibreOffice Macros Library is an inbuilt library provided by LibreOffice whereas My Macros is a user defined library.
ii. LibreOffice Macros Library contains modules with pre recorded macros whereas My Macros contain macros that we write or add to LibreOffice.
4. Differentiate between Predefined function in Calc and Macros as a function .
Ans: Predefined function in Calc is different from Macros as a function in the following ways –
i. Predefined function in Calc is an inbuilt function whereas Macros as a function is a user defined function.
ii. Predefined function in Calc can not be customized whereas Macros as a function can be customized.
5. List the rules that should be kept in mind while naming a Macro .
Ans: The rules that should be kept in mind while naming a Macro are as follows-
i. It should begin with a letter.
ii. It should not contain spaces.
iii. It should not contain special characters except underscore ( _ ).
6. Give any one advantage of Macros.
Ans: The two advantages of Macros are given below –
i. Using Macros we can automate repetitive tasks.
ii. Using Macros we can save our time.
Class 10 IT Chapter 5 Using Macros in Spreadsheet questions answers
Related Posts :
- Chapter 1 Introduction to Styles Questions Answers
- Chapter 1 Introduction to Styles Online Quizzes / MCQ Tests
- 40+ important MCQs of Chapter 1 Introduction to Styles
- Chapter 2 Working with Images questions answers
- Chapter 3 Advanced Features of writer Questions Answers
- Chapter 4 Analyse Data Using Scenarios and Goal Seek
- Chapter 5 Using Macros in Spreadsheet questions answers
- Chapter 6 Linking Spreadsheet data questions answers
- Chapter 7 Share and Review Spreadsheet questions answers
- Chapter 8 Introduction to Database Management System questions answers
- Chapter 9 Starting with LibreOffice Base questions answers
- Chapter 10 Working with Multiple Tables questions answers
- Chapter 11 Queries in Base questions answers
- Class 10 Unit 1 Communications Skills important Questions Answers.
- Class 10 Employability Skills Unit 1 Communication Skills Exercise Solutions
- Class 10 IT 402 free PDF download book, syllabus and previous year question paper.

Hello students,
Welcome to my site www.elearnersmentor.com. I have been in teaching profession since 2004. Presently I am working as a vocational subject teacher(IT) in a reputed govt. higher secondary school. Read more