Home > Microsoft Excel > Quizzes > Microsoft Excel Practice Test
Microsoft Excel Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 72% • Most missed: “The fill function can be ____ to complete formulas in a range.”
Microsoft Excel Practice Test
Time left 00:00
25 Questions

1. What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?
2. What is the collection of worksheets called?
3. What is the keyboard shortcut to view formulas instead of values in MS Excel?
4. Steps for protecting a sheet by password in MS Excel?
5. How many times undo levels can be used in a worksheet?
6. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
7. Which function is used to get days, months, or years between two dates?
8. Which function is used to remove extra spaces from the text in MS Excel?
9. How many hyperlinks can be there in a worksheet?
10. What is the default file name of Microsoft Excel file?
11. Which chart type is used to show trends over time and categories?
12. Which function is used to find the sum of complex numbers in MS Excel?
13. How many users can open the Excel file at the same time?
14. What is the keyboard shortcut to insert a SUM formula in MS Excel?
15. The Excel ____ function returns the Boolean value FALSE.
16. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
17. Which function is used to create a date with year, month, and day?
18. The total number of characters that a cell contains is?
19. Which chart type is used to visually compare values across a few categories?
20. Show/Hide Gridlines option is available in the ____ Menu.
21. The total number of columns in a worksheet?
22. The ____ function is used to convert to text in a number format in MS Excel.
23. What is the keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar in MS Excel?
24. Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?
25. Which feature is used to wrap extra-long text into multiple lines in MS Excel?

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