Question

) Write the purpose of the following functions in Excel-
(i) MAX
(ii) ROUND​

Answer 1

Answer:

(i)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.

(ii)The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.