Bookmark this page
Difficulty Level: AllBeginnerIntermediateExpert
Ques 1. What is Microsoft Excel?
Ques 2. What is ribbon?
Ques 3. How can I hide or show the ribbon?
Ques 4. How can you wrap the text within a cell?
Ques 5. Is it possible to prevent someone from copying the cell from your worksheet?
Ques 6. How you can sum up the Rows and Column number quickly in the excel sheet?
Ques 7. How you can add a new excel worksheet?
Ques 8. How you can resize the column in MS Excel?
Ques 9. What are three report formats that are available in Excel?
Ques 10. How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?
Ques 11. Is it possible to make Pivot table using multiple sources of data?
Ques 12. What does a LOOK UP function searches in the MS Excel?
Ques 13. What is the sequence of operating mathematical operation in Excel?
Ques 14. How cell reference is useful in the calculation?
Ques 15. What is the AND function does in excel?
Ques 16. How you can disable the automating sorting in pivot tables?
Ques 17. What is the "What If" condition in excel formulas?
Ques 18. What is the benefit of using formula in excel sheet?
Ques 19. What is the quick way to return to a specific area of a worksheet?
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?
Ques 21. To move to the previous worksheet and to next sheet, what keys will you press?
Ques 22. How do I put password to protect my entire Spreadsheet so data cannot be changed?
Ques 23. What is Freeze Panes and how do I do it?
Ques 24. How do I Format data in MS Excel?
Ques 25. How do I resize Columns and Rows to better fit the data in MS Excel?
Ques 26. What does a red triangle at the top right of a cell indicates?
Ques 27. How do I combine different chart types into my Excel spreadsheet?
Ques 28. Using Excel is there a way to close all open Excel files at once instead of closing them one at a time?
Ques 29. What is IF function in excel?
Ques 30. Is there a way to apply the same formatting to every sheet in a workbook in Excel?
Ques 31. How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?
Ques 32. How can I printout the formulas in an Excel spreadsheet - rather than the results?
Ques 33. Is it possible to change the color and font of the sheet tabs?
Ques 34. What you could do to stop the pivot table from loosing the column width upon refreshing?
Ques 35. How do I find the first empty cell in column A?
Ques 36. Which event do you use to check whether the Pivot Table is modified or not?