资源描述：
《会计继续教育考试（accounting continuing education examination）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、会计继续教育考试（Accountingcontinuingeducationexamination）Judgmentquestions:1,intheuseoffixedbalancedeclinemethod,thecalculationofanassetintheintervalbetweenthedepreciationvalue,youcanusetheDBfunctionpairs2,onthetopoftheworkbookA,B,C...Etc.lettersworktablecolumn.Yes3.T
2、henumbers1,2,3ontheleftmostsideoftheworkbookrepresentthecolumnnumberoftheworksheet.Correctanswer:wrong4,inEXCEL,cansetthecellborders,butnotthecellshading.B,wrong5.AEXCELworkbookcanhaveupto16worksheets.B,wrong1,EXCELworksheetnamecannotbemodified.B,wrong4,through
3、theEXCELtableprotection,youcanachievepartofthecellcanbeenteredormodified,theotherpartcannot.A,yeah5.TheinputarrayshouldbeinputintheselectedareaandpresstheShift+Ctrl+Altkeyatthesametime.B,wrong1,inEXCEL,youcansettheformulainthedisplaycell.A,yeah2,ifyouwanttoachi
4、evemultiplejudgments,youcanusethenestedIFfunctiontoachieve.A,yeah3,theSUMIFfunctionisthenumberofcellsthatsatisfythegivenconditioninthecalculatedregion.B,wrong4.InEXCEL,youcannotsetanareawheretheuserprintsonlythisarea.B,wrong5,thefirsttimetouse"planningsolver",s
5、houldfirst"tool"-"loadingmacro"selected"planningsolution"".A,yeah3,becauseChineseisatextvalue,EXCELcannotsolvetheproblemofwriteconversionoftheamount.B,wrong5,inthemenubarclick"format"-"Toolbar"-"controltoolbox",youcanopenthecontroltoolbox.B,wrong1,"search","rep
6、lacement","positioning"inthemenubar"Edit"function.A,yeah2,ifyouusethewindow"freezepane",thenyoucan'tmodifythecellcontentofEXCEL.B,wrong5,clickonthemenubar"data"-"classificationsummary",canbeclassifiedaccordingtothecolumncount.A,yeahRadioexamination:1,intheworks
7、heetareaA1:B1inordertoenterdata10and20,thevalueintheregionA2:B2is1,2,inthecellC1inputformula=A$1+$B1,thecellC1copytoD2,thenthevalueofD2displayishowmuch?Thecorrectanswer:CA,30B,3C,22D,112,aEXCELworkbookdefaultstothe(correctanswer:C)worksheet.A,1B,2C,3D,43,intheB
8、5cellthereisaformulaforSUM(B2:B4),andcopyittoD5,theformulabecomes:thecorrectanswer:AA,SUM(D2:D4)B,SUM(B2:D4)C,SUM(D2:B4)D,SUM(B2:B4)4,iftheB1:B3cellsare1,2,3,thentheformulaS
