Excel Shortcuts Test: Ace Your Spreadsheet Skills

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

Which shortcuts insert the day of today in a cell?
The date as value, not the function TODAY()

CTRL + :

CTRL + D

CTRL + SHIFT + D

CTRL + ;

2 / 10

Which shortcuts paste in values? (Available only with Excel 365)

CTRL + ALT + V

SHIFT + C

CTRL + SHIFT + V

CTRL + SHIFT + C

3 / 10

Which shortcut can audit a part of your formula?

F10

F11

4 / 10

Which shortcut autocompletes a formula?

CTRL + SHIT + A

ALT + RIGHT ARROW

TAB

SHIT + TAB

5 / 10

Which shortcut removes the borders?

Ctrl + '

Ctrl + ]

Ctrl + [

Ctrl + 9

6 / 10

What is the shortcut to open the dialog box "Save As"?

ALT + S

F12

SHIFT + S

CTRL + SHIFT + S

7 / 10

Which shortcuts select the entire row?

SHIFT + SPACE

CTRL + SPACE

ALT + SHIFT + R

CTRL + SHIFT + R

8 / 10

Which shortcut allows you to edit the content of a cell?

F12

9 / 10

Which keyboard shortcut allows you to select the entire column according to the active cell?

CTRL + SPACE

SHIFT + F5

CTRL + SHIFT + C

CTRL + ALT + C

10 / 10

Which shortcuts insert the SUM function in a cell?

CTRL + ALT + S

SHIFT + F4

CTRL + F7

Alt + =

Your score is

The average score is 60%

Excel Shortcuts Test: Ace Your Spreadsheet Skills

Most Viewed Posts