Question

4. Which function is used to find the maximum value in a set of values?​

Answer 1

Answer:

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.

Answer 2

Answer:

MAX function

Explanation:

• The MAX function in Excel returns the data's biggest numeric number.
• MAX does not take into account empty cells, logical values TRUE and FALSE, or text values.
• Choose a cell below or to the right of the numbers you're looking for the smallest number for.
• Click the arrow next to AutoSum on the Home tab, in the Editing group, then click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

#SPJ3