Keyboard shortcuts in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Using keyboard shortcuts to quickly insert the current date

You want to insert the current date into a cell in Google Sheets without typing it manually. Which keyboard shortcut will do this?

A Ctrl + ; (semicolon)

B Ctrl + Shift + D

C Alt + D

D Ctrl + Alt + T

💡 Hint

Think about shortcuts that insert static dates rather than formulas.

In Google Sheets, pressing Ctrl + ; inserts the current date as a fixed value. Other options do not perform this action.

📊 Formula Result

intermediate

Effect of keyboard shortcut on formula editing

You are editing a formula in a cell. Which keyboard shortcut will move the cursor to the beginning of the formula text?

A End key

B Ctrl + End

C Ctrl + Home

D Home key

💡 Hint

Think about keys that move the cursor within text.

The Home key moves the cursor to the start of the formula text when editing a cell. Ctrl + Home moves to the start of the sheet, not the formula.

❓ Function Choice

advanced

Choosing the shortcut to quickly fill down a formula

You have a formula in cell A1 and want to copy it down to cells A2 through A10 using a keyboard shortcut. Which shortcut will do this?

A Ctrl + R

B Ctrl + Shift + V

C Ctrl + D

D Ctrl + Shift + D

💡 Hint

Think about shortcuts that fill down from the active cell.

Ctrl + D fills the formula down from the active cell to the selected cells below. Ctrl + R fills right, and the others do not fill formulas.

❓ data_analysis

advanced

Identifying the shortcut to select an entire column

You want to select the entire column of the active cell quickly using the keyboard. Which shortcut will do this in Google Sheets?

A Ctrl + Space

B Shift + Space

C Ctrl + Shift + Space

D Alt + Space

💡 Hint

One shortcut selects the entire row, another the entire column.

Ctrl + Space selects the entire column of the active cell. Shift + Space selects the entire row.

🧠 Conceptual

expert

Understanding shortcut conflicts on different operating systems

On a Mac, which keyboard shortcut inserts the current time as a static value in Google Sheets?

A Cmd + Alt + T

B Cmd + Shift + ; (semicolon)

C Ctrl + Shift + ; (semicolon)

D Cmd + ; (semicolon)

💡 Hint

The shortcut for current time differs from current date on Mac.

On Mac, Cmd + Shift + ; inserts the current time as a static value. Cmd + ; inserts the current date.

Practice

1. Which keyboard shortcut in Google Sheets is used to undo the last action?

easy

A. Ctrl + Z (Command + Z on Mac)

B. Ctrl + Y (Command + Y on Mac)

C. Ctrl + C (Command + C on Mac)

D. Ctrl + V (Command + V on Mac)

Solution

1. Step 1: Understand the undo function

   Undo reverses the last change made in the sheet.

2. Step 2: Identify the correct shortcut

   Ctrl + Z (or Command + Z on Mac) is the standard undo shortcut in Google Sheets.

3. Final Answer:

   Ctrl + Z (Command + Z on Mac) -> Option A

4. Quick Check:

   Undo = Ctrl + Z [OK]

Hint: Undo is always Ctrl + Z or Command + Z on Mac [OK]

Common Mistakes:

• Confusing undo with redo shortcut
• Using copy or paste shortcuts instead
• Trying Ctrl + Y for undo instead of redo

2. Which of the following is the correct keyboard shortcut to copy selected cells in Google Sheets?

easy

A. Ctrl + C

B. Ctrl + V

C. Ctrl + X

D. Ctrl + Z

Solution

1. Step 1: Recall the copy shortcut

   Copy duplicates the selected content without removing it.

2. Step 2: Match the shortcut to copy

   Ctrl + C (Command + C on Mac) is the standard copy shortcut.

3. Final Answer:

   Ctrl + C -> Option A

4. Quick Check:

   Copy = Ctrl + C [OK]

Hint: Copy is always Ctrl + C or Command + C on Mac [OK]

Common Mistakes:

• Mixing copy with paste shortcut
• Using cut shortcut instead of copy
• Confusing undo shortcut with copy

3. If you want to quickly select an entire column in Google Sheets, which shortcut should you use?

medium

A. Shift + Space

B. Alt + Space

C. Ctrl + A

D. Ctrl + Space

Solution

1. Step 1: Understand selection shortcuts

   Ctrl + Space selects the entire column of the active cell.

2. Step 2: Identify the correct shortcut

   Ctrl + Space is the standard shortcut for selecting a column in Google Sheets.

3. Final Answer:

   Ctrl + Space -> Option D

4. Quick Check:

   Select column = Ctrl + Space [OK]

Hint: Select column quickly with Ctrl + Space [OK]

Common Mistakes:

• Using Shift + Space which selects a row
• Trying Ctrl + A which selects all cells
• Confusing Alt + Space with other shortcuts

4. You tried to paste copied cells using Ctrl + P in Google Sheets, but it didn't work. What is the correct shortcut to paste?

medium

A. Ctrl + X

B. Ctrl + P

C. Ctrl + V

D. Ctrl + C

Solution

1. Step 1: Identify the paste shortcut

   Paste inserts copied content into the selected cells.

2. Step 2: Correct the wrong shortcut

   Ctrl + V (Command + V on Mac) is the correct paste shortcut, not Ctrl + P.

3. Final Answer:

   Ctrl + V -> Option C

4. Quick Check:

   Paste = Ctrl + V [OK]

Hint: Paste is Ctrl + V, not Ctrl + P [OK]

Common Mistakes:

• Using Ctrl + P which is print
• Confusing paste with copy or cut
• Trying Ctrl + X which cuts instead of pastes

5. You want to quickly insert a new row above the current row in Google Sheets without using the mouse. Which keyboard shortcut should you use?

hard

A. Ctrl + Alt + Down Arrow

B. Ctrl + Shift + Plus (+)

C. Ctrl + Shift + Minus (-)

D. Ctrl + Enter

Solution

1. Step 1: Understand inserting rows shortcut

   Ctrl + Shift + Plus (+) inserts a new row or column depending on selection.

2. Step 2: Confirm the correct shortcut for new row

   Using Ctrl + Shift + Plus (+) with a selected row inserts a new row above.

3. Final Answer:

   Ctrl + Shift + Plus (+) -> Option B

4. Quick Check:

   Insert row = Ctrl + Shift + + [OK]

Hint: Insert row with Ctrl + Shift + + (plus) [OK]

Common Mistakes:

• Using Ctrl + Shift + Minus which deletes rows
• Trying Ctrl + Enter which edits cell
• Confusing with arrow key shortcuts