Microsoft Excel MCQ Test: Microsoft Excel MCQs - Practice Questions
1. How can you change the font size of selected text in an Excel cell?
2. What is the default extension for an Excel workbook file?
3. How can you create a custom data validation rule in Excel?
4. Which formula can be used to count the number of cells in a range that contain numbers?
5. How can you create a dynamic array in Excel without using array formulas?
6. Which formula can be used to calculate the internal rate of return (IRR) in Excel?
7. How can you sort data alphabetically in Excel?
8. Which function is used to extract the middle name from a full name in Excel?
9. How can you protect a specific cell from being edited in Excel?
10. Which function is used to sum a range of cells in Microsoft Excel?
11. How can you protect specific cells from being edited in Excel?
12. How can you protect an entire Excel workbook from unauthorized access?
13. Which keyboard shortcut is used to open the 'Find and Replace' dialog box in Excel?
14. Which option allows you to create a new worksheet in an Excel workbook?
15. Which option allows you to adjust the width of columns in Excel?
16. Which Excel feature allows you to create dynamic dashboards?
17. Which Excel tool can be used to perform complex data analysis and visualization?
18. How can you split text from one cell into multiple cells based on a delimiter in Excel?
19. How can you merge multiple cells into a single cell in Excel?
20. How can you create a pivot table in Excel?
21. Which chart type is best suited for displaying trends over a period in Excel?
22. How can you apply a currency format to cells in Excel?
23. How can you apply conditional formatting to highlight cells that contain specific text?
24. Which Excel feature allows you to create automated workflows and data integrations?
25. How can you perform a Monte Carlo simulation in Excel?
26. Which Excel function can be used to calculate the total number of cells that meet a specific condition?
27. Which function is used to find the largest value in a range in Microsoft Excel?
28. How can you apply a border to a cell in Excel?
29. How can you create a custom Excel function using VBA?
30. How can you link data between multiple Excel workbooks?