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. MEDIAN

B. AVERAGE

C. AVERAGEA

D. MODE

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

In Excel, which function is used to calculate the exponential growth?

A. GROWTH

B. EXP

C. TREND

D. LOG

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
GROWTH calculates exponential growth based on existing data. EXP returns e raised to a power, LOG is logarithm, TREND for linear trend.

This question belongs to: Computer Microsoft Office

Question #2

Which object query language is natively used behind the graphical interface layout to filter and extract records in MS Access tables?

A. HyperText Markup Language (HTML)

B. Structured Query Language (SQL)

C. Unified Modeling Language (UML)

D. Extensible Markup Language (XML)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
MS Access uses SQL (Structured Query Language) behind its graphical Query Design view to communicate with, query, and manipulate relational databases.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, what is the purpose of 'Action Buttons'?

A. To create a hyperlink to a specific slide

B. To insert a button that plays a sound

C. To navigate to another slide, file, or webpage, or run a program

D. To animate objects

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Action Buttons are predefined shapes that can be programmed to perform actions like navigation, running a program, playing a sound, etc. They are used for interactive presentations.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs