In Excel, which function is used to calculate the arithmetic mean of a set of numbers? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the arithmetic mean of a set of numbers?

A. MODE

B. AVERAGE

C. AVERAGEA

D. MEDIAN

Answer: Option B

Solution (By JKSSB Mock Tests)

AVERAGE is the arithmetic mean. AVERAGEA includes logical values, MEDIAN is middle value, MODE is most frequent.

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

What is the shortcut key to open the 'Font' dialog box in MS Word?

A. Alt + O, F

B. Ctrl + D

C. Ctrl + Shift + F

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + D opens the Font dialog box in Word. Ctrl + F opens Find, Ctrl+Shift+F opens the Font dialog as well (but less common), Alt+O,F is menu navigation. However, Ctrl+D is the standard shortcut.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, what is the purpose of 'Section Break (Next Page)'?

A. Starts a new section on the same page

B. Inserts a page break only

C. Ends the document

D. Starts a new section on the next page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Next Page section break starts a new section on a new page.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following is a type of slide transition in PowerPoint?

A. Grow/Shrink

B. Fade

C. Spin

D. Fly In

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Fade is a transition. Fly In, Spin, Grow/Shrink are animations.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs