Skip to content

Menu

Game modes

Account

← Question library
GK QUESTION#1303

In MS Excel, which function is used to count the number of cells within a specified range that satisfy a given condition?

  1. A=COUNTIF(A1:A10, ">10")Correct answer
  2. B=COUNTBLANK(A1:A10)
  3. C=COUNT(A1:A10)
  4. D=SUMIF(A1:A10, ">10")
Show AnswerHide Answer

Answer

A. =COUNTIF(A1:A10, ">10")

Show ExplanationHide Explanation

Explanation

=COUNTIF(A1:A10, ">10"). COUNTIF counts the number of cells in a range that satisfy a given condition. COUNTBLANK → counts empty cells. COUNT → counts numeric cells only. SUMIF → adds values that meet a condition.

Sign in to report a question issue

Explore this topic

In Microsoft Word, the Mail Merge Wizard is located under the _________ tab.In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula…Consider the following statements about MS PowerPoint: 1. The slide number can be added to each slide of…