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

In Excel, which function is used to calculate the probability of a given z-score?
A. NORM.DIST
B. NORM.S.DIST
C. PROB
D. Both A and B
Answer: Option D
Solution (By JKExamLibrary)
NORM.DIST and NORM.S.DIST both calculate normal distribution probabilities (standard and non-standard).

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Access, the default value of the 'Required' property for a field is:
A. Maybe
B. No
C. Null
D. Yes

Correct Answer: Option B


Explanation:
By default, fields are not required; Required = No.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which component of an MS Access window workspace displays all available database objects like tables, queries, reports, and forms for double-click retrieval?
A. Status Ribbon bar
B. Navigation Pane
C. Quick Access Panel
D. Properties Sheet window

Correct Answer: Option B


Explanation:
The Navigation Pane on the left side of the screen provides central access to open, edit, or delete any object within the database file.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the function of the keyboard shortcut Ctrl + W across Microsoft Office applications like Word and Excel?
A. Exits the entire parent software application system
B. Saves the file and opens a blank document layout
C. Launches the web browser lookup helper tool
D. Closes the currently active document or workbook window

Correct Answer: Option D


Explanation:
Ctrl + W closes the currently active file, document, or workbook window without closing the main parent application shell. Alt + F4 exits the entire application.

This question belongs to: Computer Microsoft Office