Ukuhlolwa kwabafundi eMicrosoft Excel

Elinye lamathuluzi ezaziwa kakhulu ezibalo ukuhlolwa komfundi. Kusetshenziselwa ukukala ukubaluleka kwezibalo kwamanani ahlukahlukene abhangqiwe. I-Microsoft Excel inomsebenzi okhethekile wokubala le nkomba. Ake sibheke ukuthi singasibala kanjani isilinganiselo soMfundi ku-Excel.

Ukuchaza ithemu

Kepha, njengabaqalayo, ake sithole ukuthi iyini inkambiso yabafundi. Le nkomba isetshenziselwa ukuqinisekisa ukulingana kwamanani aphakathi amasampula amabili. Lokho wukuthi, kunquma ukubaluleka kokungafani phakathi kwamaqembu amabili wedatha. Ngasikhathi sinye, kusetshenziswa iqoqo lezindlela zokunquma le nqubo. Inkomba ingabalwa icatshangelwa ukusatshalaliswa kwendlela eyodwa noma ezimbili.

Ukubalwa kwesikhombisi ku-Excel

Manje siphendukela ngqo kumbuzo wokuthi singasibala kanjani lesi sikhombisi ku-Excel. Kungenziwa ngokusebenzisa umsebenzi STUDENT.TEST. Ezinguqulweni ze-Excel 2007 nangaphambilini, yabizwa ISIVIVINYO. Kodwa-ke, ibishiywe ezinguqulweni zakamuva ngezinjongo zokuhambisana, kepha kusanconyelwa ukusebenzisa entsha yesimanje kuyo - STUDENT.TEST. Lo msebenzi ungasetshenziswa ngezindlela ezintathu, okuzoxoxwa ngazo ngemininingwane engezansi.

Indlela yoku-1: Umsebenzi Wizard

Indlela elula yokubala le nkomba ngokusebenzisa i-Function Wizard.

1. Sakha itafula ngemigqa emibili yokuguquguquka.



2. Chofoza kunoma iseli elingenalutho. Chofoza inkinobho "Faka umsebenzi" ukushayela Umsebenzi Wizard.



3. Ngemuva kokuba kuvulwe umsebenzi weWizard. Sifuna inani ohlwini ISIVIVINYO noma STUDENT.TEST. Khetha bese uchofoza inkinobho. "Kulungile".



4. Iwindi lokuphikisana liyavula. Emasimini "I-Array1" futhi Array2 sifaka izixhumanisi zemigqa emibili ehambisanayo yokuguquguquka. Lokhu kungenziwa ngokumane ukhethe amaseli owafunayo nesikhombisi.

   Ensimini Imisila faka inani "1"uma ukusatshalaliswa kwendlela eyodwa kuzobalwa, futhi "2" uma kwenzeka usatshalaliswa ngezindlela ezimbili.

   Ensimini "Thayipha" Kufakwa amanani alandelayo:

   • 1 - isampula liqukethe amanani athembekile;
   • I-2 - isampula iqukethe amanani azimele;
   • I-3 - isampula iqukethe amanani azimele ngokuphambuka okungalingani.

   Lapho yonke idatha igcwele, chofoza inkinobho "Kulungile".

Ukubalwa kuyenziwa, bese umphumela ukhonjiswa esikrinini kuseli elikhethwe ngaphambilini.

Indlela 2: sebenza ngethebhu yamafomula

Umsebenzi STUDENT.TEST ingabizwa futhi ngokuya kuthebhu Amafomula usebenzisa inkinobho ekhethekile kubambo.

1. Khetha iseli ukubonisa umphumela ephepheni. Iya kuthebhu Amafomula.



2. Chofoza inkinobho "Eminye imisebenzi"etholakala kubambo kubhokisi lamathuluzi Umtapo wesici. Kuluhlu olwehliswayo, iya esigabeni "Izibalo". Ukusuka kwezinketho ezethulwe, khetha ST'YUDENT.TEST.



3. Iwindi lokuphikisana liyavula, esalifunda ngokuningiliziwe lapho sichaza indlela edlule. Zonke ezinye izinto ziyafana ncamashí nazo.

Indlela Yesithathu: Ukungenela

Ifomula STUDENT.TEST Ungafaka futhi ngesandla kunoma yisiphi iseli eshidi noma emugqeni wokusebenza. Ukuvela kwayo kwe-syntactic kungokulandelayo:

= STUDENT.TEST (Array1; Array2; Imisila; Uhlobo)

Lokho okushiwo yilowo nalowo mpikiswano kwabhekwa ekuhlaziyweni kwendlela yokuqala. Lawa maxabiso kufanele afakwe esikhundleni salo msebenzi.

Ngemuva kokuthi idatha ifakiwe, cindezela inkinobho Ngena ukubonisa umphumela esikrinini.

Njengoba ubona, inqubomgomo yomfundi e-Excel ibalwa kalula futhi ngokushesha. Into esemqoka ukuthi umsebenzisi owenza izibalo kumele aqonde ukuthi uyini nokuthi iyiphi idatha yokufakelwa efanelekile. Uhlelo lwenza izibalo eziqondile uqobo.