01 na 01
Bincika Darajar Mafi Girma Da Ayyukan MODE
Google Sheets yana da taswirar yanar gizo wanda aka yaba don sauƙin amfani. Saboda ba a haɗa shi da wata na'ura ɗaya ba, ana iya samun dama daga ko'ina kuma a kowane irin na'ura. Idan kun kasance sabon zuwa Google Sheets, zaku buƙatar jagorancin ayyuka da yawa don farawa. Wannan talifin yana duban aikin MODE, wanda ya samo lamarin mafi yawan lokuta a cikin saitin lambobi.
Alal misali, don lambar da aka saita:
1,2,3,1,4Yanayin shine lambar 1 tun lokacin da yake faruwa sau biyu a cikin jerin kuma duk sauran lambobi ya bayyana sau ɗaya kawai.
Idan lambobi biyu ko fiye sun auku a cikin jerin lambobi iri ɗaya, suna la'akari da yanayin.
Domin lambar da aka saita:
1,2,3,1,2duka lambobi 1 da 2 suna dauke su ne yanayin tun lokacin da suka faru sau biyu a cikin jerin kuma lamba 3 ya bayyana sau ɗaya kawai. A misalin na biyu, an saita saitin lamba a matsayin bimodal.
Don samun yanayin don saitin lambobi lokacin amfani da Google Sheets, yi amfani da aikin MODE.
Yadda za a Yi amfani da aikin NASI a cikin Google Sheets
Bude da sabon rubutun Google Sheets kuma ku bi wadannan matakai don koyon yadda ake amfani da aikin MODE.
- Shigar da wadannan bayanan cikin sassan A1 zuwa A5: Kalmar "daya," da kuma adadi na 2, 3, 1 da 4 kamar yadda aka nuna a cikin zane mai suna wannan labarin.
- Danna kan salula A6, wanda shine wurin da za a nuna sakamakon.
- Rubuta daidai alamar = bin kalma "yanayin ."
- Yayin da kake bugawa, akwatin zane-zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da wasika M.
- Lokacin da kalmar "yanayin" ya bayyana a saman akwatin, danna maɓallin shigarwa a kan keyboard don shigar da aikin aikin kuma bude sashi na zagaye ( a cikin salula A6.
- Sanya siffofin A1 zuwa A5 don haɗa su a matsayin muhawarar aikin.
- Rubuta takalmin rufewa ) don ƙulla ƙididdigar aikin.
- Latsa maɓallin shigarwa akan keyboard don kammala aikin.
- An sami kuskuren N / A a cell A6 tun da ba a sami lambar a cikin kewayon da aka zaɓa na sel ba ya bayyana fiye da sau ɗaya.
- Danna kan salula A1 kuma rubuta lamba 1 don maye gurbin kalma "daya."
- Latsa maɓallin shigarwa a kan keyboard
- Sakamakon aikin MODE a cikin cell A6 ya canza zuwa 1. Domin akwai yanzu kwayoyin halitta guda biyu da ke dauke da lamba 1, shine yanayin don saita lambar da aka zaɓa.
- Lokacin da ka danna kan salula A6, cikakken aikin = MODE (A1: A5) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Hanyoyin Sanya da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, ɓangaren sharaɗi da kuma muhawara .
Haɗin aikin aikin MODE shine: = MODE (number_1, number_2, ... number_30)
- number_1 - (da ake buƙata) bayanan da za a hada a lissafin yanayin
- number_2: number_30 - (na zaɓi) ƙarin bayanan bayanan da za a haɗa a cikin lissafin yanayin. Matsakaicin adadin shigarwar da aka yarda shi ne 30.
Ƙididdigar lissafi na iya ƙunsar:
- jerin lambobi
- tantanin halitta sunyi bayanin wuri na bayanan a cikin takardun aiki
- wani kewayon tantancewar salula
- wani layi mai suna
Bayanan kula
- Bayanin rubutun da aka haɗa a cikin kewayon labaran labaran suna watsi da aikin. Idan an tsara sassan da ke dauke da rubutu don riƙe lambobi, yanayin zai sake rikodin, idan ya cancanta, don sauke canje-canje.
- Idan babu darajar ya bayyana fiye da sau ɗaya a cikin jerin zaɓin da aka zaɓa, kuskure N N / A ya bayyana a cikin tantanin halitta inda aikin yake.