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 shortcut autocompletes a formula?

ALT + RIGHT ARROW

CTRL + SHIT + A

SHIT + TAB

TAB

2 / 10

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

CTRL + :

CTRL + D

CTRL + ;

CTRL + SHIFT + D

3 / 10

Which shortcuts select the entire row?

CTRL + SPACE

SHIFT + SPACE

CTRL + SHIFT + R

ALT + SHIFT + R

4 / 10

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

F12

5 / 10

Which shortcuts insert the SUM function in a cell?

Alt + =

CTRL + F7

SHIFT + F4

CTRL + ALT + S

6 / 10

Which shortcuts open a new workbook?

CTRL + SHIFT + N

CTRL + N

ALT + CTRL + N

ALT + N

7 / 10

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

SHIFT + C

CTRL + SHIFT + C

CTRL + SHIFT + V

CTRL + ALT + V

8 / 10

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

CTRL + SHIFT + S

F12

SHIFT + S

ALT + S

9 / 10

Which shortcut allows you to add dollars to your references?

SHIT + F3

10 / 10

Which shortcut can audit a part of your formula?

F10

F11

Your score is

The average score is 58%

Excel Shortcuts Test: Ace Your Spreadsheet Skills

Most Viewed Posts