Daga cikin manyan masu aikin Excel, aikin yana nuna fifikon ikon sa SAURARA. Yana ba ka damar nunawa a cikin ƙayyadadden tantanin halitta ragowar rarrabawa lamba ɗaya ta wani. Bari mu ƙara koyo yadda za a iya amfani da wannan aikin a aikace, kuma mu bayyana yanayin aiki tare da shi.
Aikace-aikcen aiki
Sunan wannan aikin ya fito ne daga sunan wanda aka shafe daga kalmar "saura kuma rabo". Wannan ma'aikacin, wanda yake na rukuni na lissafi, zai baka damar nuna ragowar sakamakon sakamakon rarraba lambobi a cikin tantanin halitta. A lokaci guda, ba a nuna duk sashin sakamakon ba. Idan rabo ya yi amfani da lambobi masu lamba tare da alama mara kyau, za a nuna sakamakon aiki tare da alamar mai rabawa. Gaskiyar magana wannan bayanin ita ce:
= OSTAT (lamba; rarrabuwa)
Kamar yadda kake gani, bayanin yana da hujja biyu ne kawai. "Lambar" rarrabuwa ne wanda aka rubuta cikin sharuddan lambobi. Hujja ta biyu sigar rarrabuwa ce, kamar yadda aka tabbatar da sunan ta. Shine na karshen su wanda yake tantance alamar wanda za a mayar da sakamakon aiki. Muhawara na iya zama ko lambobin ƙima kansu ko nassoshi game da sel waɗanda suke cikin su.
Yi la'akari da zaɓuɓɓuka da yawa don bayyanawar gabatarwar da sakamakon rarrabuwa:
- Bayanin gabatarwa
= OSTAT (5; 3)Sakamakon: 2.
- Bayanin gabatarwa:
= OSTAT (-5; 3)Sakamakon: 2 (tunda rabewar lamari ne mai inganci).
- Bayanin gabatarwa:
= OSTAT (5; -3)Sakamakon: -2 (tunda rarrabuwa darajar lambobi ce mara kyau).
- Bayanin gabatarwa:
= OSTAT (6; 3)Sakamakon: 0 (tunda 6 a kunne 3 raba ba tare da saura ba).
Misalin mai aiki
Yanzu, tare da takamaiman misali, zamuyi la'akari da yanayin amfani da wannan ma'aikacin.
- Bude littafin aiki mai kyau, zabi gidan da zai nuna sakamakon sarrafa bayanai, sannan ka latsa alamar "Saka aikin"an sanya shi kusa da dabarar dabara.
- Kunna cigaba Wizards na Aiki. Matsa zuwa rukuni "Ilmin lissafi" ko "Cikakken jerin haruffa". Zaɓi suna SAURARA. Zaɓi shi kuma danna maballin. "Ok"located a cikin kasa da rabin taga.
- Da muhawara taga yana farawa. Ya ƙunshi fannoni biyu waɗanda suka dace da muhawara da muka bayyana a sama. A fagen "Lambar" shigar da lamba mai lamba wanda zai zama rarraba. A fagen "Mai rarrabawa" shigar da lambar adadi wanda zai zama mai rarrabewa. Kamar yadda muhawara, zaka iya shigar da hanyar haɗi zuwa sel waɗanda a ƙayyadaddun ƙimar suke. Bayan an nuna dukkan bayanan, danna maballin "Ok".
- Bayan an gama aiki na ƙarshe, sakamakon aiki na mai aiki, wato, ragowar rarraba lambobi biyu, an nuna shi a cikin tantanin da muka lura a sakin farko na wannan littafin.
Darasi: Mayan Maɗaukaki
Kamar yadda kake gani, ma'aikacin da ake binciken yana saukaka sauƙi don nuna ragowar rarraba lambobi a cikin tantanin da aka sanya a gaba. A lokaci guda, ana yin aikin ne gwargwadon ka'idodin doka guda ɗaya kamar na sauran ayyukan aikace-aikacen Excel.
