Ukubalwa kombandela womfundi ku-Excel

Umbandela womfundi igama elivamile leqembu lokuhlolwa kwezibalo (imvamisa, uhlamvu lwesiLatini “t” lwengezwa ngaphambi kwegama elithi “umbandela”). Kuvame ukusetshenziselwa ukuhlola ukuthi izindlela zamasampula amabili ziyalingana yini. Ake sibone ukuthi ubalwa kanjani lo mbandela ku-Excel usebenzisa umsebenzi okhethekile.

Okuqukethwe

Isibalo sokuhlolwa kuka-t somfundi

Ukuze senze izibalo ezihambisanayo, sidinga umsebenzi “ISIVIVINYO SOMFUNDI”, ezinguqulweni zangaphambili ze-Excel (2007 nangaphezulu) - “TEST”, nayo esezinhlelweni zesimanje ukuze kugcinwe ukuhambisana namadokhumenti amadala.

Umsebenzi ungasetshenziswa ngezindlela ezahlukene. Ake sihlaziye inketho ngayinye ngokwehlukana sisebenzisa isibonelo sethebula elinemigqa emibili-amakholomu amanani ezinombolo.

Umbandela wokubalwa kwabafundi ku-Excel

Indlela 1: Ukusebenzisa Iwizadi Yomsebenzi

Le ndlela yinhle ngoba awudingi ukukhumbula ifomula yomsebenzi (uhlu lwezimpikiswano zalo). Ngakho, i-algorithm yezenzo imi kanje:

  1. Sima kunoma iyiphi iseli yamahhala, bese uchofoza isithonjana "Faka umsebenzi" kwesokunxele sebha yefomula.Umbandela wokubalwa kwabafundi ku-Excel
  2. Efasiteleni elivuliwe Umsebenzi Wizards khetha isigaba “Uhlu oluphelele lwama-alfabhethi”, ohlwini olungezansi sithola u-opharetha “ISIVIVINYO SOMFUNDI”, yimaka bese uchofoza OK.Umbandela wokubalwa kwabafundi ku-Excel
  3. Iwindi lizovela esikrinini lapho sigcwalisa khona izimpikiswano zomsebenzi, emva kwalokho sicindezela OK:
    • "Masiv1“Futhi "Massive2" - cacisa ububanzi bamaseli aqukethe uchungechunge lwezinombolo (kithi, lokhu “A2:A7” и “B2:B7”). Lokhu singakwenza mathupha ngokufaka izixhumanisi ezisuka kukhibhodi, noma simane sikhethe izakhi ezidingekayo kuthebula ngokwalo.
    • “Imisila” – Ngibhala inombolo "1"uma ufuna ukwenza ukubala kokusabalalisa kwendlela eyodwa, noma "2" – ngezinhlangothi ezimbili.
    • "Ithiphu" - kulo mkhakha bonisa: "1" - uma isampula iqukethe okuguquguqukayo okuncikile; "2" – kusukela ezimele; "3" - kusuka kumanani azimele anokwehluka okungalingani.Umbandela wokubalwa kwabafundi ku-Excel
  4. Njengomphumela, inani elibaliwe lombandela lizovela kuseli yethu nomsebenzi.Umbandela wokubalwa kwabafundi ku-Excel

Indlela 2: faka umsebenzi ngokusebenzisa “Amafomula”

  1. Shintshela kuthebhu "Amafomula", nayo enenkinobho "Faka umsebenzi", okuyikhona esikudingayo.Umbandela wokubalwa kwabafundi ku-Excel
  2. Ngenxa yalokho, izovuleka Isilekeleli somsebenzi, ezinye izenzo ezifanayo nalezo ezichazwe ngenhla.

Ngethebhu "Amafomula" umsebenzi “ISIVIVINYO SOMFUNDI” ingaqhutshwa ngokuhlukile:

  1. Eqenjini lamathuluzi "Ilabhulali Yomsebenzi" chofoza isithonjana "Ezinye Izici", ngemva kwalokho kuzovuleka uhlu, lapho sikhetha khona isigaba "Izibalo". Ngokuskrola ohlwini oluhlongozwayo, singathola u-opharetha esimdingayo.Umbandela wokubalwa kwabafundi ku-Excel
  2. Isikrini sizobonisa iwindi lokugcwalisa izimpikiswano, esesivele sihlangane nazo ngaphambili.

Indlela yoku-3: Ukufaka ifomula mathupha

Abasebenzisi abanolwazi bangenza ngaphandle Umsebenzi Wizards futhi kuseli edingekayo faka ngokushesha ifomula enezixhumanisi eziya kububanzi bedatha oyifunayo namanye amapharamitha. I-syntax yomsebenzi ngokuvamile ibonakala kanje:

= ISIVIVINYO.SOMFUNDI(I-Array1;I-Array2;Imisila;Uhlobo)

Umbandela wokubalwa kwabafundi ku-Excel

Sihlaziye impikiswano ngayinye esigabeni sokuqala sokushicilelwa. Osekusele ukuthi kwenziwe ngemuva kokuthayipha ifomula ukucindezela Faka ukwenza izibalo.

Isiphetho

Ngakho, ungakwazi ukubala ukuhlola kuka-t koMfundi ku-Excel usebenzisa umsebenzi okhethekile ongaqaliswa ngezindlela ezahlukene. Futhi, umsebenzisi unethuba lokufaka ngokushesha ifomula yomsebenzi kuseli oyifunayo, noma kunjalo, kulokhu, kuzodingeka ukhumbule i-syntax yayo, engase ibe nzima ngenxa yokuthi ayisetshenziswa njalo.

shiya impendulo