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 21 of 60
Question #401
In Excel, which function is used to calculate the depreciation of an asset using the straight-line method?
A. DDB
B. SYD
C. SLN
D. DB
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SLN returns straight-line depreciation. SYD is sum-of-years digits, DDB double-declining balance, DB fixed declining.
This question belongs to: Computer Microsoft Office
Question #402
In MS PowerPoint, which of the following is used to insert a table with a specific number of rows and columns?
A. Insert > Table > Excel Spreadsheet
B. Insert > Table > Quick Tables
C. Insert > Table > Draw Table
D. Insert > Table > Insert Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Insert Table dialog lets you specify rows and columns.
This question belongs to: Computer Microsoft Office
Question #403
In Word, which of the following is used to create a multilevel list?
A. Review > Multilevel List
B. Insert > Multilevel List
C. Home > Multilevel List
D. References > Multilevel List
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Multilevel List is in the Home tab, Paragraph group.
This question belongs to: Computer Microsoft Office
Question #404
In Access, which of the following is used to create a backup of a database?
A. File > Export > Backup
B. File > Save As > Back Up Database
C. Home > Backup
D. Database Tools > Backup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In Access, you can back up via File > Save As > Back Up Database.
This question belongs to: Computer Microsoft Office
Question #405
What is the shortcut key to insert a page break in MS Word?
A. Ctrl + Enter
B. Alt + Enter
C. Ctrl + Shift + Enter
D. Ctrl + Return
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Enter inserts a manual page break.
This question belongs to: Computer Microsoft Office
Question #406
In Excel, which function is used to calculate the median of a set of numbers?
A. MEDIAN
B. PERCENTILE
C. AVERAGE
D. MODE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MEDIAN returns the middle value.
This question belongs to: Computer Microsoft Office
Question #407
In MS PowerPoint, which option is used to insert a sound file into a slide?
A. Insert > Media > Audio
B. Insert > Audio
C. Both A and C
D. Insert > Sound
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Insert > Audio or Insert > Media > Audio both work.
This question belongs to: Computer Microsoft Office
Question #408
In Word, which of the following is used to protect a document with a password?
A. Insert > Protect Document
B. Review > Protect Document
C. File > Info > Protect Document
D. Home > Protect Document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Protect Document is under File > Info.
This question belongs to: Computer Microsoft Office
Question #409
In Access, which of the following is a valid expression for a validation rule?
A. Like A
B. All of the above
C. >0 And <100
D. Between 1 And 10
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
All are valid validation rule expressions.
This question belongs to: Computer Microsoft Office
Question #410
What is the shortcut key to open the 'Symbol' dialog in MS Excel?
A. Ctrl + Shift + S
B. Alt + N, U, S
C. Both A and B
D. Insert > Symbol
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can insert symbol via Insert > Symbol or Alt+N,U,S.
This question belongs to: Computer Microsoft Office
Question #411
In MS PowerPoint, which of the following is used to apply a theme to a presentation?
A. Design tab > Themes
B. Slide Show tab > Themes
C. Home tab > Themes
D. Insert tab > Themes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Themes are on the Design tab.
This question belongs to: Computer Microsoft Office
Question #412
In Word, which of the following is used to add a caption to a figure?
A. References > Insert Caption
B. View > Caption
C. Review > Caption
D. Insert > Caption
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Caption is under References.
This question belongs to: Computer Microsoft Office
Question #413
In Access, which of the following is used to create a query that uses SQL?
A. Design View
B. Datasheet View
C. Both A and B
D. SQL View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can create a query in SQL View or Design View.
This question belongs to: Computer Microsoft Office
Question #414
In MS Excel, what is the exact output of the formula =TEXT(DATE(2026,6,18), dddd)?
A. June
B. 18
C. Thu
D. Thursday
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The TEXT function formats a numeric date value into a text representation based on a specified format code. The code dddd returns the full name of the day of the week (June 18, 2026 is a Thursday).
This question belongs to: Computer Microsoft Office
Question #415
Which of the following field properties in MS Access determines the maximum number of characters that can be stored in a 'Short Text' data type field?
A. Format
B. Field Size
C. Validation Rule
D. Input Mask
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Field Size property specifies the upper limit of character storage for a Short Text field, which defaults to 255 characters but can be set to any value between 1 and 255.
This question belongs to: Computer Microsoft Office
Question #416
In MS Word, which specialized feature must be activated to allow footnotes to automatically maintain separate, distinct numbering streams across different chapters?
A. Page Break
B. Section Break
C. Bookmark
D. Style Separator
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Section breaks divide a document into independent parts with their own formatting, headers, footers, margins, and footnote/endnote numbering properties.
This question belongs to: Computer Microsoft Office
Question #417
What is the function of the keyboard shortcut Ctrl + Shift + L when working with an active data grid range in MS Excel?
A. Inserts a bulleted list inside a cell text string
B. Locks the selected cell ranges
C. Aligns cell contents to the left edge
D. Toggles AutoFilter drop-down arrows on or off
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + L is the native keyboard shortcut to instantly apply or remove the dynamic AutoFilter toggle sorting keys on the active data range headers.
This question belongs to: Computer Microsoft Office
Question #418
In MS PowerPoint, which delivery option is used to display a presentation across an active network loop so external stakeholders can follow along live via a web browser?
A. Presenter View Setup
B. Custom Slide Show
C. Present Online (Office Presentation Service)
D. Kiosk Mode Projection
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Present Online feature broadcasts a live slide show directly over the network, generating a shareable hyperlink that remote attendees can open in a web browser.
This question belongs to: Computer Microsoft Office
Question #419
Which of the following mathematical formulas is evaluated correctly to find the geometric mean of cells A1 through A3 in MS Excel?
A. =GMEAN(A1:A3)
B. =GEOMEAN(A1:A3)
C. =PRODUCT(A1:A3)^(1/3)
D. =MEAN.GEOMETRIC(A1:A3)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The native, built-in function to compute the geometric mean of an array or numerical dataset range in Excel is GEOMEAN.
This question belongs to: Computer Microsoft Office
Question #420
What does pressing the shortcut key combination Alt + Shift + D do in an active document workspace in MS Word?
A. Opens the Font properties dialog box
B. Deletes the current paragraph block
C. Inserts an automated, current system Date field
D. Applies a double strikethrough effect
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt + Shift + D instantly inserts a dynamic DATE field that reflects the current system date at the cursor position. Similarly, Alt + Shift + T inserts the current Time field.
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?'