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 12 of 60
Question #221
In MS Word, which of the following is used to create a template?
A. Save As > Web Page
B. Save As > Word Document
C. Save As > Word Template
D. Save As > PDF
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
To create a template, you choose 'Word Template' from the Save As type list. This saves as .dotx/.dotm.
This question belongs to: Computer Microsoft Office
Question #222
In Excel, what is the result of the formula =LEN(Excel)?
A. 7
B. 6
C. 5
D. 4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LEN returns the number of characters in a text string. Excel has 5 characters.
This question belongs to: Computer Microsoft Office
Question #223
Which tab in MS PowerPoint contains the 'Animation Pane'?
A. Slide Show
B. Insert
C. Animations
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Animation Pane is found on the Animations tab, in the Advanced Animation group.
This question belongs to: Computer Microsoft Office
Question #224
In MS Access, what is the function of a 'Macro'?
A. Creates queries
B. Automates repetitive tasks
C. Stores data
D. Designs forms
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Macros are used to automate tasks and add functionality to forms, reports, and controls. They are not for data storage, query creation, or form design per se.
This question belongs to: Computer Microsoft Office
Question #225
What is the shortcut key to open the 'Page Setup' dialog box in MS Word?
A. Alt + P, S, P
B. F5
C. Ctrl + P
D. Ctrl + Shift + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
There is no single shortcut; you can use Alt+P, S, P (sequential) to open Page Setup. Ctrl+Shift+P opens the Change Case dialog? Actually Ctrl+Shift+P changes font size? Not standard. Ctrl+P is Print. F5 is Go To. So the correct approach is Alt+P, S, P.
This question belongs to: Computer Microsoft Office
Question #226
In Excel, which function is used to multiply numbers?
A. PRODUCT
B. Both B and C
C. *
D. MULTIPLY
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can multiply using the * operator, or the PRODUCT function. MULTIPLY is not a function.
This question belongs to: Computer Microsoft Office
Question #227
In MS PowerPoint, which option allows you to rehearse timings and record narration for a slideshow?
A. Rehearse Timings
B. Record Slide Show
C. Both A and B
D. Slide Show > Set Up Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Record Slide Show' option can record narration, timings, etc. 'Rehearse Timings' specifically lets you practice and save timings. Both are related.
This question belongs to: Computer Microsoft Office
Question #228
In MS Word, what is the purpose of the 'Section Break'?
A. To start a new chapter
B. To divide a document into sections that can have different formatting
C. To insert a page break
D. To create columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Section breaks allow you to apply different page formatting (like margins, headers/footers, columns) to different parts of the document.
This question belongs to: Computer Microsoft Office
Question #229
In Access, which query type is used to display data from multiple tables based on a common field?
A. Crosstab Query
B. Parameter Query
C. Action Query
D. Select Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Select queries can join multiple tables to display data. Action queries modify data, Parameter queries prompt for criteria, Crosstab summarizes data.
This question belongs to: Computer Microsoft Office
Question #230
What is the shortcut key to increase the indent of a paragraph in MS Word?
A. Ctrl + M
B. Ctrl + T
C. Tab key
D. Ctrl + Shift + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + M increases the left indent of a paragraph. Ctrl + T creates a hanging indent. Ctrl + Shift + M decreases indent. Tab key indents only the first line (or entire paragraph if selected).
This question belongs to: Computer Microsoft Office
Question #231
In Excel, which function is used to find the smallest value in a range?
A. SMALL
B. MIN
C. MINA
D. MINIFS
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.
This question belongs to: Computer Microsoft Office
Question #232
In MS PowerPoint, what is the difference between a 'Theme' and a 'Template'?
A. A Template includes colors, fonts, and effects; a Theme includes content
B. They are the same
C. Theme is for slides, Template is for handouts
D. A Theme includes colors, fonts, and effects; a Template includes content and layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Theme is a set of design elements (colors, fonts, effects). A Template is a file that includes a theme, slide layouts, and often content placeholders or sample content to provide a starting point.
This question belongs to: Computer Microsoft Office
Question #233
In MS Word, which feature automatically numbers pages, dates, and document information at the top or bottom of pages?
A. Page Number
B. Bookmarks
C. Fields
D. Header and Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Headers and Footers are areas at the top and bottom of pages where you can insert page numbers, dates, etc. Page Number is a specific element within headers/footers.
This question belongs to: Computer Microsoft Office
Question #234
In MS Access, which of the following is a valid data type for storing monetary values?
A. Currency
B. Double
C. Number
D. Decimal
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Currency is a specific data type designed for monetary values with fixed decimal precision to avoid rounding errors. Number can also store monetary but Currency is more appropriate.
This question belongs to: Computer Microsoft Office
Question #235
Which shortcut key is used to center align text in MS Office?
A. Ctrl + E
B. Ctrl + J
C. Ctrl + R
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + E centers text. Ctrl + L left aligns, Ctrl + R right aligns, Ctrl + J justifies.
This question belongs to: Computer Microsoft Office
Question #236
In MS PowerPoint, which feature allows you to animate the text in a bulleted list one bullet at a time?
A. Rehearse Timings
B. Animation Pane
C. Effect Options
D. Trigger
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
After applying an animation, you can use Effect Options to set the sequence (e.g., 'By Paragraph' for bullets) so each bullet animates separately.
This question belongs to: Computer Microsoft Office
Question #237
In MS Word, what does the 'Track Changes' feature do?
A. Saves versions of the document
B. Records edits made to the document so they can be reviewed later
C. Checks spelling and grammar
D. Adds comments
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Track Changes records all insertions, deletions, and formatting changes, marking them for review. It does not check spelling, save versions (though it can be combined), or add comments (though comments can be added).
This question belongs to: Computer Microsoft Office
Question #238
In Excel, which function is used to calculate the number of days between two dates?
A. All of the above
B. NETWORKDAYS
C. DAYS
D. DATEDIF
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DAYS, DATEDIF, and NETWORKDAYS all can calculate days between dates (NETWORKDAYS counts working days). So all are valid.
This question belongs to: Computer Microsoft Office
Question #239
In MS PowerPoint, which option is used to compress pictures to reduce file size?
A. Resize
B. Reduce File Size
C. Compress Pictures
D. Optimize
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Compress Pictures feature (under Format tab) reduces file size by compressing images.
This question belongs to: Computer Microsoft Office
Question #240
In MS Access, what is a 'Relationship'?
A. A connection between two databases
B. A link between a table and a report
C. A connection between two tables based on a common field
D. A connection between a query and a form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A relationship in Access is an association between two tables that uses a common field to link data. It can also be between queries, but primarily tables.
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?'