Returns the one-tailed probability-value of a z-test

=ZTEST(array, x, [sigma])

=ZTEST(A2:A10, 42, 1.5)