統(tǒng)計(jì)認(rèn)知與技術(shù)職業(yè)能力訓(xùn)練答案-項(xiàng)目一-任務(wù)四

1、工程一統(tǒng)計(jì)觀念的建立任務(wù)四認(rèn)知統(tǒng)計(jì)計(jì)算工具一知識(shí)認(rèn)知能力訓(xùn)練（-）單項(xiàng)選擇題CBDBABACCD（二）多項(xiàng)選擇題ABCDEACBEABCDEABCDE（三）判斷題.對(duì).錯(cuò),對(duì).錯(cuò).錯(cuò).錯(cuò).對(duì).錯(cuò).對(duì).對(duì)二、專業(yè)運(yùn)用能力訓(xùn)練能力訓(xùn)練一：Tris里貼板X晨AG三三三鄉(xiāng)，三三三痣痣對(duì)力r力式辭目，T” TTris里貼板X晨AG三三三鄉(xiāng)，三三三痣痣對(duì)力r力式辭目，T” T數(shù)值B I U e A A 里 %，Times New Roman三三I三. 凈目潮蛤 三目三欄巖B臺(tái)并后居中文件JSA卯HI布局公式數(shù)JE市間 視圖 加栽項(xiàng)福聽間詼器ACROBATft區(qū)斯切電號(hào)制VfSE!*Times New Ro

2、man三三I三. 凈目潮蛤 三目三欄巖B臺(tái)并后居中對(duì)開式G數(shù)般安 ，38線琲序HN3法查找和選擇D28I X fx =AVERAGE(D3:D27)VEifi n*UABCDEFGHIJKLMN01表1.4-2某校會(huì)計(jì)1206班三門課程的期中考試成績2班圾學(xué)號(hào)基礎(chǔ)會(huì)計(jì)經(jīng)濟(jì)法統(tǒng)計(jì)總分?jǐn)?shù)總平均分3會(huì)計(jì)12062101958895278934 1會(huì)計(jì)12062102928495271905 |會(huì)計(jì)12062103948193268896會(huì)計(jì)12062104888791266897會(huì)計(jì)12062105897392254858#1+12062106877391251849 1會(huì)計(jì)120621078670

3、942508310會(huì)計(jì)1206210SSS72902508311會(huì)計(jì)1206210986758824983121會(huì)計(jì)120621108S70872458213 j#1+120621118970852448114 1會(huì)計(jì)120621128864912438115會(huì)計(jì)120621138371892438116會(huì)計(jì)120621148170872387917J_會(huì)計(jì)120621158670822387918 |會(huì)計(jì)120621168568842377919會(huì)計(jì)120621178765832357820會(huì)計(jì)120621188564S3,2327721 I會(huì)計(jì)1206211983707723077續(xù)表表1

4、42某校會(huì)計(jì)1206班三門課程的期中萼試成績-Excel餐區(qū)更切 J電復(fù)制.TQTCEfe rTimes New Roman 9A* A三三|三會(huì).停目詡跖|教值軍,，林線招野印百畬園最黑的,加收條件揩式套用單元格桂式痛入捌除格式史耳陰的篩選查找和選擇一 表圖式， - - ， - e清除”-一杼式單元格B I u J 與-A嚏. M 三但 后運(yùn) 國合并后居中G對(duì)九方式G開始 猛入 煩右局 公式 教據(jù) 市房 視圉 力噬啖福沂帝S35ACROBAT登錄|1文件D28-：! K /=AVERAGE（D3:D27）ABCDEFGHIJKLMN016會(huì)計(jì)12062114817087238，7917會(huì)計(jì)1

5、2062115867082238，7918#1+120621168568842377919到12062117876583235，7820會(huì)計(jì)12062118856483232，7721會(huì)計(jì)12062119837077230，7722會(huì)計(jì)12062120816284227，7623會(huì)計(jì)12062121895976224,7524會(huì)計(jì)12062122786973220，7325會(huì)計(jì)12062123874784218,7326會(huì)計(jì)120621248250802127127會(huì)計(jì)120621258246711996628各慷程平均分8669862418029按總平均分分組分隔點(diǎn)人數(shù)比重（）30姒下59003160-7069143270807911443380-90891144349CO1007一835合計(jì)-2510036Sheet1三、專業(yè)拓展能力訓(xùn)練假如以單元格B4至F15輸入表格數(shù)據(jù)，那么去除科達(dá)公司為“三公司”或類別為“男式西褲”之外的總金額公式如下：=SUM（F$4:F$14）-SUMIF（C$4:C$14,”三公司，F(xiàn)