Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

Microsoft Excel Interview Questions and Answers

Ques 16. How you can disable the automating sorting in pivot tables?

Ans.

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

Is it helpful? Add Comment View Comments
Ques 17. What is the "What If" condition in excel formulas?
Ans.

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.

Is it helpful? Add Comment View Comments
Ques 18. What is the benefit of using formula in excel sheet?
Ans. 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.
Is it helpful? Add Comment View Comments
Ques 19. What is the quick way to return to a specific area of a worksheet?
Ans. 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.
Is it helpful? Add Comment View Comments
Ques 20. What filter will you use, if you want more than two conditions or if you want to analyse the list using database function?
Ans. You will use Advanced Criteria Filter, to analyse the list or if more than two conditions should be tested.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2016 WithoutBook