The Excel function of ________ is used to find the largest value in a range of cells.Group of answer choicesSUM(range)COUNT(range)MAX(range)COUNTIF(range, criteria)

The Excel function used to find the largest value in a range of cells is ________. The available options are:

1. SUM(range)
2. COUNT(range)
3. MAX(range)
4. COUNTIF(range, criteria)

To determine the correct answer, we need to consider the purpose of each function:

1. SUM(range) calculates the sum of all the values in a given range.
2. COUNT(range) counts the number of cells that contain numerical values in a given range.
3. MAX(range) identifies the largest value within a range of cells.
4. COUNTIF(range, criteria) counts the number of cells in a range that meet a specific criteria.

Based on the given options, the correct answer is MAX(range) since it specifically finds the largest value in a range of cells.