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.  
B2:B6 hold 75, 59, 60, 74 and 90. C2 has =IF(B2>=75, "A", IF(B2>=60, "B", "C")) copied down to C6. Reading C2 to C6, the grades are:

Correct Answer: A [A, C, B, B, A]

Explanation:

75 → A (equal counts); 59 → C; 60 → B; 74 → B; 90 → A.

2.  
A branch wants to keep customer records, search them with queries and print formatted reports. The most suitable Office program is:

Correct Answer: E [Access]

Explanation:

Tables + queries + reports = Access (a DBMS).

3.  

Directions (next 5 questions): A worksheet has the data below in rows 2 to 7 (row 1 holds the headings).

A (Name) B (Branch) C (Deposit ₹)
2 Arun Salem 42000
3 Bindu Erode 18500
4 Charan Salem 27500
5 Divya Madurai 35000
6 Ezhil Erode 51000
7 Farida Salem 9500
What does =COUNTIF(C2:C7, ">30000") return?

Correct Answer: B [3]

Explanation:

42000, 35000, 51000 → 3.

4.  
What does =SUMIF(B2:B7, "Salem", C2:C7) return?

Correct Answer: D [79000]

Explanation:

42000 + 27500 + 9500 = 79000.

5.  
D4 contains =IF(C4>=40000, "High", IF(C4>=25000, "Medium", "Low")). What does it show?

Correct Answer: C [Medium]

Explanation:

C4 = 27500: not ≥ 40000, but ≥ 25000 → Medium.

6.  
What does =VLOOKUP("Divya", A2:C7, 3, FALSE) return?

Correct Answer: E [35000]

Explanation:

Finds Divya in column A and returns the 3rd column of that row: 35000.

7.  
What does =ROUND(AVERAGE(C2:C7), 0) return?

Correct Answer: A [30583]

Explanation:

Total 1,83,500 ÷ 6 = 30,583.33 → 30583.

8.  
F5 contains =B$2*$C3+D4. It is copied to H9. The formula in H9 is:

Correct Answer: B [=D$2*$C7+F8]

Explanation:

Move 2 right, 4 down: B$2 → D$2; $C3 → $C7; D4 → F8.

9.  
Consider the following statements:
I. In PowerPoint, Shift + F5 starts the show from the current slide.
II. In Word, F5 starts a slide show.
III. In Excel, F2 lets you edit the active cell.
Which of the statements given above is/are correct?

Correct Answer: C [Only I and III]

Explanation:

I and III true; II false – F5 in Word opens Go To.

10.  
Match the key in the program with its action:
List I: (a) Ctrl + 1 in Word; (b) Ctrl + 1 in Excel; (c) Ctrl + D in Word; (d) Ctrl + D in Excel
List II: (1) fill down; (2) Format Cells; (3) Font dialog; (4) single line spacing

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

Explanation:

Same keys, different jobs – read the program name.

11.  
Match the error value with its cause:
List I: (a) #REF!; (b) #NAME?; (c) #VALUE!; (d) #NUM!
List II: (1) reference to a deleted cell; (2) invalid number such as SQRT(−4); (3) wrong type of value; (4) misspelt function name

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

Explanation:

Learn the six error values with one cause each.

12.  
What is the result of = −2^2 + (0 − 2^2) in Excel?

Correct Answer: D [0]

Explanation:

Excel applies the sign first: −2^2 = 4; 0 − 2^2 = −4; 4 + (−4) = 0.

13.  
A1:A10 holds 12, (blank), NA, 8, (blank), (blank), 15, Yes, 0, (blank). What is =COUNT(A1:A10)+COUNTA(A1:A10)−COUNTBLANK(A1:A10)?

Correct Answer: A [6]

Explanation:

COUNT 4 (12, 8, 15, 0) + COUNTA 6 − COUNTBLANK 4 = 6.

14.  
Consider the following statements about MS Word:
I. Mail merge needs a main document and a data source.
II. Format Painter copies text from one place to another.
III. Track Changes lets the author accept or reject each edit.
Which of the statements given above is/are correct?

Correct Answer: C [Only I and III]

Explanation:

I and III true; II false – Format Painter copies formatting, not text.

15.  
Which pair is NOT correctly matched?

Correct Answer: C [.docx – Excel template]

Explanation:

.docx is a Word document; Excel templates are .xltx.

16.  
In Excel, =AND(10>5, OR(3>4, 2=2), NOT(1>2)) returns:

Correct Answer: B [TRUE]

Explanation:

10>5 TRUE; OR(FALSE, TRUE) TRUE; NOT(FALSE) TRUE → AND = TRUE.

17.  
=MID("PASSBOOK", 5, 3) & RIGHT("SALEM", 2) returns:

Correct Answer: B [BOOEM]

Explanation:

MID from the 5th character, 3 characters = BOO; RIGHT 2 of SALEM = EM → BOOEM.

📘 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