Umsebenzi weTabortion ukubala kwenani lomsebenzi yengxabano ngayinye efanelekile echazwe ngesinyathelo esithile emingceleni esungulwe kahle. Le nqubo iyithuluzi lokuxazulula imisebenzi ehlukahlukene. Ngosizo lwayo, ungenza izimpande zendawo ze-equation, thola okuphezulu kanye ne-minima, ukuxazulula eminye imisebenzi. Ngohlelo lwe-Excel, i-Tabation kulula kakhulu ukwenza ukwedlula ukusebenzisa iphepha, isibambo nokubala. Ake sibheke ukuthi lokhu kwenziwa kanjani kulolu hlelo lokusebenza.
Ukusetshenziswa kwe-tabulation
I-tablization isetshenziswa ngokwakha itafula lapho inani lengxabano ngesinyathelo esikhethiwe lizoqoshwa kwikholamu eyodwa, nakwesibili - umsebenzi ohambelana nawo. Ngemuva kwalokho, ngesisekelo sokubalwa, ungakha uhlelo. Cabanga ukuthi lokhu kwenziwa kanjani esibonelweni esithile.Ukudala itafula
Dala itafula elinetafula elinamakholomu X, lapho inani lengxabano lizokhonjiswa, futhi f (x), lapho kuboniswa khona umsebenzi ohambisanayo. Isibonelo, thatha umsebenzi f (x) = x ^ 2 + 2x, yize ukusebenza kwanoma yiluphi uhlobo lungasetshenziselwa inqubo ye-tab. Sibeka igxathu (h) ngenani le-2
- Esitokisini sokuqala sekholamu "X" Faka inani "-10". Ngokushesha emva kwalokho sichofoza inkinobho ethi Enter. Lokhu kubaluleke kakhulu, kusukela uma uzama ukukhohlisa igundane, inani esitokisini lizophenduka ifomula, futhi kulokhu akudingekile.
- Onke amanani angeziwe angagcwaliswa ngesandla, anamathele esiteji 2, kepha kulula kakhulu ukwenza lokhu usebenzisa ithuluzi le-autofill. Ikakhulu le ndlela iyasebenza uma uhla lwezingxabano lukhulu, futhi isinyathelo esincane sincane.
Khetha iseli equkethe inani lengxabano yokuqala. Ngenkathi usethebhu "Yasekhaya", chofoza inkinobho ethi "Gcwalisa", okutholakala ethepheni ku-Izilungiselelo Zezilungiselelo ze- "Ukuhlela". Uhlu lwesenzo oluvelayo, ngikhetha ukuthuthuka komshwana "...".
- Iwindi lokuhlelwa kwethuthuka livuleka. Epharamitha "yendawo", sibeka i-switch endaweni ethi "ngamakholomu", kusukela kithi amanani wengxabano azofakwa kukholamu, hhayi ngentambo. In the "Isinyathelo" field, setha inani 2. In the "Inani Lomkhawulo", faka inombolo 10. Ukuze uqale inqubekela phambili, cindezela inkinobho ethi "KULUNGILE".
- Njengoba ukwazi ukubona, ikholomu igcwele amanani ane-pitch kanye nemingcele.
- Manje udinga ukugcwalisa ikholomu yomsebenzi f (x) = x ^ 2 + 2x. Ukuze wenze lokhu, esitokisini sokuqala sekholamu ehambisanayo, bhala le nkulumo ngethempulethi elandelayo:
= x ^ 2 + 2 * X
Ngasikhathi sinye, esikhundleni senani le-X Sifaka izixhumanisi zeseli lokuqala kusuka kwikholamu ngezimpikiswano. Sichofoza inkinobho ethi Enter ukuze ubonise umphumela wokubala esikrinini.
- Ukuze ubale umsebenzi futhi kweminye imigqa, sizophinde sisebenzise ubuchwepheshe obuqhubekayo, kepha kulokhu sizosebenzisa umaki wokugcwaliswa. Sisungula isikhombisi ekhoneni elingezansi kwesokudla seseli lapho ifomula isivele ikhona. Umaki wokugcwalisa uyavela, wethulwa ngendlela encane ngosayizi wesiphambano. UClement inkinobho yegundane kwesobunxele futhi welula isikhombisi kanye nekholomu yonke egcwalisiwe.
- Ngemuva kwalesi senzo, ikholomu yonke enamagugu omsebenzi izogcwaliswa ngokuzenzakalelayo.
Ngakho-ke, umsebenzi wethebhu wenziwe. Ngokuyisisekelo sayo, singathola, ngokwesibonelo, ukuthi okungenani umsebenzi (0) utholakala ngamanani we-rengral -2 kanye no-0 kufinyelelwe endaweni ehambelana nengxabano 10, futhi ingu-120.
Isifundo: Kanjani ukugcwalisa ngokuzenzakalela ku-Excel
Ihluzo zokwakha
Kususelwa kuthebhu efakwe etafuleni, ungakha uhlelo lokusebenza.
- Khetha wonke amanani etafuleni nesikhombisi ngenkinobho yegundane kwesobunxele. Ake siphendukele kuthebhu ethi "Faka", ku-Chart Tool Block ethepheni sicindezela inkinobho ethi "Amagrafu". Uhlu lwezinketho zegrafu ezitholakalayo luyatholakala. Khetha uhlobo esilubheka njengefanele kakhulu. Endabeni yethu, iphelele, ngokwesibonelo, uhlelo olulula.
- Ngemuva kwalokho, isoftware yohlelo yenza inqubo yokwakha igrafu ngokususelwa ebangeni letafula elikhethiwe.
Ngaphezu kwalokho, uma ufisa, umsebenzisi angahlela ishadi njengoba kubonakala kunesidingo kusetshenziswa amathuluzi we-Excel ngalezi zinhloso. Ungangeza amagama ama-axes ezixhumanisi namahluzo awonke, susa noma uqambe kabusha i-legend, susa umugqa wokuphikisana, njll.
Isifundo: Ungayakha kanjani uhlelo ku-Excel
Njengoba sibona, umsebenzi we-tabution, ngokuvamile, inqubo ilula. Kuliqiniso, ukubalwa kungathatha isikhathi eside. Ikakhulu uma imingcele yezimpikiswano ibanzi kakhulu, futhi igxathu lincane. Sindiswe kakhulu isikhathi sokusiza amathuluzi aphelele aphelele. Ngaphezu kwalokho, ohlelweni olufanayo, ngokwesisekelo umphumela, ungakha igrafu yokwethula okubukwayo.