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.