Excel Interview Questions For Data Analyst

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

 

What is an absolute cell reference?
A reference that changes when copied
A reference that doesn't change when copied
A reference to another sheet
A reference to another workbook
How does INDEX differ from LOOKUP?
No difference
INDEX is more flexible
LOOKUP is more flexible
INDEX is faster
What does the CONCATENATE function do?
Splits text
Joins text
Formats text
Counts text
How do you combine text from multiple cells?
Use SUM
Use CONCATENATE or &
Use VLOOKUP
Use IF
What's the main purpose of the INDIRECT function?
Creates direct references
Creates indirect references
Formats cells
Creates hyperlinks
Where is the Find and Replace feature located?
Home tab
Data tab
Review tab
Formulas tab
How do you edit a formula in Excel?
Double-click the cell
Press F2
Right-click > Edit Formula
Click the formula bar
What does the SUMIF function do?
Adds all numbers
Adds numbers meeting a condition
Counts numbers meeting a condition
Averages numbers meeting a condition
What do MAX and MIN functions do?
Find average values
Find extreme values
Sort data
Format numbers
Which function returns the mode of a data set?
MODE
MEDIAN
AVERAGE
MOST
What does the DATEVALUE function do?
Formats dates
Converts text to date
Calculates date difference
Returns current date
What is VBA in Excel?
Visual Basic Application
Very Big Application
Variable Basic Algorithm
Vertical Bar Analysis
What does the RIGHT function do?
Aligns text right
Extracts rightmost characters
Moves cell right
Formats right side
Which function would you use to return the smallest value in a range?
MIN
SMALL
LOWEST
LEAST
What does TRIM do?
Removes all spaces
Removes leading/trailing spaces
Joins text
Splits text
What is a Slicer used for in Excel?
Cutting data
Filtering pivot tables and charts
Formatting cells
Splitting text
What is a cell address?
A unique cell identifier
A formula
A data type
A chart type
What's the primary use of the RANDBETWEEN function?
Generates random decimal
Generates random integer in range
Sorts randomly
Selects random cells
What are Freeze Panes used for?
To lock specific rows or columns
To protect the worksheet
To create a table
To format cells
Which function returns a reference to a single cell?
CELL
REF
OFFSET
INDEX
Which function calculates the number of days between two dates?
DAYS
DATEDIF
DAYSBETWEEN
DATERANGE
What does the TRANSPOSE function do in Excel?
Converts text case
Flips data horizontally
Switches rows and columns
Rotates text
Which function would you use to return the absolute value of a number?
ABSOLUTE
ABS
POSITIVE
UNSIGNED
What does SIGN do?
Formats cell
Returns 1, 0, or -1 based on number's sign
Creates signature
Checks if positive
Which Excel feature allows you to create dynamic chart titles?
Data Validation
Name Manager
VLOOKUP function
Cell References
Score: 0/25