how to find the total average and blanks ?

Excel PRACTICE Test STARTER File v200427 - Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View ? Tell me what you want to do. Sign in & Share & Cut AutoSum - Copy Arial - 10 A A Wrap Text General Normal 2 Normal Bad Insert Delete Format Fill AY O Paste Format Painter BIU . . QAB= Merge & Center $ ~ % " 00 .0 Conditional Format as Good Neutral Calculation Sort & Find & Formatting * Table 41 2 Clear Filter ~ Select - Clipboard Font Alignment Number Styles Cells Editing M15 X Y fx A B C D E F G H J K L M N O 1 SenCol Inc. Practice Test 2016 - 2019 Client Activity Date Here W N Your Full Name 4 5 Zone 2016 2016 2016 CPS HPC HPS Gross Pay Other Gross Profit Zone Zone Zone 6 Name Staff Clients Hours Ratio Ratio Ratio Revenue Costs Costs Profit Margin Bonus Visit EC Cod 7 North 854 141560 1608716 22842716 12879000 4466410 3 8 East 910 245800 1722161 38592161 15035000 7557216 9 West 630 101900 1198440 36483440 24255000 3222502 10 South 480 85000 917900 23667900 18480000 2672912 w 11 Home 156 28500 294460 5569460 3006000 893771 6 12 13 Total 14 Average 15 Zone 16 Lowest Profit Margin is Number of zones with a HPS of less than 1,900 EC Cod 17 18 The 2nd highest Profit Margin is Total Zone bonuses that are more than $5,000 19 20 21 U A Sheet1 + Ready g - + 150% x ] 7:54 PM Type here to search 10/16/2020Excel PRACTICE Test STARTER File v200427 - Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View ? Tell me what you want to do. Sign in & Share & Cut Arial - 10 AA Wrap Text General Normal 2 Normal Bad E AutoSum ~ AYO Paste Copy BIU-A . =Merge & Center Neutral Calculation Insert Delete Format Fill Conditional Format as |Good Sort & Find & Format Painter Formatting * Table Clear Filter - Select Clipboard Font Alignment Number Styles Cells Editing M15 X v fx A E F G H J K L M N O P Q R S 1 2016 - 2019 Client Activity Date Here D UI A WN CPS HPC HPS Gross Pay Other Gross Profit Zone Zone Zone 2017 % Change 6 Ratio Ratio Ratio Revenue Costs Costs Profit Margin Bonus Visit EC Code Clients 2017-2016 22842716 12879000 4466410 3 8 38592161 15035000 7557216 9 36483440 24255000 3222502 10 23667900 18480000 2672912 W 11 5569460 3006000 893771 6 12 13 14 15 A Zone Plo 16 Number of zones with a HPS of less than 1,900 EC Code Forecast 17 0.0% 18 Total Zone bonuses that are more than $5,000 19 20 21 JAWN 1.4% 1.5% 2.9% 2.2% Sheet1 + Enter -- + 150% O EI 7:56 PM Type here to search 9 x ] 10/16/2020 E