1. Which Microsoft Office application is used primarily for word processing?
A) Excel
B) PowerPoint
C) Word
D) Access
View AnswerC
2. What is the default file extension for a Microsoft Word document?
A) .docx
B) .xlsx
C) .pptx
D) .txt
View AnswerA
3. In Excel, what function would you use to find the average of a set of numbers?
A) AVERAGE()
B) MEAN()
C) AVG()
D) SUM()
View AnswerA
4. Which feature in PowerPoint is used to add animations to text and objects?
A) Transition
B) Animation Pane
C) Slide Show
D) Layout
View AnswerB
5. What shortcut key is used to save a document in Microsoft Word?
A) Ctrl + S
B) Ctrl + P
C) Ctrl + O
D) Ctrl + N
View AnswerA
6. Which tab would you find the “Insert Chart” option in Excel?
A) Home
B) Insert
C) Data
D) View
View AnswerB
7. In Microsoft Access, what is a primary key?
A) A field that uniquely identifies a record
B) A key that opens a table
C) A key for formatting text
D) A field that allows duplicate values
View AnswerA
8. What is the maximum number of characters allowed in a single cell in Excel?
A) 255
B) 1024
C) 32767
D) 65536
View AnswerC
9. Which of the following is NOT a valid function in Excel?
A) COUNTIF()
B) SUMIF()
C) AVERAGEIF()
D) AVERAGEALL()
View AnswerD
10. In Word, which view is best for editing a document?
A) Print Layout
B) Web Layout
C) Outline
D) Draft
View AnswerA
11. Which of the following file formats can PowerPoint export to?
A) .pdf
B) .jpg
C) .mp4
D) All of the above
View AnswerD
12. What does the “R” in RTF format stand for?
A) Read
B) Rich
C) Regular
D) Rendered
View AnswerB
13. What feature allows users to highlight specific text in Word?
A) Font Color
B) Highlight
C) Underline
D) Bold
View AnswerB
14. In Excel, which of the following functions returns the current date?
A) TODAY()
B) CURRENTDATE()
C) NOW()
D) DATENOW()
View AnswerA
15. Which PowerPoint view allows you to see the entire slide layout?
A) Slide Sorter
B) Normal
C) Reading View
D) Presenter View
View AnswerA
16. What is the maximum number of rows in an Excel worksheet?
A) 1,048,576
B) 65,536
C) 256
D) 32,768
View AnswerA
17. Which of the following features is used to create a mail merge in Word?
A) Insert
B) Review
C) Mailings
D) View
View AnswerC
18. Which option would you choose to add a footer in a Word document?
A) Insert > Header & Footer
B) Layout > Page Setup
C) Design > Footer
D) Home > Paragraph
View AnswerA
19. In Excel, what does VLOOKUP function do?
A) Looks for a value in a vertical column
B) Looks for a value in a horizontal row
C) Looks for a value in a table
D) All of the above
View AnswerA
20. Which shortcut key is used to print a document in Word?
A) Ctrl + P
B) Ctrl + S
C) Ctrl + N
D) Ctrl + O
View AnswerA
21. In PowerPoint, which option allows you to change the design of your slides?
A) Themes
B) Background Styles
C) Slide Master
D) Format
View AnswerA
22. What is the purpose of the “Format Painter” in Microsoft Office applications?
A) To copy formatting from one section to another
B) To create charts
C) To change the page layout
D) To spell check
View AnswerA
23. Which file extension is associated with Microsoft Access database files?
A) .xlsx
B) .docx
C) .mdb
D) .pptx
View AnswerC
24. In Excel, what is the purpose of the “Freeze Panes” feature?
A) To lock certain rows or columns in place
B) To split the worksheet into sections
C) To add gridlines
D) To create a pie chart
View AnswerA
25. Which of the following is NOT a view option in PowerPoint?
A) Outline View
B) Slide Sorter
C) Draft View
D) Normal View
View AnswerC
26. Which function is used to concatenate two strings in Excel?
A) CONCATENATE()
B) JOIN()
C) MERGE()
D) COMBINE()
View AnswerA
27. What is the shortcut key for the “Find” function in Word?
A) Ctrl + F
B) Ctrl + H
C) Ctrl + G
D) Ctrl + R
View AnswerA
28. Which of the following chart types is NOT available in Excel?
A) Line Chart
B) Pie Chart
C) Area Chart
D) Vector Chart
View AnswerD
29. In Word, what feature is used to check the spelling and grammar of a document?
A) Thesaurus
B) Research
C) Proofing
D) Review
View AnswerC
30. What is the purpose of the “Page Layout” tab in Excel?
A) To set margins and page orientation
B) To edit cell formulas
C) To add text to a chart
D) To insert images
View AnswerA
31. Which option allows you to apply a style to a table in Word?
A) Design
B) Format
C) Layout
D) Insert
View AnswerA
32. Which of the following can be used to sort data in Excel?
A) Filter
B) Sort & Filter
C) Conditional Formatting
D) Data Validation
View AnswerB
33. What feature allows you to track changes made to a document in Word?
A) Track Changes
B) Comments
C) Review
D) Edit
View AnswerA
34. Which shortcut is used to create a new workbook in Excel?
A) Ctrl + N
B) Ctrl + W
C) Ctrl + O
D) Ctrl + X
View AnswerA
35. In PowerPoint, what is the function of the “Slide Show” tab?
A) To add slides
B) To run the presentation
C) To edit slide content
D) To change slide designs
View AnswerB
36. What is the default font size in a new Microsoft Word document?
A) 10
B) 11
C) 12
D) 14
View AnswerC
37. Which option would you use to create a bulleted list in Word?
A) Home > Paragraph
B) Insert > List
C) Layout > Bullets
D) Review > Bulleted List
View AnswerA
38. What is the purpose of the “Comments” feature in Word?
A) To add notes or feedback
B) To highlight text
C) To spell check
D) To insert graphics
View AnswerA
39. In Excel, what is the result of the formula =2^3?
A) 6
B) 8
C) 9
D) 4
View AnswerB
40. Which view in PowerPoint allows you to edit individual slides?
A) Slide Sorter
B) Normal
C) Outline
D) Presenter
View AnswerB
41. Which of the following file formats can Word save a document as?
A) .xlsx
B) .pptx
C) .doc
D) .html
View AnswerC
42. In Excel, what is the maximum number of columns allowed in a worksheet?
A) 256
B) 1024
C) 16384
D) 32768
View AnswerC
43. Which option would you select to change the orientation of a page in Word?
A) Layout > Page Setup
B) Design > Page Layout
C) Review > Orientation
D) Home > Page Setup
View AnswerA
44. In PowerPoint, how can you add a new slide?
A) Home > New Slide
B) Insert > Slide
C) Design > New Slide
D) View > Slide
View AnswerA
45. What feature in Word allows you to create a table of contents?
A) Insert > Table of Contents
B) References > Table of Contents
C) Layout > Table of Contents
D) Home > Table of Contents
View AnswerB
46. Which of the following functions can be used to count non-empty cells in a range in Excel?
A) COUNT()
B) COUNTA()
C) COUNTIF()
D) ALL()
View AnswerB
47. In Excel, what is the purpose of the “Data Validation” feature?
A) To restrict the type of data entered in a cell
B) To create a drop-down list
C) To check for errors
D) All of the above
View AnswerD
48. Which option is used to insert a hyperlink in Word?
A) Insert > Hyperlink
B) Home > Link
C) Design > Hyperlink
D) References > Link
View AnswerA
49. In PowerPoint, what is the purpose of the “Presenter View”?
A) To show notes to the presenter
B) To add animations
C) To edit slides
D) To create a slideshow
View AnswerA
50. What function would you use in Excel to find the largest number in a range?
A) MAX()
B) LARGE()
C) HIGHEST()
D) FIND()
View AnswerA
51. Which of the following tools can you use to protect a Word document?
A) Encrypt
B) Password
C) Restrict Editing
D) All of the above
View AnswerD
52. In Excel, which symbol is used to start a formula?
A) #
B) *
C) =
D) +
View AnswerC
53. Which function in Excel allows you to look up values in a table?
A) LOOKUP()
B) VLOOKUP()
C) HLOOKUP()
D) All of the above
View AnswerD
54. In Word, what is the purpose of “Styles”?
A) To change the font size
B) To apply consistent formatting
C) To add page numbers
D) To insert images
View AnswerB
55. Which feature allows you to sort data in Access?
A) Filter
B) Sort
C) Query
D) All of the above
View AnswerD
56. In PowerPoint, which element can you use to transition between slides?
A) Animation
B) Transition
C) Slide Design
D) Slide Layout
View AnswerB
57. What is the purpose of the “Review” tab in Word?
A) To format text
B) To insert images
C) To track changes and comments
D) To create tables
View AnswerC
58. Which function calculates the total of a range of cells in Excel?
A) TOTAL()
B) SUM()
C) ADD()
D) COUNT()
View AnswerB
59. What does the “AutoSum” button do in Excel?
A) Automatically saves the workbook
B) Inserts a formula to sum numbers
C) Formats cells as currency
D) Sorts the selected data
View AnswerB
60. In Word, which option is used to insert a page break?
A) Insert > Page Break
B) Layout > Breaks
C) Design > Page Break
D) Review > Break
View AnswerB
61. Which Excel feature allows you to create a drop-down list in a cell?
A) Data Validation
B) Filter
C) Conditional Formatting
D) Sorting
View AnswerA
62. What is the maximum number of worksheets in a single Excel workbook?
A) 255
B) 100
C) 10
D) Unlimited
View AnswerD
63. In PowerPoint, which option allows you to create a custom animation?
A) Animation Pane
B) Slide Master
C) Format
D) Design
View AnswerA
64. Which of the following is a valid way to create a hyperlink in Word?
A) Ctrl + K
B) Alt + H
C) Shift + H
D) Ctrl + L
View AnswerA
65. In Excel, what does the IF function do?
A) Returns TRUE or FALSE based on a condition
B) Adds two numbers
C) Counts cells
D) Returns the largest number
View AnswerA
66. Which option in Word allows you to change paragraph spacing?
A) Home > Paragraph
B) Layout > Spacing
C) Design > Paragraph
D) Review > Paragraph
View AnswerA
67. In PowerPoint, what is the function of the “Design Ideas” feature?
A) To suggest design layouts for slides
B) To add animations
C) To create a presentation
D) To insert images
View AnswerA
68. Which of the following features is NOT available in Excel?
A) Data Table
B) Pivot Table
C) Relationship Chart
D) Mind Map
View AnswerD
69. In Word, what does the “Track Changes” feature do?
A) It tracks word count
B) It records edits and comments made to a document
C) It tracks page numbers
D) It tracks formatting changes
View AnswerB
70. Which Excel function returns the current time?
A) TIME()
B) NOW()
C) CURRENTTIME()
D) TODAY()
View AnswerB
71. What does the “Merge & Center” button do in Excel?
A) Merges selected cells and centers the content
B) Merges two worksheets
C) Merges data from different files
D) Centers text in a single cell
View AnswerA
72. In Word, what is the purpose of the “Page Setup” dialog box?
A) To change page margins, size, and orientation
B) To insert graphics
C) To add headers and footers
D) To format paragraphs
View AnswerA
73. Which shortcut is used to undo an action in Microsoft Office applications?
A) Ctrl + U
B) Ctrl + Z
C) Ctrl + Y
D) Ctrl + A
View AnswerB
74. In Excel, how can you protect a workbook from unauthorized access?
A) By adding a password
B) By changing the file extension
C) By encrypting data
D) Both A and C
View AnswerD
75. What does the “Sort” feature do in Excel?
A) Organizes data in a specified order
B) Counts cells with data
C) Formats cells
D) Changes the font
View AnswerA
76. In PowerPoint, which tab allows you to insert images and shapes?
A) Insert
B) Design
C) Home
D) Slide Show
View AnswerA
77. Which option allows you to add a signature line in Word?
A) Insert > Signature Line
B) Review > Signature
C) Layout > Signature
D) Home > Signature
View AnswerA
78. In Excel, what is the result of =5*10+2?
A) 50
B) 52
C) 12
D) 7
View AnswerB
79. What does the “Conditional Formatting” feature in Excel do?
A) Changes the font style
B) Applies formatting based on cell values
C) Protects data
D) Merges cells
View AnswerB
80. Which function calculates the number of cells that meet a specific condition in Excel?
A) COUNTIF()
B) SUMIF()
C) AVERAGEIF()
D) ALL()
View AnswerA
81. What is the purpose of the “Home” tab in Word?
A) To edit text
B) To format text and paragraphs
C) To insert graphics
D) To review changes
View AnswerB
82. In PowerPoint, which option allows you to record a slideshow?
A) Slide Show
B) Insert
C) Review
D) Design
View AnswerA
83. What does the “Page Break” feature do in Word?
A) Moves the cursor to a new line
B) Splits a page into sections
C) Starts a new page
D) Creates a table of contents
View AnswerC
84. In Excel, which feature allows you to visually represent data?
A) Table
B) Chart
C) Formula
D) Range
View AnswerB
85. Which of the following can you do with the “Find and Replace” feature in Word?
A) Find specific words or phrases
B) Replace words with synonyms
C) Change formatting
D) All of the above
View AnswerA
86. What does the “Table” feature do in Word?
A) Organizes data in rows and columns
B) Adds a graphic
C) Creates a document outline
D) Formats text
View AnswerA
87. In Excel, what is the purpose of the “PivotTable”?
A) To create charts
B) To summarize large amounts of data
C) To format cells
D) To insert images
View AnswerB
88. Which of the following file types can Excel open?
A) .csv
B) .txt
C) .xls
D) All of the above
View AnswerD
89. What is the default alignment for text in a Word document?
A) Center
B) Left
C) Right
D) Justified
View AnswerB
90. In PowerPoint, which feature allows you to set up a timed presentation?
A) Transition
B) Animation
C) Slide Show
D) Presenter View
View AnswerC
91. What is the function of the “Text Box” in Word?
A) To add images
B) To insert a title
C) To create a separate area for text
D) To format paragraphs
View AnswerC
92. In Excel, what does the function COUNTIF() do?
A) Counts all cells
B) Counts cells that meet a specific criterion
C) Counts blank cells
D) Counts cells with errors
View AnswerB
93. Which of the following features can you use to add a visual element in Word?
A) Clip Art
B) Shapes
C) Charts
D) All of the above
View AnswerD
94. What does the “Review” tab allow you to do in Word?
A) Change font styles
B) Check spelling and grammar
C) Insert graphics
D) Format paragraphs
View AnswerB
95. In PowerPoint, which option allows you to add a video to a slide?
A) Insert > Video
B) Design > Video
C) Home > Media
D) View > Video
View AnswerA
96. Which Excel function can be used to find the minimum value in a range?
A) MIN()
B) LOWEST()
C) MINVALUE()
D) SMALLEST()
View AnswerA
97. In Word, what does the “Header” feature do?
A) Adds text at the top of each page
B) Adds a title to a document
C) Inserts page numbers
D) Formats paragraphs
View AnswerA
98. In Excel, what is the function of the “Filter” option?
A) To add graphics
B) To sort data
C) To display only the rows that meet certain criteria
D) To change font color
View AnswerC
99. What is the purpose of the “Insert Object” feature in Word?
A) To add a graphic
B) To embed a file or program
C) To create a hyperlink
D) To format text
View AnswerB
100. Which of the following shortcuts opens the “Help” menu in Microsoft Office applications?
A) F1
B) Ctrl + H
C) Alt + H
D) Ctrl + ?
View AnswerA