Electronic Spreadsheet (Advanced) Class – X

Part – 5

Short Notes

Video Tutorial

Questions and Answers

Q.1. What is a Macro?

Ans. A macro is a saved sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that “types” your address.

Q.2.  How to activate the developer tab in MS Excel?

  • Ans. Click on File –> Options. An Excel Options dialog box appears.
    • Select the Customize Ribbon option from the left side.
    • Now choose the Main Tabs option from choosing commands from the drop-down list.
    • Click on the Developer tab and tick the checkbox.
    • Click on OK.

Q.3. Write steps to record a macro.

Ans. 1. Place the cursor in a cell from where you want to start record.

2. Click on Developer –> Record Macro. A Record Macro dialog box will appear.

3. Type a name for Macro by following rules for giving the names.

4. Assign short cut key, and write the description, these are optional parts.

5. Click on the OK button.

6. The Macro recorder will start.

Q.4. How will you change the short cut key or and description of the recorded macro?

Ans. 1. Click on Developer –> Macros option from code group. A macro dialog box will appear.

2. Select the macro name to edit or change the short cut key or description.

3. Click on the options button. The Macro Options dialog box will appear.

4. Do the desired changes.

5. Click on OK Button.

6. Close the Macro dialog box.

Q.5. How will you  delete the macro?

Ans. 1. Click on Developer –> Macros option from code group. A macro dialog box will appear.

2. Select the macro name to edit or change the short cut key or description.

3. Click on the Delete button. It will ask for the confirmation.

4. Click on the Yes button. The macro gets deleted.

Multiple-choice questions

The correct answers have been made Bold and Italicised.

  1. Which of the following tab helps to add commands or tab in the ribbon in MS Excel?
    • Home
    • Insert
    • File
    • Review
  2. Which of the following button needs to be clicked to start recording a macro?
    • Visual Basic
    • Macros
    • Record Macro
    • Use Relative References
  3. Which of the following option is not available in Store macro in the list?
    • This Workbook
    • New Workbook
    • Personal Macro Workbook
    • Sheet1
  4. Which of the following option tells a summary of a macro in the macro dialog box?
    • Macro Name
    • Description
    • Buttons
    • List of macros
  5. The options button in the macro dialog box allows to
    • Change the shortcut key assigned and edit the description
    • Opens the Visual Basic Code editor
    • Delete a macro
    • Run a macro
  6. Identify the valid macro name:
    • Mac 1
    • 1_Mac
    • Mac_1
    • 1Mac
error: Content is protected !!
Back to Top