Google Sheets Automation with Macros Questions and Answers

Question 1

An analyst records a macro to apply specific formatting (bold font, yellow background) to a selected cell.
They choose the 'Use relative references' option during recording.
If they select cell C5 and run the macro, and then later select cell D10 and run the same macro, what will be the result?

Accepted Answer

The formatting will be applied to cell C5 first, and then to cell D10.

Answer

Only the originally recorded cell will be formatted.

Answer

The macro will format only cell C5 each time it is run.

Answer

An error will occur because the macro was not recorded for cell D10.

Question 2

When you record a macro in Google Sheets, what is automatically generated in the background?

Accepted Answer

A Google Apps Script function that replicates the recorded actions.

Answer

A new, separate Google Sheet file containing the macro steps.

Answer

A private folder in Google Drive to store the macro.

Answer

An XML file embedded within the sheet's metadata.

Question 3

A user wants to create a clickable button on their sheet that executes a macro named 'ArchiveData'. Which of the following describes the correct procedure?

Accepted Answer

Insert a Drawing, style it as a button, and then use the 'Assign script' option to link the macro's function name.

Answer

Use the 'Insert > Button' menu and select the macro from a dropdown list.

Answer

Format a cell to look like a button and use conditional formatting to link the macro.

Answer

Create a custom formula =RUNMACRO("ArchiveData") in a cell.

Question 4

Which of the following is a key limitation of the macro recorder in Google Sheets?

Accepted Answer

Macros recorded in one Google Sheet cannot be directly used in a different Google Sheet without manual steps.

Answer

Macros cannot be edited once they are recorded.

Answer

Macros can only be activated by keyboard shortcuts, not from the menu.

Answer

The macro recorder cannot record formatting changes like changing a cell's color.

Question 5

A user records a macro with 'Use absolute references' selected. The macro was recorded to sort the specific range A2:D100. If the user later adds more data and wants to sort the range A2:D150, what will happen when they run the macro?

Accepted Answer

The macro will only sort the original range, A2:D100, ignoring the new data.

Answer

The macro will automatically detect and sort the new range A2:D150.

Answer

The macro will produce an error because the data range has changed.

Answer

The macro will ask the user to confirm the new range before sorting.

Question 6

To make a macro run automatically every time a user changes the value of any cell in the spreadsheet, what must be done?

Accepted Answer

The macro function must be manually renamed to 'onEdit(e)' in the Apps Script editor.

Answer

Assign the macro to the special 'onOpen(e)' simple trigger.

Answer

Create a time-driven trigger set to run every minute.

Answer

This is not possible; macros can only be run manually via the menu or shortcuts.

An analyst records a macro to apply specific formatting (bold font, yellow background) to a selected cell.They choose the 'Use relative references' option during recording.If they select cell C5 and run the macro, and then later select cell D10 and run the same macro, what will be the result?

An analyst records a macro to apply specific formatting (bold font, yellow background) to a selected cell.
They choose the 'Use relative references' option during recording.
If they select cell C5 and run the macro, and then later select cell D10 and run the same macro, what will be the result?