Sitshintsha i-Direction Movement Curve kwi-Excel

Ngokungagqibekanga, i-Excel ihamba ngokuzenzekelayo isalathisi esele isebenzayo , okanye isilayidi yeselluli ukuya kwisisele esilandelayo xa iqhosha lokungena kwikhibhodi icinezelwa. Esi sikhokelo esingagqibekanga sokuhambisa isikhombisi sikhethwe kuba idatha idla ngokufakwe kwiikholamu enye iseli emva kwesinye i-cursor ishukumisela phantsi xa ukhiye olungenayo ucacisa ukungena kwedatha.

Ukutshintshwa koLawulo lweCursor

Ukuziphatha okungagqibekanga kungatshintshwa ukuze isikhombisi sitshele ngakwesokudla, ngakwesobunxele, okanye phezulu endaweni yehla. Kwakhona kunokwenzeka ukuba isikhombisi singashenxi nakwezinye, kodwa hlala kuseli langoku emva kokuba ukhiye wokungena ucacisiwe. Ukutshintshwa kwesikhokelo sesikhombisi kwenziwa ngokusebenzisa i- Advanced options kwibhokisi yencoko yebhokisi ye -Excel. Fumana imiyalelo malunga nokwenza utshintsho ngezantsi.

01 ka 02

Sitshintsha i-Direction Movement Curve kwi-Excel

© Ted French

Ukutshintsha isalathisi isikhombisi sisenza:

  1. Cofa kwifayile yefayile yedbhoni ukuvula imenyu yefayile
  2. Cofa kwiNketho kwimenyu ukuvula ibhokisi yencoko yebhokisi ye- Excel
  3. Cofa kwi- Advanced kwi-pane yesandla sokunxele kwibhokisi yencoko
  4. Ngaphantsi koku Emva kokucindezela ukungena, fudula ukhetho kwicandelo lokunene lokunene, cofa kwitolo eliphantsi kweNqununu ukuze ukhethe isikhokelo esiya kuso siza kuhamba xa ukhiye we-Enter ushicilelwe.
  5. Ukuba isalathisi seseli sihlale kwiseli enye, susa uphawu lokutshekisha kwibhokisi elandelayo emva kokucindezela Faka, susa ukhetho

02 we 02

Ukusebenzisa iTeb uze ufake ii Keys Xa ufaka iDatha

Ukuba ngokufakela ukungena kwedatha kwimigqa kunokuba ungene phantsi kwiikholamu, ungasebenzisa ukhiye weTeb ukuhambisa ngakwesobunxele ukuya kwesokudla kwiphepha lokusebenzela kunokuba utshintshe isalathisi esingagqibekanga usebenzisa imiyalelo echazwe ngasentla.

Emva kokungena kwiseli yokuqala yedatha:

  1. Cinezela ukhiye weTeb ukuhambisa iseli enye ngakwesokudla kumqolo ofanayo
  2. Qhubeka ungena kwedatha kwaye usebenzisa ikhi yeTeb ukuya kwiseli elandelayo ukuya ngasekunene de kube sekugqitywe umqolo wedatha
  3. Cinezela ukhiye wokungena ukubuyela kwikholam yokuqala ukuqala umqolo olandelayo weedatha