In Excel, which of the following is a valid function to find the average of numbers? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which of the following is a valid function to find the average of numbers?

A. AVERAGEIF

B. MEAN

C. AVERAGE

D. AVG

Answer: Option C

Solution (By JKSSB Mock Tests)

The AVERAGE function calculates the arithmetic mean. AVG is not a function, MEAN is not, AVERAGEIF averages based on a condition.

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 to print a document in MS Word?

A. Ctrl + F2

B. Alt + P

C. Ctrl + P

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+P and Ctrl+F2 both open Print.

This question belongs to: Computer Microsoft Office

Question #2

Which feature in MS Excel automatically fills adjacent cells when it recognizes a clear data pattern, such as combining first and last names?

A. Consolidate

B. Flash Fill

C. AutoCorrect

D. Data Validation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Flash Fill recognizes structural text patterns and completes data entry down an entire column automatically.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the function =NETWORKDAYS(start, end) returns:

A. Total days between dates

B. Number of calendar days

C. Number of working days (excluding weekends) between dates

D. Days including holidays

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs