Yi la'akari da Ayyukan MODE a cikin Google Sheets

01 na 01

Bincika Darajar Mafi Girma Da Ayyukan MODE

Shafukan Lissafi na Google Ayyukan MODE. © Ted Faransanci

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,4

Yanayin 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,2

duka 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.

  1. 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.
  2. Danna kan salula A6, wanda shine wurin da za a nuna sakamakon.
  3. Rubuta daidai alamar = bin kalma "yanayin ."
  4. Yayin da kake bugawa, akwatin zane-zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da wasika M.
  5. 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.
  6. Sanya siffofin A1 zuwa A5 don haɗa su a matsayin muhawarar aikin.
  7. Rubuta takalmin rufewa ) don ƙulla ƙididdigar aikin.
  8. Latsa maɓallin shigarwa akan keyboard don kammala aikin.
  9. 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.
  10. Danna kan salula A1 kuma rubuta lamba 1 don maye gurbin kalma "daya."
  11. Latsa maɓallin shigarwa a kan keyboard
  12. 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.
  13. 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)

Ƙididdigar lissafi na iya ƙunsar:

Bayanan kula