Calculate an average
BeginnerCalculating an average manually means summing all values and dividing by the count. For example, the average of 1, 2, 3, 4, and 5 is =SUM(1,2,3,4,5)/5. The AVERAGE function does this in one step:
=AVERAGE(1, 2, 3, 4, 5)
Just like SUM, AVERAGE works with cell references. Instead of typing numbers directly, you can reference cells like A1 or C4.
Your task
Use the AVERAGE function in cell A7 to calculate the average of the numbers in cells A1 through A5.
Note: Function names in Excel are always written in uppercase (SUM, AVERAGE, COUNT). That's just the convention.
Need some help?
Calculate an average
BeginnerCalculating an average manually means summing all values and dividing by the count. For example, the average of 1, 2, 3, 4, and 5 is =SUM(1,2,3,4,5)/5. The AVERAGE function does this in one step:
=AVERAGE(1, 2, 3, 4, 5)
Just like SUM, AVERAGE works with cell references. Instead of typing numbers directly, you can reference cells like A1 or C4.
Your task
Use the AVERAGE function in cell A7 to calculate the average of the numbers in cells A1 through A5.
Note: Function names in Excel are always written in uppercase (SUM, AVERAGE, COUNT). That's just the convention.