Chigawochi chikuwonetsa mwachidule zina mwazowerengera zofunikira kwambiri za Excel.
MALANGIZO
ntchito MALANGIZO (AVERAGE) amagwiritsidwa ntchito powerengetsera avareji ya masamu. Mkangano ukhoza kuperekedwa, mwachitsanzo, ngati kutchulidwa kwa maselo osiyanasiyana.
WOPANDA MTIMA
Kuti muwerengere tanthauzo la masamu a maselo omwe amakwaniritsa mulingo womwe waperekedwa, gwiritsani ntchito ntchitoyi WOPANDA MTIMA (AVERAGEIF). Umu ndi momwe, mwachitsanzo, mungawerengere tanthauzo la masamu a maselo onse pamndandanda A1:O1, yemwe mtengo wake suli wofanana ndi ziro (<>0).
Zindikirani: chizindikiro <> kutanthauza OSATI KULINGANA. Ntchito WOPANDA MTIMA zofanana kwambiri ndi ntchito SUMMESLI.
WAMEDIAN
Kugwiritsa ntchito WAMEDIAN (MEDIAN) mutha kufotokozera zapakati (pakati) pagulu la manambala.
Onani:
FASHION
ntchito FASHION (MODE) imapeza nambala yomwe imapezeka pafupipafupi pagulu la manambala.
Kusiyana kwakukulu
Kuti muwerengere kupatuka kokhazikika, gwiritsani ntchito ntchitoyi Mtengo wa STDEV (STDEV).
MIN
Kugwiritsa ntchito MIN (MIN) mutha kupeza mtengo wocheperako kuchokera pagulu la manambala.
Max
Kugwiritsa ntchito Max (MAX) mutha kupeza mtengo wokwera kuchokera pagulu la manambala.
LALIKULU
Apa ndi momwe mungagwiritsire ntchito LALIKULU (LARGE) mutha kupeza mtengo wachitatu waukulu kuchokera pagulu la manambala.
Onani:
KAPENA
Umu ndi momwe mungapezere mtengo wachiwiri wocheperako pogwiritsa ntchito ntchitoyi KAPENA (WACHINYAMATA).
Onani: