Answer:
The correct answer to the following question will be "NORM.S.INV".
Explanation:
- The NORM.IN.V function in Excel determines the opposite of the Cumulative Standard Distribution Function for just a value of x which is given, and the standard deviation and mean of the distribution provided. The probability of NORMINV(mean, probability, standard deviation).
- In Excel 2010, the standard. S. Inv function is new and is therefore not easily accessible in Excel's earlier versions.
Therefore, NORM.S.INV is the right answer.
Well knowing how the government is with security id go with A. as it makes a lot of sense unlike B and D and if they were looking for software the question would mention it