Chimodzi mwazida zodziwika bwino kwambiri zowerengera anthu ndi kuyesa kwa Ophunzira. Amagwiritsidwa ntchito poyesa kuchuluka kwa mawerengero azinthu zingapo zophatikizidwa. Microsoft Excel ili ndi ntchito yapadera kuwerengera chizindikiro ichi. Tiyeni tiwone momwe kuwerengera kuyeserera kwa Ophunzira ku Excel.
Tanthauzo la mawuwa
Koma, poyambira, tiyeni tidziwe chomwe chitsimikiziro chaophunzira ndicho. Chizindikirochi chimagwiritsidwa ntchito kuti zitsimikizire kufanana kwa mitundu iwiri. Ndiye kuti, ndizomwe zimasiyanitsa tanthauzo la kusiyana pakati pa magulu awiriwa a data. Nthawi yomweyo, njira zonse zimagwiritsidwa ntchito kuti mudziwe izi. Chizindikirochi chimatha kuwerengeka poganizira njira imodzi kapena yogawa awiri.
Kuwerengeredwa kwa chizindikiro ku Excel
Tsopano titembenukira mwachindunji ku funso la momwe tingawerengere chizindikiro ichi mu Excel. Itha kuchitika kudzera mu ntchito STUDENT.TEST. M'mitundu ya Excel 2007 ndi m'mbuyomu, adayitanidwa KUYESA. Komabe, adasiyidwa mumagulu amtsogolo kuti agwirizane, koma adalimbikitsidwabe kugwiritsa ntchito ina yamakono mwa iwo - STUDENT.TEST. Ntchitoyi ikhoza kugwiritsidwa ntchito m'njira zitatu, zomwe zidzafotokozeredwa mwatsatanetsatane pansipa.
Njira 1: Wizard wa Ntchito
Njira zosavuta kuwerengera izi ndi kudzera mu Ntchito Wizard.
- Timapanga tebulo lokhala ndi mizere iwiri yosiyanasiyana.
- Dinani pa cell iliyonse yopanda kanthu. Dinani batani "Ikani ntchito" kuyitanira Wizard wa Ntchito.
- Pambuyo pa Ntchito Wizard watsegula. Tikuyang'ana phindu pamndandanda KUYESA kapena STUDENT.TEST. Sankhani ndikudina batani. "Zabwino".
- Windo la mkangano likutseguka. M'minda "Pantan1" ndi Array2 timalowa m'magulu awiri omwe ali ndi mizere iwiri yosiyanasiyana. Izi zitha kuchitidwa ndikungosankha maselo omwe akufuna ndi cholozera.
M'munda Mchira lowetsani mtengo wake "1"ngati magawidwe amodzi adzawerengedwa, ndipo "2" m'malo ogawa awiri.
M'munda "Mtundu" Mfundo zotsatirazi zalembedwa:
- 1 - zitsanzo zimakhala ndi zodalirika;
- 2 - chitsanzocho chimakhala ndi mfundo zoyima palokha;
- 3 - chitsanzocho chimakhala ndi mitengo yodziyimira payokha komanso yopatuka mosiyanasiyana.
Pamene deta yonse yadzaza, dinani batani "Zabwino".
Kuwerengera kumachitika, ndipo zotsatira zake zimawonetsedwa pazenera mu foni yosankhidwa.
Njira 2: gwiritsani ntchito tsamba la Fomula
Ntchito STUDENT.TEST ingathenso kutchedwa mwa kupita ku tabu Mawonekedwe kugwiritsa ntchito batani lapadera pa riboni.
- Sankhani khungu kuti muwonetse zotsatira patsamba. Pitani ku tabu Mawonekedwe.
- Dinani batani "Ntchito zina"ili pa riboni m'bokosi la chida Laibulale ya Feature. Pamndandanda wotsitsa, pitani pagawo "Zowerengera". Kuchokera pazomwe zaperekedwa, sankhani ST'YUDENT.TEST.
- Zenera lamatsutso limatseguka, lomwe tidaphunzira mwatsatanetsatane pofotokoza njira yapita. Zochita zina zonse ndizofanana ndendende.
Njira 3: Kulowera Pamanja
Formula STUDENT.TEST Mutha kuyikanso pamanja mu cell iliyonse papepala kapena mzere wothandizira. Maonekedwe ake enieni ndi awa:
= STUDENT.TEST (Array1; Array2; Mchira; Mtundu)
Zomwe tanthauzo lirilonse limatanthawuza zomwe zidawerengedwa posanthula njira yoyamba. Mfundo izi ziyenera kulowezedwa mu ntchitoyi.
Pambuyo poti deta yaikidwa, dinani batani Lowani kuwonetsa zotsatira zake pazenera.
Monga mukuwonera, kutsimikizira kwa ophunzira ku Excel kumawerengeredwa mosavuta komanso mwachangu. Chachikulu ndikuti wosuta omwe amawerengera ayenera kumvetsetsa zomwe ali komanso zomwe amawunikira. Pulogalamuyi imawerengera molunjika.
