Hot Student Stories
top-5-grammar-and-spelling-checkers-to-rock-in-2019

In the formula =int(average(a1:a100)), which would occur first? ____ a. the integer portion of the value is extracted. b. the average of the integer value is calculated. c. the average of the values in the range a1:a100 is calculated. d. the average of the values in the range a1:a100 is added to the integer.

Chelsea Hayes

in Mathematics

follow
followin
1 answer
11 views

1 answer


Annie Barnes on February 9, 2019

The average of the values in the range A1:A100 is calculated. When you have something nested, in this case the calls to the function, but can also take place in computer programming, you have the result of a call to the function become the argument of a function separately. AVERAGE(A1:A100) will run first. Let's say that the result is 83.5 Then INT(83.5) will run, resulting in an 83 as the result in the cell of the nested function exists in.


Add you answer