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 20 of 60
Question #381
In Word, which of the following is used to create a watermark?
A. Insert > Watermark
B. Page Layout > Watermark
C. Review > Watermark
D. Design > Watermark
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Watermark is under the Design tab (or Page Layout in older).
This question belongs to: Computer Microsoft Office
Question #382
In Access, which of the following is used to create a relationship between tables?
A. Create > Relationships
B. External Data > Relationships
C. Home > Relationships
D. Database Tools > Relationships
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Relationships are managed from the Database Tools tab.
This question belongs to: Computer Microsoft Office
Question #383
In Excel, which function is used to calculate the probability of a given z-score?
A. NORM.S.DIST
B. PROB
C. NORM.DIST
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NORM.DIST and NORM.S.DIST both calculate normal distribution probabilities (standard and non-standard).
This question belongs to: Computer Microsoft Office
Question #384
In MS PowerPoint, which option is used to insert a video from a file?
A. Both A and B
B. Insert > Media > Video
C. Insert > Video > This Device
D. Insert > Object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can insert video from file via Insert > Video > This Device (or Similar).
This question belongs to: Computer Microsoft Office
Question #385
In Access, which of the following is a valid query that updates data?
A. Append Query
B. Update Query
C. All of the above
D. Delete Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Update, Append, and Delete are all action queries that modify data.
This question belongs to: Computer Microsoft Office
Question #386
What is the shortcut key to select all content in MS Office?
A. Ctrl + E
B. Ctrl + A
C. Ctrl + Shift + A
D. Alt + A
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+A selects all.
This question belongs to: Computer Microsoft Office
Question #387
In Excel, which function is used to calculate the future value of a lump sum?
A. PV
B. FV
C. NPER
D. PMT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
FV can calculate future value of a lump sum (if PMT=0).
This question belongs to: Computer Microsoft Office
Question #388
In MS PowerPoint, which view is used to see all slides as thumbnails?
A. Outline View
B. Reading View
C. Normal View
D. Slide Sorter View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Sorter shows thumbnails.
This question belongs to: Computer Microsoft Office
Question #389
In Word, which of the following is used to insert a symbol?
A. Home > Symbol
B. Insert > Advanced Symbol
C. Insert > Symbol
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Insert > Symbol and Insert > Advanced Symbol are similar.
This question belongs to: Computer Microsoft Office
Question #390
In Access, which of the following is used to create a form with subforms?
A. Form Design
B. Create > Form
C. Form Wizard
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can create subforms using wizard or design.
This question belongs to: Computer Microsoft Office
Question #391
What is the shortcut key to open the 'Page Layout' dialog in MS Excel?
A. Alt + P, S, P
B. Ctrl + P
C. F5
D. Ctrl + Shift + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+P,S,P opens Page Setup in Excel.
This question belongs to: Computer Microsoft Office
Question #392
In MS PowerPoint, which option is used to create a custom slideshow?
A. Design > Custom Show
B. Transitions > Custom Show
C. Slide Show > Custom Slide Show
D. View > Custom Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Custom Slide Show is under the Slide Show tab.
This question belongs to: Computer Microsoft Office
Question #393
In Word, which of the following is used to add a table of figures?
A. Review > Table of Figures
B. Insert > Table of Figures
C. View > Table of Figures
D. References > Insert Table of Figures
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Table of Figures is under References.
This question belongs to: Computer Microsoft Office
Question #394
In Access, which of the following is a valid field property for a text field?
A. Field Size
B. Caption
C. Format
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are properties of a text field.
This question belongs to: Computer Microsoft Office
Question #395
What is the shortcut key to paste without formatting in MS Office?
A. Alt + E, S, V
B. Ctrl + Shift + V
C. Both B and C
D. Ctrl + Alt + V
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Alt+V opens Paste Special, then you can choose unformatted text. Alt+E,S,V also does that. Ctrl+Shift+V is not standard in Office (it works in some non-Office apps).
This question belongs to: Computer Microsoft Office
Question #396
In Excel, which function is used to return the current time?
A. =TODAY()
B. =TIME()
C. =NOW()
D. =CURRENTTIME()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NOW() returns date and time. TIME() creates a time from given hours, minutes, seconds. There is no CURRENTTIME.
This question belongs to: Computer Microsoft Office
Question #397
In MS PowerPoint, which option is used to add a footnote to a slide?
A. Insert > Header & Footer
B. Insert > Footnote
C. View > Footnote
D. Review > Footnote
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Footnotes in PowerPoint are added via Header & Footer (then Footer tab). There is no specific Footnote command.
This question belongs to: Computer Microsoft Office
Question #398
In Word, which of the following is used to change the case of selected text?
A. Home > Change Case
B. Review > Change Case
C. Insert > Change Case
D. Format > Change Case
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Change Case is in the Home tab, Font group.
This question belongs to: Computer Microsoft Office
Question #399
In Access, which of the following is used to run a macro?
A. Run button in Macro Design
B. Both A and B
C. Create > Run Macro
D. Double-click macro in Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can run a macro by double-clicking it or using the Run button in Design view.
This question belongs to: Computer Microsoft Office
Question #400
What is the shortcut key to open the 'Find and Replace' dialog in MS Word with the Go To tab active?
A. Ctrl + H
B. Ctrl + G
C. F5
D. Both A and C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+G and F5 both open the Go To tab of Find and Replace.
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?'