Ukufaka uhlelo lokusebenza lwe-tabling ku-Microsoft Excel

Ukusebenza kwetabhula ukubalwa kwenani lomsebenzi wempikiswano ngayinye ehambisanayo echazwe ngesinyathelo esithile, ngaphakathi kwemingcele echazwe ngokucacile. Le nqubo iyithuluzi lokuxazulula izinkinga eziningi. Ngosizo lwayo, ungazenzela izimpande zezindawo, uthole ubukhulu kanye nezincane, uphinde uxazulule ezinye izinkinga. Sebenzisa i-Excel kulula kakhulu ukuyisebenzisa kunokusebenzisa iphepha, ipeni kanye nesibali. Ake sibheke ukuthi lokhu kwenziwa kanjani kulolu hlelo lokusebenza.

Kusetshenziswa Amathebhu

I-Tabulation isetshenziswa ngokwakha itafula lapho inani lengxabano nesinyathelo esikhethiwe lizobhalwa kukholamu eyodwa, kanye nenani lomsebenzi elihambisanayo kukholamu yesibili. Ngemuva kwalokho, ngokuya ngokubala, ungakha igrafu. Cabanga ukuthi kwenziwa kanjani lokhu ngesibonelo esithile.

Ukudalwa kwetafula

Dala unhlokweni wethebula ngezinsika xezizokhombisa ukubaluleka kwengxabano, futhi f (x)lapho kuboniswa khona inani elihambisanayo lomsebenzi. Isibonelo, thatha umsebenzi f (x) = x ^ 2 + 2xnoma umsebenzi wethebhu wanoma yiluphi uhlobo ungasetshenziswa. Setha isinyathelo (h) ngenani le- 2. Umngcele kusuka -10 ngaphambili 10. Manje sidinga ukugcwalisa ikholamu yokuphikisana, silandela isinyathelo 2 ngaphakathi kwemingcele enikeziwe.

1. Esitokisini sokuqala sekholamu x faka inani "-10". Ngokushesha emva kwalokho, chofoza inkinobho Ngena. Lokhu kubaluleke kakhulu, ngoba uma uzama ukukhohlisa igundane, inani esitokisini lizoba ifomula, futhi kulokhu akudingekile.



2. Onke amanye amanani angagcwaliswa ngesandla, ngokulandela igxathu 2, kepha kulula kakhulu ukwenza lokhu usebenzisa ithuluzi eliphelele elizenzakalelayo. Le nketho ibaluleke kakhulu uma ububanzi bempikiswano bukhulu futhi negxathu lilincane.

   Khetha iseli eliqukethe inani lengxabano yokuqala. Ukuba kuthebhu "Ikhaya"chofoza inkinobho Gcwalisa, etholakala kubambo ku-block block "Ukuhlela". Uhlu lwezenzo ezivela, khetha "Ukuqhubeka ...".



3. Iwindi lezilungiselelo zokuqhubekela phambili liyavula. Ipharamitha "Indawo" setha ukushintshela esimweni Ikholomu ngekholamu, ngoba kithi amanani amanani wokuphikisana azofakwa kukholamu, hhayi emgqeni. Ensimini "Isinyathelo" inani elisethiwe 2. Ensimini "Umkhawulo wenani" faka inombolo 10. Ukuze uqale ukuqhubekela phambili, chofoza inkinobho "Kulungile".



4. Njengoba ukwazi ukubona, ikholomu ligcwele amanani ngesinyathelo esibekiwe nemingcele.



5. Manje udinga ukugcwalisa ikholomu yokusebenza f (x) = x ^ 2 + 2x. Ukuze wenze lokhu, esitokisini sokuqala kwekholomu ehambisanayo, bhala isisho ngenqubo elandelayo:

   = x ^ 2 + 2 * x

   Ngaphezu kwalokho, esikhundleni senani x sibeka izixhumanisi zeseli lokuqala kusuka kukholamu ngezimpikiswano. Chofoza inkinobho Ngenaukubonisa umphumela wokubala.



6. Ukuze senze ukubala komsebenzi kweminye imigqa, siphinda sisebenzise ubuchwepheshe obuqedile, kepha kulokhu, sisebenzisa umaki wokugcwalisa. Faka ikhesa ekhoneni elingezansi kweseli esele liqukethe ifomula. Umaka wokugcwalisa uyavela, wethulwe njengophambano oluncane. Bamba phansi inkinobho yegundane kwesobunxele bese uhudula isikhombisi kuwo wonke ikholomu ukuze ugcwaliswe.



7. Ngemuva kwalesi senzo, yonke ikholomu enamanani womsebenzi izogcwaliswa ngokuzenzakalela.

Ngakho-ke, kwenziwa umsebenzi wokuhlaziya. Ngokusekelwe kulo, singathola, ngokwesibonelo, ukuthi ubuncane bomsebenzi (0) kutholwe ngamanani wokuphikisana -2 futhi 0. Isilinganiso somsebenzi ngaphakathi kokuhluka kwengxabano kusuka -10 ngaphambili 10 kufinyelelwa endaweni ehambelana nengxabano 10, futhi wenza 120.

Isifundo: Ungayenza kanjani i-autocomplete ku-Excel

Ukuhlela

Ngokusekelwe kokubhalwe etafuleni, ungahlela umsebenzi.

1. Khetha wonke amanani asetafuleni nesikhombisi ngenkathi uphethe inkinobho yegundane kwesobunxele. Iya kuthebhu Faka, ebhokisini lamathuluzi Amashadi kuthebhu chofoza inkinobho "Amashadi". Uhlu lokukhethwa kukho kokukhethwa kweshadi liyavula. Khetha uhlobo esilubheka njengelufanele kunazo zonke. Isibonelo sethu, ngokwesibonelo, uhlelo olulula luphelele.



2. Ngemuva kwalokho, ephepheni lokusebenzela, uhlelo lenza inqubo yokuhlelwa kwamasheya ngokususelwa kububanzi bethebula elikhethiwe.

Ngaphezu kwalokho, uma kufiswa, umsebenzisi angahlela ishadi njengoba ebona kufanelekile, esebenzisa amathuluzi e-Excel ngalezi zinhloso. Ungangeza amagama ama-axes avumelanayo negrafu iyonke, ususe noma uqambe kabusha leanal, ususe umugqa wokuphikisana, njll.

Isifundo: Ungasakha kanjani isheduli ku-Excel

Njengoba ukwazi ukubona, ukwengeza umsebenzi ngokuvamile inqubo eqondile. Kuliqiniso, ukubala kungathatha isikhashana. Ikakhulu uma imingcele yokuphikisana ibanzi kakhulu futhi isinyathelo sincane. Ukugcina isikhathi ngokubalulekile kuzosiza amathuluzi we-Excel autofill. Ngaphezu kwalokho, kuhlelo olufanayo, olususelwa kumphumela, ungakha igrafu yokwethulwa okubonakalayo.