【文章內(nèi)容簡介】 __________________________________________________ 97 13 BETADIST________________________________________________________________ 98 13 BETAINV_________________________________________________________________ 99 13 BINOMDIST _____________________________________________________________ 100 13 CHIDIST ________________________________________________________________ 101 1 CHIINV _________________________________________________________________ 101 14 CHITEST ________________________________________________________________ 102 14 CONFIDENCE ___________________________________________________________ 103 14 CORREL ________________________________________________________________ 104 14 COUNT _________________________________________________________________ 105 14 COUNTA ________________________________________________________________ 105 14 COUNTBLANK __________________________________________________________ 106 14 COUNTIF _______________________________________________________________ 106 14 COVAR _________________________________________________________________ 107 14 CRITBINOM ____________________________________________________________ 108 150、 DEVSQ __________________________________________________________________ 108 15 EXPONDIST _____________________________________________________________ 109 15 FDIST ___________________________________________________________________ 110 15 FINV ____________________________________________________________________ 110 15 FISHER _________________________________________________________________ 111 15 FISHERINV _____________________________________________________________ 112 15 FORECAST______________________________________________________________ 112 15 FREQUENCY ____________________________________________________________ 113 15 FTEST __________________________________________________________________ 114 15 GAMMADIST____________________________________________________________ 115 160、 GAMMAINV_____________________________________________________________ 116 Excel 2020 函數(shù)大全 HuXunmiao 7 16 GAMMALN _____________________________________________________________ 116 16 GEOMEAN ______________________________________________________________ 117 16 GROWTH _______________________________________________________________ 118 16 HARMEAN ______________________________________________________________ 119 16 HYPGEOMDIST _________________________________________________________ 119 16 INTERCEPT _____________________________________________________________ 121 16 KURT ___________________________________________________________________ 121 16 LARGE _________________________________________________________________ 122 16 LINEST _________________________________________________________________ 123 170、 LOGEST ________________________________________________________________ 129 17 LOGINV ________________________________________________________________ 131 17 LOGNORMDIST _________________________________________________________ 132 第五章 查找與引用函數(shù) ___________________________________________________ 133 17 ADDRESS _______________________________________________________________ 133 17 AREAS __________________________________________________________________ 134 17 CHOOSE ________________________________________________________________ 134 17 COLUMN _______________________________________________________________ 135 17 COLUMNS ______________________________________________________________ 136 17 HLOOKUP ______________________________________________________________ 136 17 HYPERLINK ____________________________________________________________ 137 180、 INDEX __________________________________________________________________ 139 18 INDIRECT ______________________________________________________________ 141 18 LOOKUP ________________________________________________________________ 141 18 MATCH _________________________________________________________________ 143 18 OFFSET _________________________________________________________________ 144 18 ROW____________________________________________________________________ 144 18 ROWS __________________________________________________________________ 145 18 RTD ____________________________________________________________________ 145 18 TRANSPOSE ____________________________________________________________ 146 18 VLOOKUP ______________________________________________________________ 147 第 六章 數(shù)據(jù)庫和列表管理函數(shù) _____________________________________________ 148 190、 DAVERAGE _____________________________________________________________ 148 Excel 2020 函數(shù)大全 HuXunmiao 8 19 DCOUNT ________________________________________________________________ 151 19 DCOUNTA_______________________________________________________________ 151 19 DGET ___________________________________________________________________ 152 19 DMAX __________________________________________________________________ 152 19 DMIN ___________________________________________________________________ 152 19 DPRODUCT _____________________________________________________________ 153 19 DSTDEV ________________________________________________________________ 153 19 DSTDEVP _______________________________________________________________ 154 19 DSUM ___________________________________________________________________ 154 200、 DVAR ___________________________________________________________________ 154 20 DVARP __________________________________________________________________ 155 20 GETPIVOTDATA ________________________________________________________ 155 第七章 文本函數(shù) ________________