Introduction to common functions of Excel?

Free consultation for quick registration of senior high school entrance examination: /xl/ In order to let everyone better understand the skills that need to be improved at work, Hunting Test Network has compiled the Introduction to Common Functions of Excel, hoping to help everyone. For more exam information, please pay attention to the post skills column of Hunting Test Network! Introduction to common functions of Excel: When we use Excel to make tables and sort out data, we often use its functions to statistically process the data in the tables. Today we introduce the following seven commonly used functions.

ABS: Find the absolute value of the parameter.

And: The AND operation returns logical FALSE, and only when all the results with parameters are logical "true" will it return logical "true", and vice versa.

Average: Find the arithmetic average of all parameters.

Column: Displays the column label value of the reference cell.

CONCATENATE: connect multiple character texts or data in a cell and display them in one cell.

COUNTIF: Counts the number of cells in the cell range that meet the specified conditions.

Date: the date when the specified value is given.

1, ABS function

Function name: ABS

Main function: find the absolute value of the corresponding number.

Usage format: ABS ($ NUMBER)

Parameter Description: Numbers represent cells that need absolute values or reference values.

Application example: If the formula =ABS(A2) is entered in cell B2, then whether a positive number (such as 100) or a negative number (such as-100) is entered in cell A2, cell B2 will display a positive number (such as100).

Special reminder: If the number parameter is not a numerical value, but some characters (such as a), the error value is "#VALUE!" Will be returned in B2. .

If you have questions about the senior high school entrance examination, don't know how to summarize the contents of the senior high school entrance examination website, and don't know the local senior high school entrance examination policy, click on the bottom to consult official website and get the review materials for free: /xl/