Recall & Review
beginner
What does the AVERAGE function do in Excel?
The AVERAGE function calculates the mean (average) of a group of numbers by adding them together and dividing by how many numbers there are.
Click to reveal answer
beginner
Write the formula to find the average of numbers in cells A1 to A5.
Use
=AVERAGE(A1:A5) to calculate the average of values in cells A1 through A5.Click to reveal answer
beginner
What happens if the AVERAGE function includes empty cells or cells with text?
Empty cells and cells with text are ignored by the AVERAGE function. Only numeric values are used in the calculation.
Click to reveal answer
intermediate
How does AVERAGE handle cells with zero values?
Cells with zero are counted as numbers and included in the average calculation, which can lower the average.
Click to reveal answer
intermediate
Can AVERAGE function handle non-adjacent cells? Give an example.
Yes, you can average non-adjacent cells by listing them separated by commas, like
=AVERAGE(A1, A3, A5).Click to reveal answer
What is the result of
=AVERAGE(2, 4, 6)?✗ Incorrect
The average is (2 + 4 + 6) ÷ 3 = 12 ÷ 3 = 4.
Which cells will be ignored by the AVERAGE function?
✗ Incorrect
AVERAGE ignores empty cells and cells containing text, only numbers are counted.
How do you write a formula to average cells B1, B3, and B5?
✗ Incorrect
Use commas to separate non-adjacent cells: =AVERAGE(B1, B3, B5).
If cells A1=5, A2=empty, A3=10, what is =AVERAGE(A1:A3)?
✗ Incorrect
Empty cell A2 is ignored, average is (5 + 10) ÷ 2 = 7.5.
What effect does including zero values have on the AVERAGE function?
✗ Incorrect
Zeros count as numbers and lower the average because they add to the total but also increase the count.
Explain how the AVERAGE function works and how it treats different types of cells.
Think about what numbers are counted and what are skipped.
You got /3 concepts.
Describe how to use the AVERAGE function with both adjacent and non-adjacent cells.
Consider how you select cells in Excel formulas.
You got /3 concepts.