Excel2016版本和截至2020年6月份的WPS版本进行的对比出于其他原因，标成绿色3种函数没有进行练习对比
数学与三角函数74 ABSACOSACOSHACOTACOTHAGGREGATEARABICASINASINHATANATAN2ATANHBASECEILING.MATHCOMBINCOMBINACOSCOSHCOTCOTHCSCCSCHDECIMALDEGREESEVENEXPFACTFACTDOUBLEFLOOR.MATHGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALMUNITODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSECSECHSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMIFSSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC
统计108 AVEDEVAVERAGEAVERAGEAAVERAGEIFAVERAGEIFSBETA.DISTBETA.INVBINOM.DISTBINOM.DIST.RANGEBINOM.INVCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTCHISQ.TESTCONFIDENCE.NORMCONFIDENCE.TCORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOUNTIFSCOVARIANCE.PCOVARIANCE.SDEVSQEXPON.DISTF.DISTF.DIST.RTF.INVF.INV.RTF.TESTFISHERFISHERINVFORECAST.ETSFORECAST.ETS.CONFINTFORECAST.ETS.SEASONALITYFORECAST.ETS.STATFORECAST.LINEARFREQUENCYGAMMAGAMMA.DISTGAMMA.INVGAMMALNGAMMALN.PRECISEGAUSSGEOMEANGROWTHHARMEANHYPGEOM.DISTINTERCEPTKURTLARGELINESTLOGESTLOGNORM.DISTLOGNORM.INVMAXMAXAMEDIANMINMINAMODE.MULTMODE.SNGLNEGBINOM.DISTNORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPEARSONPERCENTILE.EXCPERCENTILE.INCPERCENTRANK.EXCPERCENTRANK.INCPERMUTPERMUTATIONAPHIPOISSON.DISTPROBQUARTILE.EXCQUARTILE.INCPANK.AVGPANK.EQRSQSKEWSKEW.PSLOPESMALLSTANDARDIZESTDEV.PSTDEV.SSTDEVASTDEVPASTEYXT.DISTT.DIST.2TT.DIST.RTT.INVT.INV.2TT.TESTTRENDTRIMMEANVAR.PVAR.SVARAVARPAWEIBULL.DISTZ.TEST
工程54 BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTBITANDBITLSHIFTBITORBITRSHIFTBITXORCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERF.PRECISEERFCERFC.PRECISEGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMCOSHIMCOTIMCSCIMCSCHIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSECIMSECHIMSINIMSINHIMSQRTIMSUBIMSUMIMTANOCT2BINOCT2DECOCT2HEX
多维数据集77CUBEKPIMEMBERCUBEMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESETCUBESETCOUNTCUBEVALUE
兼容性410BETADISTBETAINVBINOMDISTCEILINGCHIDISTCHIINVCHITESTCONFIDENCECOVARCRITBINOMEXPONDISTFDISTFINVFLOORFORECASTFTESTGAMMADISTGAMMAINVHYPGEOMDISTLOGINVLOGNORMDISTMODENEGBINOMDISTNORMDISTNORMINVNORMSDISTNORMSINVPERCENTILEPERCENTRANKPOISSONQUARTILERANKSTDEVSTDEVPTDISTTINVTTESTVARVARPWEIBULLZTEST
WEB33ENCODEURLFILTERXMLWEBSERVICE
Office函数总数464WPS函数总数419Office有wps没有45
主题附有网盘Excel版链接
