What will be your formula if you are going to get the average of the - ProProfs Discuss
Topics
Products
Follow Us:

What will be your formula if you are going to get the average of the cells: A1=90 A2=85 A3=80 A4=75 A5=75?

This question is part of Basic quiz on Microsoft Excel Exam Quiz #2
Asked by Lorie, Last updated: Feb 22, 2020

+ Answer
Request

2 Answers

M. Klose

M. Klose, Content Writer, Oakland

Answered Jan 04, 2019

In an excel spreadsheet, many people get tired of having to calculate the costs of items to get an average. Instead of inputting everything, the person can type in a formula for a range of cells and have the computer program calculate the amount for each cell.

If you want to get the average of the cells for A1 through A5, you can put it into a formula. For instance, if A1 is 90, A2 is 85, A3 is 80, A4 is 75 and A5 is 75, then you would type into the cell an equal sign and the word average.

Then you need to put in the cells, so you would type A1 colon and then A5 to show that you want the average of these cells together.

 

lorie

Lorie

Answered Sep 29, 2018

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

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

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