Question

Which one of the following is accurate about COUNTIFS and FREQUENCY functions in excel?

1) COUNTIFS function counts the number of cells in a range that meet multiple criteria, while FREQUENCY function calculates how often values occur within a range.
2) COUNTIFS function calculates the sum of cells in a range that meet multiple criteria, while FREQUENCY function counts the number of cells that meet a single criterion.
3) COUNTIFS function counts the number of cells in a range that meet a single criterion, while FREQUENCY function calculates how often values occur within a range.
4) COUNTIFS function calculates the sum of cells in a range that meet a single criterion, while FREQUENCY function counts the number of cells that meet multiple criteria.

Answer 1

The COUNTIFS function counts cells that meet multiple criteria, while the FREQUENCY function calculates the occurrence of values within a range in Excel.

Step-by-step explanation:

The first option is accurate about COUNTIFS and FREQUENCY functions in Excel. COUNTIFS function counts the number of cells in a range that meet multiple criteria. For example, you can use COUNTIFS to count the number of students who scored above a certain grade and attended school on a specific day. On the other hand, FREQUENCY function calculates how often values occur within a range. It can be used to determine the frequency distribution of a set of data values.