MCQ on MS Excel Set 5

Leave a Comment / By /

MCQ on MS Excel Set 5 for all Competitive Exams

Welcome to an interactive post featuring Multiple Choice Questions (MCQs) focused on Microsoft Excel! Perfect for interview preparation or competitive exams

MCQ on MS Excel Set 5 by MCQBOX

Welcome to your MCQ ON MS Excel Set 5

1. Which function is used to find the rank of a number in a list in Excel?

2. What does the 'Trace Precedents' feature in Excel do?

3. Which function is used to calculate the factorial of a number in Excel?

4. What does the 'Watch Window' feature in Excel allow users to do?

5. Which Excel feature is used to create a relationship between tables based on a common column?

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

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

8. What does the 'What-If Analysis' feature in Excel allow users to do?

9. Which Excel feature is used to consolidate data from multiple ranges into one?

10. What does the 'Flash Fill' feature in Excel do?

Leave a Comment

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

Scroll to Top