Excel Interview Questions For Data Analyst

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