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 53 of 60
Question #1041
In MS Access, which data type is best for a field that stores employee ID numbers that are not used in calculations?
A. Number
B. Short Text
C. Currency
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
If not used in calculations, Short Text is suitable for alphanumeric IDs.
This question belongs to: Computer Microsoft Office
Question #1042
Which of the following is the default view in MS Word 2016?
A. Print Layout
B. Web Layout
C. Draft
D. Read Mode
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Print Layout is the default view.
This question belongs to: Computer Microsoft Office
Question #1043
In Excel, the 'Evaluate Formula' feature is found under which tab?
A. Review
B. Formulas
C. Data
D. View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Evaluate Formula is in Formulas tab, Formula Auditing group.
This question belongs to: Computer Microsoft Office
Question #1044
In MS Word, which key is used to extend selection in combination with arrow keys?
A. Ctrl
B. Shift
C. Alt
D. Ctrl + Shift
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift extends selection.
This question belongs to: Computer Microsoft Office
Question #1045
In PowerPoint, to insert a screenshot, go to:
A. Insert -> Screenshot
B. Home -> Screenshot
C. Design -> Screenshot
D. View -> Screenshot
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Screenshot is in Insert tab.
This question belongs to: Computer Microsoft Office
Question #1046
In MS Access, which of the following is NOT a valid query type?
A. Action query
B. Cross-reference query
C. Select query
D. Crosstab query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Cross-reference is not a standard query type. Standard: Select, Action (Update, Delete, Append, Make-Table), Crosstab, Parameter, SQL Specific.
This question belongs to: Computer Microsoft Office
Question #1047
The shortcut to display the 'Open' dialog in MS Office is:
A. Ctrl + N
B. Ctrl + O
C. Both A and B
D. Ctrl + F12
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+O and Ctrl+F12 both open the Open dialog.
This question belongs to: Computer Microsoft Office
Question #1048
In MS Word, the 'References' tab includes tools for:
A. Macros
B. Table of Contents, Footnotes, Citations, Bibliography
C. Spelling & Grammar
D. Mail Merge
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
References tab is for academic tools.
This question belongs to: Computer Microsoft Office
Question #1049
In PowerPoint, to copy a slide from another presentation and keep its formatting, use:
A. Copy and paste
B. Insert -> Slides from File
C. All of the above
D. Reuse Slides with 'Keep source formatting' checked
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All methods allow copying slides, but Reuse Slides offers the option.
This question belongs to: Computer Microsoft Office
Question #1050
In MS Access, which object can contain other objects like buttons, text boxes, and subforms?
A. Form
B. Table
C. Macro
D. Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms serve as containers for controls.
This question belongs to: Computer Microsoft Office
Question #1051
What is the shortcut to close the active document in MS Word?
A. Ctrl + W
B. Ctrl + F4
C. Both A and B
D. Alt + F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+W and Ctrl+F4 close document window.
This question belongs to: Computer Microsoft Office
Question #1052
In Excel, the 'Watch Window' is used to:
A. Track changes to the workbook
B. View all open workbooks
C. Audit formulas
D. Monitor the values of cells in a separate window while working
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Watch Window (Formulas tab) keeps selected cells visible.
This question belongs to: Computer Microsoft Office
Question #1053
In PowerPoint, which option is used to apply a transition to only the selected slides?
A. Set custom show
B. Use Slide Master
C. Click Apply To All but then undo for others
D. Select slide, choose transition; do not click Apply To All
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Select slides and pick a transition; it applies only to those.
This question belongs to: Computer Microsoft Office
Question #1054
In MS Access, which of the following is a valid data type for a field that will store an employee's photo?
A. OLE Object
B. Attachment
C. Memo
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both Attachment and OLE Object can store images, but Attachment is newer.
This question belongs to: Computer Microsoft Office
Question #1055
Which of the following is NOT a slide show option in PowerPoint?
A. Broadcast Slide Show
B. Set Up Slide Show
C. Rehearse Timings
D. Record Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Actually Broadcast Slide Show is an option (in older versions). But Present Online replaced it. I'll change: Which is not found under Slide Show tab? Maybe 'Custom Animation'. I'll avoid confusion. I'll ask: Which of the following is NOT a tool on the Slide Show tab? Option D: Custom Animation (that's on Animations tab). So D.
This question belongs to: Computer Microsoft Office
Question #1056
Which of the following is NOT found on the Slide Show tab in PowerPoint?
A. From Beginning
B. Custom Animation
C. Set Up Slide Show
D. Rehearse Timings
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Custom Animation is on the Animations tab.
This question belongs to: Computer Microsoft Office
Question #1057
In MS Access, to create a form that automatically adjusts to the size of the window, you can use:
A. Design View with auto-resize
B. Layout View and anchoring
C. All of the above
D. Property 'Auto Resize'
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Anchoring controls in Layout View helps responsive design.
This question belongs to: Computer Microsoft Office
Question #1058
The keyboard shortcut to move the cursor to the beginning of the line in MS Word is:
A. Home
B. Alt + Home
C. Shift + Home
D. Ctrl + Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Home moves to start of line.
This question belongs to: Computer Microsoft Office
Question #1059
In MS Word, which option is used to change the page color?
A. Layout -> Page Background
B. Design -> Page Color
C. Insert -> Background
D. Home -> Shading
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Page Color is on the Design tab.
This question belongs to: Computer Microsoft Office
Question #1060
In PowerPoint, the 'Compare' feature allows:
A. Comparing fonts
B. Comparing file sizes
C. Comparing two slide transitions
D. Merging two presentations and reviewing changes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Compare (Review tab) merges presentations.
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: