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. NORM.DIST

B. NORM.S.DIST

C. Both A and B

D. PROB

Answer: Option C

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 Word, which of the following is used to add a caption to a figure?

A. References > Insert Caption

B. Insert > Caption

C. View > Caption

D. Review > Caption

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Caption is under References.

This question belongs to: Computer Microsoft Office

Question #2

What is the function of the keyboard shortcut Ctrl + Shift + G when editing an active document layout in MS Word?

A. Inserts a automated hyperlink field

B. Activates the gridlines alignment layer

C. Converts selected lowercase text blocks to uppercase

D. Opens the Word Count summary dialog box

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + G directly opens the Word Count statistics dialog box, providing real-time data on pages, words, characters, paragraphs, and lines.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what does the 'Format' property of a field do?

A. Restricts data entry to a pattern

B. Specifies the data type

C. Controls how data is displayed, not how it is stored

D. Sets the maximum number of characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Format property customizes display (e.g., date format).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs