TOP Microsoft Excel Interview Questions and Answers
To move to the previous worksheet and to next sheet, what keys will you press?
To move to the previous worksheet you will use the keys Ctrl+PgUp, and to move to the next sheet you will use keys Ctrl+PgDown.
What filter will you use, if you want more than two conditions or if you want to analyse the list using database function?
You will use Advanced Criteria Filter, to analyse the list or if more than two conditions should be tested.
What is the quick way to return to a specific area of a worksheet?
The quick way to return to a specific area of worksheet is by using name box. You can type the cell address or range name in name box to return to a specific area of a worksheet.
What is the benefit of using formula in excel sheet?
Calculating the numbers in excel sheet, not only help you to give the final ‘sum up’ of the number but, it also calculate automatically the number replaced by another number or digit. Through excel sheet, the complex calculations becomes easy like payroll deduction or averaging the student’s result.
What is the “What If” condition in excel formulas?
The “What If” condition is used to change the data in Microsoft excel formulas to give different answers.
Example: You are buying a new car and want to calculate the exact amount of tax that will be levied on it then you can use the “What If” function. For instance there is three cells A4,B4 and C4. First cell says about the amount, second cell will tell about the percentage (7.5%) of tax and final cell will calculate the exact amount of tax.
How you can disable the automating sorting in pivot tables?
To disable the automating sorting in pivot tables,
Go to > “More Sort Options”> Right Click “Pivot table” > Select “Sort” menu > Select “ More Options” > Deselect the “ Sort automatically when the report is created”.
What is the AND function does in excel?
Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.
Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5, and ‘False’ if any of those values<5. You can use AND function to do that.
How cell reference is useful in the calculation?
In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.
What is the sequence of operating mathematical operation in Excel?
The order of sequence of operating is BEDMAS
What does a LOOK UP function searches in the MS Excel?
In Microsoft excel, the LOOKUP function returns a value from a range or from an array.