excel_training

Formatcell-Pattern,FontandBorderToChangethepattern,fontorborder,please:Selectacelloranarea,selectmenuFormat/CellsorclickmouserightbuttontoselectformatcellsYoucantrydifferentkindsofselectionStageIActualDateFirstPlanIncludingPB,RCandSC,TargettoInt2.ReqA4/19/996/4/99ReqA4/19/996/4/99PB,RCDesign6/7/998/6/99Design6/7/997/16/99andSC,CodeUT8/9/999/10/99CodeUT7/19/998/31/99TargettoInt2IntTest9/13/9910/15/99IntTest9/1/9912/1/99Int2actuallystartin9/27/99andfinishedin10/15/99ShortCutPostponein8/9/99AttentionpelaseAttentionpleaseInsertCell,RowandColumnToinsert,selectthecell/row/columnyouwanttoinsertbeforeit,selectmenuInsert/Cells,orRoworColumn.Payattentiontothedifferentresultcausedbydifferentinsert.StageIActualDateFirstPlanIncludingPB,RCandSC,TargettoInt2.ReqA6/4/99ReqA4/19/996/4/99PB,RCDesign4/19/998/6/99Design6/7/997/16/996/7/991.ResultofInsertRowandSC,CodeUT9/10/99CodeUT7/19/998/31/99TargettoInt2IntTest8/9/9910/15/99IntTest9/1/9912/1/999/13/99Int2actuallystartin9/27/99andfinishedin10/15/99ShortCutPostponein8/9/992.ResultofIntertCellwithshiftright4.ResultofInsertColumn3.ResultofInterCellwithshiftdownRepeatandSeriesTorepeatorseries,selectthecellorthearea,movethecursortotherightlowercornerofthearea(withasmalldotthere),thenjustdrag.ReqA6/7/996/8/996/9/996/10/996/11/99ReqAReqAReqA6/8/996/8/996/9/996/10/996/11/99ReqAReqAReqA6/9/99ReqA6/10/9912343579MergeCell/WrapTomergecells,selectthosecells,thengotoformatcell/Alignment/MergeCellsTowrap,selectthosecells,thengotoformatcell/Alignment/WrapStageIActualDateFirstPlanIncludingPB,RCandSC,TargettoInt2.ReqA4/19/996/4/99ReqA4/19/996/4/99Design6/7/998/6/99Design6/7/997/16/99CodeUT8/9/999/10/99CodeUT7/19/998/31/99IntTest9/13/9910/15/99IntTest9/1/9912/1/99Int2actuallystartin9/27/99andfinishedin10/15/99ShortCutPostponein8/9/99Mergethe4cellsto1.StageIActualDateFirstPlanIncludingPB,RCandSC,TargettoInt2.ReqA4/19/996/4/99ReqA4/19/996/4/99Design6/7/998/6/99Design6/7/997/16/99CodeUT8/9/999/10/99CodeUT7/19/998/31/99IntTest9/13/9910/15/99IntTest9/1/9912/1/99Int2actuallystartin9/27/99andfinishedin10/15/99ShortCutPostponein8/9/99WrapNew/Rename/DeleteSheetTonewaworksheet,gotomenuInsert/Worksheetorusemouserightbuttonatthebottomofthesheet.Torenameaworksheet,gotomenuFormat/Sheet/Renameorusemouserightbuttonatthecerrainsheetatthebottom.Todeleteaworksheet,gotomenuEdit/DeleteSheetorusemouserightbuttonatthecerrainsheetatthebottom.AddCommentsSelectthecellyouwanttoaddcomments,gotomenuInsert/Commentorusemouserightbutton.Selectthecellyouwanttodeletecomments,usemouserightbutton.YoucanseethecommentofacellbymovingthecursortothecellorgotomenuView/Comments.Youcanchangethestyoeofacommentsbyusingmouserightbutton/editComments/Formatcomments.NameAgeAddressPhoneMobilePagerShow/HideTohideColumnsorRows,selectthecolumnsorrowstohide,usemouserightbuttonandselecthideorgotomenuFormat/Row/Hide.ToshowhidedColumnsorRows,selectthecolumnsorrowsincludethosehidedrows/columns,usemouserightbuttonandselectunhideorgotomenuFormat/Row/Unhide.ABFCDGEPrintSelecttheareaandgotomenuFile/PrintArea/SetPrintArea.GotomenuFile/PrintArea/ClearPrintAreatoclearthedefinedprintarea.GotomenuFile/Pagesetup/Page/Scalingtoprintthecontentinacertainnumberofpages.ValueValidationTouseValueValidation,selectthecellsandgotomenuData/Valicationdefinethevalidationyouneed.NumberListStringCustom5AUFwww.homedfgsdfSortSelecttheareayouwanttosort,gotomenuData/Sort,definesortbywhat.Youcansortbythevalueinacertaincolumn.CRNumberArea/ProjectStatusDescriptionOwnerSeverity*Age*StatusPlatformBuildCRisIntegratedIntoCSGce51081asyn_appsLc.i5r.03:VoiceShortcutatMainMenuproblemKenBorgelt337Thiscametoasyn_appsfromUISon4/6.Tryingtodetermineifthisbelongsinmainmenuora ppt 关于艾滋病ppt课件精益管理ppt下载地图下载ppt可编辑假如ppt教学课件下载triz基础知识ppt emplate.CSGce54647asyn_appsOci5r15:AttachingNumberinPhonebookfailedMaxWu12Maxindicatesthishasbeenresolved.ThiswillberemovedfromApril17list.pendingCSGce54648asyn_appsOc.int5r.15CallTimesmenuiteminRecentCallsmenunotaccessibleMaxWu22Maxindicatesthishasbeenresolved.ThiswillberemovedfromApril17list.pendingCSGce54654asyn_appsNSelectingSID/NID1causesmainpowerdownexceptionJohnKraus/GarySteimle12Thisisastackoverflowproblemandisbeingcharacterized.CSGce54864asyn_appsNcint5r.16,willpowerdownwhenthereisnewmessageandpress"TextMsgs"Vencat/Jinghong21BeinginvestigatedbymsgteamCSGce54889asyn_appsOc.int5r.16:CannotplaceacallonholdMukund20ThisisstillbeinganalyzedbyFloridateam.BehaviorappearstobecorrectaccordingtoFlexCSGce53706plat_intg_cdmaNcint5r.12,InfoSrvcSetupscreendisplaysoftkeyincorrect.Jinghong310Thisstillmightbeanmsggappissue.Needtogetbackgroundinformationonsoftkeyupdates.CSGce53710plat_intg_cdmaN911callshouldreattempcallwhencallisdroppedJacques/Gopal310Jacques/GopalneedstotellKenifthisisarealproblem,orthatthisfeatureisNOTSUPPORTEDinthisphonerelease.CSGce53778plat_intg_cdmaNcint5r.13,NotransientnoticedisplayedafterpressdoneinInfoSetupJinghongXu39BeinginvestigatedbymsgteamCSGce53667synergyNCallForwardingoptionnotfunctioningcorrectlyJacques/Gopal310WaitingforanalysisinformationfromGopal.NOTE:Thisiscurrentlystuckinthesynergyproject.Tryingtogetsomeonetomoveitovertoasyn_apps.FilterSelecttheareayouwanttofilter,gotomenuData/Filter/AutoFilter.CRNumberArea/ProjectStatusDescriptionOwnerSeverity*Age*StatusPlatformBuildCRisIntegratedIntoCSGce51081asyn_appsLc.i5r.03:VoiceShortcutatMainMenuproblemKenBorgelt337Thiscametoasyn_appsfromUISon4/6.Tryingtodetermineifthisbelongsinmainmenuorapptemplate.CSGce54647asyn_appsOci5r15:AttachingNumberinPhonebookfailedMaxWu12Maxindicatesthishasbeenresolved.ThiswillberemovedfromApril17list.pendingCSGce54648asyn_appsOc.int5r.15CallTimesmenuiteminRecentCallsmenunotaccessibleMaxWu22Maxindicatesthishasbeenresolved.ThiswillberemovedfromApril17list.pendingCSGce54654asyn_appsNSelectingSID/NID1causesmainpowerdownexceptionJohnKraus/GarySteimle12Thisisastackoverflowproblemandisbeingcharacterized.CSGce54864asyn_appsNcint5r.16,willpowerdownwhenthereisnewmessageandpress"TextMsgs"Vencat/Jinghong21BeinginvestigatedbymsgteamCSGce54889asyn_appsOc.int5r.16:CannotplaceacallonholdMukund20ThisisstillbeinganalyzedbyFloridateam.BehaviorappearstobecorrectaccordingtoFlexCSGce53706plat_intg_cdmaNcint5r.12,InfoSrvcSetupscreendisplaysoftkeyincorrect.Jinghong310Thisstillmightbeanmsggappissue.Needtogetbackgroundinformationonsoftkeyupdates.CSGce53710plat_intg_cdmaN911callshouldreattempcallwhencallisdroppedJacques/Gopal310Jacques/GopalneedstotellKenifthisisarealproblem,orthatthisfeatureisNOTSUPPORTEDinthisphonerelease.CSGce53778plat_intg_cdmaNcint5r.13,NotransientnoticedisplayedafterpressdoneinInfoSetupJinghongXu39BeinginvestigatedbymsgteamCSGce53667synergyNCallForwardingoptionnotfunctioningcorrectlyJacques/Gopal310WaitingforanalysisinformationfromGopal.NOTE:Thisiscurrentlystuckinthesynergyproject.Tryingtogetsomeonetomoveitovertoasyn_apps.CalculationTodocalculationgotomenuInsert/Function.ApplicationNCLOC%OrganizationBrowserproxy10000.78%GSD-MIELMaxCode23563Messaging1520011.85%GSD-MASCIncallsetup20611.61%GSD-MPSCAppswithMaxCodePhonebookRingVb24321.90%GSD-MPSCCenterwithMaxCodeGSD-SCMCInitsetup38663.01%GSD-MPSCPhoneStatus25992.03%GSD-MPSCBasicPhone37232.90%GSD-MPSCVolumewithMeter5550.43%GSD-MPSCPowerdown3200.25%GSD-NAFVolume4980.39%GSD-NAFNAR5160.40%GSD-NAFIdle6470.50%GSD-NAFSCMCCodeTotal51470Powerup7650.60%GSD-NAFMIELCodeTotal1000Calling58664.57%GSD-NAFMASCCodeTotal15200Mainmenu23891.86%GSD-NASNAFCodeTotal8612Personalize33002.57%GSD-NASNASCodeTotal14387Datebook86986.78%GSD-NASATSOCodeTotal9600FixedDial128009.98%GSD-SCMCKDCCodeTotal12777SIM45003.51%GSD-SCMCRecentcall106078.27%GSD-SCMCPhonebook2356318.37%GSD-SCMCNetworkreg2540.20%PCS-ATSOBluetooth5540.43%PCS-ATSONetworksetting87926.85%PCS-ATSOCDMADataapp127779.96%PCS-KDCTotal128282DatainOtherSheetCalculatetheSUMofthenumberinpreviouseSheet10CalculatetheMINofthenumberinpreviouseSheet1MakeChartSelectthedataareayouwanttomakechart,gotomenuInsert/ChartGroup/UngroupGotomenuData/GroupandOutline/Group11Phonebook11.1Overview11-111.2GeneralDescription11-211.3AccessingthePhonebook11-311.4ListView11-411.4.1GeneralDescription11-411.4.2ListViewScreenElements11-411.4.3SortedbyName11-511.4.4SortedbySpeedNumber11-611.4.5SortedbyVoiceName11-711.5DetailedView11-811.5.1GeneralDescription11-811.5.2DetailedViewScreenElements11-811.5.3SortedbyName11-911.5.4SortedbySpeedNumber11-1011.5.5SortedbyVoiceName11-1111.5.6PhoneswithSIMCards11-128RecentCalls8.1Overview8-18.2Unanswered/MissedCalls8-28.2.1NewMissedCallDialogandReminder8-28.2.2SecondaryDisplayUnanswered/MissedCalls8-38.3AccessingRecentCalls8-58.3.1RecentCallsMenu8-58.4ReceivedCallsandDialedCalls8-78.4.1AccessingReceivedCallsandDialedCalls8-78.4.2ReceivedCalls/DialedCallsListView8-8TesterPetterAllenTomDeveloperHarryGrayFreeze/UnfreezeFreeze/Unfreezeshouldbeusedtogetherwithwindowsplit,orselectanareathengotomenuWindow/FreezePanesConditionalFormatSelecttheareandgotomenuFormat/ConditionalFormating1234562234563345674455785567896678910778910118891011129910111213ControlPivotTableUnderstandCselectedNotSee!VerygoodonthisGodApplicationLOCNCLOC%OrganizationResourceDocSizeTestCaseDefectProductivityBrowserproxy120010000.76%??Messaging390801520011.57%GSD-MASC15348Incallsetup20611.57%GSD-MPSCRingVb371324321.85%GSD-MPSC3Initsetup589338662.94%GSD-MPSC5PhoneStatus259925991.98%GSD-MPSC4BasicPhone372337232.83%GSD-MPSCVolumewithMeter5555550.42%GSD-MPSCVoiceControl0.00%GSD-MPSCPowerdown3200.24%GSD-NAF1Volume4984980.38%GSD-NAFNAR5165160.39%GSD-NAFIdle6470.49%GSD-NAFPowerup7650.58%GSD-NAF1Calling58664.47%GSD-NAFMainmenu434323891.82%GSD-NAS1Personalize850033002.51%GSD-NAS2Datebook1997286986.62%GSD-NAS4543FieldTestMode0.00%GSD-NASVoiceRecognition350130692.34%GSD-NASWakeupreminder0.00%GSD-NASFixedDial128009.74%GSD-SCMCSIM704345003.43%GSD-SCMC5342Recentcall21405106078.08%GSD-SCMC3Phonebook410592356317.94%GSD-SCMC8Networkreg2540.19%PCS-ATSO1Bluetooth5545540.42%PCS-ATSO768DisplaiInfoRec0.00%PCS-ATSO2Networksetting87926.69%PCS-ATSO/GSD-MIEL6CDMADataapp12777127779.73%PCS-KDC6TOTAL131351Area/Project(All)CountofCRNumberAge*OwnerSeverity*01291037GrandTotalJacques/Gopal322Jacques/GopalTotal22Jinghong311JinghongTotal11JinghongXu311JinghongXuTotal11JohnKraus/GarySteimle111JohnKraus/GarySteimleTotal11KenBorgelt311KenBorgeltTotal11MaxWu111211MaxWuTotal22Mukund211MukundTotal11Vencat/Jinghong211Vencat/JinghongTotal11GrandTotal11313110