Microsoft Office MCQs
Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.
Question #1
Report Error
In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula?
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.
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?
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.
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?
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.
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?
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.
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?
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.
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?
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.
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?
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.
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?
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.
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?
Correct Answer: Option C
Explanation:
Ctrl + E is the standard keyboard shortcut used to center-align the selected text or paragraph in MS Word.
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?
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.
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
