MS Office MCQs with Answers and Explanations

Question #1021

Share Report

To select the entire table in MS Word, you can press:

A. Alt + 5 on the numeric keypad (with NumLock off)

B. Ctrl + A

C. Click the table move handle

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+5 (num pad) selects whole table. Clicking the table move handle also selects.

This question belongs to: Computer Microsoft Office

Question #1022

Share Report

In Excel, which function returns the serial number of the date that is a specified number of months before or after a start date?

A. EOMONTH()

B. EDATE()

C. MONTH()

D. DATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
EDATE(start_date, months) shifts date by months.

This question belongs to: Computer Microsoft Office

Question #1023

Share Report

In PowerPoint, which tab would you use to change the orientation of slides from landscape to portrait?

A. Home -> Orientation

B. Insert -> Slide Orientation

C. Design -> Slide Size -> Custom Slide Size

D. View -> Slide Orientation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide orientation is under Design -> Slide Size.

This question belongs to: Computer Microsoft Office

Question #1024

Share Report

In MS Access, the 'Row Source' property of a combo box determines:

A. The SQL query to update records

B. The field where the selected value is stored

C. The list of values displayed for selection

D. The default value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Row Source provides the data for the list.

This question belongs to: Computer Microsoft Office

Question #1025

Share Report

In MS Word, the 'Ctrl + Alt + F' shortcut inserts:

A. A footnote

B. A page number

C. An endnote

D. A hyperlink

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+F inserts a footnote. Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Question #1026

Share Report

In Excel, the chart type that shows the relationship between two sets of numeric data using dots is:

A. Bar chart

B. Bubble chart

C. Line chart

D. Scatter (XY) chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Scatter chart plots x,y pairs.

This question belongs to: Computer Microsoft Office

Question #1027

Share Report

In PowerPoint, which shortcut key is used to insert a new comment?

A. Alt + M

B. Ctrl + Shift + M

C. Ctrl + M

D. Ctrl + Alt + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+M inserts comment.

This question belongs to: Computer Microsoft Office

Question #1028

Share Report

In MS Access, which action query adds records from a query result to an existing table?

A. Update query

B. Delete query

C. Make-Table query

D. Append query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Append query inserts rows.

This question belongs to: Computer Microsoft Office

Question #1029

Share Report

To quickly create a chart on a new sheet in Excel, select data and press:

A. F11

B. Shift + F11

C. Alt + F1

D. Ctrl + F11

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F11 creates chart sheet.

This question belongs to: Computer Microsoft Office

Question #1030

Share Report

In MS Word, what does the 'Ctrl + Enter' shortcut do?

A. Starts a new line

B. Inserts a section break

C. Inserts a page break

D. Inserts a column break

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Enter inserts a manual page break.

This question belongs to: Computer Microsoft Office

Question #1031

Share Report

In Excel, the function =ISBLANK(A1) returns:

A. Both A and B

B. TRUE if A1 is empty, FALSE otherwise

C. FALSE if A1 has a space

D. TRUE only if A1 contains a formula returning empty

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ISBLANK returns TRUE if cell is empty. A cell with a space is not empty, so FALSE.

This question belongs to: Computer Microsoft Office

Question #1032

Share Report

In PowerPoint, the 'Action' button can be used to:

A. Change slide layout

B. Hyperlink to another slide, file, URL, or run a program

C. Insert a video

D. Add animation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Action buttons are interactive.

This question belongs to: Computer Microsoft Office

Question #1033

Share Report

In MS Access, to specify that a field can only accept values between 1 and 100, set:

A. Default Value

B. Validation Rule = Between 1 And 100

C. Required = Yes

D. Input Mask

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Validation Rule restricts input.

This question belongs to: Computer Microsoft Office

Question #1034

Share Report

What is the shortcut to open the 'Replace' dialog in MS Excel?

A. F5

B. Ctrl + F

C. Ctrl + R

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+H for Replace.

This question belongs to: Computer Microsoft Office

Question #1035

Share Report

In MS Word, the 'Ctrl + Alt + D' shortcut inserts:

A. A document property

B. A date

C. A footnote

D. An endnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Question #1036

Share Report

In Excel, which function returns the number of cells in a range that meet multiple criteria?

A. SUMIFS()

B. DCOUNT()

C. COUNTIF()

D. COUNTIFS()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNTIFS handles multiple criteria.

This question belongs to: Computer Microsoft Office

Question #1037

Share Report

In PowerPoint, which of the following is a type of animation that makes an object leave the slide?

A. Emphasis

B. Exit

C. Motion Path

D. Entrance

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Exit animations make objects disappear.

This question belongs to: Computer Microsoft Office

Question #1038

Share Report

In MS Access, what does the term 'query by example (QBE)' refer to?

A. Designing a query using the graphical query design grid

B. Creating a form from a query

C. Writing SQL code

D. Using a parameter query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
QBE is the graphical query designer.

This question belongs to: Computer Microsoft Office

Question #1039

Share Report

In Excel, what is the default number format for cells?

A. Custom

B. Number

C. Text

D. General

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
General is the default format.

This question belongs to: Computer Microsoft Office

Question #1040

Share Report

In PowerPoint, the 'Eyedropper' tool is useful for:

A. Matching a color from one object to another

B. Drawing a freeform shape

C. Filling a shape with gradient

D. Removing a color from an image

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Eyedropper picks up a color from any element.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics