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

In Excel, which function returns the average of absolute deviations of data points from their mean?
A. AVERAGE()
B. VAR()
C. STDEV()
D. AVEDEV()
Answer: Option D
Solution (By JKExamLibrary)
AVEDEV calculates average absolute deviation.

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 PowerPoint, which option allows you to apply a consistent look to all slides, including fonts, colors, and effects?
A. Template
B. Style
C. Layout
D. Theme

Correct Answer: Option D


Explanation:
A Theme is a set of design elements including colors, fonts, and effects that can be applied to all slides. Template is a file that includes layout and content, Layout is a slide arrangement, Style is formatting.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the shortcut to check spelling and grammar in MS Word?
A. Shift + F7
B. F7
C. Ctrl + F7
D. Alt + F7

Correct Answer: Option B


Explanation:
F7 runs the Spelling & Grammar check. Shift+F7 is thesaurus.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which of the following is a type of animation in PowerPoint?
A. Slide Transition
B. Motion Paths
C. Slide Master
D. Design Template

Correct Answer: Option B


Explanation:
Motion Paths are animation effects for objects. Transition is not an animation category.

This question belongs to: Computer Microsoft Office