Tips for using review schedule
Exam review steps:
1. Comprehensive review of basic knowledge.
2. Analyze existing problems in detail, and review to identify and fill in any gaps.
3. Review in sections. Make sure that there are differences among the same, and similarities among the differences.
4. Special topic review. Cultivation of comprehensive abilities and expansion of one’s application abilities
Requirements: Count the number of people in the statistics department who are in production and whose positions are master operators
The formula is:
=COUNTIFS(B2:B9,F2,C2:C9,G2)
The COUNTIFS function counts the number of cells in a conditional area that meet multiple specified conditions. Common usage is:
=COUNTIFS(condition area 1, specified condition 1, condition area 2, specified condition 2...)
2: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:
VLOOKUP (Who are you looking for, where are you looking for, which column of content is returned, exact or approximate)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
Recommended by the editor of Huajun Software Park
Review scheduleIt 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 review schedule, please download it quickly. also,ratio analysis table,On-campus allowance scheduleIt is also a good form template. Welcome to click to download and experience it!
it works
it works
it works