MS Office MCQs with Answers and Explanations

Question #1161

Share Report

In MS Access, a query that prompts for input each time it runs is a:

A. Select query

B. Action query

C. Crosstab query

D. Parameter query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Parameter query asks for criteria.

This question belongs to: Computer Microsoft Office

Question #1162

Share Report

Which of the following is the correct extension for an Excel binary workbook for large datasets?

A. .xlsb

B. .xltx

C. .xlsm

D. .xlsx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.xlsb is binary workbook, faster for large data.

This question belongs to: Computer Microsoft Office

Question #1163

Share Report

In MS Word, the 'Alt + Ctrl + F2' shortcut opens:

A. New document

B. Open dialog (same as Ctrl+O)

C. Save As

D. Print dialog

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Ctrl+F2 opens Open dialog.

This question belongs to: Computer Microsoft Office

Question #1164

Share Report

In PowerPoint, 'Handout Master' allows you to set the layout for:

A. Speaker notes

B. Printed handouts with multiple slides per page

C. Slide transitions

D. Slide thumbnails

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Handout Master formats printed handouts.

This question belongs to: Computer Microsoft Office

Question #1165

Share Report

In MS Access, which of the following is a valid event for a form?

A. On Click

B. On Load

C. All of these

D. After Update

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms have many events including On Load, On Click, After Update.

This question belongs to: Computer Microsoft Office

Question #1166

Share Report

What is the shortcut to replace a specific word in an MS Word document?

A. Ctrl + R

B. Ctrl + H

C. Ctrl + F

D. F7

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+H replace.

This question belongs to: Computer Microsoft Office

Question #1167

Share Report

In MS Word, the default orientation is:

A. Portrait

B. A4

C. Landscape

D. Letter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Portrait is default orientation.

This question belongs to: Computer Microsoft Office

Question #1168

Share Report

In PowerPoint, the shortcut to end a slide show is:

A. Break

B. End

C. Esc

D. Ctrl + Q

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Esc.

This question belongs to: Computer Microsoft Office

Question #1169

Share Report

In MS Access, which SQL clause groups rows that have the same values?

A. ORDER BY

B. WHERE

C. HAVING

D. GROUP BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
GROUP BY groups rows.

This question belongs to: Computer Microsoft Office

Question #1170

Share Report

Which of the following is the shortcut to insert a new slide in PowerPoint?

A. Ctrl + N

B. Ctrl + M

C. Ctrl + D

D. Ctrl + I

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+M new slide.

This question belongs to: Computer Microsoft Office

Question #1171

Share Report

In MS Word, the 'Print Layout' view shows:

A. Thumbnails

B. Document as it will appear when printed, with margins and page breaks

C. Only text without formatting

D. Outline headings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Print Layout is WYSIWYG view.

This question belongs to: Computer Microsoft Office

Question #1172

Share Report

In Excel, what does the '&' operator do?

A. Concatenates text strings

B. Performs logical AND

C. Adds numbers

D. Raises to power

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
& joins text.

This question belongs to: Computer Microsoft Office

Question #1173

Share Report

In PowerPoint, the 'Slide Sorter' view is used for:

A. Adding animations

B. Rearranging and organizing slides

C. Editing slide content

D. Viewing notes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Sorter shows thumbnails for ordering.

This question belongs to: Computer Microsoft Office

Question #1174

Share Report

In MS Access, the default name of the first table created in a blank database is:

A. NewTable

B. Default

C. Table1

D. MainTable

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Access names new table Table1.

This question belongs to: Computer Microsoft Office

Question #1175

Share Report

What is the function of 'Ctrl + Page Up' in MS Word?

A. Move to the top of the previous page

B. Scroll up

C. Insert page break

D. Move to previous section

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Page Up goes to previous page top.

This question belongs to: Computer Microsoft Office

Question #1176

Share Report

In Excel, the shortcut to select the entire column is:

A. Shift + Spacebar

B. Ctrl + Shift + Spacebar

C. Ctrl + Spacebar

D. Alt + Spacebar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Space selects column; Shift+Space row.

This question belongs to: Computer Microsoft Office

Question #1177

Share Report

In PowerPoint, to make the ribbon appear or disappear, press:

A. Alt + F1

B. F1

C. Shift + F1

D. Ctrl + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F1 toggles ribbon.

This question belongs to: Computer Microsoft Office

Question #1178

Share Report

In MS Access, which data type stores a value that is either -1 (Yes) or 0 (No)?

A. Yes/No

B. Boolean

C. Logical

D. Both A and B, but it's called Yes/No

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The data type is Yes/No.

This question belongs to: Computer Microsoft Office

Question #1179

Share Report

To quickly switch between uppercase, lowercase, and title case in MS Word, select text and press:

A. F3

B. Ctrl + F3

C. Alt + F3

D. Shift + F3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F3 toggles case.

This question belongs to: Computer Microsoft Office

Question #1180

Share Report

In Excel, which of the following is a valid date format?

A. mm/dd/yyyy

B. yyyy-mm-dd

C. All of these

D. dd/mm/yyyy

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Excel can display many date formats.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics