Microsoft Excel Interview Questions and Answers for a Successful Interview
Almost every job these days requires you to have a basic, functional knowledge of Excel. Excel is the top spreadsheet application in the world with over a billion users, and most offices rely on Excel for many daily tasks. If you’re applying for jobs that require any amount of tracking, data, or simple calculations, you will be expected to know Excel. Here are some interview questions you could expect at a basic job interview.
1) What is Microsoft Excel?
Microsoft excel is an electronic worksheet developed by Microsoft, to be used for organizing, storing and manipulating.
2) What is ribbon?
The ribbon runs on the top of the application and is the replacement for the toolbars and menus. The ribbons have various tabs on the top, and each tab has its own group of commands.
3) How can I hide or show the ribbon?
Use the CTRL and F1 key to toggle & show or hide the ribbon.
4) How can you wrap the text within a cell?
You have to select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.
5) Is it possible to prevent someone from copying the cell from your worksheet?
Yes, it is possible. In order to protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect sheet > Password. By
entering password, you can secure your worksheet from getting copied by others.
6) How you can sum up the Rows and Column number quickly in the excel sheet?
By using SUM function you can get the total sum of the rows and columns, in an excel worksheet.
7) How you can add a new excel worksheet?
To add a new Excel worksheet you have to insert worksheet tab at the bottom of the screen.
8) How you can resize the column?
To resize the column you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.
9) What are three report formats that are available in Excel?
10) How would you provide a Dynamic range in “Data Source” of Pivot Tables?
To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using offset function and base the pivot table using a named range created in the first step.
11) Is it possible to make Pivot table using multiple sources of data?
If the multiple sources are different worksheets, from same workbook, then it is possible to make Pivot table using multiple sources of data.
12) Which event do you use to check whether the Pivot Table is modified or not?
To check whether the pivot table is modified or not we use “PivotTableUpdate” in worksheet containing the pivot table.
13) What you could do to stop the pivot table from loosing the column width upon refreshing?
Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.
14) What is IF function in excel?
To perform the logic test IF function is performed. It checks whether certain conditions is true or false. If the condition is true then it will give result accordingly if the condition is false then the result or out-put will be different.
Example: For example, you select the cell and you want to display that cell as “Greater than five”, when value is true (=5 or 5) and “less than five” when value is false( <5 ). For that by using IF condition you can display result.
=IF (Logical test, value if true, value if false)
=IF (A1>5, “Greater than five, “Less than five”)
15) What does a red triangle at the top right of a cell indicates?
A red triangle in the cell indicates the comment associated with the cell. If you place mouse on it, it will show the comment.