Computer question from Jr. Assistant exam, 2026 by JKSSB
In Microsoft Excel, student scores are listed in column B (Math) and column C (Science). Which formula correctly counts the number of students who scored ≥ 80 in Math and ≥ 90 in Science? (≥ means greater than or equal to
Last updated Jun 24, 2026
Correct Answer:
Option A —
=COUNTIFS(B2:B10,">=80",C2:C10,">=90")
In Excel, the COUNTIFS function is the standard tool for this task because it is built to handle multiple conditions at once.
Why Option A works
The formula breaks down into these logical steps:
Search Area 1 (B2 to B10): It looks at the Math scores.
Condition 1 (Greater than or equal to 80): It identifies everyone who scored at least 80.
Search Area 2 (C2 to C10): It looks at the Science scores.
Condition 2 (Greater than or equal to 90): It identifies everyone who scored at least 90.
The function only counts a row if both conditions are true at the same time.
A Note on the Syntax
In Excel formulas, when you use logical tests like "at least" or "more than," you must enclose those instructions in double quotation marks (for example, ">=80"). Without the quotes, Excel will not understand the instruction and will return an error.
Why the others are less ideal
Option B: This function is usually used for multiplying lists of numbers. While it can be "forced" to count things, it requires a much more complex setup than what was written.
Option C: This is an "Array Formula." These are often harder to write and can slow down your spreadsheet if you have a lot of data. Additionally, the way it was written in the quiz is not the correct way to structure that specific command.
Answer verified by Quintessence Classes faculty — Karan Nagar, Srinagar.
