Microsoft Excel Interview Questions and Answers
Ques 11. How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?
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.
Ques 12. 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 13. 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 14. 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 15. 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.
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?