MS Office (Word, Excel, PowerPoint) MCQs

Solved MS Office MCQs on Word, Excel and PowerPoint shortcuts, formulas, cell references and features, asked in PPSC clerk and computer operator tests.

1. 1

   In MS Word, which shortcut makes selected text bold?

   ACtrl + BBCtrl + DCCtrl + IDCtrl + U

   Correct answer: A. Ctrl + B

   Ctrl + B applies bold, Ctrl + I applies italic and Ctrl + U underlines. Ctrl + D opens the Font dialog box.

   easyShow answer
2. 2

   In MS Word, which shortcut centre-aligns the selected paragraph?

   ACtrl + JBCtrl + ECCtrl + CDCtrl + L

   Correct answer: B. Ctrl + E

   Ctrl + E centres text. Ctrl + L aligns left, Ctrl + R aligns right and Ctrl + J justifies.

   easyShow answer
3. 3

   In MS Word, Ctrl + J is used to:

   AJustify the paragraphBJump to a pageCInsert a hyperlinkDJoin two paragraphs

   Correct answer: A. Justify the paragraph

   Ctrl + J justifies text so that it aligns evenly with both the left and right margins.

   mediumShow answer
4. 4

   Which key opens the Save As dialog box in MS Word?

   AF5BF2CF12DF7

   Correct answer: C. F12

   F12 opens Save As. F7 runs the Spelling and Grammar check.

   mediumShow answer
5. 5

   In MS Word, which key starts the spelling and grammar check?

   AF1BF7CF9DF11

   Correct answer: B. F7

   F7 opens the spelling and grammar checker (the Editor pane in newer versions). F1 opens Help.

   easyShow answer
6. 6

   Which shortcut inserts a manual page break in MS Word?

   AAlt + EnterBCtrl + EnterCCtrl + Shift + PDShift + Enter

   Correct answer: B. Ctrl + Enter

   Ctrl + Enter starts a new page. Shift + Enter inserts a line break within the same paragraph.

   mediumShow answer
7. 7

   In MS Word, which shortcut cycles selected text through UPPERCASE, lowercase and Capitalize Each Word?

   AShift + F3BCtrl + F3CAlt + F3DF3

   Correct answer: A. Shift + F3

   Shift + F3 toggles the case of selected text between the common capitalization styles.

   hardShow answer
8. 8

   Which shortcut opens the Find and Replace dialog with the Replace tab active in MS Word?

   ACtrl + FBCtrl + HCCtrl + GDCtrl + R

   Correct answer: B. Ctrl + H

   Ctrl + H opens Replace. Ctrl + F opens Find (the Navigation pane) and Ctrl + G opens Go To.

   easyShow answer
9. 9

   The shortcut Ctrl + K in MS Office applications is used to:

   AKeep text togetherBInsert a commentCInsert a hyperlinkDLock the document

   Correct answer: C. Insert a hyperlink

   Ctrl + K opens the Insert Hyperlink dialog in Word, Excel and PowerPoint.

   easyShow answer
10. 10

    Mail Merge in MS Word is found under which tab?

    AInsertBReferencesCReviewDMailings

    Correct answer: D. Mailings

    The Mailings tab holds the Mail Merge tools for producing letters, envelopes and labels from a list of recipients.

    easyShow answer
12. 11

    Table of Contents in MS Word is inserted from which tab?

    ALayoutBInsertCViewDReferences

    Correct answer: D. References

    The References tab contains Table of Contents, Footnotes, Citations and Captions.

    mediumShow answer
13. 12

    In MS Excel, every formula must begin with which symbol?

    A$B#C@D=

    Correct answer: D. =

    Starting with an equals sign tells Excel the entry is a formula, for example =A1+B1.

    easyShow answer
14. 13

    In MS Excel, the intersection of a row and a column is called a:

    AFieldBSheetCRangeDCell

    Correct answer: D. Cell

    A cell is named by its column letter and row number, for example B3. A group of cells is a range.

    easyShow answer
15. 14

    In MS Excel, $A$1 is an example of which type of cell reference?

    ARelativeBCircularCAbsoluteDMixed

    Correct answer: C. Absolute

    The dollar signs lock both the column and the row, so the reference does not change when the formula is copied. A$1 or $A1 would be mixed references.

    Read details

    mediumShow answer
16. 15

    While editing a formula in Excel, which key cycles a reference through relative, absolute and mixed forms?

    AF2BF4CF9DF11

    Correct answer: B. F4

    Pressing F4 on a reference switches it between A1, $A$1, A$1 and $A1. F2 puts a cell into edit mode.

    hardShow answer
17. 16

    Which key puts the active cell into edit mode in MS Excel?

    AF2BF4CF5DF7

    Correct answer: A. F2

    F2 lets you edit the cell's contents directly, with the cursor at the end of the entry.

    mediumShow answer
18. 17

    Which Excel function adds up a range of numbers?

    A=COUNT()B=SUM()C=TOTAL()D=ADD()

    Correct answer: B. =SUM()

    =SUM(A1:A10) adds all the numbers in cells A1 to A10. There is no ADD or TOTAL function for this.

    easyShow answer
19. 18

    In MS Excel, the COUNTA function counts:

    AOnly cells containing numbersBCells containing text onlyCCells that are not emptyDOnly blank cells

    Correct answer: C. Cells that are not empty

    COUNTA counts every non-empty cell. COUNT counts only numbers, and COUNTBLANK counts empty cells.

    mediumShow answer
20. 19

    Which Excel function returns one value if a condition is true and another if it is false?

    AVLOOKUPBANDCCHOOSEDIF

    Correct answer: D. IF

    For example, =IF(B2>=33,"Pass","Fail") shows Pass when B2 is 33 or more.

    easyShow answer
21. 20

    In MS Excel, pressing Ctrl + ; (semicolon) in a cell:

    ADeletes the rowBInserts the current timeCInserts today's dateDAdds a comment

    Correct answer: C. Inserts today's date

    Ctrl + ; enters today's date as a fixed value. Ctrl + Shift + ; enters the current time.

    hardShow answer