MS Office & Productivity Tools MCQ

Question 1 of 20

In Excel, which feature allows you to freeze rows or columns so they remain visible while scrolling?

A

Split

B

Freeze Panes

C

Filter

D

Pivot

Question 2 of 20

In MS Word, which alignment spreads the text across the full width of the document, making both left and right edges straight?

A

Center

B

Left

C

Right

D

Justify

Question 3 of 20

In Word, which feature automatically corrects common misspellings as you type?

A

Spell Check

B

AutoCorrect

C

AutoFormat

D

Find and Replace

Question 4 of 20

Which feature in Microsoft PowerPoint allows you to apply a consistent visual style (font, color, logo) across all slides?

A

Slide Sorter

B

Animation Pane

C

Slide Master

D

Notes Page

Question 5 of 20

What does the 'Absolute Cell Reference' look like in Excel?

A

A1

B

$A$1

C

#A1

D

@A1

Question 6 of 20

What is the shortcut to 'Hyperlink' a selected text in Microsoft Office applications?

A

Ctrl + H

B

Ctrl + L

C

Ctrl + K

D

Ctrl + P

Question 7 of 20

What is the shortcut to open the 'Find and Replace' dialog box in Microsoft Word?

A

Ctrl + F

B

Ctrl + H

C

Ctrl + R

D

Ctrl + G

Question 8 of 20

In Microsoft Excel, which symbol is mandatory to start any formula?

A

+

B

=

C

#

D

@

Question 9 of 20

Which of the following is NOT a type of page margin in MS Word?

A

Top

B

Left

C

Right

D

Center

Question 10 of 20

In MS Word, 'Gutter Margin' is used for:

A

Left margin only

B

Right margin only

C

Margin added for binding

D

Margin added for pictures

Question 11 of 20

In Microsoft Excel, which function is used to look for a value in the leftmost column of a table and return a value in the same row from a specified column?

A

HLOOKUP

B

VLOOKUP

C

LOOKUP

D

MATCH

Question 12 of 20

Which of these features in MS Word allows you to insert decorative text?

A

SmartArt

B

WordArt

C

ClipArt

D

TextWrap

Question 13 of 20

What is the shortcut to 'Save As' a file in Microsoft Word?

A

Ctrl + S

B

Ctrl + Shift + S

C

F12

D

Alt + S

Question 14 of 20

What is the extension of a macro-enabled Excel workbook?

A

.xlsx

B

.xlsm

C

.xlsb

D

.xltx

Question 15 of 20

Which function in Excel counts the number of cells that are not empty in a range?

A

COUNT

B

COUNTA

C

COUNTBLANK

D

SUM

Question 16 of 20

In MS PowerPoint, which view shows all slides in a presentation as thumbnails for easy reordering?

A

Reading View

B

Slide Show

C

Slide Sorter

D

Outline View

Question 17 of 20

Which Excel error occurs when a formula or function contains invalid numeric values?

A

#REF!

B

#NUM!

C

#VALUE!

D

#DIV/0!

Question 18 of 20

Which shortcut is used to insert a new slide in a PowerPoint presentation?

A

Ctrl + N

B

Ctrl + M

C

Ctrl + S

D

Ctrl + Shift + N

Question 19 of 20

Which tab in MS PowerPoint is used to add entrance, emphasis, or exit effects to individual objects on a slide?

A

Animations

B

Transitions

C

Slide Show

D

Insert

Question 20 of 20

In PowerPoint, which transition effect makes one slide appear to move behind another slide?

A

Animation

B

Transition

C

Format

D

Design