NCERT Solutions Information Technology Class 10 Chapter 5 Using Macros In Spreadsheet | TutorialAICSIP

If you are looking for NCERT Solutions Information Technology Class 10 Chapter 5 Using Macros in Spreadsheet. You are landed on right page here. Let’s discuss NCERT Solutions Information Technology Class 10 Chapter 5 Using Macros in Spreadsheet.

NCERT Solutions Information Technology Class 10 Chapter 5 Using Macros in Spreadsheet

[1] Macro Recordings can be enabled from the ___________________ option in the menu bar.
(a) Sheet
(b) Data
(c) Tools
(d) Window.

Ans. (c) Tools
Sheet, Data and Window are not relevant options.

[2] Which of the following is an invalid Macro Name?
(a) 1formatword
(b) format word
(c) format*word
(d) Format_word.

Ans. (d) Format_word
(a) 1formatword – Starts with a number as macro name must starts with an alphabet
(b) format word – Contains a space as macro name should not contain any space
(c) format*word – Contains a special character (*) as macro name should not contain a special characters

[3] Which of the following Libraries contains modules with pre-recorded macros and should not be changed?
(a) My Macros
(b) LibreOfficeMacros
(c) Untitled1
(d) Test.

Ans. (b) LibreOfficeMacros (Application Macros)
MyMacros and untitled can be edited or changed anytime where is Test is not a library name given in macros organizer.

[4] Identify which of the following is a programming Language?
(a) Calc
(b) BASIC
(c) Writer
(d) Macro

Ans. (b) BASIC
Calc and Writer are applications of LibreOffce whereas Macro is important feature of LibreOffce Calc.

[5] The Module can be executed from the IDE by pressing _______________.
(a) F3
(b) F4
(c) F5
(d) F6

Ans. (c) F5
F3, F4 and F6 keys are not used in macros.

[6] Which of the following is the default name of the Macro?
(a) Default
(b) Main
(c) Macro1
(d) Main_Macro

Ans. (b) Main

B. 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 _______________ and returning a ________________.

Ans.Arguments/values, result/value

[4] Macro ____________ allows us to add, delete a module.

Ans.: Organizer

[6] The code of macro begins with _______followed by the name of the macro and ends with _____________.

Ans.: Sub, End Sub

[7] By default a macro is saved in the _____________________.

Ans. (b) Main

C. State whether the following statements are True or False

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

Ans.: False
Macro is a group of instructions executing a multiple instructions.

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

Ans.:True
A macros can be used infinite numbers of times after its creation.

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

Ans.: False
No, Macro feature is not enabled by default in LibreOffice Calc, It can be turned on through Tools > Options > LibreOffice Calc > Advanced > Enable Macro Recording (May be limited) option

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

Ans.: False
Macro can be stopped by pressing Stop Recording button.

[5] Every Macro should be given a unique name.

Ans.:True

[6] A macro once created can be edited later.

Ans.: True

D. Answer the following questions

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

Answer:

• 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 later.
• A sequence of actions such as keystrokes and clicks can be recorded and then run as per the requirement.

Macros can be used in the following situations:

1. To apply the specific formatting repeatedly in spreadsheet
2. To use a specific formula repeatedly in spreadsheet

[2] List the actions that are not recorded by a macro.

Answer:

The actions cannot be recorded by Macro:

1. Opening of windows
2. Actions carried out in another window than where the recording was started.
3. Window switching
4. Actions that are not related to the spreadsheet contents
5. Selections are recorded only if they are done by using the keyboard (cursor traveling), but not
   when the mouse is used
6. The macro recorder works only in Calc and Writer.

[3] How is LibreOffice Macros Library different from my Macros?

Answer:

A Library is a collection of modules which in turn is a collection of macros. A LibreOffice Macros library contains default macros stored by LibreOffce whereas my Macros contains modules of macros created and recorded by user.

[4] Differentiate between predefined function in Calc and Macros as a function.

Answer:

[5] List the rules that should be kept in mind while naming a macro.

Answer:

The rules that should be kept in mind while naming a macro are as follows:

• Macros should be always starts with a letter
• It doe not contain any space
• It does not contain a special character except for (underscore)

[6] Give any one advantage of macros.

Answer:

Macros are beneficial in many ways as follows:

1. Macro can be used again and again
2. Macro can be copied and distributed to multiple users
3. Macro can serve as a part of a broader solution to a customer requirement that involves both host applications and workstation applications

Follow this link to access comprehensive notes on Macros:

Related