Which function in Microsoft Excel is used to count items in a cell range?

Which function in Microsoft Excel is used to count items in a cell range?

  • (A) COUNT
  • (B) AVG
  • (C) SUM
  • (D) MAX
  • In Microsoft Excel, the suitable function to determine how many items are within a range of cells is: (A) COUNT.
  • COUNT: Counts only cells with numeric values.
  • COUNTA: Counts cells not empty for any value (such as text, number, etc.).
  • COUNTIF: Counts the number of cells based on one criteria only.
  • Other choices describe different types of calculations included:
  • AVG (AVERAGE) gives a value that is an average of other like values in one range of cells.
  • SUM adds all of the values together.
  • MAX returns the highest number found in a range of cells.
Facebook
WhatsApp
Related MCQs:

 ‘NATO’ is an abbreviation of:

  • (A) North Atlantic Treaty Organization
  • (B) Non-Aligned Treaty Organization
  • (C) Non-Aligned Trading Organization
  • (D) North American Transport Organization

You May Like

Comment

You cannot copy content of this page

Scroll to Top