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
Question #1 Report Error
In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula?
A. F4
B. F2
C. F11
D. F8

Correct Answer: Option A


Explanation:
Pressing the F4 key while editing a cell reference in an Excel formula toggles through absolute ($A$1), mixed (A$1, $A1), and relative (A1) references.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS PowerPoint, which view allows you to see all the slides in a presentation as thumbnails arranged in horizontal rows for easy reordering?
A. Presenter View
B. Reading View
C. Slide Sorter View
D. Outline View

Correct Answer: Option C


Explanation:
Slide Sorter View displays all slides in the presentation as miniature thumbnails, allowing users to easily reorder, delete, or organize slides into sections.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which of the following database objects in MS Access is primarily designed to securely look up, enter, or modify data in a table through a user-friendly layout?
A. Form
B. Macro
C. Report
D. Query

Correct Answer: Option A


Explanation:
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.

This question belongs to: Computer Microsoft Office
Question #4 Report Error
What is the key combination used to insert a mandatory page break manually in MS Word?
A. Ctrl + Enter
B. Shift + Enter
C. Alt + Enter
D. Ctrl + Shift + Enter

Correct Answer: Option A


Explanation:
Ctrl + Enter inserts a hard or manual page break at the cursor position in MS Word, while Shift + Enter inserts a soft line break.

This question belongs to: Computer Microsoft Office
Question #5 Report Error
Which transition or animation effect property in MS PowerPoint allows an animation to start at the exact same time as the previous animation item?
A. After Previous
B. With Previous
C. Trigger
D. On Click

Correct Answer: Option B


Explanation:
The 'With Previous' setting starts the selected animation effect simultaneously with the animation immediately preceding it on the slide timeline.

This question belongs to: Computer Microsoft Office
Question #6 Report Error
In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?
A. Short Text
B. OLE Object
C. Long Text
D. Hyperlink

Correct Answer: Option C


Explanation:
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, whereas 'Short Text' is capped at 255 characters.

This question belongs to: Computer Microsoft Office
Question #7 Report Error
What is the function of the shortcut key combination Ctrl + Shift + G in MS Word?
A. Activates the Research pane
B. Opens the Word Count dialog box
C. Toggles between uppercase and lowercase text
D. Inserts a hyperlink

Correct Answer: Option B


Explanation:
Ctrl + Shift + G directly opens the Word Count statistics dialog box in MS Word, providing details like pages, words, characters, and paragraphs.

This question belongs to: Computer Microsoft Office
Question #8 Report Error
Which feature in MS PowerPoint allows you to pick specific slides from a larger presentation file to build an alternative sequence without modifying the original slides?
A. Rehearsed Timings
B. Custom Slide Show
C. Broadcast Slide Show
D. Slide Master

Correct Answer: Option B


Explanation:
A Custom Slide Show lets you select specific slides from your current presentation file and arrange them into a separate tailored sequence for a specific audience.

This question belongs to: Computer Microsoft Office
Question #9 Report Error
What happens when you select a block of text in MS Word and press the 'Ctrl + E' shortcut?
A. The text is left-aligned
B. The text is justified
C. The text is centered
D. The text is right-aligned

Correct Answer: Option C


Explanation:
Ctrl + E is the standard keyboard shortcut used to center-align the selected text or paragraph in MS Word.

This question belongs to: Computer Microsoft Office
Question #10 Report Error
Which function in MS Excel counts the number of cells in a specified range that contain numerical data only?
A. COUNTIF
B. COUNT
C. COUNTBLANK
D. COUNTA

Correct Answer: Option B


Explanation:
The COUNT function counts cells containing numbers only. COUNTA counts all non-empty cells regardless of data type, and COUNTBLANK counts empty cells.

This question belongs to: Computer Microsoft Office