Microsoft Excel Interview Questions and Answers

Ques 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.

Ques 12. 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.

Ques 13. What is the sequence of operating mathematical operation in Excel?

The order of sequence of operating is BEDMAS

• Brackets
• Exponents
• Division
• Multiplication
• Addition
• Subtraction

Ques 14. How cell reference is useful in the calculation?

In order to avoid writing the data again and again forcalculating 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.

Ques 15. 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.