Google Sheets Test Google Sheets Automation with Macros 2

Question 1

When you record a macro in Google Sheets, what language is the underlying code written in?

Accepted Answer

Google Apps Script (JavaScript-based)

Answer

Google Sheets macros are stored as Google Apps Script, which is based on JavaScript.

Question 2

Which menu path is used to begin recording a new macro?

Accepted Answer

Extensions > Macros > Record macro

Answer

Macro recording lives under Extensions > Macros > Record macro.

Question 3

What is the maximum number of macros you can assign a keyboard shortcut to in a single Google Sheets file?

Accepted Answer

10

Answer

Google Sheets limits keyboard-shortcut-assigned macros to 10 per file.

Question 4

The keyboard shortcut assigned to a recorded macro typically follows which pattern?

Accepted Answer

Ctrl+Alt+Shift+<number>

Answer

Recorded macro shortcuts use Ctrl+Alt+Shift plus a number key.

Question 5

When recording, choosing 'Relative references' means the macro will:

Accepted Answer

Act on cells relative to your current selection

Answer

Relative references make the macro operate based on the position of the active cell.

Google Sheets Test Practice Test