Keyboard shortcuts in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to copy the selected cells using the keyboard shortcut.

Google Sheets

Press Ctrl + [1] to copy the selected cells.

Drag options to blanks, or click blank then click option'

AZ

BC

CX

DV

Attempts:

3 left

💡 Hint

Common Mistakes

Pressing Ctrl + V instead of Ctrl + C

Pressing Ctrl + X which cuts instead of copies

Pressing Ctrl + Z which undoes the last action

Ctrl + C is the standard shortcut to copy selected cells in Google Sheets.

2fill in blank

medium

Complete the code to paste the copied cells using the keyboard shortcut.

Google Sheets

Press Ctrl + [1] to paste the copied cells.

Drag options to blanks, or click blank then click option'

AV

BC

CX

DZ

Attempts:

3 left

💡 Hint

Common Mistakes

Pressing Ctrl + C instead of Ctrl + V

Pressing Ctrl + X which cuts instead of pastes

Pressing Ctrl + Z which undoes the last action

Ctrl + V pastes the copied content in Google Sheets and many other programs.

3fill in blank

hard

Fix the error in the shortcut to undo the last action.

Google Sheets

Press Ctrl + [1] to undo the last action.

Drag options to blanks, or click blank then click option'

AZ

BC

CX

DY

Attempts:

3 left

💡 Hint

Common Mistakes

Pressing Ctrl + Y which is redo, not undo

Pressing Ctrl + X which cuts content

Pressing Ctrl + C which copies content

Ctrl + Z is the universal shortcut to undo the last action in Google Sheets.

4fill in blank

hard

Fill both blanks to select the entire column of the active cell.

Google Sheets

Press Ctrl + [1] to select the entire column, then press Ctrl + [2] to copy it.

Drag options to blanks, or click blank then click option'

ASpace

BC

CArrow Down

DV

Attempts:

3 left

💡 Hint

Common Mistakes

Using Arrow Down instead of Space to select the column

Using Ctrl + V instead of Ctrl + C to copy

Ctrl + Space selects the entire column, and Ctrl + C copies it.

5fill in blank

hard

Fill all three blanks to insert a new row above the current row.

Google Sheets

Press Shift + [1] + [2] to open the insert menu, then press [3] to insert a row above.

Drag options to blanks, or click blank then click option'

ACtrl

BAlt

CI

DR

Attempts:

3 left

💡 Hint

Common Mistakes

Using Alt instead of Ctrl to open the insert menu

Pressing I instead of R to insert the row

Shift + Ctrl + I opens the insert menu, then pressing R inserts a row above.

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