MCQ on MS Excel Set 4

Welcome to your MCQ on MS Excel Set 4

1. Which function is used to calculate the interest on a loan or investment in Excel?

2. What does the 'Conditional Formatting' feature in Excel allow users to do?

3. Which function is used to find the largest integer less than or equal to a given number in Excel?

4. What does the 'Protect Sheet' feature in Excel allow users to do?

5. Which keyboard shortcut is used to save an Excel workbook?

6. What does the 'Goal Seek' feature in Excel allow users to do?

7. Which function is used to calculate the exponential growth of an investment in Excel?

8. What does the 'Subtotal' function in Excel do?

9. Which Excel feature is used to create drop-down lists in cells?

10. What does the 'Scenario Manager' feature in Excel allow users to do?

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top