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 17 of 60
Question #321
What is the shortcut key to open the 'New Comment' in MS Word?
A. Alt + M
B. Ctrl + Shift + M
C. Ctrl + Alt + M
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Alt+M inserts a comment.
This question belongs to: Computer Microsoft Office
Question #322
In Excel, which function is used to count the number of blank cells in a range?
A. COUNTBLANK
B. COUNT
C. COUNTIF
D. COUNTA
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNTBLANK counts empty cells.
This question belongs to: Computer Microsoft Office
Question #323
In MS PowerPoint, which option is used to remove a background from an image?
A. Artistic Effects
B. Compress Pictures
C. Crop
D. Remove Background
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Remove Background is a feature under the Format tab that removes the background from a picture.
This question belongs to: Computer Microsoft Office
Question #324
In MS Word, which of the following is used to create a cross-reference to a numbered item?
A. Bookmark
B. Hyperlink
C. Footnote
D. Cross-reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Cross-reference can refer to numbered items, headings, figures, etc. Hyperlink is for web links, Bookmark marks a location, Footnote adds a note.
This question belongs to: Computer Microsoft Office
Question #325
In Access, which of the following is not a valid object in a database?
A. Form
B. Query
C. Table
D. Slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide is a PowerPoint object, not an Access object.
This question belongs to: Computer Microsoft Office
Question #326
What is the shortcut key to open the 'Spelling' dialog in MS Excel?
A. Shift + F7
B. F7
C. Ctrl + F7
D. Alt + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F7 opens the Spelling dialog in Excel as well as Word.
This question belongs to: Computer Microsoft Office
Question #327
In MS PowerPoint, which of the following is a valid way to duplicate a slide?
A. Home > New Slide > Duplicate Selected Slides
B. All of the above
C. Ctrl + D
D. Right-click > Duplicate Slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All methods can duplicate a slide.
This question belongs to: Computer Microsoft Office
Question #328
In Excel, which function is used to concatenate text strings?
A. All of the above
B. CONCAT
C. TEXTJOIN
D. CONCATENATE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
CONCAT, CONCATENATE, and TEXTJOIN all concatenate text (TEXTJOIN with delimiter).
This question belongs to: Computer Microsoft Office
Question #329
In MS Word, which feature allows you to see the formatting applied to text?
A. Format Painter
B. Thesaurus
C. Styles
D. Reveal Formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reveal Formatting (Shift+F1) shows a task pane displaying all formatting of selected text. Styles show applied style but not all formatting.
This question belongs to: Computer Microsoft Office
Question #330
In Access, what is the purpose of the 'Index' property?
A. To set a default value
B. To create a primary key
C. To enforce uniqueness
D. To speed up searching and sorting on that field
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
An index improves performance for searches and sorts. Primary key automatically creates an index, but Index property can be set for any field.
This question belongs to: Computer Microsoft Office
Question #331
What is the shortcut key to open the 'Open' dialog in MS Office?
A. Ctrl + N
B. Ctrl + P
C. Ctrl + O
D. Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+O opens the Open dialog.
This question belongs to: Computer Microsoft Office
Question #332
In Excel, which function is used to calculate the number of periods for a loan?
A. NPER
B. PMT
C. RATE
D. PV
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
NPER calculates the number of payment periods.
This question belongs to: Computer Microsoft Office
Question #333
In MS PowerPoint, which view allows you to edit the master slide layout?
A. Slide Master View
B. Outline View
C. Slide Sorter View
D. Normal View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Master View is used to edit the slide master and layouts.
This question belongs to: Computer Microsoft Office
Question #334
In MS Word, which of the following is used to add a footnote?
A. References > Insert Footnote
B. View > Footnote
C. Insert > Footnote
D. Review > Footnote
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Footnotes are inserted from the References tab.
This question belongs to: Computer Microsoft Office
Question #335
In Access, which of the following is a valid way to run a query?
A. Double-click the query in the Navigation Pane
B. All of the above
C. Open the query in Datasheet View
D. Run button in Design View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can run a query by double-clicking, opening in Datasheet view, or clicking Run in Design View.
This question belongs to: Computer Microsoft Office
Question #336
What is the shortcut key to add a border to selected text in MS Word?
A. There is no direct shortcut
B. Ctrl + B
C. Ctrl + Shift + B
D. Alt + B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
There is no single shortcut to add a border; you must use the Borders button on the Home tab.
This question belongs to: Computer Microsoft Office
Question #337
In MS PowerPoint, which of the following is a valid animation effect category?
A. All of the above
B. Emphasis
C. Exit
D. Entrance
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Entrance, Emphasis, and Exit are the main animation categories.
This question belongs to: Computer Microsoft Office
Question #338
In MS Word, which of the following is used to create a table of authorities?
A. References > Table of Authorities
B. Insert > Table of Authorities
C. View > Table of Authorities
D. Review > Table of Authorities
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Authorities is in the References tab, used for legal citations.
This question belongs to: Computer Microsoft Office
Question #339
In Access, which of the following is a valid way to import data from an Excel spreadsheet?
A. External Data tab > Excel
B. Create > Import Excel
C. File > Open > Excel
D. Home > Import
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The External Data tab has options to import from Excel. File > Open opens Access databases, not import.
This question belongs to: Computer Microsoft Office
Question #340
What is the shortcut key to redo an action in MS Office?
A. Ctrl + Y
B. Ctrl + Z
C. Ctrl + Shift + Z
D. Alt + Shift + Backspace
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Y is redo. Ctrl+Z is undo. Ctrl+Shift+Z sometimes also redo but standard is Ctrl+Y.
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?'