MS Office

MS Office MCQs (1-50)

1. MS Office was developed by which company?

A. Apple
B. Google
C. Microsoft
D. IBM

Answer: C

---

2. MS Word is primarily used for?

A. Data analysis
B. Creating documents
C. Programming
D. Networking

Answer: B

---

3. Default file extension of Word 2007 and later is?

A. .doc
B. .xls
C. .ppt
D. .docx

Answer: D

---

4. Shortcut key to open Run dialog box?

A. Ctrl + R
B. Windows + R
C. Alt + R
D. Shift + R

Answer: B

---

5. Which tab contains font options in MS Word?

A. Insert
B. Design
C. Home
D. Review

Answer: C

---

6. Clipboard stores data temporarily for?

A. Deleting
B. Copy & Paste
C. Saving
D. Printing

Answer: B

---

7. Default font in MS Word is?

A. Arial
B. Times New Roman
C. Calibri
D. Verdana

Answer: C

---

8. Maximum font size in Word is?

A. 72
B. 100
C. 256
D. 512

Answer: A

---

9. Bold shortcut key?

A. Ctrl + B
B. Ctrl + I
C. Ctrl + U
D. Ctrl + L

Answer: A

---

10. Italic shortcut key?

A. Ctrl + U
B. Ctrl + I
C. Ctrl + B
D. Ctrl + T

Answer: B

---

11. Excel is mainly used for?

A. Drawing
B. Spreadsheet
C. Animation
D. Browsing

Answer: B

---

12. First spreadsheet software?

A. Excel
B. Lotus
C. VisiCalc
D. Calc

Answer: C

---

13. Intersection of row and column is?

A. Range
B. Table
C. Cell
D. Sheet

Answer: C

---

14. Default file name in Excel?

A. Sheet1
B. Book1
C. Excel1
D. Data1

Answer: B

---

15. Excel file extension after 2007?

A. .xls
B. .xlsx
C. .docx
D. .pptx

Answer: B

---

16. Rows in Excel are represented by?

A. Letters
B. Symbols
C. Numbers
D. Colors

Answer: C

---

17. Columns in Excel are represented by?

A. Numbers
B. Letters
C. Symbols
D. Codes

Answer: B

---

18. Last column in Excel is?

A. ZZZ
B. XFD
C. ABC
D. ZFD

Answer: B

---

19. Shortcut to save file?

A. Ctrl + S
B. Ctrl + P
C. Ctrl + C
D. Ctrl + V

Answer: A

---

20. Formula in Excel starts with?

A. @
B. #
C. =
D. $

Answer: C

---

21. Workbook in Excel is a collection of?

A. Charts
B. Cells
C. Worksheets
D. Rows

Answer: C

---

22. Shortcut to insert AutoSum in Excel?

A. Ctrl + =
B. Alt + =
C. Shift + =
D. Ctrl + S

Answer: B

---

23. Maximum number of columns in Excel (2007 and later)?

A. 65536
B. 1024
C. 16384
D. 8192

Answer: C

---

24. Maximum number of rows in Excel (2007 and later)?

A. 1048576
B. 65536
C. 1000000
D. 500000

Answer: A

---

25. Shortcut key to copy data?

A. Ctrl + V
B. Ctrl + X
C. Ctrl + C
D. Ctrl + P

Answer: C

---

26. Shortcut key to paste data?

A. Ctrl + X
B. Ctrl + V
C. Ctrl + C
D. Ctrl + A

Answer: B

---

27. Shortcut key to cut data?

A. Ctrl + X
B. Ctrl + V
C. Ctrl + C
D. Ctrl + Z

Answer: A

---

28. Which function counts number of characters?

A. LEN()
B. COUNT()
C. SUM()
D. MID()

Answer: A

---

29. Function used to add numbers?

A. COUNT()
B. SUM()
C. LEN()
D. AVG()

Answer: B

---

30. Function to convert text to uppercase?

A. LOWER()
B. PROPER()
C. UPPER()
D. MID()

Answer: C

---

31. Function to convert text to lowercase?

A. LOWER()
B. UPPER()
C. LEN()
D. LEFT()

Answer: A

---

32. Function to remove extra spaces?

A. CLEAN()
B. TRIM()
C. REMOVE()
D. CUT()

Answer: B

---

33. RIGHT() function extracts characters from?

A. Left
B. Middle
C. Right
D. Center

Answer: C

---

34. LEFT() function extracts from?

A. Right
B. Left
C. Middle
D. Bottom

Answer: B

---

35. MID() function extracts text from?

A. End
B. Start
C. Middle
D. Top

Answer: C

---

36. Default alignment of numbers in Excel?

A. Left
B. Center
C. Right
D. Justify

Answer: C

---

37. Default alignment of text in Excel?

A. Right
B. Left
C. Center
D. Justify

Answer: B

---

38. Shortcut to find in Excel?

A. Ctrl + F
B. Ctrl + H
C. Ctrl + G
D. Ctrl + Z

Answer: A

---

39. Shortcut to replace in Excel?

A. Ctrl + F
B. Ctrl + R
C. Ctrl + H
D. Ctrl + G

Answer: C

---

40. Shortcut to undo?

A. Ctrl + Y
B. Ctrl + U
C. Ctrl + Z
D. Ctrl + X

Answer: C

---

41. Shortcut to redo?

A. Ctrl + Y
B. Ctrl + Z
C. Ctrl + X
D. Ctrl + A

Answer: A

---

42. Which chart shows proportions?

A. Bar Chart
B. Pie Chart
C. Line Chart
D. Area Chart

Answer: B

---

43. Which chart shows trends over time?

A. Pie
B. Column
C. Line
D. Bar

Answer: C

---

44. Which chart compares categories?

A. Pie
B. Column
C. Scatter
D. Line

Answer: B

---

45. Shortcut to insert chart?

A. F1
B. F11
C. F5
D. F2

Answer: B

---

46. Which group inserts pictures in Excel?

A. Data
B. Insert
C. Review
D. View

Answer: B

---

47. Which tab is used for page margins?

A. Insert
B. Home
C. Page Layout
D. Data

Answer: C

---

48. Which tab is used for spell check?

A. Review
B. View
C. Data
D. Insert

Answer: A

---

49. Which tab contains Zoom option?

A. Insert
B. View
C. Home
D. Data

Answer: B

---

50. Which feature locks rows/columns?

A. Split
B. Freeze Panes
C. Zoom
D. Filter

Answer: B

---

51. What does VBA stand for?

A. Visual Basic Application
B. Visual Basic for Applications
C. Virtual Basic Access
D. Visual Binary Application

Answer: B

---

52. Default number of worksheets in Excel 2016?

A. 3
B. 5
C. 1
D. 2

Answer: C

---

53. Maximum characters in a cell?

A. 10000
B. 32767
C. 65535
D. 50000

Answer: B

---

54. Maximum column width in Excel?

A. 100
B. 255
C. 500
D. 1024

Answer: B

---

55. Default column width?

A. 10
B. 8.43
C. 12
D. 15

Answer: B

---

56. Default row height?

A. 20
B. 18
C. 15
D. 10

Answer: C

---

57. Which feature removes duplicate data?

A. Sort
B. Filter
C. Remove Duplicates
D. Data Validation

Answer: C

---

58. Which tool splits data into columns?

A. Flash Fill
B. Text to Columns
C. Sort
D. Filter

Answer: B

---

59. Flash Fill is used for?

A. Formatting
B. Auto pattern filling
C. Deleting
D. Printing

Answer: B

---

60. Which tool restricts input data?

A. Sort
B. Filter
C. Data Validation
D. Format

Answer: C

---

61. Which tab contains Data Validation?

A. Home
B. Insert
C. Data
D. Review

Answer: C

---

62. What is a range?

A. Single cell
B. Group of cells
C. Chart
D. File

