MS Office & Productivity Tools MCQ

Question 1 of 20

In Excel, which keyboard shortcut allows you to toggle between showing formulas and results?

A

Ctrl + F

B

Ctrl + `

C

Alt + F

D

Ctrl + Shift + F

Question 2 of 20

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

A

.xlsx

B

.xlsm

C

.xlsb

D

.xltx

Question 3 of 20

Which keyboard shortcut is used to 'Undo' the last action in Microsoft Word and Excel?

A

Ctrl + X

B

Ctrl + Y

C

Ctrl + Z

D

Ctrl + S

Question 4 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 5 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 6 of 20

In Excel, which chart type is best for showing trends over time?

A

Pie Chart

B

Line Chart

C

Scatter Plot

D

Bar Chart

Question 7 of 20

Which Excel tool helps you find the right input value to achieve a specific result?

A

Pivot Table

B

Data Validation

C

Goal Seek

D

Solver

Question 8 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 9 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 10 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 11 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 12 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 13 of 20

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

A

Animation

B

Transition

C

Format

D

Design

Question 14 of 20

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

A

SmartArt

B

WordArt

C

ClipArt

D

TextWrap

Question 15 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 16 of 20

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

A

A1

B

$A$1

C

#A1

D

@A1

Question 17 of 20

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

A

+

B

=

C

#

D

@

Question 18 of 20

Which tool in MS Word is used to create multiple letters, labels, or envelopes with a single template and a data source?

A

Hyperlink

B

Mail Merge

C

Macro

D

Thesaurus

Question 19 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 20 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