What is Z.TEST function in Excel? Z.TEST is one of Statistical functions in Microsoft Excel that returns the one-tailed P-value of a z-test.Go to the explanation section below to see how Z.TEST can be used in a formula to compute a two-tailed probability value. For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the…