Microsoft Excel MCQ Test 3

1. Which Excel function can be used to calculate the total number of cells that meet a specific condition?

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

3. What is the purpose of the VLOOKUP function in Excel?

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

5. Which Excel feature allows you to create dynamic dashboards?

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

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

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

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

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