MS Excel Interview Questions for Freshers and Experienced Candidates

Posted By SLA Consultants India - Digital Marketing Training Institute slaconsultantsindia on 2018-05-20 7:32 AM

Description

1. What is Microsoft Excel?
2. How can you wrap the text within a cell?
3. What is ribbon?
4. Explain Spreadsheet and its Basics.
5. How many data formats are available in Excel? Name some of them.
6. Specify the order of operations used for evaluating formulas in Excel
7. Is it possible to prevent someone from copying the cell from your worksheet?
8. Explain Macro in MS-Excel.
9. What are charts in MS-Excel?
10. How can you sum up the Rows and Column number quickly in the Excel sheet?
11. Explain few useful functions in Excel.
12. What does a red triangle at the top right of a cell indicate?
13. How can you add a new Excel worksheet?
14. What is the use of NameBox in MS-Excel?
15. How can you resize the column?
16. How many rows and columns are there in Microsoft Excel 2003 and later versions?
17. Explain pivot tables and its uses.
18. What is the easiest solution to reduce the file size?
19. How can you disable the automating sorting in pivot tables?
20. What is the AND function does in Excel?
21. How cell reference is useful in the calculation?
22. What are three report formats that are available in Excel?
23. How would you provide a Dynamic range in “Data Source” of Pivot Tables?
24. How would you provide a Dynamic range in “Data Source” of Pivot Tables?
25. Which event do you use to check whether the Pivot Table is modified or not?
26. How can you disable automatic sorting in pivot tables?
27. What is Freeze Panes in MS-Excel?
28. How to use Data Modeling for creating Pivot Table
29. What is Countif function and how to use it?
30. Which option do we use to adjust the text within a cell and what is the procedure to do it?
31. How to select all the objects in the sheet?
32. What is the use of Name box?
33. What is a Dashboard and what are the important things we should keep in mind while creating a dashboard?
34. How can you format a cell? What are the options?
35. Is it possible to make Pivot Table using multiple sources of data? How?
36. What could you do to stop the pivot table from loosing the column width upon refreshing?
37. Explain workbook protection types in Excel.
38. Explain the difference between SUBSTITUTE and REPLACE function in MS-Excel?
39. Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel.
40. What is IF function in Excel?
41. Can we create shortcuts to Excel functions?
42. How many report formats are available in Excel and what are their names?
43. What is the difference between function and formula in MS-Excel?
44. What is Chart in MS-Excel? Why is it important to you an appropriate chart?
45. What is Syntax of Vlookup?
46. How can we determine the day of the week for a particular date?
47. What is the shortcut to put the filter on data in Microsoft Excel 2013?
48. What is the use of LOOKUP function in Excel?
49. How can you apply the same formatting to every sheet in a workbook in MS-Excel?
50. To move to the previous worksheet and next sheet, what keys will you press?
51. What filter will you use, if you want more than two conditions or if you want to analyze the list using database function
52. What are left, right, fill and distributed alignments?
53. What is the quick way to return to a particular area of a worksheet?
54. Which function is used to determine the day of the week for a date?
55. What is the benefit of using formula in Excel sheet?
56. What is Nested IF function?
57. What is Pivot table and why we use it?
58. How to use advanced filter?
59. How we can change the cell formatting?
60. What is conditional formatting and how to use it?
61. How to make drop down list?
62. How to make dynamic drop down list?
63. What is the “What If” condition in Excel formulas?

Tags: ms excel questions, advanced excel interviews questions, question answer of excel, excel interviews question

Other Information

Ratings & Review

Send Business Query

×

Message*

Name*

Phone

Email*

Text within image*

Close

Post Review

×

Uh oh! You must log in to submit a review. Click Here to Login.

Close

Send Business Info via SMS

×

Please fill below given details

Mobile*

Text within image*

Close

Send Business Info via Email

×

Please fill below given details

Email To*

Email From*

Name*

Text within image*

Close