Keyboard shortcuts for efficiency in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the entire column in Excel using a keyboard shortcut.

Excel

Press [1] to select the entire column of the active cell.

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

ACtrl + C

BCtrl + Space

CAlt + Enter

DShift + Space

Attempts:

3 left

💡 Hint

Common Mistakes

Using Shift + Space which selects the entire row instead of the column.

Pressing Ctrl + C which copies the selection instead of selecting a column.

Pressing Ctrl + Space selects the entire column of the active cell in Excel.

2fill in blank

medium

Complete the code to quickly insert the current date in a cell.

Excel

Press [1] to insert the current date as a static value in the selected cell.

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

ACtrl + ;

BCtrl + D

CCtrl + Shift + :

DAlt + F4

Attempts:

3 left

💡 Hint

Common Mistakes

Using Ctrl + Shift + : which inserts the current time instead of the date.

Pressing Ctrl + D which fills down the content from the cell above.

Pressing Ctrl + ; inserts the current date as a fixed value in the selected cell.

3fill in blank

hard

Fix the error in the shortcut to copy the selected cells.

Excel

Press [1] to copy the selected cells to the clipboard.

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

ACtrl + X

BCtrl + V

CCtrl + C

DCtrl + Z

Attempts:

3 left

💡 Hint

Common Mistakes

Using Ctrl + V which pastes instead of copying.

Using Ctrl + X which cuts instead of copying.

Ctrl + C copies the selected cells. Ctrl + V pastes, Ctrl + X cuts, and Ctrl + Z undoes.

4fill in blank

hard

Fill both blanks to complete the shortcut for undoing and redoing actions.

Excel

Press [1] to undo an action, and [2] to redo it.

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

ACtrl + Z

BCtrl + Y

CCtrl + X

DCtrl + C

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing redo with cut or copy shortcuts.

Using Ctrl + C or Ctrl + X instead of redo shortcut.

Ctrl + Z undoes the last action, and Ctrl + Y redoes it.

5fill in blank

hard

Fill all three blanks to complete the shortcut for saving, opening, and creating a new workbook.

Excel

Press [1] to save, [2] to open an existing file, and [3] to create a new workbook.

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

ACtrl + S

BCtrl + O

CCtrl + N

DCtrl + P

Attempts:

3 left

💡 Hint

Common Mistakes

Using Ctrl + P instead of Ctrl + N for new workbook.

Mixing up open and new shortcuts.

Ctrl + S saves the current workbook, Ctrl + O opens an existing file, and Ctrl + N creates a new workbook.