50 Common Excel Interview Questions

Are you preparing for an Excel interview? Take a look at the most common Excel interview questions and answers. These questions will help you prepare adequately for the interview. You can use these questions to test your future employees if you are an interviewer. Apart from work, these questions are a good way to gain Excel knowledge. You can also compete with your friends and colleagues.

If you enjoy this quiz, feel free to try others on this website such as the Excel Beginner quiz.

Excel Interview Questions

Results

Related

Related

#1. What does VLOOKUP function do in Excel?

Searches

Searches

Calculates

Calculates

Formats

Formats

Extracts

Extracts

#2. How do you freeze panes in Excel?

Alt + F5

Alt + F5

Alt + F12

Alt + F12

Alt + E

Alt + E

Alt + W

Alt + W

#3. What is a relative cell reference in Excel?

$A$1

$A$1

A1

A1

$A1

$A1

A$1

A$1

#4. Which function is used to count the number of cells with data in a range?

COUNTA

COUNTA

COUNTBLANK

COUNTBLANK

COUNTIF

COUNTIF

COUNT

COUNT

#5. What keyboard shortcut is used to open the "Format Cells" dialog box?

Alt + F4

Alt + F4

Alt + F2

Alt + F2

Alt + F1

Alt + F1

Alt + F5

Alt + F5

#6. How can you add a new worksheet in Excel?

Shift + N

Shift + N

Ctrl + N

Ctrl + N

Alt + N

Alt + N

F12

F12

#7. Which Excel feature is used to summarize data in a graphical representation?

PivotTable

PivotTable

AutoFilter

AutoFilter

Sparklines

Sparklines

Data Bars

Data Bars

#8. What does the COUNT function do in Excel?

Counts text

Counts text

Counts errors

Counts errors

Counts numbers

Counts numbers

Counts blank cells

Counts blank cells

#9. What is the keyboard shortcut to paste values only in Excel?

Alt + V

Alt + V

Ctrl + V

Ctrl + V

Alt + Shift + V

Alt + Shift + V

Alt + P

Alt + P

#10. Which Excel function returns the largest value in a dataset?

MAX

MAX

LARGE

LARGE

MAXIMUM

MAXIMUM

BIGGEST

BIGGEST

#11. How do you remove duplicates from a list in Excel?

Data Validation

Data Validation

Conditional Formatting

Conditional Formatting

Remove Duplicates

Remove Duplicates

Sorting

Sorting

#12. What is the purpose of the CONCATENATE function in Excel?

Joins two or more text strings

Joins two or more text strings

Sums a range of numbers

Sums a range of numbers

Extracts data from a table

Extracts data from a table

Merges cells

Merges cells

#13. Which function is used to calculate the standard deviation of a range?

STDEVP

STDEVP

VARP

VARP

STDEV

STDEV

VARP

VARP

#14. How do you create a drop-down list in Excel?

Data Validation

Data Validation

AutoFill

AutoFill

Data Sorting

Data Sorting

Data Analysis

Data Analysis

#15. Which keyboard shortcut is used to insert a new row in Excel?

Alt + R

Alt + R

Ctrl + R

Ctrl + R

Alt + I

Alt + I

Ctrl + I

Ctrl + I

#16. What is the default file extension for Excel workbooks?

.xls

.xls

.xlsx

.xlsx

.exl

.exl

.xlw

.xlw

#17. Which function is used to find the largest number less than or equal to a given value in Excel?

CEILING

CEILING

FLOOR

FLOOR

ROUND

ROUND

TRUNC

TRUNC

#18. What does the IF function do in Excel?

Checks if a condition is met and returns one value if true and another if false

Checks if a condition is met and returns one value if true and another if false

Returns the sum of a range

Returns the sum of a range

Calculates the square root of a number

Calculates the square root of a number

Finds the average

Finds the average

#19. How can you add a comment to a cell in Excel?

Right-click and select "Add Comment"

Right-click and select "Add Comment"

Ctrl + C

Ctrl + C

Alt + C

Alt + C

Shift + A

Shift + A

#20. Which chart type is best for showing the relationship between two sets of data in Excel?

Line Chart

Line Chart

Scatter Plot

Scatter Plot

Bar Chart

Bar Chart

Pie Chart

Pie Chart

#21. What does the PMT function in Excel calculate?

Payment for a loan with constant payments and interest rate

Payment for a loan with constant payments and interest rate

Present value of an investment

Present value of an investment

Percentage change between two values

Percentage change between two values

Principal amount of a loan

Principal amount of a loan

#22. How do you change the page orientation to landscape in Excel?

