Are you going for an interview??? Feeling nervous?? Don’t worry. To make your interview successful, we have listed more than 15 excel interview questions for Data Analyst, Business Analyst, and Financial Analyst interviews that can be asked by the interviewer.
Excel Interview Questions
How can you format a cell?
By using cell “Format cells” option you can change the number, alignment, font, text color, background color, border, fill, and protection of any cell. To get more details, click Excel cell formatting.
How many types of formats available in Excel? What are they?
There are different types of formats available in Microsoft Excel. Few of them are:
Can you make pivot table using two different worksheets?
Creating a pivot table on the worksheet using multiple sources on the different worksheet is possible. The workbook of these worksheets must be the same. Click on the link to get details about How to create excel pivot table using multiple worksheets.
Can you resize the column with a single click?
There are three ways to resize the column.
- One way is to drag the boundary of the column towards the right side.
- Second is to go to the format icon available at the home tab and choose the Auto size column width.
- The third is to go to the boundary where alphabets are written and double click on the boundary as shown in the image.
How does “If function” in excel works?
The function is used to test the condition whether it is false or true. If the condition is in favor then it gives a favorable result and if the condition is false then the result comes differently. In fact, you can apply Excel If statement in multiple conditions range.
How to protect the cell of your worksheet from copying by someone else?
To protect your worksheet, go to the menu-> review ->protect sheet-> password. Now you need to enter your password so that you can prevent your worksheet from getting copied.
Can you highlight cells containing duplicate values?
Yes, we can highlight cells using conditional formatting.
- Select the data set.
- Go to the home tab.
- Click on the conditional formatting icon.
- You will find highlight cell rules.
- Press on duplicate values option.
For more details, click conditional formatting excel formula and check how to apply
By using formula, can you combine the text available on multiple cells?
You can combine text via three different methods:
How will you find the length of the text?
To find the length of the string, you need to use LEN formula. For example, if your string is in A2 then type LEN(A2).
What is the format to write Vlookup formula? How can it be used?
VLookup formula is
VLookup(lookup_value, table_array, col_index_num, [range_lookup]). To apply this formula on data set click on Vlookup function in excel.
What is a pivot chart?
After creating a pivot table, you will get a data set that you can use to create a pivot chart. The advantage of the pivot chart is whenever you make changes in your pivot table than that changes will reflect in the pivot chart.
Which chart is the most suitable for showing the performance?
For showing performance based on the target completion then bullet chart is the most preferred chart. The chart will show you lots of information and consume lesser space on your report.
Can you create a hyperlink in excel?
To add a hyperlink, you need to select the cell on which you want to apply hyperlink and use Ctrl+K. By pressing, Control key along with K, you will find hyperlink dialog box where you need to specify your URL.
The ribbon is the top side area where menu items and toolbars are located.
What is the syntax of Sum and Average formula in excel?
The syntax of these formulas is very easy. For Sum “=SUM(A2, A3)” whereas for average “=AVERAGE(A1: A5). For more details, go to excel formulas basic.
What are wildcard characters in Excel?
There are 3 wildcard characters available:
- Asterisk (*)
- Question Mark (?)
For business purpose, which Excel chart is best and why?
For business related issues, the Pareto chart is the best chart for you. Now the question is “Why Pareto chart is best to solve your business issues?” The Pareto chart works on the basis of the Pareto Principle that helps in identifying the root cause and problems occurring in your business. If you find lots of problems and want to focus on the biggest problem then you need Pareto Chart. Check how to make Pareto chart by Clicking here…..
How you can remove duplicates in excel?
To remove duplicates, to need to find duplicates using conditional formatting AND Countif function. Click here to check the process of removing duplicate values in excel.
How to add Bullet Points in Excel?
Like MS Word, you will not find shortcut of adding bullets. But you can use different methods to add bullets in excel.
- Using the symbol box.
- Copy Paste from Ms Word
- Using Formula
To know its step by step process, you need to Click Here.
What is Data Validation?
The data validation is an option which is available in the data tab. This option allows you to enter data that fully satisfies the criteria. For example, if you want to enter the roll no. or age of the student then you need to use Data validation so that it can accept the numeric values only.
How to wrap text in Excel?
The wrapping up of text is to avoid the overflow of text out of the cell. By doing wrap text, you need to be sure that the text fits in the cell. To get the detailed information, click here.
What are the top 5 functions in Excel?
In Excel, there are lots of functions and as such you cannot say that these are your top 5 functions. But here I am listing five functions that are asked in the interviews
Apart from this, Sum and Average, Left/Len/Mid/Right are the functions that also can be asked by the interviewers.
How to combine text of multiple cells using formula?
There are lots of functions available in excel to combine text available in the multiple cells. These are:
What are frequently used Excel Shortcuts?
Here you can check few excel shortcuts that you need frequently:
- Ctrl+U: Underline
- Ctrl+L: Create Table
- F12: Save as
- Shift+F11: New Worksheet
Apart from these, there are other shortcuts also that are frequently used while writing any post.
What is Slicer in Excel?
The Excel slicer is used to filter the data whenever you choose one or more than one options in the slicer box. To get the detailed information Click Here.
What is the use of Pareto Chart?
The Pareto chart is mainly used by business person. With this chart you can make analysis about the flaws coming to your business. You can check here how to create Pareto chart in excel by clicking on the link.
Which function will you use to replace value with another value in Excel?
By using Excel Replace function, you can replace one value with another. If you want to know how to use replace function in excel then Click Here.
What is Goal Seek function?
The Goal seek function in Excel gives you the input value by altering the output value. To know how to use goal seek function, you need to Click Here.
What is Excel Add-Ins?
In Excel Add-Ins, you will find various optional commands that you need to install and then activate them for using it. Click Here to check add-Ins in excel.
How to add Strikethrough in excel?
The Strikethrough in excel is putting a line on the text which has already been checked or the task has completed. To add strikethrough in excel, you need to click Ctrl+S. If you want to know more methods to add strikethrough in excel then click here.
How to calculate standard deviation in excel?
To calculate the standard deviation in excel, you need to apply STDEV formula. The syntax is STDEV(number 1, [number 2], …..). If you want to know other methods then Click Here.
How to lock rows and columns in excel?
To lock rows and columns in excel, you need to freeze panes in excel. Click here to check the steps to freeze the panes in excel.
How to perform multiplication in excel?
To multiply two columns in excel you need to use multiplication operator (*). If you want to know other functions then Click Here.
How to find square root in excel?
To find square root in excel, you need to use SQRT function. The syntax of the SQRT is SQRT(Number). To get the detailed information, Click here and check how to use square root function in excel.
How to apply Excel if statement in multiple conditions?
In order to apply excel if statement in different conditions you need to click here and check the formula to apply for performing logical test and if inside if.
How to resize the column?
To resize the column, go to the format icon available at the home tab and then select Autofit Column Width. Another way to resize the column is to change the width of one column and then drag the column boundary as per the width you require.
How you calculate the unique address of a cell?
The unique address of any cell is calculated on the basis of row and column of any cell.
How to describe excel skills on a resume?
While mentioning your excel skills in your resume, you need to focus on a few aspects:
- Specify yourself: You need to mention your proficiency in excel. Never say that you have an advanced excel skill. Different people take this in different ways. Instead of saying advanced excel proficiency; you can say that you have advanced proficiency in MS Excel including pivot tables, Index/Match, VLookup, and Data Tables.
- Excel Courses: Mention the excel courses you have undergone whether it is online or offline. After the name of the course, you need to briefly explain the learning you got from that course.
- Honest: While mentioning everything you need, to be honest. For example, if you know the basics of excel then mention clearly. Do not mention that you know advanced excel as interviewer may ask you some excel practical questions based on advanced excel and at that time you will be caught.
- Highlight your knowledge or topics in which you are master.
- AngularJS Interview Questions
- Interview Questions for Managers
- SQL Interview Questions
- Project Manager Interview Questions
- Interview Questions for Software Testing
- SEO Interview Questions