MS Office Mcqs
MS Office Mcqs
MS Office Mcqs
questions that can help you get started. I'll provide a few examples, and let me know if you’d like
more questions in specific areas like MS Word, Excel, PowerPoint, or Outlook.
---
**1. In MS Word, which shortcut key is used to align text to the center?**
- A) Ctrl + L
- B) Ctrl + E
- C) Ctrl + R
- D) Ctrl + J
**Answer:** B) Ctrl + E
**2. In MS Excel, which function is used to find the average of a range of values?**
- A) SUM
- B) COUNT
- C) AVERAGE
- D) MAX
**Answer:** C) AVERAGE
**3. What is the default file extension for an MS PowerPoint presentation in recent versions?**
- A) .ppt
- B) .pptx
- C) .pdf
- D) .docx
**Answer:** B) .pptx
**4. In Outlook, which feature allows you to organize emails into folders?**
- A) Categories
- B) Tasks
- C) Folders
- D) Notes
**Answer:** C) Folders
- A) MS Word
- B) MS Excel
- C) MS PowerPoint
- D) MS Outlook
**Answer:** B) MS Excel
- A) AutoFormat
- B) Spell Check
- C) AutoCorrect
- D) Grammar Check
**Answer:** C) AutoCorrect
**7. In MS Excel, what does the '$' symbol do when added in front of a row or column in a cell
reference?**
- A) Ctrl + S
- B) Ctrl + P
- C) Ctrl + N
- D) Ctrl + A
**Answer:** A) Ctrl + S
**9. In MS PowerPoint, which of the following views allows you to see slide thumbnails in order?**
- B) Normal View
- C) Outline View
- D) Notes View
**10. What function in MS Excel will return the largest value in a set of values?**
- A) MIN
- B) MAX
- C) AVERAGE
- D) COUNT
**Answer:** B) MAX
---
- A) 1024
- B) 16384
- C) 65536
- D) 1048576
**Answer:** B) 16384
**13. In MS Word, what is the purpose of the “Track Changes” feature?**
**14. Which MS Excel function is used to join the contents of multiple cells into one cell?**
- A) CONCATENATE
- B) JOIN
- C) MERGE
- D) LINK
**Answer:** A) CONCATENATE
**15. Which keyboard shortcut in MS PowerPoint starts a slideshow from the beginning?**
- A) F5
- B) F11
- C) Ctrl + Enter
- D) Alt + S
**Answer:** A) F5
---
- A) Conditional Formatting
- B) Data Validation
- C) Sorting
- D) Cell Styles
- A) MS Word
- B) MS Excel
- C) MS PowerPoint
- D) MS Outlook
**Answer:** D) MS Outlook
- A) To add footnotes
- B) Reading View
- C) Master View
- D) Data View
- A) Pie Chart
- B) Line Chart
- C) Bar Chart
- D) Scatter Chart
**22. In MS Word, which key combination will open the “Find” dialog box?**
- A) Ctrl + H
- B) Ctrl + F
- C) Ctrl + G
- D) Ctrl + P
**Answer:** B) Ctrl + F
**23. Which of these is a valid function to calculate the sum of cells in Excel?**
- A) ADD
- B) TOTAL
- C) SUM
- D) COMBINE
**Answer:** C) SUM
- A) Animations
- B) Design
- C) Insert
- D) Transitions
**Answer:** D) Transitions
- A) Ctrl + Enter
- B) Alt + Shift
- C) Ctrl + Shift
- D) Alt + Enter
---
- A) #
- B) @
- C) =
- D) $
**Answer:** C) =
- A) Rules
- B) Filters
- C) Categories
- D) Labels
**Answer:** C) Categories
**28. In MS Word, which option is used to display a document in full-screen reading mode?**
**29. In MS Excel, which function calculates the number of cells that contain numbers in a range?**
- A) COUNT
- B) SUM
- C) COUNTA
- D) AVERAGE
**Answer:** A) COUNT
- A) Ctrl + M
- B) Ctrl + S
- C) Ctrl + N
- D) Ctrl + D
**Answer:** A) Ctrl + M
---
**32. Which MS Excel function returns the current date and time?**
- A) NOW()
- B) TODAY()
- C) DATE()
- D) TIME()
**Answer:** A) NOW()
- A) Outline View
- D) Reading View
**Answer:** B) Slide Sorter View
- A) Left
- B) Center
- C) Right
- D) Justified
**Answer:** A) Left
---
**36. In MS Excel, which function calculates the minimum value in a set of values?**
- A) MIN()
- B) AVERAGE()
- C) SMALL()
- D) MAX()
**Answer:** A) MIN()
- B) To organize emails
- D) To create categories
- A) AutoFit
- B) AutoFormat
- C) AutoSize
- D) AutoAdjust
**Answer:** A) AutoFit
**39. Which Excel function is used to calculate the remainder when a number is divided by another
number?**
- A) DIVIDE
- B) MOD
- C) ROUND
- D) REMAINDER
**Answer:** B) MOD
---
**41. Which of the following is used to apply the same formatting as one cell to another cell in
Excel?**
- A) Format Painter
- B) Style Brush
- C) Cell Copier
- D) Format Copier
**Answer:** A) Format Painter
- A) Insert
- B) Layout
- C) Review
- D) Home
**Answer:** D) Home
- A) .pptx
- B) .pptm
- C) .ppsx
- D) .ppt
**Answer:** C) .ppsx
**44. Which Excel feature allows you to restrict cell entries to specific data?**
- A) Data Validation
- B) Conditional Formatting
- C) Filters
- D) Sorting
- A) Text to Speech
- B) Speech Recognition
- C) Dictation
- D) AutoCorrect
**Answer:** C) Dictation
---
**46. In Excel, which function combines text from different cells?**
- A) CONCATENATE
- B) JOIN
- C) MERGE
- D) UNION
**Answer:** A) CONCATENATE
- A) Bold text
- B) Insert a hyperlink
- D) Delete text
- A) Designer
- B) Arranger
- C) Formatter
- D) Presenter
**Answer:** A) Designer
**49. In MS Excel, which of these functions would you use to find the average of a range?**
- A) SUM
- B) AVG
- C) MEAN
- D) AVERAGE
**Answer:** D) AVERAGE
**50. In MS Word, which feature allows you to create a list with a specific order?**
- A) Bullets
- B) Numbers
- C) Symbols
- D) Indentation
**Answer:** B) Numbers
---
**51. In MS Excel, which function allows you to count cells that meet a specific condition?**
- A) COUNT
- B) COUNTIF
- C) COUNTA
- D) SUMIF
**Answer:** B) COUNTIF
**52. Which MS Word shortcut is used to open the “Font” dialog box?**
- A) Ctrl + D
- B) Ctrl + F
- C) Ctrl + M
- D) Ctrl + L
**Answer:** A) Ctrl + D
- A) Normal View
- C) Outline View
- A) Ctrl + H
- B) Ctrl + L
- C) Ctrl + K
- D) Ctrl + U
**Answer:** C) Ctrl + K
---
**56. In MS Excel, which function is used to search for a value in the first column of a range and
return a value in the same row?**
- A) HLOOKUP
- B) VLOOKUP
- C) SEARCH
- D) FIND
**Answer:** B) VLOOKUP
- A) Arial
- C) Calibri
- D) Verdana
**Answer:** C) Calibri
- A) 200%
- B) 400%
- C) 300%
- D) 500%
**Answer:** B) 400%
**60. Which formula in Excel can be used to determine if two cells have the same value?**
- A) MATCH
- B) EXACT
- C) COMPARE
- D) SAME
**Answer:** B) EXACT
---
- A) Eraser
- B) Clear Formatting
- C) Remove Style
- D) Plain Text
**62. Which of the following features in Outlook allows for setting automatic replies?**
- A) Forward
- B) Reply All
- C) Out of Office Assistant
- D) Archive
**63. In MS Excel, which function would return the largest number in a range of cells?**
- A) MAX
- B) HIGHEST
- C) LARGEST
- D) SUM
**Answer:** A) MAX
- A) Arrange
- B) Design
- C) Format
- D) Sort
**Answer:** A) Arrange
- A) Merge Documents
---
**66. In MS Excel, which of the following options keeps column headings visible while scrolling?**
- A) Freeze Panes
- B) Split Screen
- C) Lock Headers
- D) Fix Columns
- A) Portrait
- B) Landscape
- C) Square
- D) Custom
**Answer:** A) Portrait
- A) Ctrl + P
- B) Ctrl + O
- C) Ctrl + D
- D) Ctrl + V
**Answer:** A) Ctrl + P
- A) Transitions
- B) Slide Show
- C) Animations
- D) Custom Slide
**Answer:** C) Animations
**70. In Excel, which function is used to return the lowest value in a range?**
- A) LOWEST
- B) MIN
- C) SMALL
- D) FLOOR
**Answer:** B) MIN
---
- A) CAPITALIZE
- B) CAPSLOCK
- C) UPPER
- D) CASE
**Answer:** C) UPPER
**73. In PowerPoint, what is the shortcut to move to the next slide during a presentation?**
- A) Spacebar
- B) Right Arrow
- C) Enter
**74. Which Outlook feature allows users to schedule an email to be sent later?**
- A) Delay Delivery
- B) Drafts
- C) Templates
- D) Categories
- D) Adds a hyperlink
---
- A) 5.6
- B) 5.7
- C) 6
- D) 5.67
**Answer:** B) 5.7
**77. Which PowerPoint view is best for rearranging the order of slides?**
- C) Outline View
- A) DATE()
- B) TODAY()
- C) NOW()
- D) CURRENT()
**Answer:** B) TODAY()
**80. Which feature in MS Word provides synonyms and antonyms for a selected word?**
- A) Spell Check
- B) Grammar Check
- C) Dictionary
- D) Thesaurus
**Answer:** D) Thesaurus
---
**81. In PowerPoint, which transition effect moves slides from right to left?**
- A) Push
- B) Wipe
- C) Slide
- D) Dissolve
**Answer:** C) Slide
**82. In Excel, which tool allows you to automatically fill cells with data based on patterns?**
- A) AutoComplete
- B) AutoFit
- C) Flash Fill
- D) Quick Access
- A) Home
- B) Layout
- C) Design
- D) Insert
**Answer:** B) Layout
- A) A1 is less than 10
- B) A1 equals 10
- C) A1 is greater than 10
- D) A1 is exactly
10
- A) Deletes a slide
- B) Duplicates a slide
**86. Which Excel function will calculate the number of non-empty cells in a range?**
- A) COUNTA
- B) COUNTBLANK
- C) COUNTIF
- D) AVERAGEA
**Answer:** A) COUNTA
- A) Centers text
- B) Left-aligns text
- C) Right-aligns text
- D) Justifies text
- A) Current date
- B) Current time
- C) Current formula
**89. Which MS Word feature shows different editing changes made by various users?**
- A) Comments
- B) Review
- C) Track Changes
- D) Compare
- A) STDEV
- B) VAR
- C) MEAN
- D) MEDIAN
**Answer:** A) STDEV
**93. In PowerPoint, which keyboard shortcut can start a slideshow from the current slide?**
- A) F5
- B) Shift + F5
- C) Ctrl + F5
- D) Alt + F5
**Answer:** B) Shift + F5
- A) Outline View
- B) Draft View
- C) Document Map
- D) Navigation Pane
---
**96. In Excel, which function is used to remove extra spaces from text?**
- A) TRIM
- B) CLEAN
- C) SUBSTITUTE
- D) FORMAT
**Answer:** A) TRIM
- A) Slide Timing
- B) Rehearse Timings
- C) Custom Timing
- D) Auto Timing
**98. In Outlook, which feature allows you to create rules to manage emails automatically?**
- A) Filters
- B) Sorting
- C) Rules
- D) Categories
**Answer:** C) Rules
- C) Applies superscript
- D) Applies subscript
---
**101. In MS PowerPoint, which view displays slides along with the notes you have added?**
- B) Normal View
- D) Outline View
**102. In MS Excel, which formula is used to find the square root of a number in cell A1?**
- A) SQR(A1)
- B) SQRT(A1)
- C) ROOT(A1)
- D) POWER(A1,2)
**Answer:** B) SQRT(A1)
- A) F1
- B) F2
- C) F3
- D) F4
**Answer:** B) F2
---
**106. In Excel, which function can calculate the median of a data range?**
- A) AVERAGE
- B) MEAN
- C) MEDIAN
- D) MIDPOINT
**Answer:** C) MEDIAN
- B) Align Objects
- D) Order Shapes
**108. In MS Outlook, which of the following options allows you to view all folders?**
- A) Folder Pane
- B) View Pane
- C) Navigation Pane
- D) Reading Pane
- A) WEEKDAY
- B) DAYNAME
- C) DATE
- D) WEEKNUM
**Answer:** A) WEEKDAY
- A) Heading 1 style
- B) Subtitle style
- C) Normal style
- D) Title style
---
- A) Combines numbers
**112. In PowerPoint, what feature helps to avoid duplicate animations on different slides?**
- A) Animation Pane
- B) Animation Painter
- C) Transition Styles
- D) Slide Sorter
- A) TIMESTAMP
- B) NOW
- C) CURRENTDATE
- D) DATEDIFF
**Answer:** B) NOW
- A) Adds a bookmark
- B) Inserts a comment
- D) Adds a reference
---
**116. In PowerPoint, which option allows you to display slides in random order?**
- A) Slide Shuffler
- B) Slide Master
- D) Randomize Slides
- B) 5
- C) 4.3
- D) 4.4
**Answer:** B) 5
- A) Home
- B) Design
- C) Layout
- D) Insert
**Answer:** B) Design
**120. In PowerPoint, which tool helps apply consistent fonts and colors across slides?**
- A) Master Slide
- B) Theme
- C) Layout
- D) Style
---
**121. In MS Word, which feature aligns text to both left and right margins?**
- A) Center alignment
- B) Right alignment
- C) Full
alignment
- D) Justify alignment
**122. In Excel, which function finds the largest number in a data range?**
- A) LARGE
- B) MAX
- C) BIG
- D) SUMIF
**Answer:** B) MAX
- B) Exiting presentation
**124. In Outlook, which command lets you arrange emails by the sender?**
- A) Sort by Sender
- B) Filter by Sender
- C) Arrange by From
- D) Group by Sender
---
These questions should round out your understanding for the placement drive. Let me know if you
need more specific tips or additional resources!