Page Layout tab > Orientation > Landscape

Page Layout tab > Orientation > Landscape

File > Page Setup > Landscape

File > Page Setup > Landscape

Home tab > Page Orientation > Landscape

Home tab > Page Orientation > Landscape

Ctrl + L

Ctrl + L

#23. What is the shortcut for auto-sum in Excel?

Alt + S

Alt + S

Ctrl + S

Ctrl + S

Alt + =

Alt + =

Ctrl + =

Ctrl + =

#24. What does the TRIM function do in Excel?

Removes all formatting from a cell

Removes all formatting from a cell

Removes leading and trailing spaces from a text

Removes leading and trailing spaces from a text

Converts text to uppercase

Converts text to uppercase

Calculates the trigonometric sine

Calculates the trigonometric sine

#25. How can you add a hyperlink to a cell in Excel?

Right-click and select "Insert Hyperlink"

Right-click and select "Insert Hyperlink"

Alt + H

Alt + H

Ctrl + K

Ctrl + K

Shift + L

Shift + L

#26. Which function calculates the internal rate of return for a series of cash flows in Excel?

IRR

IRR

NPV

NPV

ROI

ROI

PV

PV

#27. How do you protect a worksheet with a password in Excel?

File > Options > Protection > Set Password

File > Options > Protection > Set Password

Home tab > Protect Sheet

Home tab > Protect Sheet

Ctrl + P

Ctrl + P

Shift + S

Shift + S

#28. What is the purpose of the AVERAGEIF function in Excel?

Averages a range of values based on specified criteria

Averages a range of values based on specified criteria

Finds the average of all values in a range

Finds the average of all values in a range

Rounds a number up to the nearest integer

Rounds a number up to the nearest integer

Converts text to lowercase

Converts text to lowercase

#29. How can you sort data in descending order in Excel?

Sort A to Z

Sort A to Z

Sort Oldest to Newest

Sort Oldest to Newest

Sort Largest to Smallest

Sort Largest to Smallest

Sort Ascending

Sort Ascending

#30. Which Excel feature is used to group and summarize data in a pivot table?

Grouping

Grouping

Summarize

Summarize

Subtotal

Subtotal

Consolidate

Consolidate

#31. What is the keyboard shortcut to open the "Find and Replace" dialog box in Excel?

Ctrl + H

Ctrl + H

Alt + F

Alt + F

Ctrl + F

Ctrl + F

Alt + R

Alt + R

#32. How can you hide a worksheet in Excel?

Right-click the worksheet tab and select "Hide"

Right-click the worksheet tab and select "Hide"

Ctrl + W

Ctrl + W

Alt + H

Alt + H

Shift + H

Shift + H

#33. What is the purpose of the INDEX function in Excel?

Returns the value at a specified row and column

Returns the value at a specified row and column

Counts the number of cells in a range

Counts the number of cells in a range

Rounds a number up to the nearest integer

Rounds a number up to the nearest integer

Converts text to lowercase

Converts text to lowercase

#34. Which Excel function is used to find the smallest value in a range?

MIN

MIN

SMALL

SMALL

MINIMUM

MINIMUM

SMALLEST

SMALLEST

#35. How do you apply conditional formatting in Excel?

Home tab > Conditional Formatting

Home tab > Conditional Formatting

Ctrl + C

Ctrl + C

Alt + F

Alt + F

Shift + A

Shift + A

#36. What is the shortcut for undo in Excel?

Alt + U

Alt + U

Ctrl + U

Ctrl + U

Alt + Z

Alt + Z

Ctrl + Z

Ctrl + Z

#37. What is the purpose of the HLOOKUP function in Excel?

Searches for a value in the top row of a table and returns a value in the same column

Searches for a value in the top row of a table and returns a value in the same column

Calculates the horizontal sum of a range

Calculates the horizontal sum of a range

Rounds a number to the nearest multiple

Rounds a number to the nearest multiple

Converts text to uppercase

Converts text to uppercase

#38. How can you add a border to a cell in Excel?

Format tab > Borders > All Borders

Format tab > Borders > All Borders

Alt + B

Alt + B

Ctrl + A

Ctrl + A

Shift + D

Shift + D

#39. What does the TEXT function do in Excel?

Converts a value to text with a specified format

Converts a value to text with a specified format

Calculates the sum of a range

Calculates the sum of a range

Rounds a number to the nearest integer

Rounds a number to the nearest integer

Removes all formatting from a cell

Removes all formatting from a cell

#40. How can you split text from one cell into multiple cells in Excel?

Data tab > Text to Columns

