answersLogoWhite

0


Best Answer

It determines the cell entry with the greatest value.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: The MAX function determines the value in a selected range of values?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Domain and range of a function?

The domain of a function determines what values of x you can plug into it whereas the range of a function determines the values that are your results. Therefore, look at the y-axis if you want to determine the range of a function and look at the x-axis if you want to determine the domain.


The ____ function determines the lowest number in a range?

The MIN Function determines the lowest number in a range


What are the domain and range of the function?

The domain of a function is the set of values for which the function is defined.The range is the set of possible results which you can get for the function.


How can you find the domain and range of a function?

The domain is a subset of the values for which the function is defined. The range is the set of values that the function takes as the argument of the function takes all the values in the domain.


What is the difference between high and maxinum in Excel?

Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.


Can the range repeat in a function?

The range in a function is the y values, and yes it can repeat


Does the total function sum the numbers in the specified range and then divides the sum by the number of nonzero cells in the range?

To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.


What displays the lowest values for a range of values in excel?

The MIN function.


What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function


What determines the arithmetic mean of a range?

You need to have all the values within the range to calculate the arithmetic mean .


The set of output values of a function or relation?

The set of output values of a function or relation is the range


The values that you use with a function are called?

values used with a function are called