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

Leave a Reply

Your email address will not be published. Required fields are marked *