|
Question 22: Which formula includes a nested function? |
||||||||||||
|
Answer:
|
||||||||||||
|
|
|
The answer is C.
Using Nested formula helps to make formulas, one inside the other, so that one formula holds the result of another formula.
Therefore below formula is a nested formula
=ROUND(MIN(A2:A7)+E1)
Question 22: Which formula includes a nested function? Answer: A. =SUM(H3*A7)+AVERAGE(B2:B6) B. =MAX(A5, A9, D12:D15) C....