辦公軟件使用教材!全套!excel word ppt（辦公軟件使用教材! 全套! excel word ppt）

《辦公軟件使用教材!全套!excel word ppt（辦公軟件使用教材! 全套! excel word ppt）》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。

1、辦公軟件使用教材!全套!excelwordppt（辦公軟件使用教材!全套!excelwordppt）55.inputnumbers,words,datesortimeClickthecellthatyouneedtoinputdata,typeinthedataandpressEnterorTabkey.Ifitistimeforaslashorminusseparateddateoftheyear,month,day,forexample,youcantype9/5/96orJun-96.Ifyou

2、pressthe12hourinputtime,pleaseemptythegridafterthetimenumber,andtypethelettera(morning)orP(afternoon),forexample,9:00P.Otherwise,ifonlythetimenumberisentered,ExcelwillbeprocessedaccordingtoAM(morning).56.fastinputeurosymbolFirstpresstheAltkey,thenusethe

3、rightdigitalkeyboard(commonlyknownassmallkeyboard),type0128ofthese4numbers,releasetheAltkey,youcanentertheeurosymbol.57.convertsthecellregionfromaformulatoavalueSometimes,youmightneedtoconvertaformulainacellregionintoavalue.Theconventionalmethodistoconv

4、ertdatawiththe"value"optionin"selectivepaste".Infact,thereisaneasierway:firstselectregionalcellcontainsaformula,holddowntherightmousebuttontodragtheregionalonganydirectioninashortdistance(donotreleasethemouse),andthendragitbackintheoriginalpositionofthe

5、cellarea(atthistime,releasethemousecellborderbecomesspent).Select"copyonlythevaluefromtheshortcutmenu".58.fastinputorderedtextIfyouoftenneedtoinputsomeregularsequencetext,suchasnumbers(1,2...)Date(1days,2days)Etc.,Youcanusethefollowingmethodtoimplementt

6、hequickinput:firstinputthefirsttwoelementsofthetextinthefirst,second,twocellswhichneedtoinputthesequencetext,suchas"aandB".Atthesametime,selectthesetwocells,themousewillbemovedtothesecondlowerrightcornerofthecellintoafinecrosslinewhen(weusuallycalled"fi

7、llhandle"),presstheleftmousebuttontodragback(ordown)thelastcellneedtofillinthesequence,releasetheleftmousebutton,thenthesequenceofthefollowingelements(suchas"C,D,e......")Automaticallyfillinthecorrespondingcellsinorder.59.inputregularfiguresSometimesiti

8、snecessarytoinputsomevaluesthatarenotnaturalincrements(suchasgeometricsequences:2,4,8)Wecandoitbyrightdragging:first,enterthefirsttwovaluesofthesequenceinfirst,second,twocells(2,4).Atthesametime,selectthesetwocells,themousewillbe