What will be your formula if you are going to get the average of the - ProProfs Discuss Topics More Products More   + Ask Question

# 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

### Request 0Follow Share     Answer AnonymouslyAnswer Later Copy Link   #### M. Klose

M. Klose, Content Writer, Oakland 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

=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 Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel  Search for Google images Select a recommended image
Upload from your computer Cancel   