Bookmark this page
Difficulty Level: AllBeginnerIntermediateExpert
Ques 1. What are three report formats that are available in Excel?
Ques 2. How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?
Ques 3. Is it possible to make Pivot table using multiple sources of data?
Ques 4. How cell reference is useful in the calculation?
Ques 5. How you can disable the automating sorting in pivot tables?
Ques 6. What is the "What If" condition in excel formulas?
Ques 7. What filter will you use, if you want more than two conditions or if you want to analyse the list using database function?
Ques 8. To move to the previous worksheet and to next sheet, what keys will you press?
Ques 9. How do I put password to protect my entire Spreadsheet so data cannot be changed?
Ques 10. What is Freeze Panes and how do I do it?
Ques 11. What does a red triangle at the top right of a cell indicates?
Ques 12. How do I combine different chart types into my Excel spreadsheet?
Ques 13. What is IF function in excel?
Ques 14. Is there a way to apply the same formatting to every sheet in a workbook in Excel?
Ques 15. How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?
Ques 16. How can I printout the formulas in an Excel spreadsheet - rather than the results?
Ques 17. Is it possible to change the color and font of the sheet tabs?
Ques 18. What you could do to stop the pivot table from loosing the column width upon refreshing?
Ques 19. How do I find the first empty cell in column A?
Ques 20. Which event do you use to check whether the Pivot Table is modified or not?