💻 Computer Science

In Excel, SUMIF function:

A Sums all cells
B Sums cells matching a condition
C Counts cells
D Averages cells

✓ Correct Answer: Option B

SUMIF sums cells that meet a specified condition.

💡 Why is B) the correct answer?

The correct answer to the question "In Excel, SUMIF function:" is Option B: Sums cells matching a condition.

The other options — A) Sums all cells, C) Counts cells, D) Averages cells — are incorrect for this Computer Science question. As explained above: SUMIF sums cells that meet a specified condition.

📚 About This Computer Science Practice Question

This 2-level Computer Science question from the MS Excel topic is part of One Paper Preparation's free exam preparation library. Each question includes the correct answer and a detailed explanation to help you understand the underlying concept, not just memorize the answer.

How to use this page: Read the question above, consider all four options (A through D), then check the highlighted correct answer and explanation. For active timed practice, start a free Computer Science practice test or use flashcards for spaced repetition review.

Related Computer Science Questions