Microsoft Office MCQs

Computer

Microsoft Office MCQs

Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.

1199
Total Questions

Practice Questions

Page 2 of 60
Question #21
In MS Excel, what type of chart is ideal for showing the relative proportional contribution of components to a singular total whole sum?
A. Line Chart
B. Bar Chart
C. Pie Chart
D. Scatter Plot
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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.
This question belongs to: Computer Microsoft Office
Question #22
Which of the following views in MS Word shows the document layout exactly as it will appear when printed on physical hardcopy sheets?
A. Outline View
B. Draft View
C. Print Layout
D. Web Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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.
This question belongs to: Computer Microsoft Office
Question #23
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?
A. Animation Painter
B. Format Painter
C. Style Manager
D. Design Template
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #24
What is the shortcut key used to insert a hyperlink into a selected cell or text across most MS Office programs?
A. Ctrl + K
B. Ctrl + L
C. Ctrl + H
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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
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?
A. Update Query
B. Append Query
C. Delete Query
D. Make-Table Query
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #26
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?
A. VLOOKUP
B. LOOKUP
C. HLOOKUP
D. MATCH
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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.
This question belongs to: Computer Microsoft Office
Question #27
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:
A. Form Tracking
B. Document Fusion
C. Mail Merge
D. Data Merging
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #28
What happens when you select a cell in MS Excel and press 'Ctrl + ;' (Control + Semicolon)?
A. The current system time is inserted
B. The cell formulas are hidden
C. The column is completely deleted
D. The current system date is inserted
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
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
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?
A. Theme Styling
B. Cell Styles
C. AutoFormat
D. Conditional Formatting
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #30
In MS PowerPoint, what is the action or function of the shortcut 'Ctrl + M'?
A. Minimizes the interface
B. Opens a new window
C. Saves the file
D. Inserts a new blank slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
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
Which section of the MS Word status bar shows real-time page metrics, word counts, and proofing status?
A. The Status Bar
B. The Ribbon
C. The Title Bar
D. The Quick Access Layout
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #32
What error message is displayed in MS Excel when a cell contains a numeric formula that references its own cell address directly or indirectly?
A. Circular Reference Warning
B. #NAME?
C. #REF!
D. #VALUE!
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #33
Which tool in MS Word allows you to track and log every deletion, insertion, formatting adjustment, or comment made within a shared document?
A. Track Changes
B. AutoCorrect
C. Compare Documents
D. Document Inspector
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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
In MS Excel, what does the error code '#NAME?' typically signify?
A. A cell is too narrow to display the output digits
B. A data type mismatch occurred inside a mathematical function
C. Excel does not recognize text within a formula name or function
D. The formula contains an invalid mathematical divisor
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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)).
This question belongs to: Computer Microsoft Office
Question #35
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?
A. Animation Painter
B. Rehearse Timings
C. Slide Master
D. Set Up Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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.
This question belongs to: Computer Microsoft Office
Question #36
In MS Access, a column within a datasheet view or table template is strictly referred to as a:
A. Field
B. Record
C. Entity
D. Tuple
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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
What is the function of the keyboard shortcut 'Ctrl + D' when a shape, text box, or slide is selected in MS PowerPoint?
A. Centers the alignment
B. Downloads the item
C. Deletes the item
D. Duplicates the item
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
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
In MS Word 2016 and later, what is the default keyboard shortcut to clear all text formatting from a selected block of text?
A. Ctrl + Shift + C
B. Alt + Spacebar
C. Ctrl + Shift + F
D. Ctrl + Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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.
This question belongs to: Computer Microsoft Office
Question #39
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?
A. OFFSET
B. MATCH
C. VLOOKUP
D. INDEX
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
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
In MS PowerPoint, what is the shortcut key combination used to insert a brand new hyperlink on a selected object or text string?
A. Ctrl + K
B. Ctrl + H
C. Ctrl + M
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + K opens the Insert Hyperlink dialog box across MS Word, Excel, and PowerPoint.
This question belongs to: Computer Microsoft Office

More Computer Topics

Computer Abbreviations MCQs
Computer Fundamentals MCQs
Computer Hardware MCQs
Computer Networking MCQs
Computer Software MCQs
CPU (Central Processing Unit) MCQs
Cyber Security MCQs
Database Management System (DBMS) MCQs
Internet and Web Technologies MCQs
Memory and Storage Devices MCQs
Operating Systems MCQs
Programming Languages MCQs
Today's Top Topics
Microsoft Office 1199 Memory and Storage Devices 438 Internet and Web Technologies 461 Database Management System (DBMS) 278 Computer Networking 325
Explore Subjects
Current Affairs 575 Maths 5575 Static General Knowledge 6362 Economy GK 2220 Geography GK 6121
Practice Mix
She ___ a great singer.
Which national park in Madhya Pradesh has the 'Mandla Plant Fossils'?
Who was the first woman to command a space mission?
In a school, 60% are boys and 40% are girls. 20% of boys and 25% of girls get scholarship. What percent of students do not get scholarship?
Which of the following is a characteristic of 'Reference-Dependent Preferences'?