Lesi sigaba sinikeza umbono weminye yemisebenzi yezibalo ewusizo kakhulu ye-Excel.
ISAVERAGE
Umsebenzi ISAVERAGE (ISILINGANISO) sisetshenziselwa ukubala isilinganiso se-arithmetic. Izingxabano zinganikezwa, isibonelo, njengereferensi yohlu lwamaseli.
NGENHLIZIYO
Ukuze ubale incazelo ye-arithmetic yamaseli ahlangabezana nombandela othile, sebenzisa umsebenzi NGENHLIZIYO (I-AVERAGEIF). Nansi indlela, isibonelo, ongabala ngayo incazelo ye-arithmetic yawo wonke amaseli kububanzi A1:O1, inani layo lingalingani noziro (<>0).
Qaphela: Sign <> kusho AKULINGANI. Umsebenzi NGENHLIZIYO ifana kakhulu nomsebenzi I-SUMMESLI.
UMEDIYA
Ukusebenzisa imisebenzi UMEDIYA (MEDIAN) ungachaza i-median (maphakathi) yesethi yezinombolo.
Hlola:
FASHION
Umsebenzi FASHION (I-MODE) ithola inombolo evame ukwenzeka kusethi yezinombolo.
Ukuphambuka okujwayelekile
Ukuze ubale ukuchezuka okujwayelekile, sebenzisa umsebenzi I-STDEV (I-STDEV).
-MIN
Ukusebenzisa imisebenzi -MIN (MIN) ungathola inani elincane kusuka kusethi yezinombolo.
MAX
Ukusebenzisa imisebenzi MAX (MAX) ungathola inani eliphakeme kusethi yezinombolo.
OKUPHAKATHI
Nansi indlela yokusebenzisa umsebenzi OKUPHAKATHI (AMAKHULU) ungathola inani elikhulu lesithathu eqoqweni lezinombolo.
Hlola:
OKUPHELELE
Nansi indlela yokuthola inani elincane lesibili usebenzisa umsebenzi OKUPHELELE (OKUNCANE).
Hlola: