Using Macros in Spreadsheet class 10 questions answers

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.

 

class 10 IT chapter 5 using macros in spreadsheet

Check your progress 

Using Macros in Spreadsheet MCQ (Multiple Choice Questions)

  1. 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

  1. _____________ 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 

  1. 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

  1. 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 :

  1. Chapter 1 Introduction to Styles Questions Answers
  2. Chapter 1 Introduction to Styles Online Quizzes / MCQ Tests
  3. 40+ important MCQs of Chapter 1 Introduction to Styles
  4. Chapter 2 Working with Images questions answers
  5. Chapter 3 Advanced Features of writer Questions Answers
  6. Chapter 4 Analyse Data Using Scenarios and Goal Seek
  7. Chapter 5 Using Macros in Spreadsheet questions answers
  8. Chapter 6 Linking Spreadsheet data questions answers
  9. Chapter 7 Share and Review Spreadsheet questions answers
  10. Chapter 8 Introduction to Database Management System questions answers
  11. Chapter 9 Starting with LibreOffice Base questions answers
  12. Chapter 10 Working with Multiple Tables questions answers
  13. Chapter 11 Queries in Base questions answers
  14. Class 10 Unit 1 Communications Skills important Questions Answers.
  15. Class 10 Employability Skills Unit 1 Communication Skills Exercise Solutions
  16. Class 10 IT 402 free PDF download book, syllabus and previous year question paper.

 

 

Leave a Comment