Question

What is the formula for calculating the average of cells C2 through C30?

Answer 1

For calculating the average of cells  C2 through C30 use the COMPUTE statement = AVERAGE(C2:C30).

Explanation:

• Excel a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions.
• Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.
• The AVERAGE function calculates the average of numbers provided as arguments.
• To calculate the average, Excel adds the numbers together and divides by the total number of values supplied. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
• To perform the average formula in Excel, enter the values, cells, or range of cells of which you're calculating the average in the format, =AVERAGE(number1, number2, etc.) or =AVERAGE(Start Value:End Value). This will calculate the average of all the values or range of cells included in the parentheses.