PYQPulse
HomeMocksPracticePYQsDashboard
PYQPulse

Timing-accurate mock tests and PYQs for SSC, Banking and Railway exams — so the real paper feels like a revision.

Exams

  • SSC exams
  • Banking exams
  • Railway exams
  • All exams

Practice

  • Practice questions
  • Mock test series
  • Sectional tests
  • Year-wise PYQs
  • Performance analytics

Company

  • About us
  • Help Centre
  • Pricing
  • Sign in

Legal

  • Privacy Policy
  • Terms of Service

Contact

  • hello@testwala.co.in
  • Telegram
  • +91 62816 87760

Practice interface modeled on the official exam pattern — not the official examination. PYQPulse is not affiliated with the Staff Selection Commission, IBPS, SBI, RBI, NABARD, SEBI or Indian Railways.

© 2026 PYQPulse. All rights reserved.

Built for aspirants, by aspirants.

HomeMocksPracticeStats
  1. Home
  2. ›
  3. PYQs
  4. ›
  5. ibps-so
  6. ›
  7. 2023
  8. ›
  9. Q306

ibps-so 2023 · Question 306 of 323

Which of the following Excel formulas performs a calculation only when cell A1 contains a value-type entry, and otherwise returns 0?

  1. A=IF(CELL("contents",A1)="v",A1*2,0)
  2. B=IF(CELL("format",A1)="v",A1*2,0)
  3. C=IF(CELL("type",A1)="v",A1*2,0)Correct
  4. D=IF(CELL("address",A1)="v",A1*2,0)
  5. E=IF(CELL("col",A1)="v",A1*2,0)

Answer: C. =IF(CELL("type",A1)="v",A1*2,0)

Official answer key verified. Detailed explanation coming soon.

Source: IBPS SO IT Officer Mains Memory Based 2023 (held 28 Jan 2024) - Adda247 · memory-based

← Q305View full paper (323 questions)Q307 →

Practice the full ibps-so 2023 paper

Timed test with all 323 questions, just like the real exam.

Start test