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

B. MEAN

C. AVG

D. AVERAGEIF

Answer: Option A

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

Share Report

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

A. 2

B. 3

C. 1

D. 4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key to open the 'Print' dialog box in MS Office?

A. Ctrl + F12

B. Ctrl + Shift + P

C. Alt + P

D. Ctrl + P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + P opens the Print dialog or the Print backstage. Ctrl+Shift+P changes font size in Word? Actually it opens the Change Font Size box? Not standard. Alt+P is not Print. Ctrl+F12 opens Open dialog.

This question belongs to: Computer Microsoft Office