Microsoft Office MCQs
Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.
Question #21
Report Error
In MS Excel, what type of chart is ideal for showing the relative proportional contribution of components to a singular total whole sum?
Correct Answer: Option D
Explanation:
Pie charts represent data as proportional slices of a circle, which makes them highly effective for showing percentages or parts of a single whole.
Pie charts represent data as proportional slices of a circle, which makes them highly effective for showing percentages or parts of a single whole.
This question belongs to:
Computer
Microsoft Office
Question #22
Report Error
Which of the following views in MS Word shows the document layout exactly as it will appear when printed on physical hardcopy sheets?
Correct Answer: Option B
Explanation:
Print Layout view shows how elements like headers, footers, margins, images, and text look on the page exactly as it would look printed on paper.
Print Layout view shows how elements like headers, footers, margins, images, and text look on the page exactly as it would look printed on paper.
This question belongs to:
Computer
Microsoft Office
Question #23
Report Error
In MS PowerPoint, which feature can be used to copy all standard formatting, animations, colors, and styling from one object and apply it to another?
Correct Answer: Option A
Explanation:
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.
This question belongs to:
Computer
Microsoft Office
Question #24
Report Error
What is the shortcut key used to insert a hyperlink into a selected cell or text across most MS Office programs?
Correct Answer: Option C
Explanation:
The standard keyboard shortcut to insert or edit a hyperlink in Microsoft applications like Word, Excel, and PowerPoint is Ctrl + K.
The standard keyboard shortcut to insert or edit a hyperlink in Microsoft applications like Word, Excel, and PowerPoint is Ctrl + K.
This question belongs to:
Computer
Microsoft Office
Question #25
Report Error
In MS Access, which query type can be executed to add brand new rows of records from an external source or table directly into an existing table?
Correct Answer: Option B
Explanation:
An Append Query selects records from one or more data sources and adds them to the end of an existing target table.
An Append Query selects records from one or more data sources and adds them to the end of an existing target table.
This question belongs to:
Computer
Microsoft Office
Question #26
Report Error
Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?
Correct Answer: Option D
Explanation:
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
This question belongs to:
Computer
Microsoft Office
Question #27
Report Error
In MS Word, the process of combining a standardized template letter document with a separate structured recipient list database to generate personalized mail is called:
Correct Answer: Option D
Explanation:
Mail Merge is a powerful feature in MS Word used to bulk-generate personalized mass documents, letters, or labels from a single structured data source.
Mail Merge is a powerful feature in MS Word used to bulk-generate personalized mass documents, letters, or labels from a single structured data source.
This question belongs to:
Computer
Microsoft Office
Question #28
Report Error
What happens when you select a cell in MS Excel and press 'Ctrl + ;' (Control + Semicolon)?
Correct Answer: Option A
Explanation:
Ctrl + ; inserts the current system date into the cell, whereas Ctrl + Shift + : (Colon) inserts the current system time.
Ctrl + ; inserts the current system date into the cell, whereas Ctrl + Shift + : (Colon) inserts the current system time.
This question belongs to:
Computer
Microsoft Office
Question #29
Report Error
Which of the following allows you to apply conditional color-coding, data bars, or icons to cells in MS Excel based directly on the numerical value they hold?
Correct Answer: Option D
Explanation:
Conditional Formatting changes the visual presentation of cells (fill colors, borders, icons) dynamically based on specific conditions or values matching rules.
Conditional Formatting changes the visual presentation of cells (fill colors, borders, icons) dynamically based on specific conditions or values matching rules.
This question belongs to:
Computer
Microsoft Office
Question #30
Report Error
In MS PowerPoint, what is the action or function of the shortcut 'Ctrl + M'?
Correct Answer: Option B
Explanation:
In MS PowerPoint, Ctrl + M inserts a new slide into the active presentation, while Ctrl + N opens a brand-new blank file.
In MS PowerPoint, Ctrl + M inserts a new slide into the active presentation, while Ctrl + N opens a brand-new blank file.
This question belongs to:
Computer
Microsoft Office
