Skip to content

Home
Subject
Exams
GK Questions
EXCEL TUTORIAL
Career Blog
Daily Current Affairs 2024

Home
Subject
Exams
GK Questions
EXCEL TUTORIAL
Career Blog
Daily Current Affairs 2024

Home
Quizzes & Surveys
MCQ ON MS Excel Set 5

MCQ ON MS Excel Set 5

Leave a Comment / By MCQBOX / 30 December 2023

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?

A) RANK()

B) ORDER()

C) SORT()

D) INDEX()

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

A) Highlights cells that are referred to by a formula in the selected cell

B) Removes precedents from formulas

C) Adds precedents to formulas

D) Checks for circular references in formulas

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

A) FACT()

B) FACTORIAL()

C) COMBIN()

D) PERMUT()

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

A) Monitor and display the values of specific cells in a separate window

B) Watch and track changes made to a worksheet in real-time

C) Display a summary of formulas used in a worksheet

D) Create visual representations of data

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

A) Lookup

B) Relationship Builder

C) Data Model

D) Data Linking

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

A) Solve complex mathematical equations

B) Analyze data patterns

C) Perform statistical analysis

D) Find optimal solutions for problems by changing variables

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

A) CEILING()

B) FLOOR()

C) ROUNDDOWN()

D) INT()

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

A) Analyze data trends

B) Perform hypothetical calculations based on different scenarios

C) Validate data entered into cells

D) Create custom charts and graphs

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

A) Merge

B) Consolidate

C) Combine

D) Aggregate

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

A) Quickly delete unnecessary data from a worksheet

B) Automatically format cells based on specified criteria

C) Automatically fill cells with data based on patterns it recognizes in adjacent columns

D) Create flash animations within cells

Please fill in the comment box below.

Time's up

Post navigation

← Previous Quiz

Next Quiz →

Leave a Reply Cancel reply