MS Office Interview Questions & Answers

MS Office Interview Online Test
1. What is a cell reference in Excel
Show Answer
2. How do you create a simple formula in Excel
Show Answer
3. What does the SUM function do in Excel
Show Answer
4. How do you format a cell to display a number as currency
Show Answer
5. What is the purpose of the VLOOKUP function
Show Answer
6. How can you sort data in Excel
Show Answer
7. What is the use of the CONCATENATE function
Show Answer
8. How do you create a chart in Excel
Show Answer
9. What is conditional formatting in Excel
Show Answer
10. How do you use the IF function in Excel
Show Answer
11. What is the difference between a worksheet and a workbook
Show Answer
12. How do you use the COUNT function in Excel
Show Answer
13. What is a formula in Excel
Show Answer
14. How can you adjust the width of a column in Excel
Show Answer
15. What is the purpose of the AVERAGE function
Show Answer
16. How do you use the PMT function in Excel
Show Answer
17. What is a pivot table in Excel
Show Answer
18. How do you freeze panes in Excel
Show Answer
19. What is the use of the HLOOKUP function
Show Answer
20. How do you apply a filter to data in Excel
Show Answer
21. What is the purpose of the DATE function in Excel
Show Answer
22. How do you use the LEFT function in Excel
Show Answer
23. What is the use of the RIGHT function
Show Answer
24. How can you use the FIND function in Excel
Show Answer
25. What does the MID function do in Excel
Show Answer
26. How do you use the RAND function in Excel
Show Answer
27. What is the RANDBETWEEN function used for
Show Answer
28. How do you use the COUNTA function in Excel
Show Answer
29. What is the difference between COUNTIF and COUNTIFS in Excel
Show Answer
30. What is a header in MS Word
Show Answer
31. How do you insert a page number in MS Word
Show Answer
32. What is a footnote in MS Word
Show Answer
33. How can you create a bulleted list in MS Word
Show Answer
34. What is the purpose of the Track Changes feature in MS Word
Show Answer
35. How do you change the font size in MS Word
Show Answer
36. What is the use of the Find and Replace function in MS Word
Show Answer
37. How can you insert a table into a document in MS Word
Show Answer
38. What is a template in MS Word
Show Answer
39. How do you apply bold formatting to text in MS Word
Show Answer
40. What is the purpose of using styles in MS Word
Show Answer
41. How do you create a new document in MS Word
Show Answer
42. What is a section break in MS Word
Show Answer
43. How do you add a hyperlink to text in MS Word
Show Answer
44. What is the use of the Page Layout tab in MS Word
Show Answer
45. How do you use the Undo and Redo functions in MS Word
Show Answer
46. What is a mail merge in MS Word
Show Answer
47. How do you insert a picture into a document in MS Word
Show Answer
48. What is the difference between Save and Save As in MS Word
Show Answer
49. How can you set up a document to print in MS Word
Show Answer
50. What is the use of the Ruler in MS Word
Show Answer
51. How do you create a numbered list in MS Word
Show Answer
52. What is a watermark in MS Word
Show Answer
53. How do you adjust line spacing in MS Word
Show Answer
54. What is a text box in MS Word
Show Answer
55. How do you add a table of contents in MS Word
Show Answer
56. What is a header and footer in MS Word
Show Answer
57. How do you use the Split function in MS Word
Show Answer
58. What is a slide master in MS PowerPoint
Show Answer
59. How do you insert a new slide in MS PowerPoint
Show Answer
60. What is a transition in MS PowerPoint
Show Answer
61. How can you add animations to text or objects in MS PowerPoint
Show Answer
62. What is a slide layout in MS PowerPoint
Show Answer
63. How do you change the design theme of a presentation in MS PowerPoint
Show Answer
64. What is the purpose of the Notes pane in MS PowerPoint
Show Answer
65. How do you insert a picture into a slide in MS PowerPoint
Show Answer
66. What is the use of the Slide Sorter view in MS PowerPoint
Show Answer
67. How can you add a hyperlink to a slide in MS PowerPoint
Show Answer
68. What is the purpose of using bullet points in MS PowerPoint
Show Answer
69. How do you record a presentation in MS PowerPoint
Show Answer
70. What is the Slide Show tab used for in MS PowerPoint
Show Answer
71. How do you insert a chart into a slide in MS PowerPoint
Show Answer
72. What is the purpose of the Format Painter tool in MS PowerPoint
Show Answer
73. How can you set a slide to advance automatically in MS PowerPoint
Show Answer
74. What is a custom show in MS PowerPoint
Show Answer
75. How do you use the Rehearse Timings feature in MS PowerPoint
Show Answer
76. What is the use of the Presenter View in MS PowerPoint
Show Answer
77. How do you apply a slide transition effect in MS PowerPoint
Show Answer
78. What is a slide layout in MS PowerPoint
Show Answer
79. How do you add a video to a slide in MS PowerPoint
Show Answer
80. What is the use of the Zoom feature in MS PowerPoint
Show Answer
81. How can you add a table to a slide in MS PowerPoint
Show Answer
82. What is the function of the Slide Master view in MS PowerPoint
Show Answer
83. How do you hide a slide during a presentation in MS PowerPoint
Show Answer
84. What is the purpose of adding slide numbers in MS PowerPoint
Show Answer
85. How do you insert a shape into a slide in MS PowerPoint
Show Answer
86. What is a hyperlink in MS PowerPoint
Show Answer
87. What is a database in MS Access
Show Answer
88. How do you create a new table in MS Access
Show Answer
89. What is a primary key in MS Access
Show Answer
90. How can you add a new record to a table in MS Access
Show Answer
91. What is a query in MS Access
Show Answer
92. How do you create a simple query in MS Access
Show Answer
93. What is a form in MS Access
Show Answer
94. How do you design a form in MS Access
Show Answer
95. What is a report in MS Access
Show Answer
96. How do you create a report in MS Access
Show Answer
97. What is a table relationship in MS Access
Show Answer
98. How do you set up a relationship between two tables in MS Access
Show Answer
99. What is a field in MS Access
Show Answer
100. How do you modify the design of a table in MS Access
Show Answer
101. What is an input mask in MS Access
Show Answer
102. How do you use the Sort feature in MS Access
Show Answer
103. What is a validation rule in MS Access
Show Answer
104. How do you add a validation rule to a field in MS Access
Show Answer
105. What is a calculated field in MS Access
Show Answer
106. How do you create a calculated field in MS Access
Show Answer
107. What is a macro in MS Access
Show Answer
108. How do you create a macro in MS Access
Show Answer
109. What is a module in MS Access
Show Answer
110. How do you write a simple VBA function in MS Access
Show Answer
111. What is the purpose of the Lookup Wizard in MS Access
Show Answer
112. How do you use the Lookup Wizard to create a dropdown list
Show Answer
113. What is an index in MS Access
Show Answer
114. How do you create an index for a field in MS Access
Show Answer
115. Explain the use of VLOOKUP function in Excel
Show Answer
116. How can you use the INDEX and MATCH functions together in Excel
Show Answer
117. What is the purpose of pivot tables in Excel
Show Answer
118. Describe the use of conditional formatting in Excel
Show Answer
119. How do you create a dynamic named range in Excel
Show Answer
120. What is the difference between absolute and relative cell references in Excel
Show Answer
121. How can you use the SUMIFS function in Excel
Show Answer
122. Explain the use of the IFERROR function in Excel
Show Answer
123. What is the purpose of the TEXT function in Excel
Show Answer
124. How do you use data validation to create a dropdown list in Excel
Show Answer
125. What is the purpose of the OFFSET function in Excel
Show Answer
126. How can you use the COUNTIFS function in Excel
Show Answer
127. Describe how you would use the HLOOKUP function in Excel
Show Answer
128. Explain the use of the CONCATENATE function in Excel
Show Answer
129. What is the purpose of the XLOOKUP function in Excel
Show Answer
130. How do you use the PMT function in Excel
Show Answer
131. What is the use of the MATCH function in Excel
Show Answer
132. How can you use the TRANSPOSE function in Excel
Show Answer
133. Explain how to create and use a table in Excel
Show Answer
134. What is the use of the INDIRECT function in Excel
Show Answer
135. Describe how you would use the SUBTOTAL function in Excel
Show Answer
136. How do you use the LEFT, MID, and RIGHT functions in Excel
Show Answer
137. What is the use of the ARRAY formula in Excel
Show Answer
138. Explain how to create a sparklines chart in Excel
Show Answer
139. How can you protect a worksheet or workbook in Excel
Show Answer
140. What is the purpose of using conditional formatting rules with formulas in Excel
Show Answer
141. How do you use the SUMPRODUCT function in Excel
Show Answer
Interview
Questions and Answers for Competitive Exams Various Entrance Test