Computers and IT MCQs
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2024-2025. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
41. With which version of Microsoft Office, the MS OneNote became a core component?
[A] Microsoft Office 2007
[B] Microsoft Office 2013
[C] Microsoft Office 2001
[D] None of the above
Show Answer
Correct Answer: B [Microsoft Office 2013]
Notes:
OneNote was initially introduced as a standalone app but it eventually became a core component of Microsoft Office; with the release of Microsoft Office 2013.
42. What is Ctrl + R used for in MS Word?
[A] it reopens the last closed document
[B] it reprints the document
[C] it right-aligns the selected text
[D] it removes the formatting
Show Answer
Correct Answer: C [it right-aligns the selected text]
Notes:
Ctrl + R is used in MS Word to right-align the selected text or selected paragraph. It is same as using the alignment options from the Formatting toolbar.
43. What is the use of VLOOKUP function in MS Excel?
[A] to get the maximum value among set of data
[B] to copy a row
[C] to find things in a table
[D] None of the above
Show Answer
Correct Answer: C [to find things in a table]
Notes:
VLOOKUP is an Excel function that is used to find things in a table or a range by row. VLOOKUP stands for Vertical Lookup and it supports approximate and exact matching, and wildcards for partial matches.
44. Which of the key combination is used to move to the bottom of the column in MS Excel?
[A] Ctrl + D
[B] Ctrl + U
[C] Ctrl + Down Arrow
[D] Ctrl + End
Show Answer
Correct Answer: C [Ctrl + Down Arrow]
Notes:
When the Ctrl key is pressed with the Down Arrow, the last cell of the column gets activated. It is a shortcut to move to the bottom of the column in MS Excel.
45. What is the best way to add a background image to all the slides?
[A] By adding a background image to the first slide
[B] By using Autocorrect option
[C] By editing the master slide
[D] It is not possible in MS PowerPoint
Show Answer
Correct Answer: C [By editing the master slide]
Notes:
By editing the master slide, we can add a background image to all the slides. It helps in giving a uniform appearance to all the slides.
46. Which of the following are types of MS Access Database object?
[A] Form
[B] Modules
[C] Tables
[D] All of the above
Show Answer
Correct Answer: D [All of the above]
Notes:
Databases in Access are composed of many objects but the major objects are Tables, Queries, Forms and Reports.
47. What is Iif function in MS Access?
[A] Indexed If
[B] Immediate If
[C] Integer If
[D] None of the above
Show Answer
Correct Answer: B [Immediate If]
Notes:
The IIf() Function is an abbreviation for “Immediate If” and this function evaluates an expression as either true or false and returns a value for each.
48. Which MS Access feature is used to copy a control’s formatting?
[A] Format Painter
[B] Format Manager
[C] AutoType
[D] None of the above
Show Answer
Correct Answer: A [Format Painter]
Notes:
The Format Painter tool of MS Access is used to apply exactly the same formatting to several controls repeatedly.
49. What serviced do BHIM mobile app offer?
[A] Transfer money through VPA
[B] Transfer money through account number
[C] Balance Enquiry
[D] All of the above
Show Answer
Correct Answer: D [All of the above]
Notes:
You can make direct bank payments to anyone on UPI using their UPI ID or scanning their QR with the BHIM app or via their account numbers. Money can be requested through the BHIM app from a UPI ID. Balance in the account can be checked too.
50. Which of the following are the features of Core banking Solutions?
[A] Accounts Management
[B] Loan management
[C] Transaction Management
[D] All of the above
Show Answer
Correct Answer: D [All of the above]
Notes:
Core Banking Solution (CBS) is networking of branches, which enables. Customers to operate their accounts, and avail banking services from any branch of the Bank on CBS network, regardless of where he maintains his account.
