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

### #1. What does VLOOKUP function do in Excel?

### #2. How do you freeze panes in Excel?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

### #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?

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

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

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