MCQ on MS Excel Set 2

Leave a Comment / By /

MCQ on MS Excel Set 2 for Competitive Exams

Test your Excel skills with our online Excel assessment test! This test is designed to evaluate your proficiency in Excel functions, formulas, data analysis, and more. Whether you’re a beginner or an advanced user, this assessment will help gauge your Excel expertise. Join us for this opportunity to showcase your skills and improve your proficiency.

MCQ on MS Excel Set 2 by MCQBOX

Welcome to your Online excel assessment test

1. Which function is used to find the smallest number in a range of cells in Excel?

2. What does the function SUMIF do in Excel?

3. Which option is used to change the reference style in Excel from relative to absolute or mixed?

4. Which keyboard shortcut is used to open the 'Go To' dialog box in Excel?

5. What is the purpose of the 'PivotTable' feature in Excel?

6. Which function is used to round a number to the nearest integer in Excel?

7. What is the purpose of the 'IF' function in Excel?

8. What does the 'AutoFill' feature in Excel do?

9. Which function is used to count the number of cells in a range that meet multiple criteria in Excel?

10. What does the 'Freeze Panes' feature in Excel allow users to do?

Leave a Comment

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

Scroll to Top