Home > Microsoft Excel > Quizzes > Shortcuts for Microsoft Excel 2019 (Windows)
Shortcuts for Microsoft Excel 2019 (Windows)
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 30% • Most missed: “Insert or edit hyperlinK (for complete cell only)”
Shortcuts for Microsoft Excel 2019 (Windows)
Time left 00:00
25 Questions

1. Enable Editing for protected view (File Info Enable Editing)

2. Select the first item/ last item in the AutoFilter list

3. Repeat a previous cell format action on current cell

4. File Save as via Excel file manager

5. Move active cell right/ left in selection

6. Align Top

7. Home select Font Size; use Arrow Key, then Enter to change size

8. Hide selected columns

9. Navigate by one cell at a time in any direction

10. Edit formula in formula Bar

11. Jump to beginning/ end of cell

12. Select single row; then insert one row above

13. Complete cell entry and move one cell down/ up

14. Close the find and replace dialog Box (with focus on dialog box)

15. Redo (after undo) or Repeat (e.g. when applying formats)

16. Duplicate row via fill down - Fill current row with content from row above.

17. Display the Find and Replace dialog box (with find selected)

18. Move to the next/ previous field which can be edited

19. Select all cells with comments

20. Enter a formula as an array formula. Formula bar will show this as e.g. {=SUM(A1:A3*B1:B3)} whichis the sum of A1*B2+A2*B2+A3+B3. This is an easy and concise method. Remember that each time editing the formula will require the Ctrl+Shift+Enter. Some keyboards seem to distinguish between left and right Shift key

21. Select all cells in data-containing area. Press twice to select everything

22. Calculate all worksheets in all open workbooks

23. Insert current time at cursor position

24. Align Right

25. Open recent file (1 thru 9)

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice Test Prove It - Microsoft Excel Test Microsoft Excel (MS Excel) Practice Test: All Topics Counting and Rounding Formulas Useful Excel Vocabulary Management Science MGSC 290 Final Excel Fundamentals Test (Upwork) Prove It - Microsoft Excel 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.