Home > Microsoft Excel > Quizzes > Microsoft Excel Functions Formulas Shortcuts
Microsoft Excel Functions Formulas Shortcuts
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 40% • Most missed: “Select From List”
Microsoft Excel Functions Formulas Shortcuts
Time left 00:00
25 Questions

1. Erase Traces

2. Show Formulas

3. Find Based on Column

4. Show all Dependents

5. Recalculate all workbooks

6. Displays the present value of a series of equal payments at a fixed rate for a specified number of payments.

7. Displays the average of the range identified in the argument. For example - =AVERAGE(E4:E9) displays the average of the numbers contained in the range E4:E9.

8. Conditional Count

9. View Macros

10. Highlight Comments

11. Displays the standard deviation of the numbers contained in the range of the argument.

12. Show formulas/values

13. Zoom to selection

14. Minimum

15. Ranges that have a $ character before the column portion of the reference and/or the row portion of the reference.

16. Find Item

17. Add/Edit Comment

18. Paste Link

19. Trace Dependents

20. Record Macros

21. Conditional Sum

22. At Least 1 Must Be True

23. Displays the sum of cells with numerical values in the argument range. For example - =SUM(D6:D21) displays the total added together if all the cells are filled.

24. Go to Formulas

25. Find Based on Row

⚡ 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.