Find Best Excel Freshers and Expert Interview Questions

Posted By EduStudy on 2018-08-19 6:38 AM

Description

1. What are the different data formats in Excel?
2. How can you wrap text in Excel?
3. How can you merge cells in Excel?
4. What is 'Format Painter' used for?
5. How would you clear all the formatting without removing the cell contents?
6. What is conditional formatting?
7. How would you highlight cells with negative values in it?
8. How would you highlight cells with duplicate values in it?
9. How would you highlight cells with errors in it?
10. How can you make text invisible in Excel?
11. What is the order of operations used when evaluating formulas in Excel?
12. What is the difference between a function and a formula in Excel?
13. What according to you are the top 5 functions in Excel?
14. What is the difference between absolute and relative cell references?
15. What are the different types of errors you can encounter in Excel?
16. How can you tackle errors when working with Excel Formulas?
17. Which function would you use to get the current date and time in Excel?
18. How can you combine the text from multiple cells using a formula?
19. What formula would you use to find the length of a text string in a cell?
20. What is the syntax of the VLOOKUP function?
21. How would you get rid of leading / trailing / double spaces in a text in Excel?
22. What are the known limitations of the VLOOKUP function?
23. When would you use the SUBTOTAL function?
24. What are volatile functions? Can you name a few?
25. What are the most useful keyboard shortcuts you use?
26. What is the shortcut for opening the find and replace dialog box
27. What is the shortcut for spell check?
28. What is the shortcut to quickly auto-sum rows/columns?
29. What is the shortcut to open a new Excel workbook?
30. How can you select all the cells in the worksheet
31. How would you insert a new line in the same cell?
32. What's the shortcut to insert a comment in Excel?
33. What is a Pivot Table, and when would you use one?
34. What are the various sections in a Pivot Table?
35. What are slicers?
36. What is a Pivot Chart
37. What are the difference between Pivot Charts Vs Regular Charts?
38. How can you refresh a Pivot Table?
39. Can you group dates in Pivot Tables?
40. What is a Pivot Cache?
41. Can you make a Pivot Table from multiple tables?
42. What are Calculated Fields in Pivot Table?
43. What is a Column chart?
44. What is a Bar chart?
45. What is a Line chart?
46. What is a Scatter chart?
47. Are Pie charts good? Should it used in reports/dashboard?
48. What is a Waterfall chart? When would you use it?
49. What are Combination charts?
50. What is a secondary axes in a chart?
51. What is a Bullet chart? When should we use it?
52. How to replace one value with another in Excel?
53. What kind of data filters are available in Excel?
54. How can you sort data in Excel?
55. What is data validation?
56. How can you transpose a data set in Excel?
57. How can you select all blank cells in Excel?
58. How can you remove duplicates from a data set?
59. What is an advanced Filter in Excel?
60. Can you sort multiple columns at one time?
61. What is a one-variable data table?
62. What is a two-variable data table?
63. What is Scenario Manager?
64. What is Goal Seek?
65. What is a Solver?
66. What is VBA?
67. What are the benefits of using VBA in Excel?
68. What is a macro in Excel?
69. How can you record a macro in Excel?
70. What are limitations of recording a macro in Excel?
71. What is a UDF in Excel VBA?
72. What are Events in VBA?
73. What are some of the useful loops in VBA?
74. What are the different ways to run a macro in Excel?
75. What are UserForms?
76. What are add-ins?
77. What is difference between a dashboard and a report?
78. What are some of the questions you should ask a client/stakeholder before creating a dashboard?
79. What are some interactive controls you can use in dashboards?
80. What are some useful chart types that you can use in a dashboard?
81. What are some best practices when creating a dashboard in Excel?
82. What is an Excel Table?
83. What are the benefits of using Excel Table?
84. What are structured references?
85. What are the commonly used file formats in which an Excel file can be saved?
86. How to reduce the size of an Excel file?
87. What steps can you take to handle slow Excel workbooks?
88. How many rows and columns are there in an Excel worksheet?
89. How to add/delete rows in Excel?
90. How can you zoom in or zoom out in Excel?
91. How to protect a sheet In Excel?
92. What are named ranges? What are its benefits?
93. Can you make the header rows/columns stick and be visible when you scroll?
94. How would you identify cells that have comments in it?
95. How would you save an Excel worksheet as a PDF?
96. How to create a hyperlink in Excel?
97. When would you consider switching from automatic to manual calculation in Excel?
98. What is Flash Fill?
99. What is a Fill Handle?
100. What are wildcard characters in Excel?
101. What is a Print Area and how can you set it in Excel?
102. How can you insert Page Numbers in Excel?

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

Related Blogs

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