Excel Macros Quiz

What do you understand by MACROS?

• It's like recording a recipe for a task.

• It's a set of instructions written in VBA.

• It automates tasks you would normally do manually.

• All of the above.

What is the first step to record a Macro?

• Open your Excel file containing the inventory table.

• Select the Developer tab.

• Click Record Macro.

• Perform the formatting tasks.

What should you do if the Developer tab is not visible?

• Go to File > Options > Customize Ribbon.

• Click on the Developer tab.

• Select the inventory table.

• None of the above.

What does the Use Relative References option do?

• Starts recording from fixed cells.

• Starts recording from wherever you are.

• Records all actions without any reference.

• None of the above.

What is the purpose of the HighlightLowStock macro?

• To format the headers.

• To highlight rows with low stock.

• To add borders to the table.

• To change the color of the table.

What happens when a cell in column C2:C21 is changed?

• Nothing.

• A message box appears.

• The cell is formatted.

• The macro stops running.

What is the function of the Absolute References option?

• Locks the cell reference during recording.

• None of the above.

• Allows dynamic cell references.

• Records actions without any cell reference.

What does the RunMacro button do?

• It stops the currently running macro.

• It executes a recorded macro.

• It opens the macro editor.

• It saves the macro.

How can you edit an existing macro?

• None of the above.

• By selecting the macro and clicking Edit.

• By going to the Developer tab and selecting Macros.

• By deleting and re-recording it.

What is the purpose of the Record Macro feature?

• To save the current workbook.

• To automate repetitive tasks.

• To create a new worksheet.

• To format cells in a spreadsheet.