Using Macros in Spreadsheet Question Answers Class 10 IT

Share with others

Using Macros in Spreadsheet Question Answers

Using Macros in Spreadsheet Question Answers

using macros in spreadsheet
Using macros in Spreadsheet

A. Multiple choice questions

1. Macro Recordings can be enabled from the ________________ option in the menu bar.

(a) Sheet
(b) Data
(c) Tools
(d) Window.

2. Which of the following is valid Macro Name?

(a) 1formatword
(b) format word
(c) format*word
(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) Untitled1
(d) Test.

4. Identify which of the following is a programming Language?

(a) Calc
(b) BASIC
(c) Writer
(d) Macro.

5. The Module can be executed from the IDE by pressing ___________________.

(a) F3
(b) F4
(c) F5
(d) F6

6. Which of the following is the default name of the Macro ___________________.

(a) Default
(b) Main
(c) Macro1
(d) Main_Macro

B. Fill in the blanks

1. _______________ library is automatically loaded when the document is opened.

2. IDE stands for ___________________.

3. Macro as a function is capable of accepting and returning a _____________________.

4. Macro ______________ allows us to add, delete a module.

5. The code of macro begins with _______________ followed by the name of the macro and ends with _________.

6. By default a macro is saved in the ________________ .

using macros in spreadsheet
Using macros in Spreadsheet

C. State whether the following statements are True or False

1. Macro is a group of instructions executing a single instruction.

2. Once created, Macro can be used any number of times.

3. By default, the Macro recording feature is turned on.

4. It is not possible to stop recording of a Macro.

5. Every Macro should be given a unique name.

6. A macro once created can be edited later.

D. Answer the following questions

Q1. What is a Macro? List any two real life situations where they can be used.

Q2. List the actions that are not recorded by a macro.

using macros in spreadsheet
Using macros in Spreadsheet

Q3. How is LibreOffice Macros Library different from my Macros?

Q4. Differentiate between predefined function in Calc and Macros as a function

Q5. List the rules that should be kept in mind while naming a macro.

Q6. Give any one advantage of macros.


Important links of Class X (IT – 402)

Unit 1: Digital Documentation (Advanced) using LibreOffice Writer

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


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 the Answers of Chapter 5 Using Macros in Spreadsheet Question Answers , but if you feel that there is/are mistakes in the Answers of Chapter 5 Using Macros in Spreadsheet Question Answers given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE Website are used to create above article “Chapter 5 Using Macros in Spreadsheet Question Answers”


using macros in spreadsheet
Using macros in Spreadsheet


Share with others

3 thoughts on “Using Macros in Spreadsheet Question Answers Class 10 IT”

  1. Thank you sir, your site is a saviour. Its simple and applicable answers are just so fun to read and easy to learn. The information is organised too. Thank you sir.

    Reply

Leave a Reply

error: Content is protected !!