Question

_____and _____ functions used to find the minimum and maximum value in a range.​

Answer 1

Answer:

To find the range, subtract lowest value from highest value. (In maths)

Explanation:

Highest term - Lowest term

Answer 2

Min and Max functions used to find the minimum and maximum value in a range.

• The data or details are maintained in table form in an excel sheet. In Excel, there are a lot of rows and columns.
• The Min function can be used to determine the minimum value inside a specific range.
• The Min function displays the smallest value in that specific range and also defines a range.

• The available Max function can be used when a maximum value needs to be found.
• syntax for the MIN() and MAX() functions
• The syntax for MIN() and MAX() is the same.

=MIN(value1,value2,value3,...)

=MAX(value1,value2,value2,...)

• Basically, you pass a collection of values to either function, and depending on which function you are using, the function determines the minimum or maximum number.
• You'll see that neither of them is interested in anything that isn't a number. Several related functions, such MINA() and MAXA(), also consider text numbers and logical values (such as TRUE/FALSE). You'll see that they frequently result in the same thing while having the same syntax. syntax for the MIN() and MAX() operations
• Both the MIN() and MAX() functions have the same syntax.

=MIN (value1,value2,value3,...)

=MAX(value1,value2,value2,...)

Hence, Min and Max functions used to find the minimum and maximum value in a range.

#SPJ3