Common functions of office, common functions of advanced office

The following steps are as follows how to use the if function formula in Office:

1. Open Office and prepare a worksheet with complete data.

2. Click the level of the first cell.

3. Select the student number and click the Insert Function button.

4. The Insert Function option pops up and selects the if function.

5. Click OK and enter the level classification rules in the function parameter box.

6. The grade with an average score < 60 is set to fail, 60< = average score< = 75 is set to pass, 76< = average score < = 85 is set to good, and 86< = average score < = 100 is set to excellent.

Enter g2<60 in each of the three regret boxes, fail, "if(g2<76,"Pass",if(g2<86,"Good","Excellent"Sleepy boy.

7. Click OK, press and hold the fill, and fill the remaining cells.

In the daily office, often use excel to calculate some data, then it will involve the use of functions, if the use of various functions can be clear, in the work, will be able to speed up the efficiency, so that the calculation of data becomes simple and easy, excel commonly used functions are very kind, the following is introduced, there must be one of your most commonly used.

An if function.

Objective: A passing score of 9 points is used to determine whether the score is passed.

Operation: Select the target cell and enter =if(b4>=9,,"Eligible","Unqualified"), click the enter key to find out whether it is qualified or not.

Two. Conditional summation.

Objective: To find a score greater than 80 and an overall score for boys.

How to operate: Enter =sumif(d3:) in the corresponding cell

d9,"Male", c3:c9) or =sumifs(c3:c9,c3:

c9,">=80",d3:d9,"Male")。

Among them, sumif is suitable for single-condition summation, and sumifs is suitable for multi-condition summing.

3. Extract the date of birth.

Purpose: To obtain the date of birth within the specified ID number.

Operation method: After selecting the cell, enter the function formula: =text(mid(b3,7,8),"0000-00-00"), and then use the shortcut key Ctrl+Enter to fill in.

4. Calculate age.

Purpose: To calculate the age of each person based on the ID number.

Operation method: In the specified cell, enter the formula: =datedif(c3,today(),"y"), click the Enter key.

5. Conditional counting.

Purpose: To calculate the business ratio of each store, operation method: enter the formula: =countif(b2:b12,e3) in the specified cell.

6. Merge cell summing.

Purpose: To calculate what each student's total score would be.

Operation: Select the area to be summed, enter the formula in the column: =sum(c3:c14)-sum(d4:d14), then press enter, and the batch filling can be completed.

The above 6 kinds of Excel commonly used functions, when using, you can use it directly, if the cells are different, modify it appropriately and click the enter key, you can get the desired result accurately.

Microsoft Word and Office** provide a variety of commonly used formulas for users to insert directly into the Word document, take Word2010 software as an example to introduce the method:

Step 1, Open the Word 2010 document window and switch to the "Insert" ribbon.

Step 2: Click the drop-down triangle button of the "Formula" button in the "Symbols" group, and select the desired formula (such as "Quadratic Formula") in the built-in formula list that opens.

If you can't find the formula you need in the built-in formulas provided by Word2010, you can point to "Other formulas in office" in the formula list, and select the formula you need in the list of more formulas from office**.

Excel functions include more than 300 functions in 11 categories, including database functions, date and time functions, engineering functions, financial functions, information functions, logical functions, query and reference functions, mathematical and trigonometric functions, statistical functions, text functions and user-defined functions.

There are more than 230 functions in 7 categories, including date and time functions, information functions, logical functions, query and reference functions, mathematical and trigonometric functions, statistical functions, and text functions, of which more than 30 are used frequently.