Tips for using capital inventory table
Fund inventory tableHow to fill it out?
1. According to the inventory objects and scope:
1. A comprehensive inventory refers to the inventory and verification of all property.
2. Partial inventory refers to the inventory of a part of the property as needed, and the main objects of the inventory are properties with high liquidity.
2. According to the inventory time:
1. Regular inventory refers to the inventory of property carried out according to the provisions of the management system or the pre-planned time.
2. Irregular inspections refer to temporary inspections of property based on actual needs.
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);
Fund inventory tableIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the fund inventory form, please download it quickly. In addition,Student class seating chart,Invoice management details listIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful