Online Quiz

← Back
Get daily current affairs & exam alerts – follow us YouTube WhatsApp Channel Telegram Channel Facebook Page Instagram
Share with friends & study groups
Link to this page from your website / blog (HTML code)
1.  
What does =10+2*3^2 return in Excel?

Correct Answer: B [28]

Explanation:

3^2 = 9; 2 × 9 = 18; 10 + 18 = 28.

2.  
Cell B3 contains =A3*$C$1. It is copied to B8. The formula in B8 is:

Correct Answer: E [=A8*$C$1]

Explanation:

5 rows down: A3 → A8; $C$1 is absolute.

3.  
=ROUND(56.785, 2) returns:

Correct Answer: D [56.79]

Explanation:

Third decimal 5 → round up: 56.79.

4.  
=MOD(47, 6) returns:

Correct Answer: A [5]

Explanation:

47 = 6 × 7 + 5 → remainder 5.

5.  
=LEN("Core Banking") returns:

Correct Answer: C [12]

Explanation:

4 + 1 space + 7 = 12 characters.

6.  
Which error value appears when a formula divides by zero?

Correct Answer: D [#DIV/0!]

Explanation:

Error value #DIV/0! = division by zero.

7.  
VLOOKUP shows #N/A. The most likely reason is:

Correct Answer: B [value not found]

Explanation:

Error value #N/A = the lookup value was not found.

8.  
Which shortcut opens the Format Cells dialog in Excel?

Correct Answer: A [Ctrl + 1]

Explanation:

Ctrl + 1 = Format Cells in Excel.

9.  
Which shortcut inserts today's date in an Excel cell?

Correct Answer: C [Ctrl + ;]

Explanation:

Ctrl + ; date; Ctrl + Shift + ; time.

10.  
Which PowerPoint view is best for re-ordering slides?

Correct Answer: E [Slide Sorter]

Explanation:

Slide Sorter shows thumbnails of all slides.

11.  
Which chart is suitable to show the share of each loan type in a bank's total loans (one whole)?

Correct Answer: E [Pie]

Explanation:

A pie chart shows the parts of one whole.

12.  
Column AD is which column number in Excel?

Correct Answer: C [30]

Explanation:

26 × 1 + 4 = 30 (Base 26 without a zero).

13.  
Match the Word shortcut with its action:
List I: (a) Ctrl + H; (b) Ctrl + K; (c) Shift + F3; (d) Shift + F7
List II: (1) thesaurus; (2) hyperlink; (3) change case; (4) replace

Correct Answer: D [a-4, b-2, c-3, d-1]

Explanation:

Ctrl + H replace; Ctrl + K hyperlink; Shift + F3 case; Shift + F7 thesaurus.

14.  
A1:A7 contains Ravi, 450, (blank), 300, -, (blank), 250. What is =COUNTA(A1:A7)?

Correct Answer: A [5]

Explanation:

Non-empty cells: Ravi, 450, 300, -, 250 = 5.

15.  
Which Excel feature keeps the header row visible while you scroll down?

Correct Answer: B [Freeze Panes]

Explanation:

Freeze Panes locks the header rows/columns.

16.  
Which tab of MS Word contains Track Changes?

Correct Answer: C [Review]

Explanation:

Track Changes and Spelling & Grammar are on the Review tab.

📘 IBPS Clerk 2026 – B4 Computer Aptitude (PDF book)
Here you get the answer with a one-line explanation. 690 questions, each with a full step-by-step explanation · shortcuts, tables, trap alerts · Prelims + Mains sectional mocks. All 5 books together: ₹599.
Get the book – ₹149 →
Score: 0 Answered: 0 / 0