Quizalize logo
placeholder image to represent content

Spread Sheet - Macros in Excel

Quiz by Jamal Haider Naqvi

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
15 questions
Show answers
  • Q1
    What is a macro in Excel?
    A feature for creating charts.
    A program that automates tasks in Excel.
    An equation used to calculate data.
    The color scheme used in Excel.
    30s
  • Q2
    How do you record a macro in Excel?
    Click on the 'Record Macro' button on the Developer tab.
    Click on the 'Run Macro' button on the Developer tab.
    Click on the 'Execute Macro' button on the Home tab.
    Enter the macro code into the Visual Basic Editor.
    30s
  • Q3
    What is the maximum number of macros that can be stored in an Excel workbook?
    10
    Unlimited
    100
    1000
    30s
  • Q4
    What is the difference between a macro and a function in Excel?
    A macro is used for formatting, while a function is used for calculations.
    A macro is used for calculations, while a function is used for formatting.
    A macro is a series of actions that performs a task, while a function is a formula that returns a value.
    There is no difference between a macro and a function.
    45s
  • Q5
    Macros can only be run on a specific worksheet.
    Not sure
    True
    Depends on the macro
    False
    30s
  • Q6
    Macros can only be created by programming experts.
    True
    False
    Not sure
    Sometimes true
    30s
  • Q7
    Macros can be assigned to keyboard shortcuts and buttons.
    False
    True
    Not sure
    Partially true
    30s
  • Q8
    Macros can be used to manipulate data in Excel worksheets.
    Not sure
    Partially true
    True
    False
    30s
  • Q9
    Macros can be shared with other users.
    False
    True
    Not sure
    Partially true
    30s
  • Q10
    Macros can be run on worksheets that are protected with a password.
    True
    Partially true
    Not sure
    False
    30s
  • Q11

     How can you view and delete macros that have been created in a worksheet?

    All of the options listed above are correct.

     Under the Developer tab, click on the Macros button in the Code group.  Select the macro to delete and click delete.

    Press Alt+F11.  Click on Tools and select Macros.  Select the macro to delete and click delete

    Press Alt+F8, select the macro to be deleted and click delete.

    45s
  • Q12

    Whilst busy recording a macro, you make a mistake.  What is the best course of action?

    You can pause the macro and click Rewind to fix it.

     None of the options listed above are correct.

    You should re-record the macro

     You should press Undo.

    45s
  • Q13

    Study the screenshot above.  Which part of the process of creating a macro is reflected in this image?

    Question Image

    A macro has already been recorded and is busy running.

    A macro recording is in progress.

    None of the above.

    No macro has been recorded yet.

    60s
  • Q14

    If you are good in writing programs, you can also use VBA to write macros in excel

    true
    false
    True or False
    30s
  • Q15

    you can also run your customized Macro assigning short keys but for buttons you need to rewrite all macro again. 

    false
    true
    True or False
    30s

Teachers give this quiz to your class