【 Weak current College 】 Office, clerk, finance will (1)

Word trick:
First, enter the three "=", carriage return, get a double-line;
Second, enter the three "~", carriage return, get a wavy line;
3. Enter the three "*" or "-" or "#", carriage return, how many surprises;
In the cell, enter = show date now ()
In the cell, enter = CHOOSE (WEEKDAY (I3, 2), "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday") displays the day of the week
Excel commonly used functions greatly entire

1. ABS function
Function name: ABS
Main features: find the appropriate number of absolute value.
Use the format: ABS (number)
Parameter description: absolute value representing the number of values you require, or refer to the cell.
Example of application: If you enter the formula in cell B2: = ABS (A2), whether in cell A2, enter a positive number (such as 100) or negative (-100), B2 are showing positive number (such as 100).
Remind: If the number argument is not a numeric value, but some characters (such as A, and so on), B2 returns incorrect value "# VALUE!".
2, AND function
Function name: AND
Main features: Returns the logical value: If all parameter values are logical "true (TRUE)", it returns the logical "true (TRUE), otherwise returns the logical" and "false (FALSE)".
Use the format: AND (logical1, logical2, ...)
Parameter description: Logical3 Logical1, Logical2, ... : Indicates that the question to test a value or expression in the condition, up to the 30.
Application examples: C5 cell entry formula: = AND (> = 60 A5, B5 > = 60) and confirm. Returns true if the C5, A5 and B5 in are greater than or equal to 60, if you return false, the A5 and B5 in at least one is less than 60.
Remind: If you specify a logical condition argument contains non-logical value, the function returns the error value # VALUE! "" Or "# NAME".
3, the AVERAGE function
Function name: AVERAGE
Main features: find out the arithmetic mean of all parameters.
Use theformat: AVERAGE (number1, number2, ...)
Parameter number1, number2 Description:, ... : The need to want to average value or reference cells (regional), arguments are not more than 30.
Application examples: enter a formula in a cell B8: = AVERAGE (B7: D7, F7: H7, 7, 8), after confirmation, you can find the B7-D7 regional, F7 to H7 in the range of values and the average value of 7, 8.
Remind: If you refer to a range that contains the value "0", then the cell; if a reference contains blank or character cell that is not included.
4, the COLUMN function
Function name: COLUMN
Main feature: display the referenced cell of the column number value.
Use the format: COLUMN (reference)
Parameter description: reference to a reference cell.
Application examples: enter a formula in a cell C11: = COLUMN (B11), confirmed to appear as 2 (column b).
Remind: If you enter a formula in a cell B11: = COLUMN (), also showed 2; match rows of a return value of function symbols — ROW (reference).
5. CONCATENATE function
Function name: CONCATENATE
Main features: multiple characters text or cell data, displayed in a cell.
Use the format: CONCATENATE (Text1, Text ...)
Parameter description: Text1, Text2, ... As the need to connect a character literal or a reference cell.
Application examples: enter formulas in cells C14: = CONCATENATE (A14, "@", B14, ".com"), after confirmation, you can apply character and cell A14 @, the characters in cell B14 and connect into a whole .com, displayed in cells C14.
Remind: If the parameter is not a referenced cell and the text format, please give parameter together with the English state of double quotation marks, if the above formula: = A14 & "@" & & ".com" B14, can achieve the same purpose.
6, the COUNTIF function
Function name: COUNTIF
Main features: statistics on a range of cells that meets the specified criteria, the number of cells.
Use the format: COUNTIF (Range, Criteria)
Parameter description: Range represents a range of statistics; Criteria indicates that the specified condition expression.
Application examples: C17 cell formula: = COUNTIF (B1: B13, "> = 80"), after confirmation, you can count out B1 to B13 ranges of cells, values greater than or equal to the number of cells to 80.
Special Alert: allows the referenced cell area there is a blank cell appears.
7, the date function
Function name: DATE
Main functions: to specify the numeric date.
Use the format: DATE (year, month, day)
Parameter description: year for the specified year value (less than 9999); month for the specified month value (which can be greater than 12); the number of days specified for the day.
Application examples: enter a formula in a cell C20: = DATE (2003, 13, 35), confirmed that the Show 2004-2-4.
Special reminder: because of the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared to January 2004, the actual number of days and number of the 4 days, so it is also extended to February 4, 2004.
8. name: DATEDIF function
Main functions: to calculate returns two date difference of the arguments.
Use the format: = DATEDIF (date1, date2, "y"), = DATEDIF (date1, date2, "m"), = DATEDIF (date1, date2, "d")
Parameter description: date1 represents a previous date, a date later date2 representative; y (m, d) requires the return of the difference between two dates (month, day).
Application examples: C23 cell formula: = DATEDIF (A23, TODAY (), "y"), is confirmed to return the system date [used TODAY ()) and A23 cell date difference, and returns the number of years.
Special Alert: this is a hidden in Excel functions that the function wizard is missing, you can directly enter the use, for the calculation of the age, seniority, etc. to be very effective.
9, the DAY function
Function name: DAY
Main functions: to find the specified date or reference cell number of days to a date.
Use the format: DAY (serial_number)
Parameter description: serial_number represents the specified date, or reference of the cell.
Example of application: enter a formula: = DAY ("2003-12-18"), after confirmation, showing the 18.
Remind: If the date is given, included in double quotation marks.
10, the DCount function
DCOUNT function names:
Key features: back to the database or list of columns that match the specified criteria and contain numbers.
Use the format: DCOUNT (database, field, criteria)
Parameter description: Database expressed the need for a range of statistics; Field indicates that the function uses the data columns (in the first row must have labels); Criteria range of cells that contains the conditions.
Example of application: as shown in Figure 1, in the enter the formula in cell F4: = DCOUNT (A1: D11, "languages", F1: G2), confirmed to find the "language" column, the result is greater than or equal to 70, but less than 80 numerical cell number (equivalent to the number of fractional sections).

Remind: If the above formula is amended as follows: = DCOUNT (A1: D11,, F1: G2), you can achieve the same purpose.