Izikhawu zokuthembana ku-Excel

Enye yezindlela zokuxazulula izinkinga zezibalo ukubalwa kwesikhashana sokuzethemba. Isetshenziswa njengenye indlela ekhethwayo ekulinganiseleni kwephuzu ngesampula elincane. Kumele kwaziwe ukuthi inqubo yokubala isikhathi sokuzethemba inzima kakhulu. Kepha amathuluzi wohlelo lwe-Excel akuvumela ukuba ukwelula kalula. Ake sibheke ukuthi kwenziwa kanjani ekusebenzeni.

Indlela 2: I-Trust Trust.

Ngaphezu kwalokho, kunesinye isici esihambisana nokubalwa kwesikhashana sokuzethemba - ukwethembana. Kwavela, kusukela ku-Excel 2010 kuphela. Lo opharetha wenza ukubalwa kwesikhashana esivamile sokuzethemba kusetshenziswa ukusatshalaliswa komfundi. Kuyinto elula kakhulu ukuyisebenzisa lapho ukuhlakazwa futhi, ngokufanele, ukuphambuka okujwayelekile akukaziwa. I-syntax ye-opharetha yile:

= Ukuzethemba .styudient (alpha; ejwayelekile_otchal; usayizi)

Njengoba sibona, amagama abasebenza futhi kuleli cala ahlala engashintshiwe.

Ake sibheke ukuthi ungabala kanjani imingcele yesikhathi sokuzithemba ngokuphambuka okujwayelekile okungaziwa esibonelweni senani elifanayo esilihlolile ngendlela edlule. Izinga lokuzethemba, njengoba okokugcina, thatha ama-97%.

1. Siqokomisa iseli lapho ukubalwa khona kuzokwenziwa. Inkinobho ethi "Faka umsebenzi".



2. Ku-wizard esebenzayo yemisebenzi, iya esigabeni "sezibalo". Khetha igama elithi "trust. Umfundi". Ubumba enkombeni ethi "KULUNGILE".



3. Izimpikiswano zezimpikiswano ze-opharetha ezibekiwe zethulwa.

   Ensimini ye-alpha, enikezwe ukuthi izinga lokuzethemba lingu-97%, qopha inombolo 0.03. Okwesibili kwimigomo yokubalwa kwale pharamitha ngeke ime.

   Ngemuva kwalokho, setha isikhombisi ensimini "yokuphambuka okujwayelekile". Kulokhu le nkomba ayaziwa futhi kuyadingeka ukubala. Lokhu kwenziwa kusetshenziswa umsebenzi okhethekile - i-stambuclone. Ukushayela iwindi lalesi sisebenzisi, chofoza unxantathu ngakwesobunxele sentambo yefomula. Uma ungatholi igama olifunayo ohlwini oluvula, bese udlula "neminye imisebenzi ...".



4. Imisebenzi iyaqala. Sithuthela esigabeni "sezibalo" bese sibhala kuyo igama elithi "StandotClona.b". Bese ubumba enkombeni ethi "KULUNGILE".



5. Iwindi lokuphikisana livuleka. Umsebenzi we-standard stomptone opharetha. Kuyincazelo yokuphambuka okujwayelekile ngesikhathi sesampula. I-syntax yayo ibukeka kanjena:

   = I-stoptonclonal.v (inombolo1; inombolo2; ...)

   Kulula ukuqagela ukuthi ukuphikisana "nenombolo" ikheli lesampula element. Uma isampula libekwe ku-array eyodwa, ungakwazi, usebenzisa ukuphikisana eyodwa kuphela, unikeze isixhumanisi kulolu banga.

   Faka isikhombisi kwinkambu ye- "Number1" futhi, njengokuhlala njalo, ubambe inkinobho yegundane kwesobunxele, sabela isethi. Ngemuva kokuxhumanisa ukushaya insimu, ungagijimeli ukucindezela inkinobho ethi "KULUNGILE", njengoba umphumela uzobe ungalungile. Owangaphambili, kudingeka sibuyele kwizimpikiswano zewindows opharetha. Umfundi ukwenza impikiswano yokugcina. Kulokhu, chofoza igama elifanele emugqeni wefomula.



6. Iwindi lokuphikisana libuye lathathelwa indawo. Faka isikhombisi kwinkambu ye- "Usayizi". Futhi, chofoza unxantathu osuvele uwujwayele ukuya ekukhetheni abahlinzeki. Njengoba uqonda, sidinga igama elithi "akhawunti". Njengoba sisebenzise lesi sici lapho sibala ngendlela edlule, sikhona kulolu hlu, ngakho-ke vele uchofoze kukho. Uma ungakutholi, bese wenza ngokusho kwe-algorithm echazwe ngendlela yokuqala.



7. Ngemuva kokushaya iwindi lengxabano, sibeka ikhesa enkambisweni ye- "Number1" futhi ngenkinobho yegundane ebambene, sigqamisa isethi. Bese ubumba enkombeni ethi "KULUNGILE".



8. Emva kwalokho, uhlelo lwenza ukubalwa futhi lubonise inani lesikhashana sokuzethemba.



9. Ukunquma imingcele, sizophinda sidinge ukubala inani lesilinganiso esijwayelekile. Kepha, unikezwe iqiniso lokuthi i-algorithm yokubala ngosizo lwefomula iyafana nangendlela edlule, futhi nomphumela awukashintshi, ngeke siyeke ngokuningiliziwe ngokwesibili.



10. Ngemuva kokudala imiphumela yokubalwa kwe-srvnah ne-trust. Umtshina, sithola umngcele ofanele wesikhashana sokuzethemba.



11. Okuhlobene kusuka emiphumeleni yokubalwa kwe-opharetha, umphumela wokubalwa kokubalwa uthembekile. Umtshina, sinomngcele wesobunxele wesikhashana sokuzethemba.



12. Uma ukubalwa ukubhala phansi ngefomula elilodwa, khona-ke ukubalwa komngcele wesokudla esimweni sethu kuzobukeka kanjena:

    = Srnavov (B2: B13) + Trust .styudient (0.03; I-stoptotclonal.v (B2: stomplonal.v (B2: stomplonkonal.v (B2)



13. Ngokuvumelana nalokhu, ifomula yokubala umngcele wesobunxele izobukeka kanjena:

    = Srnavov (B2: B13) - Essential.styudent (0.03; I-stoptonclonal.v (B2: stomplonkonal.v (B2: stomplonkonal.v (B2: B13); Akhawunti (B2: B13))

Njengoba ubona, amathuluzi we-Excel azosiza kakhulu ukubalwa kwesikhashana sokuzethemba nemingcele yalo. Ngalezi zinhloso, opharetha abathile basetshenziselwa amasampula, lapho ukuhlakazwa kwaziwa futhi kungaziwa.