Yanayin don lissafin bayanan martaba an bayyana shi azaman mafi yawan lokuta a cikin jerin.
Alal misali, a jere biyu a cikin hoton da ke sama, lamba 3 shine yanayin tun lokacin da ya bayyana sau biyu a cikin jerin bayanai A2 zuwa D2, yayin da duk lambobin da aka bayyana kawai sau ɗaya.
Har ila yau, an yi la'akari da yanayin, tare da ma'ana da tsakiyar tsakani, don zama ma'auni na matsakaicin adadi ko kuma tsakiyar al'amuran bayanai.
Don rarraba bayanai na al'ada - wakiltar ta hanyar zane-zane ta hanyar kararrawa - matsakaici ga kowane nau'in ma'auni na tsakiya shine nauyin daidai. Don cikakkiyar rarraba bayanai, adadin ƙimar za ta iya bambanta da matakan uku.
Yin amfani da aikin MODE a cikin Excel yana sa sauƙin gane darajar da ta fi sau da yawa a cikin saitin bayanan da aka zaɓa.
01 na 03
Bincika Mafi Girma Aikin Kasuwanci a Yanayin Data
Canje-canje ga Ayyukan MODE - Excel 2010
A cikin Excel 2010 , Microsoft ya gabatar da wasu hanyoyi guda biyu don yin amfani da aikin MODE na kowane abu:
- Ayyukan MODESNGL: Anyi amfani da bayanai tare da yanayin guda - mai kama da aikin MODE da aka rufe a nan;
- Ayyukan MODE.MULT: An yi amfani da shi idan bayanan yana iya samun hanyoyi masu yawa - lambobi biyu ko fiye waɗanda suke faruwa tare da wannan mita.
Don amfani da aikin MODE na yau da kullum a Excel 2010 da kuma wasu daga baya, dole ne a shigar da hannu da hannu, saboda babu wani akwatin maganganu da ke haɗuwa da shi a cikin waɗannan nauyin shirin.
02 na 03
Hanyoyin Sanya da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara.
Hadawa don aikin MODE shine:
= MODE (Number1, Number2, Number3, ... Number255)
Number1 - (da ake buƙata) dabi'u da ake amfani dashi don lissafin yanayin. Wannan hujja zata iya ƙunsar:
- ainihin lambobi - rabu da ƙira - misali a jere 3 a cikin hoto a sama;
- wani rukunin da ya ƙunshe da tantanin halitta ya danganta da wuri na bayanan a cikin takardun aiki - misalai a cikin layuka 2, 5,6, da 7;
- a hade da bayanan salula da kuma bayanai - misali a jere 4;
- wani layi mai suna;
- nassoshin tantancewar mutum wanda ya rabu da ƙira.
Number2, Number3, ... Number255 - (na zaɓi) ƙarin dabi'un ko ƙididdigar sel har zuwa iyakar 255 da ake amfani dasu don lissafin yanayin.
Bayanan kula
- Idan tashar bayanan da aka zaɓa ba ta ƙunshe da cikakkun bayanai ba, aikin MODE zai dawo da darajan N / A - kamar yadda aka nuna a jere 7 a cikin hoton da ke sama.
- Idan ƙididdiga masu yawa a cikin bayanan da aka zaɓa ya faru tare da wannan mita (a wasu kalmomin, bayanan ya ƙunshi hanyoyi masu yawa) aikin zai dawo da irin wannan yanayin da cibiyoyinsa a matsayin yanayin don dukan saitin bayanai - kamar yadda aka nuna a jere 5 a cikin hoton da ke sama . Rigon bayanan A5 zuwa D5 yana da hanyoyi 2 - 1 da 3, amma 1 - yanayin farko ya ci karo - an mayar da shi azaman yanayin ga dukan kewayon.
- Ayyukan ba su kula ba:
- rubutu kirtani;
- mahimmanci ko Boolean dabi'u;
- kullun maras.
Misalin Ayyukan Hanya
03 na 03
Misalin Ayyukan Hanya
A cikin hoton da ke sama, ana amfani da aikin MODE don lissafin yanayin don yawan jeri na bayanai. Kamar yadda aka ambata, tun da Excel 2007 babu wani akwatin maganganu da aka samo don shigar da aikin da muhawararsa.
Duk da cewa dole ne a shigar da aikin tare da hannunka, zaɓuɓɓuka biyu sun wanzu don shigar da hujjar aikin (s):
- rubutawa a bayanan bayanai ko bayanan salula;
- ta amfani da maimaita kuma danna don zaɓar tantance salula a cikin takardun aiki.
Amfani da mahimmanci kuma danna - wanda ya haɗa da amfani da linzamin kwamfuta don nuna haskaka da kwayoyin bayanan - shine ya rage yiwuwar kurakurai ta hanyar buga kuskure.
Da ke ƙasa an jera matakan da ake amfani dasu don shigar da aikin MODE a cikin cell F2 a cikin hoto a sama.
- Danna kan cell F2 - don sa shi tantanin halitta;
- Rubuta da wadannan: = Yanayin (
- Danna kuma ja tare da linzamin kwamfuta don nuna haskaka sel A2 zuwa D2 a cikin takardun aiki don shigar da wannan kewayon kamar yadda muhawara ta aiki;
- Rubuta takalmin rufewa ko iyaye " ) " don ƙaddamar da gardamar aikin;
- Latsa maɓallin shigarwa a kan keyboard don kammala aikin;
- Amsar 3 ya kamata a bayyana a cell F2 tun da wannan lambar ya fi bayyana (sau biyu) a cikin jerin bayanai;
- Lokacin da ka danna kan tantanin halitta F2 cikakken aikin = MODE (A2: D2) ya bayyana a cikin maɓallin tsari a sama da aikin aiki.