Excel Interview Questions For Data Analyst

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

 

What does the TRIM function do?
Removes leading and trailing spaces
Removes all spaces
Trims text to a specific length
Removes duplicate characters
How do you select non-adjacent cells in Excel?
Click and drag
Use Ctrl + Click
Use Shift + Click
Double-click each cell
What does the RAND function generate in Excel?
Random integer
Random decimal between 0 and 1
Random date
Random text
What is the main purpose of QUOTIENT?
Divides with remainder
Returns integer portion of division
Calculates percentages
Multiplies numbers
Which of these is not a data format available in Excel?
Number
Text
Date
Binary
What is the correct order of operations in Excel?
PEMDAS
BODMAS
DMSAEP
SADMEP
Which function would you use to extract the first 5 characters from a text string?
LEFT
RIGHT
MID
EXTRACT
Which function counts cells containing numbers in Excel?
COUNT
COUNTA
COUNTIF
COUNTBLANK
Where is the Filter option in Excel?
Home tab
Data tab
Insert tab
View tab
Which function returns the kth largest value in a dataset?
MAX
LARGE
HIGHEST
TOP
What does PROPER do?
Formats cells
Capitalizes first letter of each word
Checks spelling
Aligns text
What does REPT do?
Removes text
Replaces text
Repeats text
Reverses text
What is a named range in Excel?
A range with a custom name
A range of numbers
A range of text
A range of dates
What does the 'V' in VLOOKUP stand for?
Value
Variable
Vector
Vertical
How do you start creating a pivot table?
Select data > Insert > Pivot Table
Data tab > Summarize
Home > Tables > Pivot
Formulas > Insert Function > Pivot
How do you create a PivotChart?
Insert > PivotChart
PivotTable Tools > Analyze > PivotChart
Chart Tools > Design > PivotChart
Data > Summarize with Chart
Which function would you use to join text from multiple cells?
CONCAT
JOIN
MERGE
COMBINE
What's the main benefit of using Excel Macros?
To format cells
To automate repetitive tasks
To create charts
To validate data
What is a benefit of using the SHEET function?
It sums all sheets
It counts sheets
It returns the sheet number
It protects sheets
What does the IF function do in Excel?
Adds numbers
Performs a logical test
Looks up values
Counts cells
How do you standardize formatting across sheets?
Use cell styles
Apply conditional formatting
Copy and paste formats
Use format painter
What does TEXT do?
Joins text
Splits text
Formats a value as text
Counts text
What does a nested IF statement allow you to do?
Test multiple conditions
Perform simultaneous calculations
Create recursive functions
Generate random numbers
What is a workbook in Excel?
A single spreadsheet
A collection of worksheets
A type of chart
A data validation tool
What does the WEEKDAY function return?
Day name
Day number of the week
Week number
Month name
Score: 0/25