Excel Shortcuts Test: Ace Your Spreadsheet Skills

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

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

CTRL + SHIFT + S

F12

SHIFT + S

ALT + S

2 / 10

Which shortcut allows you to add dollars to your references?

SHIT + F3

3 / 10

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

CTRL + D

CTRL + SHIFT + D

CTRL + :

CTRL + ;

4 / 10

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

CTRL + SPACE

CTRL + ALT + C

SHIFT + F5

CTRL + SHIFT + C

5 / 10

Which shortcut autocompletes a formula?

CTRL + SHIT + A

ALT + RIGHT ARROW

SHIT + TAB

TAB

6 / 10

Which shortcuts insert the SUM function in a cell?

Alt + =

SHIFT + F4

CTRL + F7

CTRL + ALT + S

7 / 10

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

SHIFT + C

CTRL + SHIFT + C

CTRL + ALT + V

CTRL + SHIFT + V

8 / 10

Which shortcuts select the entire row?

CTRL + SPACE

CTRL + SHIFT + R

ALT + SHIFT + R

SHIFT + SPACE

9 / 10

Which shortcut can audit a part of your formula?

F11

F10

10 / 10

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

F12

Your score is

The average score is 60%

Excel Shortcuts Test: Ace Your Spreadsheet Skills

Most Viewed Posts