Here are **100 multiple-choice questions (MCQs)** covering **Microsoft
Excel, Word, and PowerPoint**. These questions are divided into three
sections for each application.
---
### **Microsoft Excel (35 MCQs)**
1. What is the file extension of an Excel workbook?
a) .txt
b) .xlsx
c) .docx
d) .ppt
**Answer: b) .xlsx**
2. Which function is used to add values in a range of cells?
a) COUNT
b) AVERAGE
c) SUM
d) MAX
**Answer: c) SUM**
3. What is the shortcut key to create a new workbook in Excel?
a) Ctrl + N
b) Ctrl + S
c) Ctrl + O
d) Ctrl + P
**Answer: a) Ctrl + N**
4. Which feature in Excel is used to visually represent data?
a) PivotTable
b) Chart
c) Filter
d) Conditional Formatting
**Answer: b) Chart**
5. What does the "IF" function do in Excel?
a) Checks if a condition is met and returns one value if true and another if
false
b) Adds up all the numbers in a range
c) Counts the number of cells in a range
d) Finds the average of a range
**Answer: a) Checks if a condition is met and returns one value if true and
another if false**
6. Which key combination is used to open the "Format Cells" dialog box?
a) Ctrl + 1
b) Ctrl + 2
c) Ctrl + 3
d) Ctrl + 4
**Answer: a) Ctrl + 1**
7. What is the purpose of the "VLOOKUP" function?
a) To look up data vertically in a table
b) To count cells with specific criteria
c) To add values in a range
d) To find the maximum value in a range
**Answer: a) To look up data vertically in a table**
8. Which feature is used to freeze rows or columns in Excel?
a) Freeze Panes
b) Split
c) Group
d) Hide
**Answer: a) Freeze Panes**
9. What does the "COUNTIF" function do?
a) Counts cells that meet a specific condition
b) Adds values in a range
c) Finds the average of a range
d) Multiplies values in a range
**Answer: a) Counts cells that meet a specific condition**
10. Which chart type is best for showing trends over time?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Scatter Plot
**Answer: c) Line Chart**
11. What is the purpose of the "PivotTable" in Excel?
a) To summarize and analyze large datasets
b) To create charts
c) To format cells
d) To insert images
**Answer: a) To summarize and analyze large datasets**
12. Which function is used to find the highest value in a range?
a) MIN
b) MAX
c) AVERAGE
d) COUNT
**Answer: b) MAX**
13. What is the shortcut key to save a workbook in Excel?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + O
d) Ctrl + P
**Answer: a) Ctrl + S**
14. Which feature is used to apply specific formatting based on cell values?
a) Data Validation
b) Conditional Formatting
c) Filter
d) Sort
**Answer: b) Conditional Formatting**
15. What does the "CONCATENATE" function do?
a) Combines text from multiple cells
b) Adds numbers in a range
c) Counts cells with text
d) Finds the average of a range
**Answer: a) Combines text from multiple cells**
16. Which key is used to edit the active cell in Excel?
a) F2
b) F4
c) F5
d) F7
**Answer: a) F2**
17. What is the purpose of the "Data Validation" feature?
a) To restrict the type of data entered in a cell
b) To format cells
c) To create charts
d) To sort data
**Answer: a) To restrict the type of data entered in a cell**
18. Which function is used to find the square root of a number?
a) SQRT
b) POWER
c) LOG
d) EXP
**Answer: a) SQRT**
19. What is the shortcut key to insert a new worksheet in Excel?
a) Shift + F11
b) Ctrl + N
c) Ctrl + S
d) Ctrl + P
**Answer: a) Shift + F11**
20. Which feature is used to remove duplicate values in Excel?
a) Remove Duplicates
b) Filter
c) Sort
d) Data Validation
**Answer: a) Remove Duplicates**
21. What does the "AVERAGE" function do?
a) Finds the average of a range of numbers
b) Adds values in a range
c) Counts cells with numbers
d) Finds the maximum value in a range
**Answer: a) Finds the average of a range of numbers**
22. Which key combination is used to bold text in Excel?
a) Ctrl + B
b) Ctrl + I
c) Ctrl + U
d) Ctrl + C
**Answer: a) Ctrl + B**
23. What is the purpose of the "Find and Replace" feature?
a) To search for specific data and replace it
b) To format cells
c) To create charts
d) To sort data
**Answer: a) To search for specific data and replace it**
24. Which function is used to count the number of cells in a range?
a) COUNT
b) SUM
c) AVERAGE
d) MAX
**Answer: a) COUNT**
25. What is the shortcut key to undo the last action in Excel?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + X
d) Ctrl + C
**Answer: a) Ctrl + Z**
26. Which feature is used to split text into multiple columns?
a) Text to Columns
b) Concatenate
c) Data Validation
d) Filter
**Answer: a) Text to Columns**
27. What does the "PMT" function do?
a) Calculates loan payments
b) Finds the average of a range
c) Counts cells with numbers
d) Adds values in a range
**Answer: a) Calculates loan payments**
28. Which key combination is used to copy data in Excel?
a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + C**
29. What is the purpose of the "Goal Seek" feature?
a) To find the input value needed to achieve a specific result
b) To create charts
c) To format cells
d) To sort data
**Answer: a) To find the input value needed to achieve a specific result**
30. Which function is used to round a number to a specified number of
digits?
a) ROUND
b) CEILING
c) FLOOR
d) INT
**Answer: a) ROUND**
31. What is the shortcut key to paste data in Excel?
a) Ctrl + V
b) Ctrl + C
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + V**
32. Which feature is used to protect a worksheet in Excel?
a) Protect Sheet
b) Protect Workbook
c) Data Validation
d) Filter
**Answer: a) Protect Sheet**
33. What does the "NOW" function do?
a) Returns the current date and time
b) Returns the current date
c) Returns the current time
d) Returns a random number
**Answer: a) Returns the current date and time**
34. Which key combination is used to cut data in Excel?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + V
d) Ctrl + Z
**Answer: a) Ctrl + X**
35. What is the purpose of the "Scenario Manager" in Excel?
a) To compare different sets of data
b) To create charts
c) To format cells
d) To sort data
**Answer: a) To compare different sets of data**
---
### **Microsoft Word (35 MCQs)**
1. What is the default file extension of a Word document?
a) .txt
b) .docx
c) .xlsx
d) .pptx
**Answer: b) .docx**
2. Which feature is used to combine multiple documents into one?
a) Mail Merge
b) Track Changes
c) Compare
d) Insert Object
**Answer: a) Mail Merge**
3. What is the shortcut key to save a document in Word?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + O
d) Ctrl + P
**Answer: a) Ctrl + S**
4. Which tab in Word is used to insert tables, pictures, and shapes?
a) Home
b) Insert
c) Layout
d) References
**Answer: b) Insert**
5. What does the "Track Changes" feature do in Word?
a) Highlights grammatical errors
b) Tracks edits made to the document
c) Inserts comments
d) Changes the font style
**Answer: b) Tracks edits made to the document**
6. Which key combination is used to bold text in Word?
a) Ctrl + B
b) Ctrl + I
c) Ctrl + U
d) Ctrl + C
**Answer: a) Ctrl + B**
7. What is the purpose of the "Thesaurus" feature in Word?
a) To find synonyms and antonyms
b) To check spelling
c) To insert citations
d) To format text
**Answer: a) To find synonyms and antonyms**
8. Which feature is used to create a table of contents in Word?
a) References > Table of Contents
b) Insert > Table
c) Layout > Columns
d) Review > Track Changes
**Answer: a) References > Table of Contents**
9. What is the shortcut key to undo the last action in Word?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + X
d) Ctrl + C
**Answer: a) Ctrl + Z**
10. Which feature is used to add page numbers in Word?
a) Insert > Page Number
b) Layout > Page Setup
c) References > Footnote
d) Review > Comments
**Answer: a) Insert > Page Number**
11. What does the "Word Count" feature do?
a) Counts the number of words, characters, and paragraphs
b) Checks spelling and grammar
c) Inserts a watermark
d) Formats text
**Answer: a) Counts the number of words, characters, and paragraphs**
12. Which key combination is used to italicize text in Word?
a) Ctrl + I
b) Ctrl + B
c) Ctrl + U
d) Ctrl + C
**Answer: a) Ctrl + I**
13. What is the purpose of the "Mail Merge" feature?
a) To create personalized documents for multiple recipients
b) To track changes in a document
c) To insert tables and charts
d) To format text
**Answer: a) To create personalized documents for multiple recipients**
14. Which feature is used to add comments in Word?
a) Review > New Comment
b) Insert > Comment
c) References > Footnote
d) Layout > Columns
**Answer: a) Review > New Comment**
15. What is the shortcut key to print a document in Word?
a) Ctrl + P
b) Ctrl + S
c) Ctrl + N
d) Ctrl + O
**Answer: a) Ctrl + P**
16. Which feature is used to check spelling and grammar in Word?
a) Review > Spelling & Grammar
b) Insert > Proofing
c) Layout > Language
d) References > Thesaurus
**Answer: a) Review > Spelling & Grammar**
17. What does the "Find and Replace" feature do in Word?
a) Searches for specific text and replaces it
b) Inserts a table
c) Formats text
d) Adds page numbers
**Answer: a) Searches for specific text and replaces it**
18. Which key combination is used to underline text in Word?
a) Ctrl + U
b) Ctrl + B
c) Ctrl + I
d) Ctrl + C
**Answer: a) Ctrl + U**
19. What is the purpose of the "Header and Footer" feature in Word?
a) To add text at the top and bottom of every page
b) To insert page numbers
c) To format text
d) To create a table of contents
**Answer: a) To add text at the top and bottom of every page**
20. Which feature is used to create a bulleted list in Word?
a) Home > Bullets
b) Insert > List
c) Layout > Columns
d) References > Footnote
**Answer: a) Home > Bullets**
21. What is the shortcut key to open a new document in Word?
a) Ctrl + N
b) Ctrl + S
c) Ctrl + O
d) Ctrl + P
**Answer: a) Ctrl + N**
22. Which feature is used to add a watermark in Word?
a) Design > Watermark
b) Insert > Picture
c) Layout > Page Setup
d) References > Footnote
**Answer: a) Design > Watermark**
23. What does the "Format Painter" feature do in Word?
a) Copies formatting from one text to another
b) Inserts a table
c) Adds page numbers
d) Checks spelling and grammar
**Answer: a) Copies formatting from one text to another**
24. Which key combination is used to copy text in Word?
a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + C**
25. What is the purpose of the "Styles" feature in Word?
a) To apply consistent formatting to text
b) To insert tables and charts
c) To add page numbers
d) To check spelling and grammar
**Answer: a) To apply consistent formatting to text**
26. Which feature is used to insert a hyperlink in Word?
a) Insert > Hyperlink
b) References > Footnote
c) Layout > Columns
d) Review > Comments
**Answer: a) Insert > Hyperlink**
27. What is the shortcut key to paste text in Word?
a) Ctrl + V
b) Ctrl + C
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + V**
28. Which feature is used to create a numbered list in Word?
a) Home > Numbering
b) Insert > List
c) Layout > Columns
d) References > Footnote
**Answer: a) Home > Numbering**
29. What does the "AutoCorrect" feature do in Word?
a) Automatically corrects spelling and grammar errors
b) Inserts a table
c) Adds page numbers
d) Formats text
**Answer: a) Automatically corrects spelling and grammar errors**
30. Which key combination is used to cut text in Word?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + V
d) Ctrl + Z
**Answer: a) Ctrl + X**
31. What is the purpose of the "Page Break" feature in Word?
a) To start a new page
b) To insert a table
c) To add page numbers
d) To format text
**Answer: a) To start a new page**
32. Which feature is used to insert a table of figures in Word?
a) References > Insert Table of Figures
b) Insert > Table
c) Layout > Columns
d) Review > Comments
**Answer: a) References > Insert Table of Figures**
33. What is the shortcut key to open an existing document in Word?
a) Ctrl + O
b) Ctrl + N
c) Ctrl + S
d) Ctrl + P
**Answer: a) Ctrl + O**
34. Which feature is used to add footnotes in Word?
a) References > Footnote
b) Insert > Comment
c) Layout > Columns
d) Review > Track Changes
**Answer: a) References > Footnote**
35. What does the "Smart Lookup" feature do in Word?
a) Provides definitions and online search results
b) Inserts a table
c) Adds page numbers
d) Formats text
**Answer: a) Provides definitions and online search results**
---
### **Microsoft PowerPoint (30 MCQs)**
1. What is the default file extension of a PowerPoint presentation?
a) .ppt
b) .pptx
c) .docx
d) .xlsx
**Answer: b) .pptx**
2. Which feature in PowerPoint is used to create a sequence of slides with
animations?
a) Slide Master
b) Transition
c) Animation Pane
d) Slide Sorter
**Answer: c) Animation Pane**
3. What is the shortcut key to start a slideshow in PowerPoint?
a) F5
b) Ctrl + S
c) Ctrl + N
d) F7
**Answer: a) F5**
4. Which view in PowerPoint allows you to see all slides in a thumbnail
format?
a) Normal View
b) Slide Sorter View
c) Reading View
d) Notes Page View
**Answer: b) Slide Sorter View**
5. What is the purpose of the "Slide Master" in PowerPoint?
a) To add animations to slides
b) To control the overall design and layout of slides
c) To insert multimedia files
d) To create hyperlinks
**Answer: b) To control the overall design and layout of slides**
6. Which key combination is used to create a new slide in PowerPoint?
a) Ctrl + M
b) Ctrl + N
c) Ctrl + S
d) Ctrl + P
**Answer: a) Ctrl + M**
7. What does the "Presenter View" feature do in PowerPoint?
a) Displays the current slide, next slide, and speaker notes on the
presenter's screen
b) Adds animations to slides
c) Inserts multimedia files
d) Creates hyperlinks
**Answer: a) Displays the current slide, next slide, and speaker notes on
the presenter's screen**
8. Which feature is used to add a transition effect between slides?
a) Transitions > Transition Effects
b) Animations > Animation Effects
c) Slide Show > Set Up Slide Show
d) Design > Slide Size
**Answer: a) Transitions > Transition Effects**
9. What is the shortcut key to save a presentation in PowerPoint?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + O
d) Ctrl + P
**Answer: a) Ctrl + S**
10. Which feature is used to add speaker notes to a slide?
a) Notes Pane
b) Slide Master
c) Animation Pane
d) Slide Sorter
**Answer: a) Notes Pane**
11. What does the "Rehearse Timings" feature do in PowerPoint?
a) Records the time spent on each slide during a presentation
b) Adds animations to slides
c) Inserts multimedia files
d) Creates hyperlinks
**Answer: a) Records the time spent on each slide during a presentation**
12. Which key combination is used to duplicate a slide in PowerPoint?
a) Ctrl + D
b) Ctrl + C
c) Ctrl + V
d) Ctrl + X
**Answer: a) Ctrl + D**
13. What is the purpose of the "Action Buttons" feature in PowerPoint?
a) To navigate between slides or perform actions during a presentation
b) To add animations to slides
c) To insert multimedia files
d) To create hyperlinks
**Answer: a) To navigate between slides or perform actions during a
presentation**
14. Which feature is used to add a background image to a slide?
a) Design > Format Background
b) Insert > Picture
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Design > Format Background**
15. What is the shortcut key to open an existing presentation in PowerPoint?
a) Ctrl + O
b) Ctrl + N
c) Ctrl + S
d) Ctrl + P
**Answer: a) Ctrl + O**
16. Which feature is used to add a chart to a slide?
a) Insert > Chart
b) Design > Slide Size
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Insert > Chart**
17. What does the "Hide Slide" feature do in PowerPoint?
a) Excludes a slide from the presentation without deleting it
b) Adds animations to slides
c) Inserts multimedia files
d) Creates hyperlinks
**Answer: a) Excludes a slide from the presentation without deleting it**
18. Which key combination is used to print a presentation in PowerPoint?
a) Ctrl + P
b) Ctrl + S
c) Ctrl + N
d) Ctrl + O
**Answer: a) Ctrl + P**
19. What is the purpose of the "SmartArt" feature in PowerPoint?
a) To create visual representations of information
b) To add animations to slides
c) To insert multimedia files
d) To create hyperlinks
**Answer: a) To create visual representations of information**
20. Which feature is used to add a video to a slide?
a) Insert > Video
b) Design > Slide Size
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Insert > Video**
21. What is the shortcut key to undo the last action in PowerPoint?
a) Ctrl + Z
b) Ctrl + Y
c) Ctrl + X
d) Ctrl + C
**Answer: a) Ctrl + Z**
22. Which feature is used to add a sound effect to a slide?
a) Insert > Audio
b) Design > Slide Size
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Insert > Audio**
23. What does the "Package Presentation for CD" feature do in PowerPoint?
a) Saves a presentation and linked files to a CD or folder
b) Adds animations to slides
c) Inserts multimedia files
d) Creates hyperlinks
**Answer: a) Saves a presentation and linked files to a CD or folder**
24. Which key combination is used to copy a slide in PowerPoint?
a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + C**
25. What is the purpose of the "Photo Album" feature in PowerPoint?
a) To create a presentation from a collection of photos
b) To add animations to slides
c) To insert multimedia files
d) To create hyperlinks
**Answer: a) To create a presentation from a collection of photos**
26. Which feature is used to add a hyperlink to a slide?
a) Insert > Hyperlink
b) Design > Slide Size
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Insert > Hyperlink**
27. What is the shortcut key to paste a slide in PowerPoint?
a) Ctrl + V
b) Ctrl + C
c) Ctrl + X
d) Ctrl + Z
**Answer: a) Ctrl + V**
28. Which feature is used to add a table to a slide?
a) Insert > Table
b) Design > Slide Size
c) Transitions > Transition Effects
d) Animations > Animation Effects
**Answer: a) Insert > Table**
29. What does the "Record Slide Show" feature do in PowerPoint?
a) Records narration and timings for a presentation
b) Adds animations to slides
c) Inserts multimedia files
d) Creates hyperlinks
**Answer: a) Records narration and timings for a presentation**
30. Which key combination is used to cut a slide in PowerPoint?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + V
d) Ctrl + Z
**Answer: a) Ctrl + X**
---
Let me know if you need more questions or additional topics!
