Excel functions commonly used by clerks

The excel functions commonly used by clerks are as follows:

1. Sum function SUM;

2. Average function AVERAGE;

3. Logical function IF;

4. Counting function COUNT;

5. Conditional summation function SUMIF;

6. Sorting function RANK;

7. Rounding function ROUND;

8. Conditional counting function COUNTIF;

9. Date and year function YEAR;

10. Numerical text conversion TEXT;

11. Conditional positioning VLOOKUP.

Note:

Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. In 1993, after version 5.0 was released as a component of Microsoft Office, Excel began to become the dominant spreadsheet software on applicable operating platforms.

Excel is a very important software in office automation, and Excel functions are built-in functions in Excel. Excel functions include a total of 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.

For more Excel-related tutorials, please visit the Excel Basic Tutorial column!

The above is the detailed content of Excel functions commonly used by clerks. For more information, please follow other related articles on the PHP Chinese website!