Ukusebenza kwamathebhu okusebenza ku-Microsoft Excel

Ukumisa umsebenzi kuwuphawu lokubaluleka komsebenzi wempikiswano ngayinye ehambelanayo, enikezwe isinyathelo esithile, ngaphakathi kwemingcele echazwe ngokucacile. Le nqubo iyithuluzi lokuxazulula imisebenzi ehlukahlukene. Ngesizo salo, ungakwazi ukubona izimpande ze-equation, thola ama-maxima ne-minima, uxazulule ezinye izinkinga. Ukusebenzisa i-Excel kwenza kube lula kakhulu kunokusebenzisa iphepha, ipeni, nokubala. Ake sithole ukuthi lokhu kwenziwa kanjani kulolu hlelo lokusebenza.

Sebenzisa amathebhu

Ukubethelwa kusetshenziswe ngokudala itafula lapho inani lempikiswano nesinyathelo esikhethiwe lizobhalwa kukholomu eyodwa, kanye nokusebenza komsebenzi okwesikhashana. Khona-ke, ngokusekelwe ekubalweni, ungakha igrafu. Cabanga ukuthi lokhu kwenziwa kanjani ngesibonelo esithile.

Indalo yethebula

Dala isihloko setafula ngamakholomu xokuyinto ezoba yinani lempikiswano, futhi f (x)lapho ukubaluleka komsebenzi kuboniswa khona. Isibonelo, thatha umsebenzi f (x) = x ^ 2 + 2x, nakuba umsebenzi wanoma yiluphi uhlobo ungasetshenziselwa inqubo yokuthutha. Setha isinyathelo (h) ngesamba 2. Umngcele kusuka -10 kuze kube 10. Manje sidinga ukugcwalisa ikholomu yokuphikisana, ngokulandela isinyathelo 2 emingcele enikeziwe.

1. Esitokisini sokuqala sekholomu "x" faka inani "-10". Masinyane emva kwalokho, chofoza inkinobho Ngena. Lokhu kubaluleke kakhulu, ngoba uma uzama ukuphatha igundane, inani eliseli cell lizophenduka ifomula, kodwa kulokhu akudingekile.



2. Wonke amagugu engeziwe angagcwaliswa ngesandla, ngokulandela isinyathelo 2kodwa kulula kakhulu ukwenza lokhu ngosizo lwethini lokugcwalisa ngokuzenzakalelayo. Ikakhulukazi le nketho iyadingeka uma uhla lwezingxabano lukhulu, kanti isinyathelo sincane kakhulu.

   Khetha iseli eliqukethe inani le-argument yokuqala. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho "Gcwalisa"okuyinto efakwe ebhokisini ebhokisini lesethingi Ukuhlela. Kuhlu lwezenzo ezivela, khetha into "Ukuqhubeka ...".



3. Iwindi yokuhlela iwindi ivula. Kupharamitha "Indawo" setha inkinobho ukuma "Ngamakholomu", ngoba kithi kithi izindinganiso zempikiswano zizofakwa kukholomu, hhayi emgqeni. Ensimini "Isinyathelo" setha inani 2. Ensimini "Inani elilinganiselwe" faka inombolo 10. Ukuze uqhubekele phambili, chofoza inkinobho "Kulungile".



4. Njengoba ungabona, ikholomu igcwele amanani ngesinyathelo esinqunyiwe nemingcele.



5. Manje kudingeka sigcwalise ikholomu yomsebenzi. f (x) = x ^ 2 + 2x. Ukuze wenze lokhu, esitokisini sokuqala sekholomu ehambelanayo sibhala inkulumo ngokusho kwephethini elilandelayo:

   = x ^ 2 + 2 * x

   Kulesi simo, esikhundleni senani x faka izixhumanisi zeselula yokuqala kusukela kukholomu ngeziphakamiso. Sicindezela inkinobho Ngena, ukubonisa umphumela wokubala esikrinini.



6. Ukuze senze isibalo somsebenzi kwezinye imigqa, saphinda sisebenzise ubuchwepheshe bokuphelela ngokuzenzakalelayo, kodwa kulokhu sisebenzisa uphawu lokugcwalisa. Setha isikhombisi ekhoneni elingaphansi kwesokudla leseli, esivele liqukethe ifomula. Uphawu lokugcwalisa luvela, luboniswa njengesiphambano esincane. Bamba inkinobho yegundane lesokunxele bese uhudula isikhombisi eduze nayo yonke ikholomu egcwalisiwe.



7. Ngemuva kwalesi senzo, yonke ikholomu enezindinganiso zomsebenzi izogcwaliswa ngokuzenzekelayo.

Ngakho-ke, umsebenzi wokuthungatha wenziwa. Ngokusekelwe kulo, singathola, isibonelo, ukuthi ubuncane bomsebenzi (0) kufinyelelwe ngamanani wokuphikisana -2 futhi 0. Umsebenzi omkhulu phakathi kokuhluka kwempikiswano evela -10 kuze kube 10 kufinyelele endaweni ehambisana ne-mpikiswano 10futhi uyakha 120.

Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel

I-Plotting

Ngokusekelwe kumathebhu akhiqizwa etafuleni, ungahlela umsebenzi.

1. Khetha wonke amanani etafuleni ngesikhombisi ngenkinobho yegundane lesokunxele egcinwe phansi. Yiya kuthebhu "Faka"ebhodini lamathuluzi "Amashadi" kwi-tape chofoza inkinobho "Amashadi". Uhlu lwezinketho zehluzo ezikhona luboniswa. Khetha uhlobo esicabanga ukuthi lufanele kakhulu. Esikhathini sethu, isibonelo, isimiso esilula siphelele.



2. Ngemuva kwalokho, eshadini, uhlelo lwenza inqubo yokuhlela ngokusekelwe ebangeni lethebula elikhethiwe.

Ngaphezu kwalokho, uma ufisa, umsebenzisi angakwazi ukuhlela isimiso njengoba ebona kufanelekile, besebenzisa amathuluzi we-Excel ngale njongo. Ungangeza amagama wezinkomba kanye negrafu ngokuphelele, ususe noma uqambe kabusha umlando, susa umugqa wezimpikiswano, njll.

Isifundo: Ungakha kanjani igrafu ku-Excel

Njengoba ungabona, umsebenzi we-tabulation, ngokujwayelekile, inqubo ilula. Yiqiniso, izibalo zingathatha isikhathi eside. Ikakhulukazi uma imingcele yezimpikiswano ikhulu kakhulu, futhi isinyathelo sincane. Amathuluzi okuzenzakalela we-Excel azosiza ukulondoloza isikhathi. Ngaphezu kwalokho, ohlelweni olufanayo ngesisekelo somphumela owatholakali, ungakha igrafu ukuze uthole ukuboniswa okubukwayo.