Exploring Excel simple formulas / functions such as SUM, AVERAGE, MAX, and MIN

Excel offers several built-in functions to perform various calculations on your data. Here are explanations of some commonly used Excel simple formulas:

1. SUM: The SUM function adds up all the numbers in a range of cells. Syntax: =SUM(number1, [number2], ...)
   • number1, number2, etc. are the cell references or ranges you want to add together.
   Example: =SUM(A1:A10) will add up all the numbers in cells A1 through A10.
2. AVERAGE: The AVERAGE function calculates the average of the numbers in a range of cells. Syntax: =AVERAGE(number1, [number2], ...)
   • number1, number2, etc. are the cell references or ranges for which you want to calculate the average.
   Example: =AVERAGE(B1:B10) will calculate the average of the numbers in cells B1 through B10.
3. MAX: The MAX function returns the largest value from a range of cells. Syntax: =MAX(number1, [number2], ...)
   • number1, number2, etc. are the cell references or ranges from which you want to find the maximum value.
   Example: =MAX(C1:C10) will return the largest value from cells C1 through C10.
4. MIN: The MIN function returns the smallest value from a range of cells. Syntax: =MIN(number1, [number2], ...)
   • number1, number2, etc. are the cell references or ranges from which you want to find the minimum value.
   Example: =MIN(D1:D10) will return the smallest value from cells D1 through D10.

These are just a few examples of simple formulas you can use in Excel. Excel offers a wide range of functions for various purposes, from basic arithmetic to complex statistical analysis. You can explore the “Formulas” tab on the Excel ribbon to discover and use many more functions for your specific needs.