Home > Microsoft Excel > Quizzes > Microsoft Excel Practice Test 2
Microsoft Excel Practice Test 2
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 29% • Most missed: “The intersection of a column and a row in a worksheet is called ____.”
Microsoft Excel Practice Test 2
Time left 00:00
25 Questions

1. The intersection of a column and a row in a worksheet is called ____.
2. The fill function can be ____ to complete formulas in a range.
3. What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?
4. Which option is used to hide/show the Headings in MS Excel?
5. The currently selected cell address is displayed in ____.
6. How many hyperlinks can be there in a worksheet?
7. Which function is used to get days, months, or years between two dates?
8. The Excel ____ function returns the Boolean value FALSE.
9. What is the keyboard shortcut to insert a SUM formula in MS Excel?
10. Which keyboard shortcut is used to apply 'Wrap Text' on the selected text?
11. Which function is used to trap and handle errors?
12. Which function is used to trap and handle #N/A errors?
13. What is the correct value of the function? =ROUND (1.9867,2)
14. Which function is used to remove extra spaces from the text in MS Excel?
15. What is the keyboard shortcut to insert a new comment in a cell in MS Excel?
16. The total number of characters that a cell contains is?
17. Which Excel function is used to get the discount rate for security?
18. What is the keyboard shortcut to switch between open Excel windows?
19. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
20. Under which Tab, the chart options are available in MS Excel?
21. What is the extension of a Microsoft Excel file?
22. The ____ function is used to convert to text in a number format in MS Excel.
23. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
24. Which function is used to get the location of text in a string in MS Excel?
25. What is the collection of worksheets called?

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