Banking (IBPS / SBI) · Computer Awareness

MS Office (Word, Excel, PowerPoint)

20 practice questions with full step-by-step solutions — free, no sign-up.

Reviewed by (19 years teaching)Written with AI helpReport a mistake

This chapter has

10
easy
8
medium
2
hard

MS Office (Word, Excel, PowerPoint) — solved practice questions

5 Banking Computer Awareness questions with step-by-step solutions. Attempt each, then reveal the answer.

These worked examples are not in the timed test, so you can study them first.

  1. Q1easyReport

    What does the shortcut Ctrl + Z do in MS Office applications?

    • AZooms into the document
    • BRedoes the last undone action
    • CUndoes the last action
    • DCuts the selected text
    Show answer & solution

    Correct answer: (C) Undoes the last action

    Ctrl + Z is Undo: it reverses your most recent action, and pressing it again goes further back. Redo is Ctrl + Y, cut is Ctrl + X, and zoom has no Ctrl + Z shortcut. Answer: Undoes the last action.
  2. Q2easyReport

    In MS Excel, the box formed where a row and a column meet is called a:

    • ARange
    • BCell
    • CWorksheet
    • DWorkbook
    Show answer & solution

    Correct answer: (B) Cell

    Each row (numbered 1, 2, 3, ...) crosses each column (lettered A, B, C, ...) in one box called a cell, named by its column and row, such as B4. A range is a group of cells (for example A1:A10), a worksheet is one full sheet of cells, and a workbook is the whole Excel file holding the sheets. Answer: Cell.
  3. Q3easyReport

    What is the default file extension of a document saved in MS Word 2007 and later versions?

    • A.pptx
    • B.docx
    • C.xlsx
    • D.doc
    Show answer & solution

    Correct answer: (B) .docx

    From Word 2007 onwards, documents are saved by default in the XML-based format with the extension .docx. .doc was the default in Word 97-2003, so it is the trap option here. .xlsx is an Excel workbook and .pptx is a PowerPoint presentation. Answer: .docx.
  4. Q4easyReport

    In MS PowerPoint, which key starts the slide show from the first slide?

    • AF7
    • BF12
    • CF5
    • DShift + F5
    Show answer & solution

    Correct answer: (C) F5

    F5 starts the slide show from the beginning (slide 1). Shift + F5 starts it from the slide you are currently on, which is the common trap. F7 runs the spelling check and F12 opens Save As. Answer: F5.
  5. Q5mediumReport

    Which formula correctly adds all the values in cells A1 to A5 in MS Excel?

    • A=ADD(A1:A5)
    • B=SUM(A1:A5)
    • C=SUM(A1,A5)
    • DSUM(A1:A5)
    Show answer & solution

    Correct answer: (B) =SUM(A1:A5)

    A colon (:) means 'from ... to', so A1:A5 is the range A1, A2, A3, A4 and A5. =SUM(A1,A5) uses a comma, which adds only the two cells A1 and A5. Excel has no ADD function, so =ADD(A1:A5) gives a #NAME? error. SUM(A1:A5) without the equals sign is treated as plain text, not a formula. Answer: =SUM(A1:A5).

Ready to test yourself? Take the 15-question MS Office (Word, Excel, PowerPoint) test →