In Excel, which function is used to calculate the standard deviation of a sample? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the standard deviation of a sample?

A. STDEV.S

B. Both A and C

C. STDEV.P

D. STDEV

Answer: Option B

Solution (By JKSSB Mock Tests)

STDEV.S calculates sample standard deviation; STDEV is the older version that also does sample. STDEV.P is population standard deviation.

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

Share Report

In MS Access, a select query that groups records and calculates sums, averages, etc., uses:

A. Totals (Group By) row

B. Sort row

C. Show row

D. Criteria row

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Clicking the Totals button (Σ) adds the Total row for grouping and aggregating.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, which key is used to extend selection in combination with arrow keys?

A. Ctrl

B. Ctrl + Shift

C. Alt

D. Shift

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift extends selection.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to insert a comment in MS Word?

A. Ctrl + Shift + M

B. Ctrl + M

C. Ctrl + Alt + M

D. Alt + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Alt + M inserts a comment. Ctrl + M indents a paragraph in Word. The others are not standard for comments.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs