| Textbook | Kips Information Technology Class 10 |
| Subject Code | 402 |
| Part | B |
| Unit | Unit-2 Electronic Spreadsheet (Advanced) |
| Chapter | 9 Using Macros in a Spreadsheet |
| Other Chapters Solutions | Kips IT Class 10 Solutions |
Contents
A. Select the correct option.
1. It is a tool that allows you to records macros.
- Macro Recorder
- Macro Viewer
- None of these
2. Which menu has the option to record a macro in Calc?
- Data
- Window
- Tools
3. Which of the following action cannot be recorded while creating a macro?
- Window Switching
- Entering Data
- None of these
4. In Calc to run a macro, choose
- Tools > Macros
- Tools > Run Macro
- Tools > Macros > Run Macro
5. Which of the following keyword is used to define a macro as function?
- Function
- Macro
- None of these
B. Fill in the Blanks.
1. Macros automate the recorded actions and save your time and effort.
2. You are actually recording your mouse clicks and Keystrokes while creating a macro.
3. A Function is a line of code that executes when you call it.
4. Each function has a Name and may have Parameters.
5. In Calc, the arguments that you pass to a macro are always Values.
C. Answer the following questions.
What is macro?
The Macros feature of Calc allows you to record a set of actions that you perform repeatedly in a spreadsheet. You can run a macro as many times as you want. After creating a macro, there is no need to do the task manually. A macro automates the recorded actions and saves your time and efforts. It is very useful when you have to repeat the same task in the same way, over and over again.
How do you turn on the Macro Recorder?
follow these steps:
• Click on the Tools menu and select Options.
• A dialog box opens. Click on LibreOffice > Advanced.
• Select the Enable macro recording option.
• Click on OK. Now, you can record macros in Calc.
Write the syntax to define a macro as a function.
The following is the syntax to define a simple function without parameters:
Function Function_Name ()
Body of Function
Function_Name=Result
End Function
Which library loads in Calc, by default?
The Standard library automatically loads in Calc, by default.
