1
In MS Excel, which symbol makes a cell reference absolute (fixed) when a formula is copied?
Correct answer: A. $
$A$1 stays fixed when copied; A1 changes. Pressing F4 while editing adds the $ signs.
easy
MS Office and Banking Technology MCQs
Solved computer awareness MCQs for banking exams: Excel functions and references, Word and PowerPoint features, and banking technology such as IMPS, AePS, NACH, CTS, CBS and SWIFT.
20 MCQsUpdated 27 October 2026
This set combines MS Office skills (absolute cell references in Excel, printing and saving shortcuts in Word) with the banking technology that IBPS and SBI papers test: Core Banking Solution, digital payments and safe online banking habits.
Try each Office shortcut on a real keyboard as you revise. For banking technology, focus on what each system lets a customer do, since options often describe a neighbouring service.
- 2
Which MS Excel function calculates the mean of a range of numbers?
Correct answer: A. AVERAGE
=AVERAGE(B2:B10) gives the arithmetic mean; MEDIAN gives the middle value.
easy - 3
In MS Excel, COUNTIF is used to:
Correct answer: D. count the cells that meet a condition
Example: =COUNTIF(C2:C50,">=40") counts the scores of 40 or more.
medium - 4
The Excel function VLOOKUP searches for a value in the:
Correct answer: A. first column of a table
VLOOKUP looks down the first column and returns a value from another column in the same row.
medium - 5
In MS Word, Ctrl + P is used to:
Correct answer: D. print
Ctrl + P opens the Print screen; Ctrl + V pastes.
easy - 6
Mail Merge in MS Word is used to:
Correct answer: D. create personalised letters for many people from one template and a list
Mail Merge fills names and addresses from a list into one letter template, as banks do for customer letters.
medium - 7
In MS PowerPoint, pressing F5 will:
Correct answer: B. start the slide show from the first slide
F5 starts the show from the beginning; Shift + F5 starts from the current slide.
easy - 8
The file extension .xlsx belongs to:
Correct answer: B. MS Excel
Excel workbooks use .xlsx; Word uses .docx and PowerPoint uses .pptx.
easy - 9
In most programs, Ctrl + S is used to:
Correct answer: C. save the file
Ctrl + S saves; Ctrl + A selects all.
easy - 10
IMPS, used for instant fund transfers at any time, stands for:
Correct answer: B. Immediate Payment Service
IMPS, run by NPCI, transfers money instantly, round the clock, including on holidays.
easy - 11
AePS, which lets people use bank services with their Aadhaar number and fingerprint, stands for:
Correct answer: D. Aadhaar enabled Payment System
AePS allows cash withdrawal and balance enquiry at micro-ATMs using Aadhaar authentication.
medium - 12
The CVV on a debit or credit card is:
Correct answer: D. a three-digit security code, usually on the back of the card
The CVV verifies online card payments. Never share it with anyone.
easy - 13
Core Banking Solution (CBS) allows a customer to:
Correct answer: C. use any branch of the same bank for their account
With CBS, all branches share one central database, so customers are customers of the bank, not just of one branch.
medium - 14
The BHIM app is based on:
Correct answer: C. UPI
BHIM (Bharat Interface for Money), launched by NPCI in 2016, uses the Unified Payments Interface.
easy - 15
NACH (National Automated Clearing House) is mainly used for:
Correct answer: B. bulk and repetitive payments such as salaries, pensions and loan EMIs
NACH, run by NPCI, handles high-volume recurring debits and credits between banks.
medium - 16
In cheque clearing, CTS stands for:
Correct answer: C. Cheque Truncation System
Under CTS, an image of the cheque travels electronically instead of the paper cheque, which speeds up clearing.
medium - 17
Which of these habits keeps online banking safer?
Correct answer: A. Logging out after every session
Always log out, never share OTPs or PINs, and use different strong passwords.
easy - 18
A prepaid payment instrument such as a mobile wallet works by:
Correct answer: B. storing money loaded in advance
You load money into a wallet first and then spend from that balance.
easy - 19
A SWIFT code is used mainly for:
Correct answer: A. international bank transfers
SWIFT (BIC) codes identify banks for international money transfers; IFSC is used within India.
medium - 20
The virtual keyboard on bank login pages mainly protects against:
Correct answer: C. keyloggers that record what you type
Clicking keys on screen makes it harder for keylogging malware to capture your password.
medium