General tips for project completion settlement form 1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
3: Fill every other row with color to make the table more cool
Ctrl + T
First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all the table, and then hold down Ctrl + T to achieve it.
The Ctrl + T method is very fast and can quickly fill the table with color, but it cannot achieve self-selected colors.
How to fill in the color of your choice
First, use the shortcut keys Ctrl+shift+right arrow+down arrow to select all the table. Then select Conditional Formatting - New Rule in the Start menu
Choose to use a formula to determine the cells to be formatted, and then enter =MOD(ROW(),2)=0 in the format *0 means even-numbered rows are filled, 1 means odd-numbered rows are filled
Then select the Format button, open the Fill tab, and choose your favorite color to fill.
Project completion settlement document update log:
1. The details are more outstanding!
2. BUG gone without a trace
Huajun editor recommends:
Project completion settlement form, word-of-mouth software, guaranteed to solve all your problems! The editor highly recommends! There are similar software on this site360 browser, if you are interested, you can download it!





















Useful
Useful
Useful