Computer Level 2 examination is one of the four grades of the national computer grade examination, sponsored by the examination center of the Ministry of Education, which mainly examines the basic knowledge of computers, the basic skills of programming with high-level computer languages and debugging on computers. The following are the test sites of computer level 2 excel compiled by me. Welcome to share.

Functions commonly used in Excel include summation function, average function, counting function, IF function, VLOOKUP function, etc.

The application of each function is described below.

(1) Introduction of Common Functions

① absolute value function ABS ($ NUMBER)

Main function: find the absolute value of parameters.

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

Application examples: =ABS(-2) means to find the absolute value of -2;

=ABC(A2) means to find the absolute value of the value in cell A2.

② MAXimum function Max (number 1, number 2 ...)

Main function: find out the maximum value of each parameter.

Parameter Description: There must be at least one parameter, which must be a number and can contain up to 255 parameters.

Application example: If A2: A4 contains numbers 3, 5 and 6, then:

= max (A2: A4) The return value is 6;

= max (a2: a4, 1, 8, 9, 10), and the return value is 10.

Note: If there is a text or logical value in the parameter, it will be ignored.

③ Minimum value function MIN (number 1, number 2 .........)

Main function: find the minimum value of each parameter.

Parameter Description: There must be at least one parameter, which must be a number and can contain up to 255 parameters.

Application example: If A2: A4 contains numbers 3, 5 and 6, then:

= min (A2: A4) The return value is 3;

= min (a2: a4, 1, 8, 9, 10), and the return value is 1.

Note: If there is a text or logical value in the parameter, it will be ignored.

④ ROUNDing function Round (number, Num_digits)

Main function: round the number of parameters according to the specified number of digits Num_digits.

Parameter Description: Parameter # indicates the number of people who want four rooms and five rooms; The parameter Num_digits indicates the number of decimal places reserved.

Application example: = round (227.568) gets 227.57.

⑤ TRUNC (number, [digit]).

Main function: according to the specified digit Num_digits, the parameter number is divided into four parts and five people.

Parameter Description: Truncate the decimal part of parameter # and return an integer; The parameter Num_digits is a precision number, and the default value is 0.

Application example: =TRUNC(227.568) gets 227.

=TRUNC(-227.568) returns -227.

⑥ downward rounding function int ($ NUMBER)

Main function: Rounds the parameter Number down to the nearest integer, and Number is a required parameter.

Parameter Description: Number indicates the value to be rounded or the referenced cell.

Application example: =INT(227.568) returns 227;

=INT(-227.568) gives -228. ;