Learning Excel
Quizzes
Exercises
Functions
Tips and Tricks
Pivot Table
French

Quiz Excel Shortcuts

Do you know some tricky Excel shortcuts?

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

1.F4

2.F2

3.F8

4.SHIT + F3

2. Which shortcuts open a new workbook?

1.ALT + N

2.CTRL + N

3.ALT + CTRL + N

4.CTRL + SHIFT + N

3. Which keyboard shortcut allows you to select the entire column where the active cell is located?

1.CTRL + SPACE

2.CTRL + ALT + C

3.CTRL + SHIFT + C

4.SHIFT + F5

4. Which shortcuts select the entire row?

1.SHIFT + SPACE

2.CTRL + SPACE

3.CTRL + SHIFT + R

4.ALT + SHIFT + R

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

1.CTRL + D

2.CTRL + ;

3.CTRL + :

4.CTRL + SHIFT + D

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

1.F2

2.F8

3.F12

4.F4

7. Which shortcut autocompletes a formula?

1.ALT + RIGHT ARROW

2.SHIT + TAB

3.TAB

4.CTRL + SHIT + A

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

1.CTRL + SHIFT + C

2.CTRL + ALT + V

3.SHIFT + C

4.CTRL + SHIFT + V

9. Which shortcut removes the borders?

1.Ctrl + ]

2.Ctrl + 9

3.Ctrl + [

4.Ctrl + Shift + -

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

1.CTRL + SHIFT + S

2.ALT + S

3.F12

4.SHIFT + S

Your email address:

Your name:

Most Viewed Posts

Quiz Excel Shortcuts

Recent Posts