In Excel, which function returns the average of absolute deviations of data points from their mean? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the average of absolute deviations of data points from their mean?

A. STDEV()

B. VAR()

C. AVERAGE()

D. AVEDEV()

Answer: Option D

Solution (By JKSSB Mock Tests)

AVEDEV calculates average absolute 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 MS Access, which type of query makes a new table?

A. Append query

B. Select query

C. Make-Table query

D. Update query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Make-Table creates new table from query results.

This question belongs to: Computer Microsoft Office

Question #2

Which keyboard shortcut is used to select all content in a document?

A. Ctrl + Shift + A

B. Ctrl + S

C. Ctrl + A

D. Ctrl + Alt + A

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + A selects all. Ctrl + S saves, Ctrl + Shift + A toggles all caps.

This question belongs to: Computer Microsoft Office

Question #3

What is the maximum number of columns that can be inserted in a single Excel worksheet (version 2016 and later)?

A. 1048576

B. 256

C. 16384

D. 65536

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Excel 2007 and later versions support 16,384 columns (up to column XFD) and 1,048,576 rows. Therefore, the correct maximum columns is 16384.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs