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 D
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 B
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 B
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 D
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 C
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 C
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 B
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 A
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
Question #31
Report Error
Which section of the MS Word status bar shows real-time page metrics, word counts, and proofing status?
Correct Answer: Option A
Explanation:
The Status Bar located at the very bottom of the window displays document metrics such as total page count, active page, word count, language, and zoom sliders.
The Status Bar located at the very bottom of the window displays document metrics such as total page count, active page, word count, language, and zoom sliders.
This question belongs to:
Computer
Microsoft Office
Question #32
Report Error
What error message is displayed in MS Excel when a cell contains a numeric formula that references its own cell address directly or indirectly?
Correct Answer: Option A
Explanation:
When a formula references its own cell address, it creates a 'Circular Reference', prompting an alert window because the formula recalculates infinitely.
When a formula references its own cell address, it creates a 'Circular Reference', prompting an alert window because the formula recalculates infinitely.
This question belongs to:
Computer
Microsoft Office
Question #33
Report Error
Which tool in MS Word allows you to track and log every deletion, insertion, formatting adjustment, or comment made within a shared document?
Correct Answer: Option B
Explanation:
Track Changes records every edit or modification made to a document, allowing other reviewers to see changes, accept them, or reject them later.
Track Changes records every edit or modification made to a document, allowing other reviewers to see changes, accept them, or reject them later.
This question belongs to:
Computer
Microsoft Office
Question #34
Report Error
In MS Excel, what does the error code '#NAME?' typically signify?
Correct Answer: Option B
Explanation:
The #NAME? error occurs when Excel fails to recognize text inside a formula, such as misspelling a function name (e.g., writing =SUUM(A1:A5) instead of =SUM(A1:A5)).
The #NAME? error occurs when Excel fails to recognize text inside a formula, such as misspelling a function name (e.g., writing =SUUM(A1:A5) instead of =SUM(A1:A5)).
This question belongs to:
Computer
Microsoft Office
Question #35
Report Error
Which specialized tool in MS PowerPoint allows an author to record precise rehearsal durations for each slide to ensure an automated slide show runs smoothly?
Correct Answer: Option A
Explanation:
Rehearse Timings allows you to run through your presentation and log the length of time spent on each slide, saving those parameters to automate presentation delivery.
Rehearse Timings allows you to run through your presentation and log the length of time spent on each slide, saving those parameters to automate presentation delivery.
This question belongs to:
Computer
Microsoft Office
Question #36
Report Error
In MS Access, a column within a datasheet view or table template is strictly referred to as a:
Correct Answer: Option C
Explanation:
In database contexts like MS Access, columns are called Fields (representing data attributes), while rows are called Records or Tuples.
In database contexts like MS Access, columns are called Fields (representing data attributes), while rows are called Records or Tuples.
This question belongs to:
Computer
Microsoft Office
Question #37
Report Error
What is the function of the keyboard shortcut 'Ctrl + D' when a shape, text box, or slide is selected in MS PowerPoint?
Correct Answer: Option A
Explanation:
Ctrl + D acts as a shortcut to quickly duplicate any selected object, shape, text box, or active slide layout within PowerPoint.
Ctrl + D acts as a shortcut to quickly duplicate any selected object, shape, text box, or active slide layout within PowerPoint.
This question belongs to:
Computer
Microsoft Office
Question #38
Report Error
In MS Word 2016 and later, what is the default keyboard shortcut to clear all text formatting from a selected block of text?
Correct Answer: Option B
Explanation:
Pressing Ctrl + Spacebar removes all character-level formatting (such as font style, size, or color) from the selected text, resetting it to the default paragraph style.
Pressing Ctrl + Spacebar removes all character-level formatting (such as font style, size, or color) from the selected text, resetting it to the default paragraph style.
This question belongs to:
Computer
Microsoft Office
Question #39
Report Error
Which of the following functions in MS Excel is used to find the relative position of a specified item within a given range of cells?
Correct Answer: Option C
Explanation:
The MATCH function searches for a specified value in a cell range and returns the relative row or column position of that item.
The MATCH function searches for a specified value in a cell range and returns the relative row or column position of that item.
This question belongs to:
Computer
Microsoft Office
Question #40
Report Error
In MS PowerPoint, what is the shortcut key combination used to insert a brand new hyperlink on a selected object or text string?
Correct Answer: Option C
Explanation:
Ctrl + K opens the Insert Hyperlink dialog box across MS Word, Excel, and PowerPoint.
Ctrl + K opens the Insert Hyperlink dialog box across MS Word, Excel, and PowerPoint.
This question belongs to:
Computer
Microsoft Office
