What will be your formula for obtaining the average of the following cells: A1=90, A2=85, A3=80, A4=75, A5=75?

Change Image Delete

Asked by Wyatt Williams, Last updated: Dec 13, 2024

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link

6 Answers

A. Cook, English Professor, M.A, Ph.D, Kentucky

Answered Mar 07, 2019

The formula to use in obtaining the average of the cells listed above in Microsoft excel is = average (a1:a5).
To get average, you add the values of all the items in the cells divided by the number of cells
= (a1 +a2+ a3 +a4+ a5)/ 5
Therefore, the two possible formulas of obtaining average in Microsoft excel are:
= average (a1:a5).
= (a1 +a2+ a3 +a4+ a5)/ 5
Hope this helps.

John Adney

Answered Dec 08, 2017

=AVERAGE(A1:A2),=(A1+A2+A3+A4+A5)/5,=average(a1:a5),=(a1+a2+a3+a4+a5)/5

Engmaroof

Answered May 06, 2017

To get the average of range a1:a5 the formula should be
= average(a1:a5)

Londafb

Answered Mar 01, 2017

To average, you add the numeric values of all the items and then divide by the NUMBER OFITEMS added.
* Capitalization is not an issue...

POSSIBLE ANSWERS TO THIS QUESTION

=(A1+A2+A3+A4+A5)/5
=AVERAGE(a1:a5)

I got the question right, but my answer was marked "wrong".

My answer was, =(A1+A2+A3+A4+A5)/5

Wbonhart

Answered Nov 29, 2016

My answer was =average(a1:a5). I did not use uppercase letters. You do not have to use uppercase letters in Excel for the formula to work. So my answer is not wrong