Tips for using cost statistics table
Cost statistics tableHow to fill it out?
(1) Outsourced materials
(2) Outsourced fuel and power
(3) Wages and employee benefits
(4) Depreciation expense
(5) Interest expenses
(6) Taxes
(7) Other expenses refer to expenses that do not belong to the above various expense elements.
2. Average: =AVERAGE(K2:K56) Find the average of the area K2 K56;
3. Ranking: =RANK(K2,K$2:KS56) ranks the results of 55 students;
4. Level: =IF(K2>=85, "Excellent", IF(K2>=74, "People", IF(K2>=60, "Pass", "Fail")))
5. Semester overall evaluation: =K2*0.3+M2*0.3+N2*0.4 Assume that column K, column M and column N respectively store the three grades of students: "usual overall evaluation", "midterm" and "final";
6. Highest score: =MAX(K2:K56) Find the highest score in the K2 to K56 area (55 students);
7. Minimum score: =MIN(K2:K56) ——- Find the lowest score in the K2 to K56 area (55 students);
Recommended by the editor of Huajun Software Park
Cost statistics tableIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need an expense statistics form, download it quickly. In addition,House and building fixed assets survey form,investment statementIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful