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 Kaustav Basak (19 years teaching)Written with AI helpReport a mistake
This chapter has
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.
- 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. - 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. - 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. - 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. - 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 →