Answer: B

---

63. Which key moves to next column?

A. Enter
B. Tab
C. Shift
D. Alt

Answer: B

---

64. Which key moves to next row?

A. Tab
B. Enter
C. Shift
D. Ctrl

Answer: B

---

65. Shortcut to open Go To dialog?

A. Ctrl + F
B. F5
C. Ctrl + G
D. Both B and C

Answer: D

---

66. Which shows cell address?

A. Status Bar
B. Name Box
C. Ribbon
D. Formula Bar

Answer: B

---

67. Where is formula displayed?

A. Name Box
B. Status Bar
C. Formula Bar
D. Ribbon

Answer: C

---

68. Which key edits active cell?

A. F1
B. F2
C. F3
D. F4

Answer: B

---

69. Shortcut to open help?

A. F1
B. F2
C. F5
D. F11

Answer: A

---

70. Which tab is used for formulas?

A. Home
B. Data
C. Formulas
D. View

Answer: C

---

71. SUM function belongs to?

A. Text
B. Logical
C. Math
D. Date

Answer: C

---

72. CONCATENATE function is used to?

A. Add numbers
B. Join text
C. Count cells
D. Format cells

Answer: B

---

73. Which chart uses XY coordinates?

A. Pie
B. Line
C. Scatter
D. Bar

Answer: C

---

74. Chart title describes?

A. Data
B. Chart
C. Axis
D. Series

Answer: B

---

75. Legend shows?

A. Axis values
B. Data series
C. Titles
D. Labels

Answer: B

---

76. Gridlines improve?

A. Formatting
B. Readability
C. Speed
D. Storage

Answer: B

---

77. What-if analysis is used for?

A. Formatting
B. Prediction
C. Deletion
D. Printing

Answer: B

---

78. Pivot Table is used for?

A. Drawing
B. Data summary
C. Writing
D. Printing

Answer: B

---

79. Freeze Panes is in which tab?

A. View
B. Home
C. Insert
D. Data

Answer: A

---

80. Which view shows page breaks?

A. Normal
B. Page Layout
C. Page Break Preview
D. Full Screen

Answer: C

---

81. Zoom control is located at?

A. Top
B. Bottom right
C. Left
D. Center

Answer: B

---

82. Which group applies themes?

A. Data
B. Page Layout
C. Insert
D. View

Answer: B

---

83. Orientation options are?

A. Left/Right
B. Top/Bottom
C. Portrait/Landscape
D. Small/Large

Answer: C

---

84. Which group manages print area?

A. Page Setup
B. Data Tools
C. Styles
D. Cells

Answer: A

---

85. Conditional formatting is in?

A. Data
B. Home
C. Insert
D. View

Answer: B

---

86. Merge & Center is used to?

A. Delete cells
B. Combine cells
C. Split cells
D. Format numbers

Answer: B

---

87. Format Painter copies?

A. Data
B. Format
C. Formula
D. Chart

Answer: B

---

88. Shortcut to format cells?

A. Ctrl + 1
B. Ctrl + 2
C. Ctrl + 3
D. Ctrl + 4

Answer: A

---

89. Ctrl + 2 applies?

A. Italic
B. Underline
C. Bold
D. Strike

Answer: C

---

90. Ctrl + 3 applies?

A. Bold
B. Italic
C. Underline
D. Strike

Answer: B

---

91. Ctrl + 4 applies?

A. Bold
B. Italic
C. Underline
D. Strike

Answer: C

---

92. Ctrl + 5 applies?

A. Bold
B. Italic
C. Underline
D. Strike

Answer: D

---

93. Which command sorts data?

A. Filter
B. Sort
C. Find
D. Replace

Answer: B

---

94. Filter is used to?

A. Delete data
B. Display selected data
C. Format data
D. Print data

Answer: B

---

95. Hyperlink is used to?

A. Format text
B. Link to resource
C. Delete file
D. Print document

Answer: B

---

96. Which option inserts symbols?

A. Data
B. Insert
C. Review
D. View

Answer: B

---

97. Equation option is in?

A. Home
B. Insert
C. Data
D. View

Answer: B

---

98. Track Changes is in?

A. Review
B. Data
C. Insert
D. View

Answer: A

---

99. Protect sheet is in?

A. Home
B. Data
C. Review
D. Insert

Answer: C

---

100. Macro recording is in?

A. Home
B. Insert
C. View
D. Data

Answer: C

---

101. Which function finds average?

A. SUM()
B. AVG()
C. AVERAGE()
D. COUNT()

Answer: C

---

102. COUNT() function counts?

A. Text
B. Numbers
C. Symbols
D. Colors

Answer: B

---

103. Absolute reference uses?

A. @
B. #
C. $
D. &

Answer: C

---

104. Relative reference changes when?

A. Copied
B. Deleted
C. Saved
D. Printed

Answer: A

---

105. Which function returns length of text?

A. COUNT()
B. LEN()
C. SUM()
D. MID()

Answer: B

---

106. Which function joins text?

A. JOIN()
B. MERGE()
C. CONCATENATE()
D. COMBINE()

Answer: C

---

107. Which function extracts middle text?

A. LEFT()
B. RIGHT()
C. MID()
D. LEN()

Answer: C

---

108. Which function trims spaces?

A. CLEAN()
B. REMOVE()
C. TRIM()
D. CUT()

Answer: C

---

109. Which function converts first letter capital?

A. UPPER()
B. LOWER()
C. PROPER()
D. MID()

Answer: C

---

110. Which function converts all letters uppercase?

A. LOWER()
B. PROPER()
C. UPPER()
D. LEN()

Answer: C

---

111. Which feature highlights cells based on rules?

A. Sort
B. Filter
C. Conditional Formatting
D. Freeze

Answer: C

---

112. Which feature converts range to table?

A. Format as Table
B. Sort
C. Filter
D. Insert Table

Answer: A

---

113. Which option inserts new row?

A. Delete
B. Insert
C. Format
D. Clear

Answer: B

---

114. Which option deletes column?

A. Insert
B. Format
C. Delete
D. Clear

Answer: C

---

115. Which option changes column width?

A. Insert
B. Delete
C. Format
D. Clear

Answer: C

---

116. Ctrl + 9 hides?

A. Column
B. Row
C. Sheet
D. Cell

Answer: B

---

117. Ctrl + Shift + 9 unhides?

A. Column
B. Row
C. Sheet
D. Cell

Answer: B

---

118. Maximum sheet name length?

A. 20
B. 31
C. 50
D. 100

Answer: B

---

119. Which option clears content?

A. Delete
B. Clear
C. Remove
D. Cut

Answer: B

---

120. Which option fills series?

A. Sort
B. Fill
C. Clear
D. Format

Answer: B

---

121. Which tool searches text?

A. Find
B. Replace
C. Sort
D. Filter

Answer: A

---

122. Which tool replaces text?

A. Find
B. Replace
C. Sort
D. Filter

Answer: B

---

123. Which group contains AutoSum?

A. Clipboard
B. Editing
C. Font
D. Styles

Answer: B

---

124. Which tab contains charts?

A. Insert
B. Home
C. Data
D. Review

Answer: A

---

125. Which chart shows comparisons?

A. Pie
B. Column
C. Scatter
D. Area

Answer: B

---

126. Which chart shows trend?

A. Pie
B. Line
C. Bar
D. Area

Answer: B

---

127. Which chart shows relationship?

A. Pie
B. Line
C. Scatter
D. Bar

Answer: C

---

128. Which tab contains margins?

A. Home
B. Page Layout
C. Insert
D. View

Answer: B

---

129. Default orientation is?

A. Landscape
B. Portrait
C. Horizontal
D. Vertical

Answer: B

---

130. Default scaling is?

A. 50%
B. 75%
C. 100%
D. 150%

Answer: C

---

131. Which shows gridlines?

A. View
B. Insert
C. Data
D. Review

Answer: A

---

132. Freeze Panes locks?

A. Data
B. Rows/Columns
C. Cells
D. Charts

Answer: B

---

133. Split option divides?

A. Data
B. Window
C. Cell
D. Chart

Answer: B

---

134. Macro is used for?

A. Formatting
B. Automation
C. Printing
D. Saving

Answer: B

---

135. Which option checks spelling?

A. Data
B. Review
C. Insert
D. View

Answer: B

---

136. Comments are used for?

A. Formatting
B. Notes
C. Calculation
D. Charts

Answer: B

---

137. Track Changes is used for?

A. Editing
B. Monitoring edits
C. Formatting
D. Deleting

Answer: B

---

138. Protect Workbook is used for?

A. Formatting
B. Security
C. Editing
D. Printing

Answer: B

---

139. Which tab shows formulas?

A. View
B. Home
C. Formulas
D. Data

Answer: C

---

140. Defined Names help in?

A. Formatting
B. Simplifying formulas
C. Printing
D. Sorting

Answer: B

---

141. Formula auditing checks?

A. Formatting
B. Errors
C. Charts
D. Data

Answer: B

---

142. Calculation options control?

A. Data
B. Formula updates
C. Charts
D. Text

Answer: B

---

143. Manual calculation updates?

A. Automatically
B. On command
C. Never
D. Always

Answer: B

---

144. Automatic calculation updates?

A. Manually
B. Instantly
C. Never
D. Slowly

Answer: B

---

145. Workbook view helps in?

A. Printing
B. Display settings
C. Saving
D. Editing

Answer: B

---

146. Page Break Preview shows?

A. Data
B. Print layout
C. Page breaks
D. Charts

Answer: C

---

147. Sheet tab is used for?

A. Charts
B. Switching sheets
C. Formatting
D. Printing

Answer: B

---

148. Status bar shows?

A. Data
B. Cell status
C. Charts
D. Formulas

Answer: B

---

149. Name box shows?

A. Formula
B. Cell address
C. Data
D. Chart

Answer: B

---

150. Formula bar shows?

A. Data
B. Formula
C. Chart
D. Sheet

Answer: B

---

151. Which function finds maximum value?

A. MAX()
B. MIN()
C. COUNT()
D. SUM()

Answer: A

---

152. Which function finds minimum value?

A. SUM()
B. MIN()
C. MAX()
D. COUNT()

Answer: B

---

153. Which operator is used for multiplication?

A. +
B. -
C. *
D. /

Answer: C

---

154. Which operator is used for division?

A. /
B. *
C. +
D. -

Answer: A

---

155. Which symbol is used for absolute reference?

A. #
B. $
C. @
D. &

Answer: B

---

156. Which feature protects worksheet?

A. Lock Cells
B. Protect Sheet
C. Hide Sheet
D. Freeze Panes

Answer: B

---

157. Which option groups data?

A. Sort
B. Group
C. Filter
D. Merge

Answer: B

---

158. Which option ungroups data?

A. Ungroup
B. Split
C. Clear
D. Remove

Answer: A

---

159. Subtotal is used for?

A. Formatting
B. Summarizing data
C. Deleting data
D. Printing

Answer: B

---

160. Which tool consolidates data?

A. Consolidate
B. Sort
C. Filter
D. Merge

Answer: A

---

161. Data model is used for?

A. Formatting
B. Relationships
C. Charts
D. Printing

Answer: B

---

162. Which tool imports data?

A. Get Data
B. Sort
C. Filter
D. Format

Answer: A

---

163. Queries are used for?

A. Editing
B. Data connections
C. Printing
D. Formatting

Answer: B

---

164. Data types include?

A. Stocks
B. Geography
C. Both A and B
D. None

Answer: C

---

165. Advanced filter is used for?

A. Complex filtering
B. Printing
C. Formatting
D. Editing

Answer: A

---

166. Flash Fill shortcut?

A. Ctrl + E
B. Ctrl + F
C. Ctrl + D
D. Ctrl + R

Answer: A

---

167. Text to Columns is in?

A. Home
B. Data
C. Insert
D. View

Answer: B

---

168. Remove duplicates is in?

A. Data
B. Home
C. Insert
D. Review

Answer: A

---

169. Freeze Panes is used to?

A. Delete data
B. Lock rows/columns
C. Format cells
D. Print sheet

Answer: B

---

170. Split divides?

A. Data
B. Window
C. Sheet
D. Chart

Answer: B

---

171. Zoom tool is used for?

A. Formatting
B. Magnification
C. Editing
D. Printing

Answer: B

---

172. New Window option does?

A. Opens new workbook
B. Opens same workbook window
C. Deletes sheet
D. Formats sheet

Answer: B

---

173. Arrange All is used for?

A. Sorting
B. Viewing multiple windows
C. Formatting
D. Printing

Answer: B

---

174. Which feature compares documents?

A. Compare
B. Merge
C. Track
D. Review

Answer: A

---

175. Merge combines?

A. Data
B. Documents
C. Charts
D. Cells

Answer: B

---

176. Restrict editing is used for?

A. Formatting
B. Security
C. Printing
D. Editing

Answer: B

---

177. Block authors prevents?

A. Printing
B. Editing
C. Saving
D. Viewing

Answer: B

---

178. Print Layout view shows?

A. Data
B. Printed format
C. Charts
D. Formulas

Answer: B

---

179. Read Mode is used for?

A. Editing
B. Reading
C. Formatting
D. Printing

Answer: B

---

180. Outline view is used for?

A. Formatting
B. Organizing headings
C. Printing
D. Editing

Answer: B

---

181. Draft view simplifies?

A. Printing
B. Layout
C. Editing
D. Charts

Answer: B

---

182. Focus mode hides?

A. Data
B. Distractions
C. Charts
D. Cells

Answer: B

---

183. Vertical scroll moves?

A. Left-right
B. Up-down
C. Zoom
D. Sheet

Answer: B

---

184. Horizontal scroll moves?

A. Up-down
B. Left-right
C. Zoom
D. Sheet

Answer: B

---

185. Name box is used for?

A. Formatting
B. Cell address
C. Chart
D. Data

Answer: B

---

186. Status bar shows?

A. Data
B. Cell state
C. Chart
D. Formula

Answer: B

---

187. Formula bar displays?

A. Chart
B. Formula
C. Sheet
D. Data

Answer: B

---

188. Workbook is saved as?

A. File
B. Chart
C. Sheet
D. Data

Answer: A

---

189. Worksheet contains?

A. Cells
B. Charts
C. Files
D. Data types

Answer: A

---

190. Cell is intersection of?

A. Row & Column
B. Sheet & Chart
C. File & Data
D. Column & Chart

Answer: A

---

191. Which is text function?

A. SUM()
B. LEN()
C. MAX()
D. MIN()

Answer: B

---

192. Which is math function?

A. MID()
B. SUM()
C. LEN()
D. LEFT()

Answer: B

---

193. Which feature inserts chart?

A. Data
B. Insert
C. Review
D. View

Answer: B

---

194. Which tab contains macros?

A. View
B. Insert
C. Data
D. Home

Answer: A

---

195. Hyperlink connects to?

A. File/Webpage
B. Cell
C. Chart
D. Row

Answer: A

---

196. Header & Footer are used for?

A. Formatting
B. Page info
C. Data
D. Chart

Answer: B

---

197. WordArt is used for?

A. Data
B. Decorative text
C. Chart
D. Formula

Answer: B

---

198. SmartArt is used for?

A. Data
B. Diagrams
C. Charts
D. Text

Answer: B

---

199. Screenshot option inserts?

A. Image
B. Chart
C. Data
D. Text

Answer: A

---

200. Equation tool is used for?

A. Chart
B. Math equations
C. Data
D. Text

Answer: B

---