Relative reference, absolute reference and mixed reference: Relative reference is calculated based on the relative position of the target cell and the cell where the calculation object is located (the relative position remains unchanged); when you need to circle the range, add "$" under the English half-angle to the rows and columns of the range to lock, which is an absolute reference; when only rows or columns are locked, it is called mixed reference

Select the range, enter the name you want to define in the name box in the upper left corner, and press Enter to complete the definition.

Selected content scope, (Formula) tab, (Defined name) group, Create from selected content

(Formula) Tab, (Defined Name) Group, Name Manager

Financial functions, date and time functions, mathematical and trigonometric functions, statistical functions

Find and reference functions, database functions, text functions, logic functions, information functions

Engineering functions, compatibility functions, cube functions, web functions

SUM, SUMIF, SUMIFS

AVERAGE, AVERAGEIF, AVERAGEIFS

COUNT (only count the number of cells [right-aligned]), COUNTA (counting the number of non-empty cells), COUNTIF (counting the number of cells that meet the conditions in the cell), COUNTIFS (counting the number of cells that meet multiple conditions in the cell)

ABS (absolute value), INT (rounded down: the largest integer smaller than the original number), ROUND (rounded by rounding function, after all, the parameters represent the decimal digits after rounding), TRUNC (turned directly after the parameter is cut off, not rounded), CEILING (rounded up: the smallest integer larger than the original number)

CONCATENATE (used to concatenate two or more characters. Note that you should add an underscore such as (A1,"_", A2) in the middle of the two cell selection or use hyphens such as (A1&"_"&A2)), MID (such as MID (A1,m,n) refers to taking n characters from the mth character from the left to the right), LEFT (such as left(A1,n) means taking the first n strings in the A1 cell from the left), RIGHT (such as right(A1,n) means taking the first n strings in the A1 cell from the right), TRIM (removing the spaces at the beginning and ends of the string in the cell), LEN (calculating the length of the string in the cell)

NOW (such as now() can return the date and time of the current system), TODAY (such as now() can return the date of the current system), YEAR (picking the year from the cell representing the date), MONTH (picking the month from the cell representing the date), DAY (picking the date from the cell representing the date), WEEKDAY (calculates the day in the selected cell representing the week)

RANK (RANK.EQ and RANK.AVG) (ranks data ascending and descending order)

MAX,MIN

VLOOKUP (First: find the column where the data object is located; second: find the column where the data object is located is the first column in the range, and the data to be searched is the last column; third: enter 6 in the column of the framed range, such as the sixth column; fourth: exact match or approximate match, generally exact match, that is, FALSE)

IF (If the parameter one condition is X<100, parameter two is not passed, and parameter three bits pass, that means that the display result is parameter two, and if the condition is not met, it is parameter three)