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 13 of 60
Question #241
What is the shortcut key to delete a slide in MS PowerPoint?
A. Delete
B. Ctrl + D
C. Both A and C
D. Ctrl + X
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pressing the Delete key (or Backspace) when a slide is selected in the thumbnail pane deletes it. Ctrl+D duplicates, Ctrl+X cuts.
This question belongs to: Computer Microsoft Office
Question #242
In Excel, what does the 'COLUMN' function return?
A. The letter of the column
B. The column number of a reference
C. The number of columns in a range
D. The column header
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COLUMN returns the column number (e.g., 1 for column A). It does not return letters or counts of columns.
This question belongs to: Computer Microsoft Office
Question #243
In MS Word, which feature allows you to create a list of captions for figures, tables, and equations?
A. Table of Contents
B. Bibliography
C. Index
D. Table of Figures
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Table of Figures generates a list of figures based on captions. Captions are inserted for figures.
This question belongs to: Computer Microsoft Office
Question #244
Which of the following is not a valid view in MS Excel?
A. Page Layout
B. Reading View
C. Normal
D. Page Break Preview
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Excel has Normal, Page Layout, and Page Break Preview views. Reading View is not a view in Excel; it's a Word view.
This question belongs to: Computer Microsoft Office
Question #245
In MS PowerPoint, what is the purpose of the 'Slide Show' tab?
A. To insert media
B. To set up and run the presentation
C. To add animations
D. To design slides
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Slide Show tab contains options to start the slideshow, set up the show, rehearse timings, etc. Animations are on the Animations tab, Insert is for media, Design is for design.
This question belongs to: Computer Microsoft Office
Question #246
In MS Access, what is the function of a 'Parameter Query'?
A. Updates data in a table
B. Prompts the user for criteria each time it is run
C. Appends records to another table
D. Deletes records
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A parameter query displays a dialog box asking for input, such as a date or name, to filter the results.
This question belongs to: Computer Microsoft Office
Question #247
What is the shortcut key to open the 'Find and Replace' dialog box in MS Word with the Replace tab active?
A. Ctrl + G
B. Ctrl + H
C. Alt + E, E
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + H opens the Find and Replace dialog with the Replace tab active. Ctrl+F opens the Navigation pane for Find. Ctrl+G opens Go To. Alt+E,E is old menu.
This question belongs to: Computer Microsoft Office
Question #248
In Excel, which function is used to find the remainder after division?
A. DIV
B. MOD
C. REMAINDER
D. QUOTIENT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
MOD returns the remainder of a division. QUOTIENT returns the integer portion.
This question belongs to: Computer Microsoft Office
Question #249
In MS PowerPoint, which option allows you to insert a chart?
A. Insert > Chart
B. Insert > Table
C. Insert > Shapes
D. Insert > SmartArt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Chart command is under the Insert tab, in the Illustrations group. SmartArt is for diagrams, Shapes for shapes, Table for tables.
This question belongs to: Computer Microsoft Office
Question #250
In MS Word, which of the following is used to apply the same formatting to multiple sections of text?
A. Copy and Paste
B. Format Painter
C. All of the above
D. Style
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Format Painter copies formatting from one selection to another; Styles apply consistent formatting; Copy and Paste can also copy formatting. All can be used.
This question belongs to: Computer Microsoft Office
Question #251
In Access, which of the following is not a type of query?
A. Report
B. Crosstab
C. Action
D. Select
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Report is a separate database object, not a query type. Query types include Select, Action, Crosstab, Parameter, etc.
This question belongs to: Computer Microsoft Office
Question #252
What is the shortcut key to open the 'Font' dialog box in MS Excel?
A. Ctrl + F
B. Ctrl + D
C. Ctrl + Shift + F
D. Ctrl + 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In Excel, Ctrl+1 opens Format Cells, not Font specifically. Ctrl+Shift+F opens the Format Cells dialog with the Font tab active. Ctrl+D fills down. Ctrl+F is Find. So Ctrl+Shift+F is correct for Font.
This question belongs to: Computer Microsoft Office
Question #253
In MS PowerPoint, which feature is used to add a text placeholder that can be edited on the slide?
A. Shape
B. WordArt
C. Table
D. Text Box
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Text Box is a rectangular area where you can type and format text independently. WordArt is styled text, Shape can contain text, but Text Box is specifically for editable text.
This question belongs to: Computer Microsoft Office
Question #254
In Excel, what does the 'TRIM' function do?
A. Truncates text to a specified length
B. Removes extra spaces from text
C. Removes non-printable characters
D. Converts text to proper case
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TRIM removes all leading, trailing, and multiple internal spaces, leaving single spaces between words. CLEAN removes non-printable characters.
This question belongs to: Computer Microsoft Office
Question #255
In MS Word, which of the following is the correct way to insert a page break?
A. Insert > Page Break
B. Alt + Enter
C. Ctrl + Shift + Enter
D. Ctrl + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Enter inserts a manual page break. Ctrl+Shift+Enter inserts a column break? Actually Alt+Enter creates a new line, Insert > Page Break also does it. But Ctrl+Enter is the keyboard shortcut.
This question belongs to: Computer Microsoft Office
Question #256
In MS Access, which data type is used to store files like images, documents, etc.?
A. Attachment
B. Hyperlink
C. Memo
D. OLE Object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Attachment data type in Access allows you to store multiple files (like images, documents) per record. OLE Object is older and less efficient.
This question belongs to: Computer Microsoft Office
Question #257
What is the shortcut key to show/hide the ribbon in MS Office applications?
A. Alt + F1
B. Ctrl + F1
C. Alt + F2
D. Ctrl + Shift + F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + F1 toggles the ribbon display in Office apps. Alt+F1 inserts a chart in Excel, others are not standard.
This question belongs to: Computer Microsoft Office
Question #258
In Excel, which function is used to calculate the payment for a loan based on constant payments and interest rate, but for a given number of periods?
A. NPER
B. RATE
C. PV
D. PMT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT calculates the periodic payment. NPER calculates number of periods, PV present value, RATE interest rate.
This question belongs to: Computer Microsoft Office
Question #259
In MS PowerPoint, which option is used to change the orientation of all slides to portrait?
A. View > Slide Master > Orientation
B. Slide Show > Set Up Show > Portrait
C. Design > Slide Size > Custom Slide Size > Portrait
D. File > Print > Portrait
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can change slide orientation by going to Design > Slide Size > Custom Slide Size and then choosing Portrait. View > Slide Master doesn't have orientation directly.
This question belongs to: Computer Microsoft Office
Question #260
In MS Word, the 'Draft' view shows the document with:
A. Outline structure
B. Full formatting and page layout
C. Minimal formatting, no page breaks
D. Web page preview
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Draft view (previously Normal view) shows the document with minimal formatting, does not show headers/footers or page breaks, and uses a continuous layout.
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?'