Chirkut.বাংলা

MCQ practice · SSC ICT Board questions · Chapter 4: My Writings and Accounts

Cumilla Board 2023

In the table, which formula applies in cell D for the price of rice?

Think it through first, then pick an option.

  1. a =B2*C2
  2. b =B3* C3
  3. c =B2*C3
  4. d = B₂×C₂
Answer and explanation

Correct answer: a =B2*C2

Rice is row 2: rate B2 times quantity C2 gives the cost.

Why the other options are wrong

  • b =B3* C3: Row 3 is lentil, not rice, so it does not fit this question; the right answer here is =B2*C2.
  • c =B2*C3: This multiplies the rice rate by the lentil quantity.
  • d = B₂×C₂: × is not the spreadsheet multiplication sign; * is needed.