Microsoft Excel MCQ Test 2

1. Which feature allows you to visualize data trends over time in Excel?

2. Which Excel feature allows you to create automated workflows and data integrations?

3. How can you create a pivot table in Excel?

4. How can you apply a currency format to cells in Excel?

5. Which keyboard shortcut is used to open the 'Find and Replace' dialog box in Excel?

6. Which formula can be used to count the number of cells in a range that contain numbers?

7. Which chart type is best suited for displaying trends over a period in Excel?

8. How can you create a dynamic array in Excel without using array formulas?

9. Which feature in Excel allows you to collaborate with others in real-time?

10. How can you create a custom Excel function using VBA?

11. How can you protect specific cells from being edited in Excel?

12. Which function is used to find the largest value in a range in Microsoft Excel?

13. Which function is used to sum a range of cells in Microsoft Excel?

14. How can you merge multiple cells into a single cell in Excel?

15. How can you split text from one cell into multiple cells based on a delimiter in Excel?

16. Which function is used to extract the middle name from a full name in Excel?

17. Which formula can be used to calculate the internal rate of return (IRR) in Excel?

18. Which option allows you to create a new worksheet in an Excel workbook?

19. How can you sort data alphabetically in Excel?

20. How can you apply a filter to data in an Excel spreadsheet?