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

In PowerPoint, 'Handout Master' allows you to set the layout for:

A. Printed handouts with multiple slides per page

B. Slide transitions

C. Slide thumbnails

D. Speaker notes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Handout Master formats printed handouts.

This question belongs to: Computer Microsoft Office

Question #2

To go to the previous page in a Word document, press:

A. Page Up

B. Ctrl + Page Up

C. Alt + Page Up

D. Ctrl + Up Arrow

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, to set a picture as the background of a slide, use:

A. Design -> Format Background -> Picture or texture fill

B. Right-click slide -> Background -> Picture

C. View -> Slide Master -> Insert Picture

D. Insert -> Picture -> Set as Background

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Format Background from Design tab allows picture fill.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs