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 56 of 60
Question #1101
In Excel, the function =CHOOSE(2, "Red", "Green", "Blue") returns:
A. Error
B. Green
C. Red
D. Blue
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CHOOSE returns the 2nd value: Green.
This question belongs to: Computer Microsoft Office
Question #1102
In MS Word, to change the case of selected text to toggle case (e.g., fROM tHIS), press:
A. Shift + F3 (repeatedly)
B. Ctrl + Shift + A
C. F3
D. Ctrl + Shift + K
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shift+F3 cycles through case options.
This question belongs to: Computer Microsoft Office
Question #1103
In PowerPoint, which feature automatically adjusts the size of text to fit within a placeholder?
A. Both A and B
B. Shrink text on overflow
C. AutoFit
D. Text Scaling
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AutoFit options: Shrink text on overflow, Resize shape to fit text.
This question belongs to: Computer Microsoft Office
Question #1104
In MS Access, to create a report with grouping and subtotals, use:
A. Report Wizard
B. Chart Wizard
C. Label Wizard
D. Blank Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Report Wizard allows grouping and summary options.
This question belongs to: Computer Microsoft Office
Question #1105
Which shortcut is used to increase the font size in MS Excel?
A. Ctrl + >
B. Ctrl + Shift + > (or Ctrl + ])
C. Ctrl + Shift + .
D. Alt + >
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Same as Word, Ctrl+Shift+> or Ctrl+].
This question belongs to: Computer Microsoft Office
Question #1106
In MS Word, the 'Navigation Pane' can be used to:
A. Search and navigate by headings, pages, and results
B. Browse files
C. Insert hyperlinks
D. Change document theme
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Navigation Pane (Ctrl+F) shows headings and search.
This question belongs to: Computer Microsoft Office
Question #1107
In PowerPoint, what is the purpose of the 'Slide Show' tab?
A. To insert media
B. To set up and control slide show settings, rehearsals, and monitors
C. To review spelling
D. To design slides
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Show tab manages presentation delivery.
This question belongs to: Computer Microsoft Office
Question #1108
In MS Access, the 'Indexed' property set to 'Yes (No Duplicates)' creates:
A. A foreign key
B. A unique index, preventing duplicate values
C. An index allowing duplicates
D. A primary key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
No Duplicates enforces uniqueness.
This question belongs to: Computer Microsoft Office
Question #1109
Which of the following is NOT a valid type of section break in MS Word?
A. Same Page
B. Odd Page
C. Next Page
D. Even Page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Section break types: Next Page, Continuous, Even Page, Odd Page.
This question belongs to: Computer Microsoft Office
Question #1110
In Excel, which function converts a value to text with a specified number format?
A. FORMAT()
B. DOLLAR()
C. VALUE()
D. TEXT()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
TEXT(value, format_text) converts to text.
This question belongs to: Computer Microsoft Office
Question #1111
In MS Word, what does a red wavy underline indicate?
A. Spelling mistake
B. Formatting inconsistency
C. Repeated word
D. Grammar error
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Red wavy line is spelling.
This question belongs to: Computer Microsoft Office
Question #1112
In PowerPoint, the 'Handout Master' can be accessed from which tab?
A. View
B. Insert
C. Slide Show
D. Design
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Handout Master is under View tab.
This question belongs to: Computer Microsoft Office
Question #1113
In MS Access, which data type is used for long text (up to 1 GB) and formatted text?
A. Long Text
B. Short Text
C. Memo
D. Attachment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Long Text (formerly Memo) can hold large amounts of text.
This question belongs to: Computer Microsoft Office
Question #1114
The shortcut to open the 'Page Setup' dialog in MS Excel is:
A. Ctrl + P
B. F12
C. Alt + P, S, P (or Page Layout tab)
D. Ctrl + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.
This question belongs to: Computer Microsoft Office
Question #1115
In Excel, which tab contains the 'Page Setup' group?
A. Data
B. View
C. Insert
D. Page Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Page Layout tab has Page Setup.
This question belongs to: Computer Microsoft Office
Question #1116
In MS Word, the 'Ctrl + Alt + H' shortcut applies:
A. Hidden text
B. Hyperlink
C. Highlighting
D. Heading style
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Alt+H applies highlight.
This question belongs to: Computer Microsoft Office
Question #1117
In PowerPoint, the 'Animations' tab contains:
A. Entrance, Emphasis, Exit, Motion Paths
B. Chart animations
C. Transitions and timings
D. Slide layouts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Animations tab for object animations.
This question belongs to: Computer Microsoft Office
Question #1118
In MS Access, to create a blank desktop database, you start with:
A. Create -> Blank Database
B. File -> New -> Blank desktop database
C. Home -> New
D. Open -> New
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Use File > New.
This question belongs to: Computer Microsoft Office
Question #1119
Which of the following is the correct way to exit MS Word?
A. Ctrl + Q
B. File -> Close
C. Alt + F4
D. Ctrl + F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt+F4 exits the application. Ctrl+F4 closes document.
This question belongs to: Computer Microsoft Office
Question #1120
In Excel, the error '#NULL!' occurs when:
A. You specify an intersection of two areas that don't intersect
B. Cell reference is invalid
C. Division by zero
D. A formula is not recognized
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
#NULL! means no intersection when using space operator.
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
Computer Software 347 CPU (Central Processing Unit) 327 Memory and Storage Devices 438 Programming Languages 0 Cyber Security 269
Explore Subjects
Computer 5279 History GK 3374 Maths 5575 Accountancy and Statistics 3179 Current Affairs 575
Practice Mix
Find the word most OPPOSITE in meaning to 'OPAQUE'.
Which organization focuses on protecting global biological diversity?
Which of these is the most recently formed national park in India among the options provided?
A mixture of two immiscible liquids can be separated by:
The 'Gol Gumbaz' in Bijapur has a whispering gallery. This architectural feature is an example of: