Computer Awareness Questions for IBPS Mains Exams – Day 10

Mentor for Bank Exam
Computer Awareness Questions for IBPS Mains Exams – Day 10
1. Which of the following shortcut keys is used to copy formatting?  
(a) Ctrl + C
(b) Shift + C
(c) Ctrl + Shift + C
(d) Alt + C
(e) None of these
Answer: C)
Explanation: The Ctrl + Shift + C key combination allows you to copy the formatting of a selected text. You can also click the Format Painter button to copy formatting.
2. Which of the following functions calculates the average or mean value of a group of numbers? 
(a) AVERAGE function
(b) AVG function
(c) SUM function
(d) COUNT function
(e) MAX function
Answer: A)
Explanation: The AVERAGE function calculates the sum of the selected values and divides it by the number of values.
3. By default, MS Outlook stores all received e-mails in the ________ folder. 
(a) Inbox
(b) Sent Mail
(c) Outbox
(d) Junk Mail
(e) None of these
Answer: A)
Explanation: By default, the Inbox folder stores all the received e-mails, whether they are read or unread.
4. Which of the following keys is used to delete characters to the left of the cursor? 
(a) Alt + Delete
(b) Shift
(c) Esc
(d) Delete
(e) Backspace
Answer: E)
Explanation: In a computer keyboard, Backspace is the key that is used to delete the characters to the left of the cursor.
5. Microsoft Word is also known as -
(a) System software
(b) Application software
(c) Operating system 
(d) Language translator
(e) Complier 
Answer: B)
Explanation: Microsoft Word is application software that helps in creating a document, such as a memo or a letter, in an effective and efficient manner.
6. Which of the following is not a version of MS Office? 
(a) MS Office 2010
(b) MS Office XP
(c) MS Office 2013
(d) MS Office 2003
(e) MS Office Vista
Answer: E)
Explanation: Vista is not an MS Office version. It is an operating system developed by Microsoft Corporation.
7. The command Ctrl + U in MS Word will do which of the following? 
(a) Unblock
(b) Block
(c) Underline
(d) Select
(e) Under select
Answer: C)
Explanation: The command Ctrl + U creates an underline to a letter, a word or a sentence in MS Word.


8. Which of the following statements is incorrect in the context of Windows 7? 
(a) Windows 7 is successor to Windows Vista
(b) It supports multi-touch feature
(c) It supports virtual hard disk
(d) It is the only operating system that provides the Device Manager feature
(e) None of these
Answer: D)
Explanation: Windows 7 is an operating system introduced by Microsoft. It provides several new features including Aero Snap, Aero Shake, virtual hard disk support and multi-touch support. It also includes the features of earlier operating system such as task Manger, Control Panel and Device Manger.
9. Which of the following key combinations is used to paste selected content from clipboard?  
(a) Ctrl + Q
(b) Ctrl + Alt + Q
(c) Ctrl + V
(d) Ctrl + Shift + V
(e) Ctrl + P
Answer: C)
Explanation: The Ctrl + V key combination is used to paste the selected content from Clipboard. It is used to remove paragraph formatting. The Ctrl + Shift + V key combination is used to paste the formatting only. The Ctrl + P key combination is used to print a document.
10. Which of the following is a text concatenation operator used in Excel? 
(a) ^
(b) &
(c) <>
(d) :
(e) %
Answer: B)
Explanation: The text concatenation operator (&) is used to join or link together more than one text string to produce a single text string.
11. Which of the following tabs in Word 2010 includes options to set page size, page margin and page orientation? 
(a) Home
(b) Insert
(c) Page Layout
(d) Review
(e) None of these
Answer: C)
Explanation: The page Layout tab of Word 2010 allows you to specify page settings, including page size, orientation, margin and paragraph spacing.
12. The Landscape layout of a page refers to _______ orientation.
(a) Horizontal
(b) Vertical
(c) Center
(d) All of the above
(e) None of these
Answer: A)
Explanation: Orientation defines the layout of a page in either horizontal or vertical direction. The Landscape orientation option specifies horizontal direction, while the Portrait orientation option specifies vertical direction.
13. Which of the following functions is used to count the number of only those cells in a cell range that contain numbers? 
(a) Len
(b) Sum
(c) Count
(d) Count A
(e) None of these
Answer: C)
Explanation: The Len function is used to count the number of characters in a cell. The sum function is used to get the sum of a cell range. The Count A functions is used to count the number of cells in a cell range containing both numbers and text.
14. What does BIOS stand for? 
(a) Basic Input Output Service
(b) Basic Input Output System
(c) Basic Input Output Solutions
(d) Basic Input Output Service
(e) Basis Input Output Solution
Answer: B)
Explanation: Basic Input-Output System (BIOS) is built-in software that keeps track of all the devices attached to the computer and provides communication between listed devices.
15. In MS-word, which menu contains the option to divide the document in two columns?
(a) File
(b) Insert
(c) Page layout
(d) References
(e) Review
Answer: C)
Explanation: The Page Layout menu contains the Columns option, which allows you to divide the document in columns.