MS Office MCQs with Answers and Explanations

Question #1021

Share Report

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

A. Click the table move handle

B. Both A and B

C. Ctrl + A

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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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. MONTH()

B. EOMONTH()

C. EDATE()

D. DATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Design -> Slide Size -> Custom Slide Size

B. View -> Slide Orientation

C. Home -> Orientation

D. Insert -> Slide Orientation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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 list of values displayed for selection

B. The field where the selected value is stored

C. The SQL query to update records

D. The default value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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. An endnote

C. A hyperlink

D. A page number

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. Bubble chart

B. Bar chart

C. Scatter (XY) chart

D. Line chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Ctrl + Alt + M

B. Alt + M

C. Ctrl + Shift + M

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Append query

B. Delete query

C. Update query

D. Make-Table query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Ctrl + F11

B. F11

C. Shift + F11

D. Alt + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Inserts a column break

B. Inserts a section break

C. Starts a new line

D. Inserts a page break

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

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. TRUE only if A1 contains a formula returning empty

B. TRUE if A1 is empty, FALSE otherwise

C. FALSE if A1 has a space

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Insert a video

B. Add animation

C. Change slide layout

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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Validation Rule = Between 1 And 100

B. Input Mask

C. Required = Yes

D. Default Value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Ctrl + H

B. Ctrl + F

C. F5

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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 footnote

B. A document property

C. A date

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. DCOUNT()

B. SUMIFS()

C. COUNTIFS()

D. COUNTIF()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Motion Path

B. Exit

C. Emphasis

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. Creating a form from a query

B. Using a parameter query

C. Designing a query using the graphical query design grid

D. Writing SQL code

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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. General

C. Text

D. Number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Removing a color from an image

B. Drawing a freeform shape

C. Matching a color from one object to another

D. Filling a shape with gradient

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Eyedropper picks up a color from any element.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics