办公软件使用教材!全套!excel word ppt（办公软件使用教材! 全套! excel word ppt）

《办公软件使用教材!全套!excel word ppt（办公软件使用教材! 全套! excel word ppt）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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