掃一掃
關(guān)注中圖網(wǎng)
官方微博
本類五星書(shū)更多>
-
>
全國(guó)計(jì)算機(jī)等級(jí)考試最新真考題庫(kù)模擬考場(chǎng)及詳解·二級(jí)MSOffice高級(jí)應(yīng)用
-
>
決戰(zhàn)行測(cè)5000題(言語(yǔ)理解與表達(dá))
-
>
軟件性能測(cè)試.分析與調(diào)優(yōu)實(shí)踐之路
-
>
第一行代碼Android
-
>
JAVA持續(xù)交付
-
>
EXCEL最強(qiáng)教科書(shū)(完全版)(全彩印刷)
-
>
深度學(xué)習(xí)
中圖價(jià):¥28.0
加入購(gòu)物車
超實(shí)用Excel函數(shù)范例速查寶典 版權(quán)信息
- ISBN：9787113210571
- 條形碼：9787113210571 ; 978-7-113-21057-1
- 裝幀：70g膠版紙
- 冊(cè)數(shù)：暫無(wú)
- 重量：暫無(wú)
- 所屬分類：>>
超實(shí)用Excel函數(shù)范例速查寶典 本書(shū)特色
本書(shū)講解了excel所包括的所有函數(shù)，并用范例來(lái)加以說(shuō)明。
超實(shí)用Excel函數(shù)范例速查寶典 內(nèi)容簡(jiǎn)介
本書(shū)是部覆蓋了Excel 2000/2002/2003/2007/2013各個(gè)版本的函數(shù)大辭典。其內(nèi)容包括: 函數(shù)的基礎(chǔ)知識(shí) ; 數(shù)學(xué)與三角函數(shù) ; 統(tǒng)計(jì)函數(shù) ; 日期和時(shí)間函數(shù) ; 邏輯函數(shù) ; 查找和引用函數(shù) ; 文本函數(shù)等。
超實(shí)用Excel函數(shù)范例速查寶典 目錄
目錄chapter 00 函數(shù)的基礎(chǔ)知識(shí) 0011 函數(shù)簡(jiǎn)介.......................................................................................................0022 輸入函數(shù).......................................................................................................0063 函數(shù)的復(fù)制和單元格引用........................................................................ 0154 函數(shù)的修改...................................................................................................0245 函數(shù)的組合...................................................................................................0276 使用數(shù)組.......................................................................................................0327 啟用加載項(xiàng)（excel 2000 ～ 2003）.................................................. 0358 檢查錯(cuò)誤.......................................................................................................0369 多維數(shù)據(jù)集函數(shù)（excel 2007 ～ 2013）......................................... 042cubekpimember 返回關(guān)鍵績(jī)效指標(biāo)（kpi）的屬性..................042cubemember 返回多維數(shù)據(jù)集的成員或群組.......................043cubememberproperty 返回多維數(shù)據(jù)集內(nèi)的成員屬性值 .........................043cuberankedmember 返回多維數(shù)據(jù)集合內(nèi)所指定順序的成員..........043cubeset 將集合表達(dá)式傳送到服務(wù)器上的多維數(shù)據(jù)集以定義項(xiàng)目 ................044cubesetcount 返回多維數(shù)據(jù)集合內(nèi)的項(xiàng)目數(shù)........................044cubevalue 從多維數(shù)據(jù)集中返回匯總值...........................045chapter 01 數(shù)學(xué)與三角函數(shù)數(shù)學(xué)與三角函數(shù)的基礎(chǔ)知識(shí) .............................................................048計(jì)算.................................................................................................052sum 求和...............................................................052sumif 帶條件求和....................................................056sumifs 以多個(gè)條件來(lái)求出數(shù)值的合計(jì)值....................060product 求多個(gè)數(shù)值的積.............................................062sumproduct 將數(shù)組元素相乘并求出乘積的合計(jì)值............063sumsq 求數(shù)值的平方和.............................................067sumx2py2 求兩個(gè)數(shù)組中各元素平方和的總和................068sumx2my2 求兩個(gè)數(shù)組中各元素平方差的總和................068sumxmy2 求兩個(gè)數(shù)組中各元素差的平方和....................068subtotal 求11 種的匯總數(shù)值.......................................070aggregate 求19 種的匯總數(shù)值.......................................072quotient 求兩數(shù)相除后商的整數(shù)部分...........................074mod 求兩數(shù)相除后的余數(shù)......................................075abs 求數(shù)值的絕對(duì)值.............................................077sign 查詢數(shù)值的正負(fù)號(hào).........................................078seriessum 用冪級(jí)數(shù)求近似值 .........................................080gcd 求*大公約數(shù).................................................082lcm 求*小公倍數(shù).................................................082數(shù)值處理..........................................................................................083int 把數(shù)值小數(shù)點(diǎn)之后的部分舍去.......................083trunc 返回舍去到指定位數(shù)的數(shù)值...........................084round 返回四舍五入到指定位數(shù)的數(shù)值....................086roundup 將數(shù)值無(wú)條件向上舍入到指定位數(shù)................088rounddown 將數(shù)值無(wú)條件舍去到指定的位數(shù)....................089ceiling 將數(shù)值向上舍入，使其*接近基數(shù)的倍數(shù).....090ceiling.precise/iso.ceiling 將數(shù)值向上舍入，使其*接近“基數(shù)”的倍數(shù) ..................................090floor 將數(shù)值向下舍入到*接近基數(shù)的倍數(shù).............092floor.precise 將數(shù)值向下舍去到*接近基數(shù)的倍數(shù) .............092mround 將數(shù)值四舍五入到指定數(shù)值的倍數(shù)................096even 將數(shù)值向上舍入到*接近的偶數(shù)值................098odd 將數(shù)值向上舍入到*接近的奇數(shù)值................099三角函數(shù)..........................................................................................100radians 將角的單位由度轉(zhuǎn)換成弧度...........................100degrees 將角的單位由弧度轉(zhuǎn)換成度...........................101sin 求數(shù)值的正弦值.............................................102cos 求數(shù)值的余弦值.............................................104tan 求數(shù)值的正切值.............................................106asin 求數(shù)值的反正弦值.........................................108acos 求數(shù)值的反余弦值.........................................109atan 求數(shù)值的反正切值.........................................110atan2 求指定坐標(biāo)點(diǎn)的反正切值............................... 111sinh 求數(shù)值的雙曲正弦值.....................................112cosh 求數(shù)值的雙曲余弦值.....................................113tanh 求數(shù)值的雙曲正切值.....................................114asinh 求數(shù)值的反雙曲正弦值.................................115acosh 求數(shù)值的反雙曲余弦值.................................116atanh 求數(shù)值的反雙曲正切值.................................117指數(shù)與對(duì)數(shù)函數(shù) ...............................................................................118power 求數(shù)值的乘冪................................................118exp 求指數(shù)的函數(shù).................................................120log 求以指定數(shù)值為底數(shù)的對(duì)數(shù)...........................122ln 求數(shù)值的自然對(duì)數(shù).........................................123log10 求數(shù)值的常用對(duì)數(shù).........................................124隨機(jī)數(shù)..............................................................................................125rand 產(chǎn)生大于等于0 且小于1 的隨機(jī)數(shù)................125randbetween 產(chǎn)生整數(shù)的隨機(jī)數(shù).........................................127圓周率·平方根..................................................................................128pi 求圓周率（π）的近似值...............................128sqrtpi 求圓周率（π）的倍數(shù)的平方根....................129sqrt 求正數(shù)的平方根.............................................130矩陣行列式......................................................................................132mdeterm 求數(shù)組矩陣行列式的值..................................132minverse 求數(shù)組矩陣的逆矩陣......................................134mmult 求兩個(gè)數(shù)組的矩陣乘積..................................136組合.................................................................................................138fact 求數(shù)值的階乘.................................................138factdouble 求數(shù)值的雙階乘.............................................139combin 求數(shù)值的組合數(shù)（二項(xiàng)系數(shù)）.......................140multinomial 求數(shù)值的多項(xiàng)系數(shù).........................................142字符轉(zhuǎn)換..........................................................................................143roman 將阿拉伯?dāng)?shù)字轉(zhuǎn)換成羅馬數(shù)字.......................143chapter 02 統(tǒng)計(jì)函數(shù) 145統(tǒng)計(jì)函數(shù)的基礎(chǔ)知識(shí)........................................................................146基礎(chǔ)統(tǒng)計(jì)..........................................................................................152count 求數(shù)值的個(gè)數(shù).................................................152counta 求非空單元格的個(gè)數(shù)......................................154countblank 求空白單元格的個(gè)數(shù)......................................156countif 求符合條件的單元格個(gè)數(shù)...............................158countifs 求符合多個(gè)條件的單元格個(gè)數(shù).......................162frequency 計(jì)算數(shù)值在某個(gè)區(qū)域內(nèi)的出現(xiàn)頻率，然后返回一列垂直數(shù)組 ................164average 求數(shù)值的平均值.............................................166averagea 求非空單元格的數(shù)據(jù)平均值...........................169averageif 求滿足條件的數(shù)值平均值 ...............................170averageifs 求滿足多個(gè)條件的數(shù)值平均值.......................172trimmean 求除去異常值的數(shù)值平均值...........................174geomean 求數(shù)值的幾何平均值......................................176harmean 求數(shù)值的調(diào)和平均值......................................177median 求數(shù)值的中間值.............................................178mode/mode.sngl 求數(shù)值中**個(gè)被查找到且出現(xiàn)頻率*高的值（眾數(shù)） .......................179mode.mult 求數(shù)值中多個(gè)出現(xiàn)頻率*高的值....................180max 求數(shù)值的*大值.............................................182min 求數(shù)值的*小值.............................................184maxa 求非空數(shù)據(jù)的*大值......................................186mina 求非空數(shù)據(jù)的*小值......................................187var/var.s 計(jì)算基于樣本的方差......................................188varp/var.p 求總體數(shù)值的方差.........................................190vara 求非空數(shù)據(jù)的樣本方差..................................192varpa 求非空數(shù)據(jù)的總體方差..................................193stdev/stdev.s 求數(shù)值的樣本標(biāo)準(zhǔn)差......................................194stdevp/stdev.p 求數(shù)值的總體標(biāo)準(zhǔn)差......................................196stdeva 求非空數(shù)據(jù)的樣本標(biāo)準(zhǔn)差...............................198stdevpa 求非空數(shù)據(jù)的總體標(biāo)準(zhǔn)差...............................199avedev 求一組數(shù)值的平均差......................................200devsq 求各數(shù)值與其平均值的偏差的平方和.............201skew 求相對(duì)于正態(tài)分布的偏斜度...........................202kurt 求相對(duì)于正態(tài)分布的峰度值...........................204排序.................................................................................................206rank/rank.eq 求數(shù)值在數(shù)值列表中的排名...........................206rank.avg 求數(shù)值在數(shù)值列表中的排名(如果排名相同則返回平均排名)...................209large 返回?cái)?shù)據(jù)集中第k 個(gè)*大值...........................210small 返回?cái)?shù)據(jù)集中第k 個(gè)*小值...........................212quartile/quartile.inc 求數(shù)值集的四分位數(shù)......................................214percentile/percentile.inc 求區(qū)域中數(shù)值的第k 個(gè)百分點(diǎn)的值................216quartile.exc 求去除數(shù)值集中的*小值和*大值后的四分位數(shù) .......................218percentile.exc 返回區(qū)域中數(shù)值的第k 個(gè)百分點(diǎn)的值（0<k<1） ........................219percentrank/percentrank.inc 求特定數(shù)值在一個(gè)數(shù)值集中的百分比排名 .....220percentrank.exc 求特定數(shù)值在一個(gè)數(shù)值集中的百分比排名（不包括0 和1） ........................222概率分布..........................................................................................223permut 求排列數(shù)........................................................223binomdist/binom.dist 求二項(xiàng)分布的概率值......................................224critbinom/binom.inv 求累積二項(xiàng)分布概率達(dá)到目標(biāo)值的*小值 .....228negbinomdist 求負(fù)二項(xiàng)分布的概率值..................................230negbinom.dist 求負(fù)二項(xiàng)分布的概率值和累積概率值 .............230hypgeomdist 求超幾何分布的概率值..................................232hypgeom.dist 求超幾何分布的概率值和累積概率值.............232poisson/poisson.dist 求泊松分布的概率值......................................236prob 求隨機(jī)變量在指定范圍內(nèi)的概率值................238normdist/norm.dist 求出正態(tài)分布的概率密度函數(shù)值和累積分布函數(shù)值 ...............................239norminv/norm.inv 求正態(tài)分布的累積分布函數(shù)的反函數(shù) .............242normsdist 求標(biāo)準(zhǔn)正態(tài)分布的累積分布函數(shù)值................244norm.s.dist 求標(biāo)準(zhǔn)正態(tài)分布的概率值和累積概率值.........244normsinv/norm.s.inv 求標(biāo)準(zhǔn)正態(tài)分布的累積分布函數(shù)的反函數(shù)值 ...246standardize 求正態(tài)化數(shù)值.................................................248lognormdist 求對(duì)數(shù)正態(tài)分布的累積分布函數(shù)值................250lognorm.dist 求對(duì)數(shù)正態(tài)分布的概率值和累積概率值.........250loginv/lognorm.inv 求對(duì)數(shù)正態(tài)分布的累積分布函數(shù)的反函數(shù)值 ...252expondist/expon.dist 求指數(shù)分布的概率值和累積概率值 ................254weibull/weibull.dist 求韋伯分布的概率值和累積概率值 ................256gammadist/gamma.dist 求伽馬分布的概率值和累積概率值................258gammainv/gamma.inv 求伽馬分布函數(shù)的反函數(shù)值...........................260gammaln/gammaln.precise 求伽馬分布的自然對(duì)數(shù)值...............................262betadist 求beta 分布函數(shù)值.......................................263beta.dist 求beta 分布的概率值和累積概率值..............263betainv/beta.inv 求beta 分布函數(shù)的反函數(shù)值.........................266估計(jì)·檢驗(yàn).........................................................................................268confidence/confidence.norm 求總體平均值的置信區(qū)間...............................268confidence.t 求遵循t 分布的總體平均值的單側(cè)置信區(qū)間 ...270chisq.dist 求x2 分布的概率和左尾概率.........................272chidist/chisq.dist.rt 求x2 分布的右尾概率....................................274chisq.inv 求x2 分布的左尾概率的反函數(shù)值..................276chiinv/chisq.inv.rt 求x2 分布的右尾概率的反函數(shù)值..................278chitest/chisq.test 進(jìn)行x2 檢驗(yàn)..................................................280f.dist 求f 分布的概率和左尾概率...........................282fdist/f.dist.rt 求f 分布的右尾概率.....................................284f.inv 求f 分布的左尾概率的反函數(shù)值...................286finv/f.inv.rt 求f 分布的右尾概率的反函數(shù)值...................288ftest/f.test 進(jìn)行f 檢驗(yàn)....................................................290t.dist 求t 分布的概率和左尾概率............................292tdist 求t 分布的右尾概率或雙尾概率.....................294t.dist.rt 求t 分布的右尾概率.......................................296t.dist.2t 求t 分布的雙尾概率.......................................297tinv/t.inv.2t 求t 分布的雙尾概率的反函數(shù)值.....................298t.inv 求t 分布的左尾概率的反函數(shù)值.....................300ttest/t.test 進(jìn)行t 檢驗(yàn).....................................................302ztest/z.test 進(jìn)行z 檢驗(yàn)....................................................304fisher 返回點(diǎn)x 的fisher 變換值.............................306fisherinv 求fisher 變換的反函數(shù)值..............................308協(xié)方差、相關(guān)系數(shù)和回歸分析 ..........................................................310covar/covariance.p 求兩個(gè)變量的協(xié)方差......................................310covariance.s 求兩個(gè)變量的協(xié)方差......................................310correl 求兩個(gè)變量間的相關(guān)系數(shù)...............................312pearson 求皮爾森積矩相關(guān)系數(shù)..................................312slope 求回歸直線的斜率.........................................314intercept 求回歸直線的截距.........................................316linest 求回歸直線的系數(shù)與常數(shù)項(xiàng) ...........................318forecast 求兩個(gè)變量間回歸直線的預(yù)測(cè)值....................320trend 求回歸直線的預(yù)測(cè)值......................................322steyx 求回歸直線的標(biāo)準(zhǔn)誤差值...............................324rsq 求回歸直線的判斷系數(shù)..................................326growth 求指數(shù)回歸曲線的預(yù)測(cè)值...............................328logest 求指數(shù)回歸曲線的系數(shù)與底數(shù).......................330chapter 03 日期和時(shí)間函數(shù) 333日期和時(shí)間函數(shù)的基礎(chǔ)知識(shí) .............................................................334當(dāng)前的日期和時(shí)間 ............................................................................338today 顯示當(dāng)前的日期.............................................338now 顯示當(dāng)前的日期和時(shí)間..................................340由序列值求指定日期和時(shí)間 .............................................................342year 根據(jù)日期序列值顯示年..................................342month 根據(jù)指定的序列值顯示月...............................344day 根據(jù)指定的序列值顯示日...............................346hour 根據(jù)指定的序列值顯示時(shí)...............................348minute 根據(jù)指定的序列值顯示分...............................348second 根據(jù)指定的序列值顯示秒...............................348weekday 根據(jù)指定的序列值顯示星期幾.......................350weeknum 根據(jù)序列值顯示該年第幾周的號(hào)碼................354由指定日期和時(shí)間求序列值 .............................................................356date 由年、月、日的數(shù)值求日期的序列值.............356time 由時(shí)、分、秒的數(shù)值求時(shí)間的序列值.............358由字符串求序列值............................................................................361datevalue 將日期字符串轉(zhuǎn)換為序列值...........................361timevalue 將時(shí)間字符串轉(zhuǎn)換成序列值...........................362計(jì)算日期 ..........................................................................................364edate 計(jì)算指定月數(shù)后的日期..................................364eomonth 計(jì)算指定月數(shù)后該月的*后一天....................365workday 求得去除周六、日和節(jié)假日之后指定天數(shù)后的日期 .........................................366workday.intl 求得去除公休日和節(jié)假日之后指定天數(shù)后的日期 .........................................368期間差..............................................................................................370networkdays 計(jì)算指定期間去除周六、日與節(jié)假日后的工作天數(shù) ......................................370networkdays.intl 計(jì)算指定期間內(nèi)去除公休日與節(jié)假日的工作日 ...372days360 求出一年以360 天計(jì)算時(shí)開(kāi)始日到結(jié)束日的天數(shù) .................................................374yearfrac 求出一年以1 計(jì)算時(shí)經(jīng)過(guò)天數(shù)的比例............375datedif 計(jì)算從開(kāi)始日到結(jié)束日的期間差....................376將序列值轉(zhuǎn)換為文本字符串 .............................................................378datestring 將日期序列值轉(zhuǎn)換為文本字符串....................378c
展開(kāi)全部
書(shū)友推薦
- >
名家?guī)阕x魯迅:朝花夕拾
- >
人文閱讀與收藏·良友文學(xué)叢書(shū):一天的工作
- >
煙與鏡
- >
月亮與六便士
- >
我與地壇
- >
上帝之肋:男人的真實(shí)旅程
- >
名家?guī)阕x魯迅:故事新編
- >
伯納黛特,你要去哪(2021新版)
本類暢銷
