Ukusebenza kwedatha yezibalo ukuqoqwa, uku-odwa, ukwenziwa kwezinto zonke kanye nokuhlaziywa kwemininingwane nekhono lokuthola izitayela nokubikezela kwento efundwayo. I-Excel inenqwaba yamathuluzi asiza ukwenza ucwaningo kule ndawo. Izinguqulo zakamuva zalolu hlelo ngokuya ngamakhono cishe azimbi kangako kunezicelo ezikhethekile emkhakheni wezibalo. Amathuluzi amakhulu okwenza izibalo kanye nokuhlaziywa yimisebenzi. Ake sifunde izici ezijwayelekile zokusebenza nazo, futhi futhi sicabange ngamanye amathuluzi awusizo kakhulu.
Imisebenzi Yesibalo
Njenganoma yimiphi eminye imisebenzi ku-Excel, imisebenzi yezibalo isebenza ngama-agumenti, angenza isimo senombolo engaguquki, izinkomba kumaseli noma i-arrays.
Izinkulumo zingafakwa ngesandla esitokisini esithile noma emugqeni wamafomula, uma wazi isincazelo sendawo ethile. Kepha kulula kakhulu ukusebenzisa iwindows yengxoxo ekhethekile, equkethe izinkundla ezikhuthazayo nezenziwe ngomumo zokufaka idatha. Iya ewindini lokuphikisana ngezinkulumo zezibalo "Mnikazi wemisebenzi" noma usebenzisa izinkinobho Imitapo Yezimpawu ekhasethini.
Kunezindlela ezintathu zokuqalisa Umsebenzi Wizard:
- Chofoza isithonjana. "Faka umsebenzi" ngakwesokunxele sebha yefomula.
- Ukuba kuthebhu Amafomula, chofoza ubambo enkingeni "Faka umsebenzi" ebhokisini lamathuluzi Umtapo wesici.
- Isinqamuleli sekhibhodi I-Shift + F3.
Lapho wenza noma ikuphi kulezi zinketho ezingenhla, kuzovulwa iwindi "Amakhosi wemisebenzi".
Ngemuva kwalokho kufanele uchofoze insimu Isigaba bese ukhetha inani "Izibalo".
Ngemuva kwalokho, uhlu lwezitatimende zezibalo luyavula. Sekukonke bangaphezulu kwekhulu. Ukuya ewindini lokuphikisana kwanoma yimuphi wabo, udinga nje ukuyikhetha bese uchofoza inkinobho "Kulungile".
Ukuze uye kuzakhi esizidingayo ngokusebenzisa iribhoni, iya kuthebhu Amafomula. Ebhokisini lamathuluzi iribhoni Umtapo wesici chofoza inkinobho "Eminye imisebenzi". Kuluhlu oluvulayo, khetha isigaba "Izibalo". Uhlu lwezinto ezitholakalayo zesiqondisi olifunayo luzovulwa. Ukuya ewindini lokuphikisana, chofoza nje elinye lazo.
Isifundo: Umsebenzi Wizard e-Excel
I-MAX
Umhlinzeki we-MAX wenzelwe ukunquma inani eliphezulu kusuka kusampula. Ine-syntax elandelayo:
= MAX (inombolo1; inombolo2; ...)
Emikhakheni yokuphikisana, udinga ukufaka amabanga weseli lapho kutholakala khona uchungechunge lwamanani. Le ndlela ifomula isibalo esikhulu kunazo zonke kusuka kuso singena kuleso seli lapho itholakala khona.
IMIN
Ngegama lomsebenzi we-Min, kuyacaca ukuthi imisebenzi yayo iphambene ngqo nefomula yangaphambilini - isesha okuncane kakhulu kusuka kusethi yezinombolo futhi ikubonisa esitokisini esinikeziwe. Ine-syntax elandelayo:
= MIN (inombolo1; inombolo2; ...)
INDAWO
Umsebenzi we-AVERAGE usesha inombolo ebangeni elibekiwe elisondele kakhulu kunani le-arithmetic kusho. Umphumela walesi sibalo uboniswa kuseli elihlukile, eliqukethe ifomula. Isifanekiso sakhe sinje:
= ISIVIVINYO (inombolo1; inombolo2; ...)
INDAWO
Umsebenzi we-AVERAGE unemisebenzi efanayo neyangaphambili, kepha kungenzeka ukusetha isimo esengeziwe kukho. Isibonelo, okuningi, okuncane, akulingani nenombolo ethile. Isethwe endaweni ehlukile yengxabano. Ngaphezu kwalokho, ibanga lokulinganisa lingangezwa njengengxabano ongayikhetha. I-syntax imi kanje:
= AVERAGES (inombolo1; inombolo2; ...; isimo; [ibanga lokulinganisa])
IMODA EYODWA
Ifomula yeMODA.ODN ikhombisa esitokisini inombolo evela kusethi eyenzeka kaningi. Ezinguqulweni ezindala ze-Excel bekukhona umsebenzi weMODA, kepha kuzinguqulo zakamuva kwahlukaniswa kabili: I-MODA.ODN (yezinombolo ngazinye) ne-MODA.NSK (yama-arrays). Kodwa-ke, le nguqulo yakudala ibuye yahlala eqenjini elihlukile, eliqoqe izakhi ezivela ezinhlotsheni ezedlule zohlelo ukuqinisekisa ukuhambisana kwemibhalo
= MODA. Munye (inombolo1; inombolo2; ...)
= MODA.NSK (inombolo1; inombolo2; ...)
UMEDAYANI
Osebenzisa i-MEDIAN unquma inani elijwayelekile ebangeni lezinombolo. Okusho ukuthi, ayizisunguli zisho izibalo, kepha inani eliphakathi kwenani elikhulu nelincane kunawo wonke. I-syntax ibukeka kanjena:
= MEDIAN (inombolo1; inombolo2; ...)
STD
Ifomula STANDOTLON efana neMODA iyisiqephu sezinguqulo ezindala zohlelo. Manje kusetshenziswa imixhaso yayo yesimanje - STANDOTKLON.V kanye STANDOTKLON.G. Eyokuqala yazo yakhelwe ukubala ukuphambuka okujwayelekile kwesampula, kanti okwesibili - inani elivamile. Lemisebenzi futhi isetshenziselwa ukubala ukuphambuka okujwayelekile. I-syntax yabo imi kanje:
= STD. B (inombolo1; inombolo2; ...)
= STD. G (inombolo1; inombolo2; ...)
Isifundo: Ifomula yokuphambuka ejwayelekile ye-Excel
OKUKHULU
Lo opharetha ukhombisa kuseli elikhethiwe inombolo evela kubantu ekhonjiswe ukwehla kwe-oda. Okusho ukuthi, uma sinesethi engu-12.97.89.65, bese sicacisa u-3 njengokuphikisana kwesikhundla, khona-ke umsebenzi uzobuyisa inombolo yesithathu ngobukhulu esitokisini. Kulokhu, kungama-65. Isithasiselo se-opharetha sinje:
= BIGGEST (uhlu; k)
Kulesi simo, k yinombolo ye-serial.
OKUPHELELE
Lo msebenzi ungumfanekiso wesibuko opharetha wangaphambilini. Iphinde ibe nengxabano yesibili njengenombolo ye-serial. Kepha kuphela kuleli cala, i-oda libhekwa kusukela komncane. I-syntax yile:
= OKUPHELELE (uhlu; k)
I-RANK.SR
Lo msebenzi unomphumela ohlukile walowo owedlule. Esitokisini esichaziwe, inikeza inombolo ye-serial yenombolo ethile kusampula ngesimo esishiwo empikiswaneni ehlukile. Kungakhuphuka noma kwehle i-oda. Lesi sakamuva sisethwe ngokuzenzakalelayo uma inkambu "I-oda" shiya kungenalutho noma faka inamba 0. I-syntax yalesi sisho imi kanje:
= RANK.CP (inombolo; uhlu; i-oda)
Imisebenzi ethandwa kakhulu futhi ethandwa kakhulu yezibalo ku-Excel echazwe ngenhla. Eqinisweni, ziningi izikhathi eziningi. Noma kunjalo, umgomo oyisisekelo wezenzo zabo uyafana: ukucubungula uluhlu lwedatha futhi kubuyise umphumela wezenzo zokukhokhelwa kuseli elicacisiwe.
