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 6 of 60
Question #101
Which of the following functions in MS Excel checks whether a cell value is text and returns TRUE or FALSE?
A. CHECKTEXT
B. ISTEXT
C. ISBLANK
D. ISNUMBER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
ISTEXT is a built-in logical informational function that returns TRUE if the evaluated field holds alphanumeric text string structures.
This question belongs to: Computer Microsoft Office
Question #102
What is the default line spacing configuration applied to a standard new document layout in MS Word 2016 and modern editions?
A. 1.15 lines
B. 2.0 lines
C. 1.5 lines
D. 1.0 lines
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Modern versions of MS Word use a default paragraph line spacing configuration of 1.15 lines, with 8 points of spacing added after paragraphs.
This question belongs to: Computer Microsoft Office
Question #103
In MS Word, what shortcut key combination inserts a small superscript index character format slightly above the baseline text level?
A. Ctrl + =
B. Ctrl + Alt + S
C. Alt + Shift + P
D. Ctrl + Shift + +
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + Plus Sign (+) converts selected characters into superscript formatting. Ctrl + Equal Sign (=) applies subscript formatting.
This question belongs to: Computer Microsoft Office
Question #104
Which presentation view displays an adjustable multi-level textual list of slide contents for quick editing in MS PowerPoint?
A. Reading Layout Mode
B. Notes Page Layout
C. Outline View
D. Slide Sorter View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Outline View isolates the text hierarchy from layout graphics, enabling rapid edits to presentation titles and bullet points.
This question belongs to: Computer Microsoft Office
Question #105
In MS Access, what field rule dictates whether a database field can accept or store null values?
A. Default Value option
B. Required property
C. Validation Rule
D. Allow Zero Length setting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When 'Required' is set to 'Yes', the field cannot be left blank or contain a null value when saving records.
This question belongs to: Computer Microsoft Office
Question #106
What is the shortcut key used to display the traditional 'Save As' file dialog window directly in MS Word and Excel?
A. F12
B. Ctrl + S
C. Shift + F12
D. Alt + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under alternative names, extensions, or file directories.
This question belongs to: Computer Microsoft Office
Question #107
Which function in MS Excel counts only the cells that match a specific user-defined condition or logical rule?
A. COUNT
B. COUNTBLANK
C. COUNTIF
D. COUNTA
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COUNTIF counts cells in a range that meet a single criteria argument (e.g., counting cells with values greater than 50).
This question belongs to: Computer Microsoft Office
Question #108
What feature in MS Word allows you to quickly locate and jump to a specific page, section, or line number in a document?
A. Document Map
B. Find tool
C. Go To tool
D. Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Go To' feature (accessed via Ctrl + G) lets you jump directly to specific pages, section markers, bookmarks, or line positions.
This question belongs to: Computer Microsoft Office
Question #109
Which of the following features in MS PowerPoint lets you bundle multiple distinct design elements (shapes, images, text) into a single object container?
A. Selection Canvas
B. SmartArt Layout
C. Group
D. Merge Shapes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Grouping (Ctrl + G) bundles multiple selected design assets together so they can be moved, scaled, or formatted as a single unit.
This question belongs to: Computer Microsoft Office
Question #110
In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range?
A. Drop Table Query
B. Remove Rows Macro
C. Truncate Action
D. Delete Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Delete Query matches target row entries using defined criteria limits and permanently removes those records from the table database.
This question belongs to: Computer Microsoft Office
Question #111
What is the keyboard shortcut to right-align a selected paragraph or text line in MS Word?
A. Ctrl + E
B. Ctrl + J
C. Ctrl + L
D. Ctrl + R
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + R is the standard shortcut to apply a right-alignment format to selected text blocks in MS Word.
This question belongs to: Computer Microsoft Office
Question #112
Which MS Excel tool lets you import raw text file lines and split them across multiple distinct worksheet columns using a delimiter like a comma or tab?
A. Text to Columns
B. Data Validation
C. Flash Fill
D. Merge Cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns using defined delimiters or fixed character widths.
This question belongs to: Computer Microsoft Office
Question #113
In MS PowerPoint, what type of animation path allows an object to follow a custom-drawn curved track or line across the slide canvas?
A. Motion Path
B. Emphasis Effect curve
C. Entrance Effect track
D. Transition Track
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Motion Paths allow objects to animate along predefined geometrical paths (circles, lines) or custom paths drawn with the mouse.
This question belongs to: Computer Microsoft Office
Question #114
What built-in reference tool in MS Word acts as a dictionary of synonyms to look up alternative word choices for a selected term?
A. Translate Panel
B. Thesaurus
C. Smart Lookup
D. Spell Checker
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Thesaurus tool (accessible via Shift + F7) searches for synonyms and antonyms for a selected word to improve vocabulary choices.
This question belongs to: Computer Microsoft Office
Question #115
Which tab on the ribbon layout houses options to insert footnotes, endnotes, captions, and an automated table of contents in MS Word?
A. Review Tab
B. References Tab
C. Design Tab
D. Insert Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The References tab consolidates all formal academic reference indexing features, including bibliographies, table of contents, and citations.
This question belongs to: Computer Microsoft Office
Question #116
In MS PowerPoint, what key combination is used to quickly sub-group or bundle a set of selected objects together?
A. Alt + G
B. Ctrl + G
C. Ctrl + Alt + G
D. Ctrl + Shift + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + G groups selected objects together. To ungroup them later, the shortcut is Ctrl + Shift + G.
This question belongs to: Computer Microsoft Office
Question #117
What is the primary difference between a 'Save' and 'Save As' command sequence in MS Office programs?
A. 'Save As' can only overwrite data lines on cloud folders.
B. 'Save' updates an existing file; 'Save As' allows you to save the file with a new name, format, or location.
C. There is no difference in modern 2026 software versions.
D. 'Save' completely locks down file text permissions automatically.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Save command saves changes to the current file name. Save As prompts for a new file name, location, or format file extension type.
This question belongs to: Computer Microsoft Office
Question #118
Which of the following line break keyboard shortcuts inserts a soft line break inside a paragraph without starting a brand new paragraph block in MS Word?
A. Ctrl + Shift + Enter
B. Ctrl + Enter
C. Shift + Enter
D. Alt + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shift + Enter drops the cursor down to the next text row line instantly without splitting the active paragraph block structure or applying paragraph spacing rules.
This question belongs to: Computer Microsoft Office
Question #119
Which field type in an MS Access database table is most suitable for storing monetary values and financial transaction amounts to avoid rounding errors?
A. Number
B. Calculated
C. Currency
D. Short Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Currency data type prevents rounding calculations during financial updates, locking precision values up to 4 decimal places.
This question belongs to: Computer Microsoft Office
Question #120
What is the shortcut key configuration used to expand or collapse the entire top menu Ribbon interface bar across MS Office products?
A. Alt + F1
B. Ctrl + Shift + R
C. Ctrl + F2
D. Ctrl + F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + F1 is the universal keyboard shortcut to hide or show the main Ribbon tools layout menu to maximize screen workspace real estate.
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 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'