Recording and running macros Excel MCQs

By: Prof. Dr. Fazal Rehman Shamil | Last updated: August 1, 2024

  1. Which tab in Excel contains the options to record and manage macros?
    a) Home
    b) Insert
    c) Data
    d) Developer
    Answer: d) Developer
  2. What is the shortcut key to start recording a macro in Excel?
    a) Alt + F8
    b) Alt + F11
    c) Alt + T + M + R
    d) Alt + F1
    Answer: c) Alt + T + M + R
  3. When recording a macro, where can you specify the macro name and description?
    a) Macro Recorder dialog box
    b) Visual Basic Editor
    c) Macro Options dialog box
    d) Record Macro dialog box
    Answer: d) Record Macro dialog box
  4. What is the file extension for an Excel workbook that contains macros?
    a) .xlsx
    b) .xlsm
    c) .csv
    d) .xlsb
    Answer: b) .xlsm
  5. Which programming language is used for writing macros in Excel?
    a) Java
    b) Python
    c) VBA (Visual Basic for Applications)
    d) C++
    Answer: c) VBA (Visual Basic for Applications)
  6. How do you run a recorded macro in Excel?
    a) Click the Home tab, then click Run Macro
    b) Press Alt + F8, select the macro, and click Run
    c) Press Ctrl + M
    d) Open the Visual Basic Editor and run the macro from there
    Answer: b) Press Alt + F8, select the macro, and click Run
  7. What is the purpose of assigning a shortcut key to a macro?
    a) To open the macro in Visual Basic Editor
    b) To delete the macro
    c) To quickly run the macro using the keyboard
    d) To save the macro
    Answer: c) To quickly run the macro using the keyboard
  8. Where can you find the option to edit an existing macro in Excel?
    a) Home tab
    b) Insert tab
    c) Developer tab
    d) Data tab
    Answer: c) Developer tab
  9. Which option should you select if you want a macro to be available in all workbooks?
    a) Store macro in: This Workbook
    b) Store macro in: New Workbook
    c) Store macro in: Personal Macro Workbook
    d) Store macro in: Module
    Answer: c) Store macro in: Personal Macro Workbook
  10. What should you do if a macro contains an error and does not run as expected?
    a) Delete the macro and start over
    b) Use the Macro Recorder to fix the error
    c) Open the Visual Basic Editor and debug the macro code
    d) Ignore the error and run the macro again
    Answer: c) Open the Visual Basic Editor and debug the macro code

Related Posts: