Ukucubungula idatha kwedatha ukuqoqwa, ukuhleleka, ukuqulunqwa nokuhlaziywa kolwazi ngekhono lokunquma izitayela kanye nokubikezelwa kwalesi simo esihlolwe. E-Excel, kunamanani amaningi amathuluzi asiza ukuqhuba ucwaningo kule ndawo. Izinguqulo zakamuva zalolu hlelo azikho ngaphansi kohlelo lokusebenza olukhethekile lwezibalo ngokuvumelana namakhono. Amathuluzi amakhulu okwenza izibalo nokuhlaziywa yimisebenzi. Ake sihlole izici ezijwayelekile zokusebenzisana nabo, futhi sihlale ngamanye amathuluzi awusizo kakhulu.
Imisebenzi yesitatimende
Njenganoma yimiphi eminye imisebenzi e-Excel, imisebenzi yezibalo isebenza ezingxabanweni ezingaba ngesimo sezinombolo eziqhubekayo, okubhekiselwe kuma-cell or arrays.
Amazwi angangena ngesandla esitokisini esithile noma kwibha yefomula, uma wazi i-syntax yomthombo othile. Kodwa kungcono kakhulu ukusebenzisa iwindi lempikiswano ekhethekile, eliqukethe amacebo nezinkambu zokufaka idatha ezilungiselelwe. Yiya efasiteleni lokuphikisana lezinkulumo zezibalo zingadlula "Umphathi wemisebenzi" noma usebenzisa izinkinobho "Amabhuku Emisebenzi" kwi-tape.
Kunezindlela ezintathu zokuqala umsebenzi wizard:
- Chofoza kusithonjana "Faka umsebenzi" ngakwesokunxele kwebha yefomula.
- Ukuba ngaphakathi kuthebhu "Amafomula", chofoza ibhande ebhokisini "Faka umsebenzi" ebhodini lamathuluzi "I-Function Library".
- Thayipha isinqamuleli sekhibhodi Shift + F3.
Uma wenza noma yikuphi okukhethwa ngenhla, ifasitela lizovuleka. "Masters Imisebenzi".
Khona-ke udinga ukuchofoza ensimini "Isigaba" bese ukhetha inani "Isitatimende".
Emva kwalokho uhlu lwezinkulumo zezibalo luzovuleka. Kuphelele kukhona okungaphezu kwekhulu. Ukuya efasiteleni lokuphikisana yimuphi wabo, udinga nje ukhethe futhi uchofoze inkinobho "Kulungile".
Ukuze siye ezakhiweni sidinga ngokusebenzisa i-ribbon, hamba kuthebhu "Amafomula". Eqenjini lamathuluzi ku-tape "I-Function Library" chofoza inkinobho "Iminye imisebenzi". Ohlu oluvulwa, khetha isigaba "Isitatimende". Uhlu lwezici ezitholakalayo zeseluleko esikufunayo. Ukuya efasiteleni lokuphikisana, chofoza nje kwenye yazo.
Isifundo: I-Excel Function Wizard
MAX
I-operator ye-MAX yakhelwe ukunquma inani eliphezulu lamasampuli. Iqukethe i-syntax elandelayo:
= MAX (inombolo 1; inombolo yesibili; ...)
Emkhakheni wezingxabano okudingayo ukungena emigqeni yamaseli lapho uchungechunge lwamanani lukhona khona. Inombolo enkulu kunazo zonke, le fomula ibonisa esitokisini.
MIN
Ngegama lomsebenzi we-MIN, kucacile ukuthi imisebenzi yayo iphikisana ngokuqondile nefomula langaphambilini - lifuna okuncane kunazo zonke kusuka kuqoqo lezinombolo bese libonisa esitokisini esinikeziwe. Iqukethe i-syntax elandelayo:
= MIN (inombolo1; inombolo2; ...)
ISAVERAGE
Umsebenzi we-AVERAGE usesho inombolo kwinani elichazwe eliseduze nencazelo ye-arithmetic. Umphumela walokhu kubalwa uboniswa esitokisini esithile lapho ifomula iqukethe khona. Isifanekiso sayo sinjengoba:
= I-AVERAGE (inombolo1; inombolo2; ...)
ISAVERAGE
Umsebenzi we-AVERAGE unemisebenzi efanayo neyaphambilini, kodwa unamandla okucacisa isimo esengeziwe. Isibonelo, ngaphezulu, okungaphansi, akulingani nenombolo ethile. Isethwe ensimini ehlukile yezingxabano. Ngaphezu kwalokho, uhla lokulinganisa lungafakwa njengengxabano yokuzikhethela. I-syntax ilandelayo:
= I-AVERAGE (inombolo1; inombolo2; ...; isimo; [ububanzi bokulinganisa])
I-MODA.ODN
I-formula MOD.AODN ibonisa esitokisini inombolo kusukela kusethi eyenzeka kaningi. Kuzinguqulo ezindala ze-Excel, kwakukhona umsebenzi we-MODA, kodwa ngezihumusho zamuva kwahlukaniswa kabili: i-MODA.ODN (yezinombolo zomuntu ngamunye) ne-MODANASK (yezinhlaka). Kodwa-ke, inguqulo endala iphinde ihlale eqenjini elihlukile, lapho izici ezisuka kuzinguqulo zangaphambilini zalolu hlelo ziqoqiwe ukuqinisekisa ukuhambisana kwamadokhumenti.
= MODA.ODN (inombolo1; inombolo2; ...)
= MODAHNA (inombolo1; inombolo2; ...)
MEDIANA
I-MEDIANA opharetha inquma inani elilinganiselwe kunamba yezinombolo. Lokhu kungukuthi, akuseli isilinganiso sesibalo samanani, kepha nje kuphela inani elilinganiselwe phakathi kwenani elikhulu kunazo zonke nelincane kakhulu lamanani. I-syntax yile:
= MEDIAN (inombolo1; inombolo2; ...)
STANDOWCLONE
I-STANDOCLON yefomula kanye ne-MODA iyinhlangano yezinguqulo ezindala zalolu hlelo. Manje i-subspecies yayo yesimanje isetshenziswa - STANDOCLON.V no-STANDOCLON.G. Eyokuqala yazo yenzelwe ukubala ukuphambana okujwayelekile kwesampula, kanti okwesibili - inani labantu jikelele. Le misebenzi isetshenziselwa ukubala ukuphambuka okujwayelekile. I-syntax yabo ilandelayo:
= STDEV.V (inombolo1; inombolo2; ...)
= STDEV.G (inombolo1; inombolo2; ...)
Isifundo: I-Excel Standard Forward Deviation
UMPHAKATHI
Lo opharetha ubonisa esitokisini esikhethiwe inombolo ngenombolo ngokuhlehlisa. Okusho ukuthi, uma sinesisindo esingu-12.97.89.65, futhi sichaza u-3 njengengxabano yesimo, khona-ke umsebenzi esitokisini uzobuyisela inombolo yesithathu enkulu kakhulu. Kulesi simo, kungu-65. Isitatimende se-syntax sithi:
= OKUKHULU (ukulungiswa; k)
Kulesi simo, i-value ye-ordinal yenani.
I-LEAST
Lo msebenzi yisithombe esibukweni sesitatimende sangaphambilini. Kuyo futhi impikiswano yesibili inombolo yenombolo. Lapha kuphela kuleli cala, lo myalelo uthathwa njengamancane. I-syntax yile:
= LEAST (i-array; k)
RANG.SR
Lo msebenzi unempumelelo yesenzo sangaphambilini. Kulo seli elicacisiwe, linikeza inombolo yokulandelana kwenani elithile kwisampula ngesimo, esichazwe ngempikiswano ehlukile. Lokhu kungenzeka ukuthi kukwenyuka noma kwehla. Lesi samuva senziwe ngokuzenzakalelayo uma insimu ikhona "Hlela" shiya kungenalutho noma ubeke khona inombolo 0. I-syntax yale nkulumo ilandelayo:
= RANK.SR (inombolo; uhlu; ukuhleleka)
Ngenhla, kuphela imisebenzi ethandwa kakhulu futhi efunwa izibalo ku-Excel ichazwe. Empeleni, ziphindwe izikhathi eziningi. Kodwa-ke, isimiso esiyisisekelo sezenzo zabo kufana: ukucubungula uhlu lwamanani nokubuyisela umphumela wezenzo zekhompyutha kumakhalekhukhwini ocacisiwe.
