What will be your formula for obtaining the average of the following - ProProfs Discuss
Cancel
TopicsDown
Products Down
Follow Us:
FacebookTwitter
Advertisement

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

What will be your formula for obtaining the average of the following cells?
<br/>
A1=90<br/>
A2=85<br/>
A3=80<br/>
A4=75<br/>
A5=75<br/>

Change Image    Delete



This question is part of MICROSOFT EXCEL EXAM
Asked by Wyatt Williams, Last updated: Sep 18, 2020

+ Answer
Request
Question menu
Vote up Vote down

6 Answers

A. Cook

A. Cook

Find happiness in writing new things.

A. Cook
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.

upvote downvote
Reply 

John Adney

John Adney

John Adney
John Adney

Answered Dec 08, 2017

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

upvote downvote
Reply 

engmaroof

engmaroof

engmaroof
Engmaroof

Answered May 06, 2017

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

londafb

londafb

londafb
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



upvote downvote
Reply 

wbonhart1

wbonhart

wbonhart1
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
upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Oct 25, 2016

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

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.