# Excel Interview Questions for Data Analyst(MCQ): Test Your Knowledge!

What is the main purpose of EVEN?

Checks if number is even

Rounds up to nearest even integer

Rounds to nearest integer

Calculates average

What type of chart shows price, volume, and date?

Line chart

Bar chart

Stock chart

Area chart

What's the main purpose of the CONCATENATE function?

Splits text

Joins text strings

Formats text

Counts characters

What Excel feature allows you to visually represent data trends?

Pivot Table

Solver

Charts

Conditional Formatting

What is PMT used for in Excel?

To calculate loan payments

To format dates

To count cells

To lookup values

What is the purpose of the COUNTA function in Excel?

Counts all cells

Counts non-empty cells

Counts numbers only

Counts text only

What's the primary use of VLOOKUP?

Sorting data

Looking up values in a table

Calculating averages

Formatting cells

What is the difference between absolute and relative cell references?

Absolute references change, relative don't

Relative references change, absolute don't

They are the same

Absolute references use letters, relative use numbers

What is the correct way to calculate the sum of cells A1 to A10, excluding negative values?

=SUMIF(A1:A10,">0")

=SUM(A1:A10,">0")

=SUMPOSITIVE(A1:A10)

=SUMPLUS(A1:A10)

Which function would you use to return the smallest value in a range?

MIN

SMALL

LOWEST

LEAST

What is a Macro in Microsoft Excel?

A shortcut key

A recorded set of actions

A type of chart

A data validation rule

What is the purpose of the ISBLANK function in Excel?

Removes blank cells

Checks if cell is empty

Formats blank cells

Counts blanks

Which function would you use to combine arrays or ranges by using a specific operator?

COMBINE

OPERATE

ARRAYFORMULA

EVALUATE

What does Advanced Filter do?

Basic data filtering

Complex filtering and extraction

Formatting filtered data

Creating filter views

What is the correct way to count the number of unique values in the range A1:A10?

=COUNTUNIQUE(A1:A10)

=COUNTA(UNIQUE(A1:A10))

=SUM(UNIQUE(A1:A10))

=DISTINCTCOUNT(A1:A10)

What is an absolute cell reference in Excel?

A reference that changes when copied

A reference that doesn't change when copied

A reference to another sheet

A reference to another workbook

What does a Bubble Chart show in Excel?

Two variables

Three variables

Four variables

Five variables

What's the primary use of Data Validation?

To format cells

To restrict input to cells

To create formulas

To sort data

What is the purpose of the IFERROR function in Excel?

Checks for errors

Handles division by zero

Traps all errors

Returns custom value on error

How are INDEX and MATCH typically used together?

To create charts

As an alternative to VLOOKUP

To format cells

To validate data

How do you create a histogram in Excel?

Insert > Histogram

Data > Histogram

Home > Insert > Histogram

Developer > Add-Ins > Histogram

What is the primary use of AutoFill in Excel?

To automatically sum columns

To fill a series based on a pattern

To format cells automatically

To insert formulas automatically

What does the AVERAGE function do in Excel?

Calculates median

Finds most frequent value

Computes arithmetic mean

Determines range

What's the primary use of the OFFSET function?

To look up values

To return a reference range

To format cells

To create charts

What does the SEARCH function do?

Finds case-sensitive

Finds case-insensitive

Replaces text

Formats text

Score: 0/25