Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
Contact
French

Quiz Excel Shortcuts

Do you know some tricky Excel shortcuts?

1. Which shortcuts insert the SUM function in a cell?

1.CTRL + F7

2.Alt + =

3.SHIFT + F4

4.CTRL + ALT + S

2. Which shortcut autocompletes a formula?

1.CTRL + SHIT + A

2.ALT + RIGHT ARROW

3.SHIT + TAB

4.TAB

3. Which shortcut allows you to add dollars to your references?

1.F2

2.F8

3.SHIT + F3

4.F4

4. Which shortcuts open a new workbook?

1.CTRL + N

2.CTRL + SHIFT + N

3.ALT + CTRL + N

4.ALT + N

5. Which shortcut can audit a part of your formula?

1.F12

2.F5

3.F9

4.F11

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

1.CTRL + SHIFT + C

2.CTRL + SHIFT + V

3.SHIFT + C

4.CTRL + ALT + V

7. Which shortcut removes the borders?

1.Ctrl + Shift + -

2.Ctrl + [

3.Ctrl + 9

4.Ctrl + ]

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

1.SHIFT + S

2.ALT + S

3.CTRL + SHIFT + S

4.F12

9. Which shortcuts select the entire row?

1.SHIFT + SPACE

2.ALT + SHIFT + R

3.CTRL + SPACE

4.CTRL + SHIFT + R

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

1.CTRL + SHIFT + D

2.CTRL + D

3.CTRL + ;

4.CTRL + :

Your email address:

Your name:

Most Viewed Posts

Quiz Excel Shortcuts

Recent Posts