Ɗaya daga cikin abubuwan da aka fi sani da kayan aikin kididdigan shine samfurin Student. An yi amfani da shi don auna ma'auni na ƙididdiga masu mahimmanci daban-daban. Microsoft Excel yana da aikin musamman don lissafta wannan alamar. Bari mu koyi yadda za a tantance jarrabawar jarrabawa a Excel.
Ma'anar lokaci
Amma, don masu farawa, bari mu binciko abin da ya kasance a matsayin ɗan littafin a gaba ɗaya. Ana nuna alamar wannan alama don duba daidaitattun dabi'u masu yawa na samfurori biyu. Wato, yana ƙayyade inganci na bambance-bambance tsakanin bangarorin biyu. A lokaci guda, ana amfani da dukan hanyoyin da za a ƙayyade wannan ƙimar. Mai nuna alama za a iya ƙididdige yin la'akari daya hanya ko rarraba hanyoyi biyu.
Kirar mai nuna alama a Excel
Yanzu mun juya kai tsaye zuwa tambayar yadda za a tantance wannan alamar a Excel. Ana iya samar da shi ta wurin aikin TEST TEST. A cikin sassan Excel 2007 da baya, an kira shi TTEST. Duk da haka, an bar shi a cikin wasu sifofin baya don dalilai masu dacewa, amma har yanzu ana bada shawarar su yi amfani da sababbin zamani - TEST TEST. Za'a iya amfani da wannan aikin ta hanyoyi uku, wanda za'a tattauna dalla-dalla a kasa.
Hanyar 1: Wizard aikin
Hanyar da ta fi dacewa don lissafta wannan alamar ita ce ta hanyar aikin mai aiki.
- Mun gina tebur tare da layuka biyu na masu canji.
- Danna kan komai maras amfani. Muna danna maɓallin "Saka aiki" don kiran aikin maye.
- Bayan an gama aikin mai aiki. Neman darajar a jerin TTEST ko TEST TEST. Zaɓi shi kuma danna maballin. "Ok".
- Maganin gardama ya buɗe. A cikin filayen "Massive1" kuma "Massiv2" shigar da daidaitattun layuka biyu na masu canji. Ana iya yin hakan ta hanyar zabar sel da ake so tare da siginan kwamfuta.
A cikin filin "Sutsi" shigar da darajar "1"idan an kirkiro lissafi ta hanyar hanyar raba ɗaya, kuma "2" a game da rarraba hanyoyi biyu.
A cikin filin "Rubuta" An shigar da dabi'u masu zuwa:
- 1 - samfurin ya ƙunshi nauyin dogara;
- 2 - samfurin ya ƙunshi dabi'u masu zaman kansu;
- 3 - samfurin ya ƙunshi dabi'u mai zaman kanta tare da ɓatawa mara kyau.
Lokacin da duk bayanai suka cika, danna maballin. "Ok".
An yi lissafi, kuma an nuna sakamakon akan allon a cikin wayar da aka zaɓa.
Hanyar 2: Yi aiki tare da shafin "Formulas"
Yanayi TEST TEST Zaka kuma iya kira ta zuwa shafin "Formulas" ta amfani da maɓalli na musamman akan tef.
- Zaɓi tantanin halitta don nuna sakamakon a kan takardar. Jeka shafin "Formulas".
- Danna maballin. "Sauran Ayyuka"wanda yake a kan tef a cikin wani asalin kayan aiki "Gidan Kayan aiki". A cikin jerin bude, je zuwa sashen "Labarin lissafi". Daga zaɓuɓɓuka da aka zaɓa zaɓa "KASHI".
- Hasken muhawara ya buɗe, wanda muka yi nazari daki-daki yayin da aka kwatanta hanyar da ta gabata. Dukkan ayyukan da aka yi daidai daidai ne a ciki.
Hanyar 3: shigarwar manhaja
Formula TEST TEST Hakanan zaka iya shigar da shi hannuwan hannu a cikin kowane tantanin halitta a kan takardar ko a cikin layi. Sakamakonsa kamar haka:
= TASKIYAR KARANTA (Array1; Array2; Tails; Rubuta)
Abin da kowanne jayayya yake nufin lokacin da aka bincika hanyar farko. Wadannan dabi'u ya kamata a sauya cikin wannan aikin.
Bayan an shigar da bayanai, danna maballin Shigar don nuna sakamakon akan allon.
Kamar yadda kake gani, jarrabawar Excel ta dalibi an ƙaddara sosai sauƙi da sauri. Abu mafi mahimmanci shi ne cewa mai amfani da yake ɗaukar lissafin dole ya fahimci abin da yake kuma abin da bayanan shigar da yake da alhakin. Shirin na kanta ya yi lissafi daidai.