Data tab > Text to Columns

Ctrl + S

Ctrl + S

Alt + T

Alt + T

Shift + L

Shift + L

#41. Which Excel function is used to count the number of unique values in a range?

COUNT

COUNT

COUNTA

COUNTA

COUNTIF

COUNTIF

COUNTUNIQUE

COUNTUNIQUE

#42. What does the AVERAGEA function do in Excel?

Calculates the average of all values in a range, including text and logical values

Calculates the average of all values in a range, including text and logical values

Calculates the average of all numeric values in a range

Calculates the average of all numeric values in a range

Finds the average of all positive values in a range

Finds the average of all positive values in a range

Converts text to uppercase

Converts text to uppercase

#43. How do you create a pivot chart in Excel?

Insert tab > Pivot Chart

Insert tab > Pivot Chart

Alt + C

Alt + C

Ctrl + Shift + P

Ctrl + Shift + P

Shift + A

Shift + A

#44. What is the function of the MAXIFS function in Excel?

Returns the maximum value in a range that meets multiple criteria

Returns the maximum value in a range that meets multiple criteria

Returns the minimum value in a range that meets multiple criteria

Returns the minimum value in a range that meets multiple criteria

Returns the median value in a range that meets multiple criteria

Returns the median value in a range that meets multiple criteria

Returns the average value in a range that meets multiple criteria

Returns the average value in a range that meets multiple criteria

#45. How do you add a background image to an Excel worksheet?

Page Layout tab > Background Image

Page Layout tab > Background Image

Alt + B

Alt + B

Ctrl + I

Ctrl + I

Shift + A

Shift + A

#46. What is the purpose of the CHOOSE function in Excel?

Returns a value from a list based on a specified position

Returns a value from a list based on a specified position

Calculates the sum of a range

Calculates the sum of a range

Rounds a number to the nearest integer

Rounds a number to the nearest integer

Converts text to uppercase

Converts text to uppercase

#47. How can you create a data table in Excel?

Data tab > What-If Analysis > Data Table

Data tab > What-If Analysis > Data Table

Alt + D

Alt + D

Ctrl + T

Ctrl + T

Shift + L

Shift + L

#48. Which function is used to find the cumulative product of a range in Excel?

PRODUCT

PRODUCT

PROD

PROD

MULTIPRODUCT

MULTIPRODUCT

CUMPROD

CUMPROD

#49. How do you insert a page break in Excel?

Page Layout tab > Breaks > Insert Page Break

Page Layout tab > Breaks > Insert Page Break

Alt + P

Alt + P

Ctrl + B

Ctrl + B

Shift + I

Shift + I

#50. What is the purpose of the ROUNDUP function in Excel?

Rounds a number up to the nearest specified multiple

Rounds a number up to the nearest specified multiple

Rounds a number to the nearest integer

Rounds a number to the nearest integer

Converts text to uppercase

Converts text to uppercase

Calculates the sum of a range

Calculates the sum of a range

Next

#51. Which of the following formulas cannot be used to join the first, second and last name like in the image below?

=TEXTJOIN(" ", TRUE, D4:F4)

=TEXTJOIN(" ", TRUE, D4:F4)

=D4 & CHAR(10) & E4 & CHAR(10) & F4

=D4 & CHAR(10) & E4 & CHAR(10) & F4

=CONCATENATE(D4, " ", E4, " ", F4)

=CONCATENATE(D4, " ", E4, " ", F4)

=D4 & " " & E4 & " " & F4

=D4 & " " & E4 & " " & F4

Next

#52. The Excel feature that predicts text transformation depending on data on the adjacent columns is known as?

Auto Fill

Auto Fill

Series Fill

Series Fill

Data Validation

Data Validation

Flash Fill

Flash Fill

Next

#53. Excel allows users to get rid of spaces inside data. Which of the following formula can get rid of spaces from the cell E8?

=SUBSTITUTE(" ", E8)

=SUBSTITUTE(" ", E8)

=TRIM(E8)

=TRIM(E8)

=CLEAN(E8)

=CLEAN(E8)

REPLACE(SAPCE, E8)

REPLACE(SAPCE, E8)

=TRIM() is the function used to remove spaces in Excel.

Related

Next

#54. You can display the current date in excell by using a function. Which is it?

=NOW()

=NOW()

=TODAY()

=TODAY()

=DATETODAY()

=DATETODAY()

=DATEDIF(TODAY)

=DATEDIF(TODAY)

You can display the date today by using the formal =TODAY(). If you want to display the current time then you need to use the =now() function

Related

Finish