MS Office MCQs with Answers and Explanations

Question #761

Share Report

In PowerPoint, which feature allows you to apply a transition effect to all slides at once?

A. Slide Master

B. Copy formatting

C. Apply To All button in Transitions tab

D. Animation Painter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
After selecting a transition, clicking 'Apply To All' sets it for every slide.

This question belongs to: Computer Microsoft Office

Question #762

Share Report

In MS Access, a relationship between two tables that requires a third junction table is called:

A. Self-join

B. Many-to-Many

C. One-to-One

D. One-to-Many

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Many-to-many relationships need a junction table with foreign keys to both primary tables.

This question belongs to: Computer Microsoft Office

Question #763

Share Report

To navigate to the next cell in a table in MS Word, press:

A. Enter

B. Arrow keys

C. Tab

D. Ctrl + Right arrow

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Tab moves to next cell; Shift+Tab to previous.

This question belongs to: Computer Microsoft Office

Question #764

Share Report

In Excel, what does the 'Flash Fill' feature do?

A. Fills a range with random numbers

B. Fills cells with a series like AutoFill

C. Automatically fills values by detecting patterns

D. Copies formatting from adjacent cells

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.

This question belongs to: Computer Microsoft Office

Question #765

Share Report

Which of the following is a correct order to apply custom animation to an object in PowerPoint?

A. Design tab -> Animate

B. Select object -> Animations tab -> Add Animation

C. Insert tab -> Animation

D. Animations tab -> Add Animation -> select object

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
First select the object, then add animation from the Animations tab.

This question belongs to: Computer Microsoft Office

Question #766

Share Report

In MS Access, to import data from an Excel file, you can use:

A. Database Tools -> Import

B. Create tab -> Table from Excel

C. External Data tab -> Import Excel

D. Home tab -> Get External Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The External Data tab provides import and link options.

This question belongs to: Computer Microsoft Office

Question #767

Share Report

What is the shortcut to open the 'Format Cells' dialog with Font tab in Excel?

A. Ctrl + 1

B. Ctrl + Shift + F

C. Alt + F

D. Ctrl + Shift + P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+F opens Format Cells -> Font. Ctrl+1 opens main Format Cells.

This question belongs to: Computer Microsoft Office

Question #768

Share Report

In MS Word, 'Kerning' refers to:

A. Adjusting the spacing between specific pairs of characters

B. Changing the line spacing

C. Applying shadow effects to text

D. Fitting text to a shape

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Kerning adjusts space between individual letters.

This question belongs to: Computer Microsoft Office

Question #769

Share Report

In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20?

A. =AND(A1>10, A1<20)

B. =IF(A1>10, A1<20)

C. =OR(A1>10, A1<20)

D. =NOT(A1>10)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AND returns TRUE if all conditions are true.

This question belongs to: Computer Microsoft Office

Question #770

Share Report

In PowerPoint, to loop a slide show continuously until Esc is pressed, set:

A. Design tab -> Customize -> Loop

B. Slide Show tab -> Set Up Slide Show -> Loop continuously until 'Esc'

C. Transitions tab -> Advance Slide -> After -> Repeat

D. Animations tab -> Repeat

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The 'Set Up Show' dialog has the loop option.

This question belongs to: Computer Microsoft Office

Question #771

Share Report

In MS Access, a select query that groups records and calculates sums, averages, etc., uses:

A. Sort row

B. Criteria row

C. Show row

D. Totals (Group By) row

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Clicking the Totals button (Σ) adds the Total row for grouping and aggregating.

This question belongs to: Computer Microsoft Office

Question #772

Share Report

Which key combination is used to switch between open applications in Windows (and also in Office)?

A. Windows + Tab

B. Alt + Tab

C. Shift + Tab

D. Ctrl + Tab

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Alt+Tab switches between open windows. Ctrl+Tab switches between document windows within an application.

This question belongs to: Computer Microsoft Office

Question #773

Share Report

In MS Word, what is the maximum font size that can be typed directly in the font size box?

A. 999

B. 72

C. 1638

D. 409

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can type up to 1638 points. The dropdown shows up to 72, but you can enter larger.

This question belongs to: Computer Microsoft Office

Question #774

Share Report

In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:

A. An error

B. Third row, second column

C. Second row, third column of the range A1:C3

D. Cell B2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell C2.

This question belongs to: Computer Microsoft Office

Question #775

Share Report

In PowerPoint, the shortcut to insert a new comment is:

A. Alt + N

B. Ctrl + Alt + M

C. Shift + F2

D. Ctrl + Shift + C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Alt+M inserts a new comment in PowerPoint.

This question belongs to: Computer Microsoft Office

Question #776

Share Report

In MS Access, which query type creates a new table from the results of a query?

A. Delete query

B. Append query

C. Make-Table query

D. Update query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Make-Table query creates a new table and populates it.

This question belongs to: Computer Microsoft Office

Question #777

Share Report

To add a row above the current row in an Excel table, press:

A. Shift + Space, Ctrl + +

B. Alt + I, R

C. Ctrl + Shift + +

D. Ctrl + +

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Select a cell, then Ctrl+Shift++ opens Insert dialog; if whole row is selected, it inserts. Also Ctrl++ works. But the common shortcut: Ctrl+Shift+plus sign. Both are plausible. I'll set A as correct: Ctrl+Shift++.

This question belongs to: Computer Microsoft Office

Question #778

Share Report

In MS Word, what does 'Widow/Orphan control' prevent?

A. A single line of a paragraph at the top or bottom of a page

B. Two consecutive hyphens

C. Overlapping text and images

D. Page breaks before headings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Widow/Orphan control keeps at least two lines together at page breaks.

This question belongs to: Computer Microsoft Office

Question #779

Share Report

In Excel, which of the following formulas calculates the monthly payment for a loan of ₹5,00,000 at 10% annual interest for 5 years?

A. =PV(10%/12, 5*12, -500000)

B. =PMT(10%/12, 5*12, -500000)

C. =FV(10%, 5, 500000)

D. =PMT(10%, 5, 500000)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
PMT requires rate per period, total periods, present value. Monthly rate is 10%/12, periods 60, PV -500000.

Microsoft Office MCQs

Practice Questions

More Computer Topics