MS Office Intermediate Level MCQ Bank

50 Comprehensive Questions on Word, Excel, and PowerPoint (Shortcuts, Options, & Functions)

--- MS WORD ---

Q1. Which keyboard shortcut is used to insert a continuous Section Break in MS Word?
A) Ctrl + Enter
B) Alt + Shift + Enter
C) Ctrl + Shift + Enter
D) Shift + Enter
Correct Answer: C) Ctrl + Shift + Enter
Explanation: Ctrl + Shift + Enter splits a column, while Page Layout > Breaks > Continuous Section Break must
normally be selected, but Ctrl+Shift+Enter natively forces a column break which functions as a structural split.

Q2. What is the purpose of the 'Navigation Pane' in MS Word, which can be toggled using Ctrl + F?
A) To design custom page margins
B) To browse documents by headings, pages, or search results
C) To create automated bibliographies
D) To preview mail merge documents
Correct Answer: B) To browse documents by headings, pages, or search results
Explanation: The Navigation Pane allows users to quickly jump around a document by clicking on organized
heading hierarchies, thumbnails, or active search terms.

Q3. Which tab contains the option to insert a dynamic 'Table of Contents'?
A) Insert
B) Design
C) Layout
D) References
Correct Answer: D) References
Explanation: The References tab contains the Table of Contents group, allowing automatic updates based on
Heading styles.
Q4. What is the shortcut key to toggle formatting marks (such as spaces, paragraph breaks, and tabs)
on and off?
A) Ctrl + * (or Ctrl + Shift + 8)
B) Ctrl + Shift + M
C) Alt + F8
D) Ctrl + Shift + S
Correct Answer: A) Ctrl + * (or Ctrl + Shift + 8)
Explanation: This shortcut toggles non-printing formatting marks, useful for identifying alignment errors or
double spaces.

Q5. In Word, what does the 'Keep with Next' paragraph formatting option prevent?
A) Merging two distinct table cells
B) Placing a page break between the current paragraph and the one following it
C) Merging two sequential styled headings
D) Copying format to other paragraphs
Correct Answer: B) Placing a page break between the current paragraph and the one following it
Explanation: This setting is highly useful for keeping section headings on the same page as their starting content.

Q6. Which shortcut increases the font size of selected text by exactly 1 point?
A) Ctrl + ]
B) Ctrl + Shift + >
C) Ctrl + Alt + +
D) Ctrl + Up Arrow
Correct Answer: A) Ctrl + ]
Explanation: Ctrl + ] increases font size by 1 pt, whereas Ctrl + Shift + > increases it to the next standard preset
size.

Q7. Which tool would you use to repeat structural layout and formatting rules across multiple
separate Word documents?
A) Format Painter
B) Page Layout Themes
C) Document Templates (.dotx)
D) Quick Parts Organizer
Correct Answer: C) Document Templates (.dotx)
Explanation: Templates (.dotx files) hold predefined layouts, styles, headers, and margins to ensure company-
wide formatting compliance.
Q8. What does the shortcut Ctrl + K do inside a selected block of text?
A) Clears paragraph indents
B) Applies strike-through format
C) Opens the Insert Hyperlink dialog
D) Converts lowercase text to uppercase
Correct Answer: C) Opens the Insert Hyperlink dialog
Explanation: Ctrl + K instantly lets you link the selected text to web pages, other document headings, or files.

Q9. Which feature tracks every modification, insertion, deletion, and comment made in a shared
document?
A) Compare Documents
B) Document Inspector
C) Track Changes (Ctrl + Shift + E)
D) Restrict Editing Settings
Correct Answer: C) Track Changes (Ctrl + Shift + E)
Explanation: Track Changes marks edits in real time, making visual peer collaboration and approval cycles
structured.

Q10. How can you insert a 'Non-Breaking Space' (to prevent two words from being split across two
pages)?
A) Ctrl + Spacebar
B) Ctrl + Shift + Spacebar
C) Alt + Spacebar
D) Shift + Enter
Correct Answer: B) Ctrl + Shift + Spacebar
Explanation: Non-breaking spaces keep closely related words (e.g., 'Page 5' or dates like 'July 15') together on a
single line.

Q11. What is the shortcut to select an entire document quickly?

A) Ctrl + S
B) Ctrl + A
C) Alt + A
D) Ctrl + Shift + End
Correct Answer: B) Ctrl + A
Explanation: Ctrl + A ('Select All') selects the entire document text, headers, and media elements simultaneously.
Q12. Which view displays the hierarchical organization of headings and body text, allowing fast drag-
and-drop structural reorganization?
A) Web Layout View
B) Draft View
C) Read Mode
D) Outline View
Correct Answer: D) Outline View
Explanation: Outline View provides structural editing controls to promote or demote heading levels and reorder
sections.

Q13. How can you copy only the *formatting* (not the actual text) of a selection to apply it
elsewhere?
A) Ctrl + C followed by Ctrl + Shift + V
B) Ctrl + Shift + C and then Ctrl + Shift + V
C) Alt + C and Alt + V
D) Ctrl + Alt + C and Ctrl + Alt + V
Correct Answer: B) Ctrl + Shift + C and then Ctrl + Shift + V
Explanation: This keyboard shortcut pair copies formatting styles and applies them to any highlighted text
without altering content.

Q14. What does 'Gutter Margin' refer to in MS Word page layout configuration?
A) Space reserved for footnotes
B) Margin space added to the binding side of pages
C) Blank space between columns in a newsletter
D) Space outside the printable page boundary
Correct Answer: B) Margin space added to the binding side of pages
Explanation: Gutter margins ensure text isn't obscured or clipped when documents are printed and bound
together.

Q15. Which shortcut jumps the cursor back to the exact last edited location in MS Word?
A) Shift + F5
B) Ctrl + Home
C) Alt + Left Arrow
D) F5
Correct Answer: A) Shift + F5
Explanation: Shift + F5 acts as a navigation bookmark back to your last three edited locations, even after
reopening the document.
Q16. What is the primary function of 'Mail Merge' in MS Word?
A) Encrypting files for secure email delivery
B) Auto-generating multiple personalized letters, envelopes, or labels using an external data source
C) Synchronizing document versions with cloud servers
D) Checking spelling and grammar in outbound emails
Correct Answer: B) Auto-generating multiple personalized letters, envelopes, or labels using an external
data source
Explanation: Mail Merge dynamically pulls data (like customer lists) from Excel or Access to customize individual
letters in bulk.

Q17. Which shortcut toggles a selected word or block of text between UPPERCASE, lowercase, and
Capitalize Each Word?
A) Ctrl + Shift + U
B) Shift + F3
C) Alt + F3
D) Ctrl + F3
Correct Answer: B) Shift + F3
Explanation: Shift + F3 cycles through case formats without requiring manual re-typing.

--- MS EXCEL ---

Q18. Which function in Excel allows you to find items in a table or range by row (searching vertically
downwards)?
A) HLOOKUP
B) VLOOKUP
C) XMATCH
D) TRANSPOSE
Correct Answer: B) VLOOKUP
Explanation: VLOOKUP looks for a value in the leftmost column of a table and returns a value in the same row
from a specified column.

Q19. How do you toggle between Relative, Absolute, and Mixed cell referencing (e.g., changing A1 to
$A$1) while writing a formula?
A) Press F2
B) Press F4
C) Press F9
D) Press Ctrl + Spacebar
Correct Answer: B) Press F4
Explanation: Pressing F4 repeatedly cycles your active formula reference through configurations ($A$1, A$1, $A1,
and A1).
Q20. What does the keyboard shortcut Ctrl + Shift + L do when working with a tabular dataset?
A) Left-aligns the content inside all selected cells
B) Alternately shades table rows (zebra-striping)
C) Toggles Sort & Filter dropdown arrows on or off on the header row
D) Locks the active worksheet
Correct Answer: C) Toggles Sort & Filter dropdown arrows on or off on the header row
Explanation: Ctrl + Shift + L is a highly efficient toggle to turn off/on filtering menus for Excel databases.

Q21. What is the core difference between the COUNT and COUNTA functions in Excel?
A) COUNT counts formulas, COUNTA counts raw values
B) COUNT counts numerical cells, COUNTA counts all non-empty cells
C) COUNT counts cells with formatting, COUNTA counts blank cells
D) COUNT is faster but has a lower data limit than COUNTA
Correct Answer: B) COUNT counts numerical cells, COUNTA counts all non-empty cells
Explanation: COUNT is restricted purely to numbers, while COUNTA counts text, booleans, error codes, and
numbers alike.

Q22. Which feature allows users to dynamically summarize, analyze, and reorganize thousands of
rows of data into structured tables?
A) PivotTables
B) Goal Seek
C) Conditional Formatting
D) Data Validation
Correct Answer: A) PivotTables
Explanation: PivotTables provide quick drag-and-drop summarizations, filtering, grouping, and basic aggregations
of large source datasets.

Q23. Which formula correctly extracts the first 4 characters of cell B2?
A) =MID(B2, 1, 4)
B) =LEFT(B2, 4)
C) =FIRST(B2, 4)
D) Both A and B are correct
Correct Answer: D) Both A and B are correct
Explanation: Both LEFT(B2, 4) and MID(B2, 1, 4) return the exact same substring starting from the first character.
Q24. What error message is returned when a formula refers to a cell that has been deleted (e.g.,
through column deletion)?
A) #VALUE!
B) #REF!
C) #DIV/0!
D) #NAME?
Correct Answer: B) #REF!
Explanation: The #REF! error represents an invalid cell reference, often caused by deleted rows, columns, or
worksheets.

Q25. What does the keyboard shortcut Alt + = do in a cell below a column of numbers?
A) Automatically inserts a SUM formula guessing the range
B) Computes the arithmetic mean
C) Clones the above cell's formatting
D) Draws a horizontal double-line border
Correct Answer: A) Automatically inserts a SUM formula guessing the range
Explanation: Alt + = is the AutoSum shortcut, saving time by writing the cell range boundaries for you.

Q26. Which tool is best for restricting cells to input only specified values, such as dates within a range
or options from a list?
A) Conditional Formatting
B) Data Validation
C) Protect Sheet settings
D) Filter Views
Correct Answer: B) Data Validation
Explanation: Data Validation prevents typos and invalid data entry by setting rules and building drop-down
menus.

Q27. If you want to look up a value that is to the *left* of your lookup column, which modern Excel
function is best suited without reorganizing columns?
A) VLOOKUP
B) HLOOKUP
C) XLOOKUP
D) MATCH
Correct Answer: C) XLOOKUP
Explanation: XLOOKUP overcomes VLOOKUP's limitation of only searching rightward, making left searches simple
and flexible.
Q28. How do you enter a new line of text (a manual line break) within a single Excel cell?
A) Shift + Enter
B) Ctrl + Enter
C) Alt + Enter
D) Tab + Enter
Correct Answer: C) Alt + Enter
Explanation: Alt + Enter adds a line break in a cell's editing view, keeping text within a single column width
structure.

Q29. What does the Excel function IFERROR do?

A) Automatically fixes typo errors in formula text
B) Displays a custom value if a formula returns an error instead of displaying the error code
C) Audits logical circular references in the worksheet
D) Prevents users from typing invalid inputs
Correct Answer: B) Displays a custom value if a formula returns an error instead of displaying the error
code
Explanation: IFERROR(value, value_if_error) catches standard errors like #DIV/0! or #N/A and returns clean
alternate outputs.

Q30. Which feature automatically styles cells (e.g. green fill for values > 100) based on their specific
values?
A) Format Cells dialog
B) Data Validation
C) Conditional Formatting
D) AutoFormat tool
Correct Answer: C) Conditional Formatting
Explanation: Conditional Formatting allows cells to dynamically update background fills and font weights based
on predefined logic rules.

Q31. What key do you press to start editing the content of the currently selected cell?
A) F1
B) F2
C) F3
D) F4
Correct Answer: B) F2
Explanation: F2 places the blinking cursor at the end of the cell's current contents to allow quick, non-destructive
editing.
Q32. Which Excel tool allows you to work backwards to find a specific input value needed to achieve a
target formula output?
A) Goal Seek
B) Solver
C) Scenario Manager
D) Flash Fill
Correct Answer: A) Goal Seek
Explanation: Goal Seek is a built-in 'What-If' analysis tool that automatically changes an input cell until a formula
reaches a desired result.

Q33. What is the keyboard shortcut to flash fill (auto-detecting and filling patterns in adjacent
columns)?
A) Ctrl + F
B) Ctrl + E
C) Ctrl + Shift + F
D) Alt + E
Correct Answer: B) Ctrl + E
Explanation: Ctrl + E triggers Flash Fill, which detects text patterns (like splitting first and last names) and
processes the rest of the column.

Q34. Which function computes the mathematical average of cells that meet a single, specified
condition?
A) AVERAGEIFS
B) AVERAGE
C) AVERAGEIF
D) SUMIF/COUNTIF
Correct Answer: C) AVERAGEIF
Explanation: AVERAGEIF calculates the mean of only those cells matching a designated criteria (e.g., averaging
sales only for 'East' region).

--- MS POWERPOINT ---

Q35. What is the shortcut to insert a new, blank slide into your active presentation?
A) Ctrl + N
B) Ctrl + M
C) Alt + N
D) Ctrl + Shift + S
Correct Answer: B) Ctrl + M
Explanation: Ctrl + M adds a new slide directly after the active slide, while Ctrl + N starts a completely new
presentation document.
Q36. Which view is used to apply universal formatting, logos, and layouts that automatically replicate
on every slide in your deck?
A) Outline View
B) Slide Sorter View
C) Slide Master View
D) Reading View
Correct Answer: C) Slide Master View
Explanation: Slide Master View controls layout templates and visual formatting universally, preventing repetitive
manual editing.

Q37. Which transition effect mimics the physical moving of objects from one slide's position to
another slide's position, creating seamless animations?
A) Fade
B) Zoom
C) Morph
D) Wipe
Correct Answer: C) Morph
Explanation: The Morph transition detects matching objects on consecutive slides and smoothly animates their
position, size, and color changes.

Q38. While delivering a slide show, which key on your keyboard immediately blanks the screen to a
solid black display?
A) Escape
B) B key
C) W key
D) Spacebar
Correct Answer: B) B key
Explanation: Pressing the 'B' key during a presentation turns the screen pitch black (pressing 'W' turns it white),
refocusing audience attention.

Q39. How do you start a slide show presentation from the *current* active slide rather than from the
first slide?
A) F5
B) Shift + F5
C) Alt + F5
D) Ctrl + F5
Correct Answer: B) Shift + F5
Explanation: F5 starts the slide show from Slide 1; Shift + F5 initiates it directly from the slide currently open on
your screen.
Q40. What is the primary function of the 'Selection Pane' in PowerPoint?
A) Selecting font themes
B) Layering, renaming, hiding, and ordering multiple overlapping graphic elements on a slide
C) Choosing pre-packaged slide layouts
D) Reviewing transition speeds
Correct Answer: B) Layering, renaming, hiding, and ordering multiple overlapping graphic elements on a
slide
Explanation: The Selection Pane provides a list of all slide components, allowing precise control over what
elements are selected and animated.

Q41. What is the shortcut key to group multiple selected objects together into a single, cohesive
shape block?
A) Ctrl + G
B) Ctrl + Shift + G
C) Alt + G
D) Ctrl + Alt + G
Correct Answer: A) Ctrl + G
Explanation: Ctrl + G groups elements to move/format together; Ctrl + Shift + G separates (ungroups) them back
into individual assets.

Q42. What happens when you double-click the Format Painter icon in PowerPoint (or Word)?
A) It formats the entire document matching the selection
B) It locks the painter active, allowing you to paint formatting onto multiple items consecutively
C) It opens a styling options dialog menu
D) It resets text formatting back to default settings
Correct Answer: B) It locks the painter active, allowing you to paint formatting onto multiple items
consecutively
Explanation: Double-clicking locks the tool on; press Escape to exit painter mode once you finish formatting
multiple separate components.

Q43. Which tool allows you to visually map and present business processes, hierarchies, and cycles
without drawing manual custom shapes?
A) SmartArt Graphics
B) Shapes Gallery
C) Charts & Graphs
D) Table Styles
Correct Answer: A) SmartArt Graphics
Explanation: SmartArt generates structured visual diagrams (such as organizational charts or process steps)
dynamically from text lists.
Q44. Which view displays a grid layout of all slides in thumbnail form, ideal for drag-and-drop slide
reordering?
A) Outline View
B) Reading View
C) Slide Sorter View
D) Notes Page View
Correct Answer: C) Slide Sorter View
Explanation: Slide Sorter View provides a bird's-eye layout of your entire deck to easily sequence slides, delete
duplicates, or test transitions.

Q45. How can you compress all images in a PowerPoint presentation to reduce file size for email
sharing?
A) Save as PDF
B) Double-click any picture, open 'Format Picture', and click 'Compress Pictures'
C) Select the slide and press Ctrl + Alt + C
D) Convert the PowerPoint presentation directly into an MP4 video format
Correct Answer: B) Double-click any picture, open 'Format Picture', and click 'Compress Pictures'
Explanation: The Compress Pictures tool downsamples high-res images to web/email resolution (e.g., 96 or 150
ppi) to trim file sizes.

Q46. What is 'Presenter View' used for during a presentation?

A) To record voiceover narrations
B) To display speaker notes, active timers, and upcoming slides on the presenter's screen while the
audience only sees the active slide
C) To convert a PowerPoint into a scrolling Word document
D) To preview animation timings in slow motion
Correct Answer: B) To display speaker notes, active timers, and upcoming slides on the presenter's screen
while the audience only sees the active slide
Explanation: Presenter View provides standard presenter controls, timers, and slide navigation guides hidden
from public view.

Q47. Which panel is used to customize the exact entry, emphasis, exit, or pathway motion of
individual slide elements?
A) Transition Effects Menu
B) Animation Pane
C) Design Ideas Engine
D) Slide Master Layout Panel
Correct Answer: B) Animation Pane
Explanation: The Animation Pane manages timing triggers, visual effects delays, speed values, and sequence
order of elements on a slide.
Q48. What keyboard shortcut is used to replicate an active object or dynamic layout slide instantly
without using copy and paste?
A) Ctrl + D
B) Ctrl + R
C) Alt + D
D) Ctrl + Shift + C
Correct Answer: A) Ctrl + D
Explanation: Ctrl + D ('Duplicate') creates an identical copy of selected elements (or whole slides) and matches
structural offset spacing.

Q49. Which tool dynamically suggests automated, professional slide design layouts and image-text
configurations based on your slide content?
A) Quick Styles Panel
B) Designer (Design Ideas)
C) Theme Generator
D) SmartArt Converter
Correct Answer: B) Designer (Design Ideas)
Explanation: PowerPoint Designer analyzes text and imagery inputs to generate polished, modern alternative
layouts instantly.

Q50. Which shortcut key activates the standard on-screen Laser Pointer during an active Slide Show?
A) Ctrl + P
B) Ctrl + L
C) Ctrl + Mouse Left Click
D) Shift + P
Correct Answer: C) Ctrl + Mouse Left Click
Explanation: Holding Ctrl and left-clicking/dragging your mouse turns your cursor into a clean virtual laser pointer
to guide audience focus.

Q51. Which option allows a presentation to continuously loop back to Slide 1 after the final slide
finishes playing?
A) Slide Sorter Options
B) Slide Show > Set Up Slide Show > Loop continuously until 'Esc'
C) Transitions > Duration Auto-Cycle
D) Master Slide settings
Correct Answer: B) Slide Show > Set Up Slide Show > Loop continuously until 'Esc'
Explanation: This is crucial for self-running trade-show kiosks, allowing endless visual cycling of marketing assets.