Elinye lamathuluzi wokubala owaziwa kakhulu ngumgogodla wabafundi. Isetshenziselwa ukukala ukubaluleka kwesibalo sezinhlobonhlobo ezihlukahlukene ezihlanganisiwe. I-Microsoft Excel inomsebenzi okhethekile wokubala le nkhomba. Ake sifunde ukuthilala kanjani ukuhlolwa kwe-T e-Excel.
Incazelo yesikhathi
Kodwa, ngokuqala, ake sithole ukuthi yini eyenza umgomo wabafundi ngokujwayelekile. Lesi sibonakaliso sisetshenziselwa ukuhlola ukulingana kwamagugu ajwayelekile wamasampuli amabili. Okusho ukuthi, kunquma ukucaciswa kwemehluko phakathi kwamaqembu amabili wedatha. Ngesikhathi esifanayo, isethi yonke yezindlela ezisetshenziselwa ukunquma lesi sikhawulo. Isibonakaliso singabalwa ngokucabangela indlela eyodwa noma ukusabalalisa ngendlela emibili.
Ukubalwa kwenkomba ku-Excel
Manje siphenduka ngokuqondile embuzweni wokubala lesi sibonakaliso ku-Excel. Kungenziwa ukukhiqizwa ngokusebenzisa umsebenzi Ukuhlolwa kokuhlola. Ngezinguqulo ze-Excel 2007 nangaphambili, ibizwe TTEST. Kodwa-ke, ishiyelwe kwezinye izinguqulo zamuva ngezinhloso zokuhambisana, kodwa zisacelwa ukuba zisetshenziswe kakhulu zanamuhla - Ukuhlolwa kokuhlola. Lo msebenzi ungasetshenziswa ngezindlela ezintathu, okuzoxoxwa ngokuningiliziwe ngezansi.
Indlela 1: Umsebenzi weWebhu
Indlela elula yokubala le nqubo iwuhlelo lomsebenzi.
- Sakha itafula ngemigqa emibili yezinguquko.
- Chofoza kunoma iyiphi iseli elingenalutho. Sicindezela inkinobho "Faka umsebenzi" ukubiza umsebenzi wizard.
- Ngemuva kokuthi umsebenzi wizard uvule. Ukufuna ukubaluleka ohlwini TTEST noma Ukuhlolwa kokuhlola. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ivuleka. Emasimini "Massive1" futhi "Massiv2" faka izixhumanisi zemigqa emibili ehambelana nayo. Lokhu kungenziwa ngokumane ukhethe amaseli afunayo ane-cursor.
Ensimini "Umsila" faka inani "1"uma kubalwa kwenziwa ngenqubo yokusabalalisa okukodwa, futhi "2" esimweni sokusatshalaliswa kokubili.
Ensimini "Thayipha" Amanani alandelayo afakiwe:
- 1 - isampula inezinhlobo ezithembekile;
- 2 - isampula inezici ezizimele;
- 3 - isampula inezici ezizimele eziphambene nokungalingani.
Uma yonke idatha igcwele, chofoza inkinobho. "Kulungile".
Ukubalwa kwenziwa, futhi umphumela uboniswa esikrinini kuseli elikhethiwe.
Indlela 2: Sebenza nethebhu "Amafomula"
Umsebenzi Ukuhlolwa kokuhlola Ungase futhi ushayele ngokuya kuthebhu "Amafomula" usebenzisa inkinobho ekhethekile kwi-tape.
- Khetha iseli ukubonisa umphumela kushidi. Iya kuthebhu "Amafomula".
- Chofoza inkinobho. "Iminye imisebenzi"elitholakala kutheyipu ematheni amathuluzi "I-Function Library". Uhlu oluvulekile, iya esigabeni "Isitatimende". Kusukela kokukhethwa okukhethiwe okukhethiwe "STUEDENT.TEST".
- Ifasitela lezimpikiswano zivuleka, esizifunde ngokuningiliziwe lapho sichaza indlela yangaphambilini. Zonke izenzo ezengeziwe zifana ncamashi kulo.
Indlela 3: okokufaka ngesandla
Ifomu Ukuhlolwa kokuhlola Ungayifaka futhi ngesandla kunoma yisiphi iseli kushidi noma kumshini womsebenzi. I-syntax yayo ilandelayo:
= Ukuhlolwa kwe-STUDENT (I-Array1; I-Array2; Imilenze; Uhlobo)
Lokho okushiwo yizo zonke izingxabano kusho ukuthi kucatshangwa uma kuhlaziywa indlela yokuqala. Lezi zimiso kufanele zishintshwe kulo msebenzi.
Ngemuva kwedatha efakiwe, cindezela inkinobho Ngena ukubonisa umphumela esikrinini.
Njengoba ubona, ukuhlola kwe-Excel yomfundi kubalwa kalula futhi ngokushesha. Into eyinhloko ukuthi umsebenzisi owenza izibalo kufanele aqonde ukuthi ungubani nokuthi yimiphi idatha yokufakwayo onesibopho. Uhlelo ngokwalo lwenza ukubala okuqondile.
