Ungayifumana njani ikhonkco le-cyclic ukuze i-Excel

Anonim

Ikhonkco leCyclic kwiMicrosoft Excel

Izalathiso zeCyclic yifomula apho iseli enye ngokulandelelana konxibelelwano kunye nezinye iiseli, ekugqibeleni ibhekisa ngokwayo. Ngamanye amaxesha, abasebenzisi basebenzise ngokufanelekileyo isixhobo esinjalo sekhompyutha. Umzekelo, le ndlela inokukunceda ngokumodeli. Kodwa, kwiimeko ezininzi, le meko iyimpazamo nje kwifomula ukuba umsebenzisi uvunyelwe ekukhubazeke okanye ngenxa yezinye izizathu. Ngokumalunga noku, ukususa impazamo, kuya kufuneka ufumane ikhonkco lokujikeleza. Makhe sibone ukuba kwenzeka njani.

Ukufumanisa unxibelelwano lwe-cyclic

Ukuba ikhonkco le-cyclic likhona encwadini, ke xa uqala ifayile, inkqubo kwibhokisi yencoko yababini iya kulumkisa ngale nyaniso. Ke, kunye nenkcazo yobukho bendlela enjalo, akuyi kubakho ngxaki. Ungayifumana njani indawo yengxaki?

Indlela yoku-1: iqhosha kwi-ribbon

  1. Ukufumanisa, apho uluhlu luyifomula, okokuqala kubo bonke, cinezela iqhosha njengomnqamlezo omhlophe kwisikwere esibomvu kwibhokisi yencoko yababini kwibhokisi yesilumkiso, ngaloo ndlela siyivale.
  2. Ukuvala ibhokisi yencoko yababini yeMicrosoft Excel

  3. Yiya kwi "formoulas" ithebhu. Kwiteyiphu kwi-Vill "Ukuxhomekeka" kwibhloko apho kukho iqhosha "lokujonga iimpazamo". Cofa kwi icon kwifom ye-triangle eguqulweyo ecaleni kweli qhosha. Kwimenyu ebonakalayo, khetha "Amakhonkco onxibelelwano". Emva kokuba inguqu malunga nalo mbhalo ngohlobo lwemenyu ibonisa zonke izinxibelelanisi ze-lop yendalo ye-cyclic kule ncwadi. Xa ucofa ekunxibelelaneni kweseli ethile, iyasebenza kwiphepha.
  4. Ukufumana iireferensi ze-CYCLICC kwi-Microsoft Excel

  5. Ngokufunda sisiphumo, siseka ukuxhomekeka kwaye siwuphelise unobangela wokuba ngumngcelele ukuba kubangelwa yimpazamo.
  6. Ukususa ikhonkco le-cyclic kwi-Microsoft Excel

  7. Emva kokuphumeza izenzo ezifanelekileyo, buyela emva ukuze ujonge iqhosha leempazamo ze-cyclic. Ngeli xesha imenyu yemenyu ehambelana nayo mayingasebenzi kwaphela.

Ukujonga kwakhona kwikhonkco lomjikelo kwiMicrosoft Excel

Indlela 2: Trace Atoll

Ikho enye indlela yokufumanisa ukuxhomekeka okungafunekiyo.

  1. Kwibhokisi yebhokisi yencoko yababini malunga nobukho bamakhonkco e-cyclic, cinezela iqhosha u "Kulungile".
  2. Ibhokisi yencoko yababini yeMicrosoft Exver

  3. Umkhondo utolo luvela, olubonisa ukuxhomekeka kwedatha kwiseli enye kwenye.

Trawsere kutolo kwiMicrosoft Excel

Kuya kufuneka kuqatshelwe ukuba indlela yesibini ibonwa ngendlela ebonakalayo ngokubonakalayo, kodwa kwangaxeshanye ayisoloko inika umfanekiso ocacileyo wokuhamba kakuhle, ngokungafaniyo nendlela yokuqala, ngakumbi kwifomumu enzima.

Njengoko ubona, fumana ikhonkco le-cyclic ukuba ilula kakhulu, ngakumbi ukuba uyayazi i-algorithm yokukhangela. Ungasebenzisa enye yeendlela ezimbini zokufumana ukuxhomekeka okunjalo. Ngandlel 'ithile kunzima ngakumbi ukufumanisa ukuba le fomula ifuneka kwinyani okanye yimpazamo nje, kunye nekhonkco elichanekileyo.

Funda ngokugqithisileyo