2.1.1076 Part 1 Section 18.17.7.356, ZTEST

a.   The standard does not specify how function arguments map to formula variables.

Office maps x-bar to sample mean and µ_0 to argument test-value.

b.   In the standard, there is no restriction on the value of sigma.

In Office, if sigma is less than or equal to 0, then #NUM! is returned.