| 1. |
(e) What will the following functions return when executed:(i) Math.max (-7, Math.min(-2,-9))(ii) Math.ceil(32.17) (iii) Math.floor(-6.85) |
|
Answer» Given : (i) MATH.max (-7, Math.min(-2,-9)) (ii) Math.ceil(32.17) (iii) Math.floor(-6.85) To Find : What is output / value returned by function Solution: (i) Math.max (-7, Math.min(-2,-9)) Math.min(-2,-9) = - 9 ( minimum of two ) Math.max (-7, -9) Math.max (-7, -9) = -7 ( maximum of two ) Math.max (-7, Math.min(-2,-9)) = - 7 (ii) Math.ceil(32.17) Math. ceil() function ALWAYS rounds a number up to the next largest integer. => Math.ceil(32.17) = 33 (iii) Math.floor(-6.85) Math.floor () function returns greatest integer LESS than or equal to => Math.floor(-6.85) = -7 Learn More: i am LOCATED near top of the excel window, below the quick access ... Excel would evaluate the formula, = 20*10/5*8 and return this ... |
|