In Excel, which function is used to calculate the probability of a given z-score? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the probability of a given z-score?

A. Both A and B

B. PROB

C. NORM.S.DIST

D. NORM.DIST

Answer: Option A

Solution (By JKSSB Mock Tests)

NORM.DIST and NORM.S.DIST both calculate normal distribution probabilities (standard and non-standard).

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS Word, which type of break starts a new section on the same page?

A. Odd Page section break

B. Next Page section break

C. Continuous section break

D. Even Page section break

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Continuous break starts a new section without a page break.

This question belongs to: Computer Microsoft Office

Question #2

To quickly minimize the ribbon in MS Office, press:

A. F1

B. Alt + F1

C. Shift + F1

D. Ctrl + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F1 collapses/expands the ribbon.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the 'Evaluate Formula' feature is found under which tab?

A. Review

B. Formulas

C. View

D. Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Evaluate Formula is in Formulas tab, Formula Auditing group.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs