An Excel function is a predefined formula that performs calculations with specific values in a specific order. All spreadsheet programs include common functions that you can use to quickly find the sum, average, count, maximum, and minimum values of a range of cells. In order to use functions properly, you need to understand the different parts of functions and how to create parameters to calculate values and cell references.
Watch the video below to learn about functions in Excel.
Components of a function
In order to work properly, functions must be written in a specific way, which is called syntax. The basic syntax for a function is an equals sign (=), a function name (such as SUM), and one or more parameters. Parameters contain the information you want to calculate. The function in the example below will add the values of cells A1:A20.
parameter handling
Parameters can refer to single cells and ranges of cells, and must be enclosed in parentheses. You can include one parameter or multiple parameters, depending on the syntax required by the function.
For example, the function =AVERAGE(B1:B9) will calculate the average of the values in the cell range B1:B9. This function contains only one parameter.
Multiple parameters must be separated by commas. For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments.
Excel common functions:
SUM: This function adds all the values of the cells in the parameter.
AVERAGE: This function determines the average of the values contained in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the parameter.
COUNT: This function counts the number of cells with numeric data in the argument. This feature is useful for quickly counting items in a cell range.
MAX: This function determines the highest cell value contained in the argument.
MIN: This function determines the lowest cell value contained in the argument.
Excel function usage tutorial
An Excel function is a predefined formula that performs calculations with specific values in a specific order. All spreadsheet programs include common functions that you can use to quickly find the sum, average, count, maximum, and minimum values of a range of cells. In order to use functions properly, you need to understand the different parts of functions and how to create parameters to calculate values and cell references.
Watch the video below to learn about functions in Excel.
Components of a function
In order to work properly, functions must be written in a specific way, which is called syntax. The basic syntax for a function is an equals sign (=), a function name (such as SUM), and one or more parameters. Parameters contain the information you want to calculate. The function in the example below will add the values of cells A1:A20.
parameter handling
Parameters can refer to single cells and ranges of cells, and must be enclosed in parentheses. You can include one parameter or multiple parameters, depending on the syntax required by the function.
For example, the function =AVERAGE(B1:B9) will calculate the average of the values in the cell range B1:B9. This function contains only one parameter.
Multiple parameters must be separated by commas. For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments.
Excel common functions:
SUM: This function adds all the values of the cells in the parameter.
AVERAGE: This function determines the average of the values contained in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the parameter.
COUNT: This function counts the number of cells with numeric data in the argument. This feature is useful for quickly counting items in a cell range.
MAX: This function determines the highest cell value contained in the argument.
MIN: This function determines the lowest cell value contained in the argument.
Related:cheap office key