Ichi chikamu chinopa mucherechedzo wemamwe eExcel anonyanya kubatsira manhamba mabasa.
AVERAGE
basa AVERAGE (AVERAGE) inoshandiswa kuverenga avhareji yemasvomhu. Nharo dzinogona kupihwa, semuenzaniso, sekureva kune huwandu hwemasero.
KUSINA MWOYO
Kuti uverenge masvomhu anoreva maseru anosangana nechiyero chakapihwa, shandisa chiito KUSINA MWOYO (AVERAGEIF). Heino nzira, semuenzaniso, iwe unogona kuverenga iyo arithmetic zvinoreva maseru ese muhuwandu A1:O1, ukoshi hwayo husina kuenzana ne zero (<>0).
Cherechedza: chiratidzo <> zvinoreva KUSATI KUenzana. Basa KUSINA MWOYO zvakafanana nekushanda SUMMESLI.
MUDHORI
Kushandisa mabasa MUDHORI (MEDIAN) unogona kutsanangura pakati (pakati) yenhamba.
Tarisa:
FASHION
basa FASHION (MODE) inowana nhamba inowanzoitika museti yenhamba.
Kusiyana kwekutsauka
Kuti uverenge kutsauka kwakajairika, shandisa basa STDEV (STDEV).
Min
Kushandisa mabasa Min (MIN) unogona kuwana iyo yepasi kukosha kubva pane seti yenhamba.
MAX
Kushandisa mabasa MAX (MAX) unogona kuwana iyo yakanyanya kukosha kubva kune seti yenhamba.
NGUVA
Heano maitiro ekushandisa basa NGUVA (KUKURU) unogona kuwana yechitatu yakakura kukosha kubva pane seti yenhamba.
Tarisa:
LEAST
Heano maitiro ekutsvaga yechipiri diki kukosha uchishandisa basa LEAST (DUKU).
Tarisa: