info@jobexams.pk

Which function is used to calculate the average in Excel?

In Microsoft Excel, the AVERAGE() function is used to calculate the arithmetic mean of a group of numbers. It adds all the numbers together and then divides the total by the count of values.
For example, if you have the numbers... Read More

1 MS OFFICE MCQS

Which function is used to calculate the average in Excel?

  • ADD()
  • SUM()
  • COUNT()
  • AVERAGE()
Correct Answer: D. AVERAGE()

Detailed Explanation

In Microsoft Excel, the AVERAGE() function is used to calculate the arithmetic mean of a group of numbers. It adds all the numbers together and then divides the total by the count of values.


For example, if you have the numbers 10, 20, and 30 in cells A1 to A3, the formula =AVERAGE(A1:A3) will return 20 because (10 + 20 + 30) ÷ 3 = 20.

Related Questions

MS Office MCQs
In Excel to join two cells we use:
0 comments
View
MS Office MCQs
In Microsoft PowerPoint, the ___ view is used to automatically play slides during a presentation.
0 comments
View
MS Office MCQs
Autocorrect is used to replace ___ words in a document?
0 comments
View
MS Office MCQs
What is the function of "Ctrl + Shift + N" in MS Word?
0 comments
View

Discussion

Thank you for your comment! Our admin will review it soon.
No comments yet. Be the first to comment!

Leave a Comment

Question Categories
General Knowledge Category MCQ'S
Computer Category MCQ'S
Chemistry Category MCQ'S
Pak Departmental Laws & Rules MCQs