My Learning Cart
?
Categories
Account

In Excel, which function would you use to find the average of a range of cells?

₹0.0
Login to Download
  • 📥 Instant PDF Download
  • ♾ Lifetime Access
  • 🛡 Secure & Original Content

What’s inside this PDF?

Question: In Excel, which function would you use to find the average of a range of cells?

Options:

  1. =AVG()
  2. =MEAN()
  3. =AVERAGE()
  4. =SUM()/COUNT()

Correct Answer: =AVERAGE()

Solution: 

The function used to find the average of a range of cells in Excel is =AVERAGE().

In Excel, which function would you use to find the average of a range of cells?

Practice Questions

Q1
In Excel, which function would you use to find the average of a range of cells?
  1. =AVG()
  2. =MEAN()
  3. =AVERAGE()
  4. =SUM()/COUNT()

Questions & Step-by-Step Solutions

In Excel, which function would you use to find the average of a range of cells?
  • Step 1: Open your Excel spreadsheet where you want to find the average.
  • Step 2: Click on the cell where you want the average to appear.
  • Step 3: Type =AVERAGE( to start the function.
  • Step 4: Select the range of cells you want to average by clicking and dragging over them.
  • Step 5: Close the parentheses by typing ) after the range.
  • Step 6: Press Enter on your keyboard to see the average result.
  • AVERAGE Function – The AVERAGE function in Excel calculates the mean of a specified range of cells.
Soulshift Feedback ×

On a scale of 0–10, how likely are you to recommend The Soulshift Academy?

Not likely Very likely
Home Practice Performance eBooks