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.
E2 contains =$B2+C$1*D2. It is copied to G6. The formula in G6 is:
Correct Answer: A [=$B6+E$1*F6]
Explanation:
Move 2 right, 4 down: $B2 → $B6; C$1 → E$1; D2 → F6.
2.
What does =2+3*4-8/2^2 return?
Correct Answer: B [12]
Explanation:
2^2 = 4; 3 × 4 = 12; 8 ÷ 4 = 2; 2 + 12 − 2 = 12.
3.
=ROUND(38450, −3) + ROUND(38450, −2) returns:
Correct Answer: E [76500]
Explanation:
Nearest thousand 38,000; nearest hundred 38,500; total 76,500.
4.
A1 contains " savings account " (extra spaces at the start, middle and end). =LEN(TRIM(A1)) returns:
Correct Answer: D [15]
Explanation:
TRIM leaves "savings account" = 7 + 1 + 7 = 15 characters.
5.
Consider the following statements about Excel:
I. A worksheet (Excel 2007 onwards) has 16,384 columns, the last being XFD.
II. Filter permanently deletes the rows that do not match.
III. COUNTA counts cells that contain text as well as numbers.
Which of the statements given above is/are correct?
I. A worksheet (Excel 2007 onwards) has 16,384 columns, the last being XFD.
II. Filter permanently deletes the rows that do not match.
III. COUNTA counts cells that contain text as well as numbers.
Which of the statements given above is/are correct?
Correct Answer: D [Only I and III]
Explanation:
I true; II false – filter only hides rows; III true.
6.
How many cells are there in the range C4:H15?
Correct Answer: C [72]
Explanation:
Columns C–H = 6, rows 4–15 = 12 → 72 (Range Box Count).
7.
Trick Spotter: to find the column number of BZ quickly, the best method is:
Correct Answer: B [26 × 2 + 26]
Explanation:
BZ = 2 × 26 + 26 = 78.
8.
Spot My Mistake: "=INT(−6.3) gives −6 because INT just removes the decimal part." What is wrong?
Correct Answer: B [INT always rounds down, so INT(−6.3) = −7]
Explanation:
INT rounds down to the next lower integer: −7.
📘 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 →
More quizzes
› IBPS Clerk Computer – Practice Sets and Mixed Mocks – Mixed Mock 2 · Mains Level
› IBPS Clerk Computer – Practice Sets and Mixed Mocks – Mixed Mock 1 · Mains Level
› IBPS Clerk Computer – Practice Sets and Mixed Mocks – Practice Set 3 · Stretch
› IBPS Clerk Computer – Practice Sets and Mixed Mocks – Practice Set 2 · Exam Level
› IBPS Clerk Computer – Practice Sets and Mixed Mocks – Practice Set 1 · Steady
› IBPS Clerk Computer – Computer Abbreviations – Exam-Level Drill · Mains Level
Score: 0
Answered: 0 / 0
