Question $6(1$ point$)$

What function should be used in MS Excel to calculate a $p-$value for a lower$-$tail hypothesis test?

a$)1-$ NORM.S$.$DIST

b$)$ COUNTIF

C$)$ NORM.S$.$DIST

d$)$ RAND