Microsoft Excel ine akawanda mabasa anotendera iwe kuti uite mabasa pasina karukureta kana rimwe basa rekuwedzera. Asi kana iwe usingazivi nezvemafomula, zvinogona kunzwa kutya. Pano, takanyora gumi nembiri zviri nyore asi inobatsira Excel mabasa kukutanga.
1. Wedzera Nhamba muMasero: SUM
Chimwe chezvinhu zvinonyanya kukosha zvaunogona kuita nenhamba wedzera ivo. Kushandisa the SUM basa muExcel unogona kuwedzera nhamba mumasero.
Iyo syntax ndeye SUM(value1, value2,...) apo value1 inodikanwa uye value2 isarudzo. Saka panharo yega yega, unogona kushandisa nhamba, sero referensi, kana masero.
Semuenzaniso, kuwedzera manhamba mumasero A2 kuburikidza neA10, iwe unoisa zvinotevera wodzvanya Enter:
=SUM(A2:A10)
Iwe wobva wawana mhedzisiro yako musero rine formula.
2. Avhareji yeNhamba muMasero: AVERAGE
Averaging boka renhamba nderimwe basa remasvomhu rinozivikanwa.
Iyo syntax yakafanana neye AVERAGE basa muExcel sekunge neSUM basa, AVERAGE(value1, value2,...) ne value1 zvinodiwa uye value2 optional. Unogona kuisa maseru referensi kana marengenzi enharo.
Kuenzanisa nhamba dziri mumasero A2 kuburikidza neA10, iwe waizoisa inotevera fomula uye wodzvanya Enter:
= Avhareji (A2: A10)
Iwe unobva wawana avhareji yako muchitokisi chine fomula.
RELATED: Maitiro ekuverengera Weighted Avhareji muExcel
3. Tsvaga Yakakwirira kana Yakaderera Kukosha: MIN uye MAX
Paunenge uchida kuwana hushoma kana huwandu hwepamusoro muhuwandu hwemasero, unoshandisa iyo MIN uye MAX mabasa.
Masyntaxes emabasa aya akafanana nemamwe, MIN(value1, value2,...) uye MAX(value1, value2,...) ne value1 zvinodiwa uye value2 sarudzo.
Kuti uwane hushoma, hushoma, muboka remaseru, isa zvinotevera uchitsiva mareferensi emasero neako. Wobva wadzvanya Enter:
=MIN(B2:B10)
Uye kuti uwane iyo yakanyanya kukosha, yakanyanya kukosha, shandisa:
=MAX(B2:B10)
Iwe unobva waona diki kana hukuru kukosha musero neformula.
4. Wana Kukosha Kwepakati: MEDIAN
Panzvimbo pehushoma kana huwandu hunokosha, unogona kuda yepakati.
Sezvaungave wakafungidzira, iyo syntax yakafanana, MEDIAN(value1, value2,...) nenharo yekutanga inodiwa uye yechipiri sarudzo.
Nekukosha kwepakati muhuwandu hwemasero isa zvinotevera wodzvanya Enter:
=MEDIAN(A2:A10)
Unobva waona nhamba yepakati yenharembozha yako.
5. Verenga Masero Ane Nhamba: COUNT
Zvimwe ungada verenga kuti macell mangani muchikamu mune nhamba. Kune izvi, iwe waizoshandisa iyo COUNT basa.
Syntax yakafanana nemabasa maviri ari pamusoro apa, COUNT(value1, value2,...) nenharo yekutanga inodiwa uye yechipiri sarudzo.
Kuti uverenge huwandu hwemasero ane nhamba muchikamu A1 kusvika B10, iwe unoisa zvinotevera wodzvanya Enter:
=COUNT(A1:B10)
Iwe wobva wawana kuverenga kwako musero rine formula.
RELATED: Maitiro ekuverenga Masero muMicrosoft Excel
6. Isa Zuva Razvino uye Nguva: ZVINO
Kana iwe uchida kuratidza zuva razvino uye nguva pese paunovhura spreadsheet yako, shandisa iyo ZVINO basa muExcel.
Iyo syntax ndeye NOW() nokuti basa racho harina nharo dzinodiwa. Iwe unogona, zvakadaro, wedzera kana kubvisa kubva pazuva razvino uye nguva kana uchida.
Kuti udzose zuva razvino uye nguva, isa zvinotevera uye wodzvanya Enter:
= IZVOZVO ()
Kuti udzose zuva uye nguva mazuva mashanu mune ramangwana kubva pazuva razvino uye nguva, isa iyi fomula uye rova Enter:
=ZVINO()+5
Uye heano maitiro emhedzisiro angatarise kune yega yega mafomula ari pamusoro.
7. Kutenderedza kune Imwe Nhamba Yemadhijiti: ROUND
Kana uine nhamba dzedesimali mubepa rako dzaunoda kutenderedza kumusoro kana pasi, shandisa iyo RUND basa muExcel.
Iyo syntax ndeye ROUND(value1, digits) panodiwa nharo dzose. For value1 , shandisa nhamba yaunoda kutenderedza. For digits , shandisa nhamba yenzvimbo dzedesimali kutenderedza nhamba.
Semuenzaniso, kutenderedza nhamba 2.25 kumusoro kwenzvimbo imwe chete, isa zvinotevera wodzvanya Enter:
=KUtenderera(2.25,1)
Uye une zvibodzwa zvako. Kana uchida kudzikisira pasi, ingo shandisa nhamba isina kunaka pakupokana kwemadijiti.
8. Dimburira Nhamba Nekubvisa Chikamu: TRUNC
Pamwe ungada kudimburira nhamba pane kuitenderedza. Kushandisa the TRUNC basa, unogona kubvisa chikamu kubva kunhamba.
Iyo syntax ndeye TRUNC(value1, digits) ne value1 zvinodiwa uye digits optional. Kana ukasaisa manhamba, kukosha kwacho kunonzi zero.
Saka, kuderedza nhamba 7.2 waizoisa zvinotevera wodzvanya Enter:
=TRUNC(7.2)
Mhedzisiro yeformula iyi yaizova nhamba yechinomwe.
9. Tsvaga Chigadzirwa Nekuwedzera Masero: PRODUCT
Kana uchida wedzera maseru akati wandei, kushandisa PRODUCT basa rinonyanya kushanda pane kushandisa chiratidzo chekuwanza (*) mufomula.
Iyo syntax ndeye PRODUCT(value1, value2,...) ne value1 zvinodiwa uye value2 optional. Unogona kushandisa value1 kwesero renji uye value2 kune mamwe maseru ekuwedzera kana zvichidikanwa.
Kuti uwane chigadzirwa chemasero A2 kuburikidza neA10, iwe waizoisa zvinotevera worova Enter:
=PRODUCT(A2:A10)
Sezvauri kuona, izvi zviri nyore pane kupinda A2 * A3 * A4 , zvichingoenda zvakadaro.
10. Shandisa Reference Number yeSero Yakapiwa: COLUMN uye ROW
Iine COLUMN uye ROW mabasa muExcel, unogona kudzosa nhamba yechinzvimbo chesero. Aya mabasa anobatsira pakuisa nhamba dzereferensi mubepa rako, kana row number, semuyenzaniso.
Syntax yeumwe neumwe ndeye COLUMN(reference) uye ROW(reference) uko kukakavara kusingadiwi. Kana ukasapinza nharo, fomula inodzosa referensi yesero rine formula.
Semuenzaniso, kana iwe ukaisa inotevera formula musero B2, mhedzisiro inenge iri 2 nekuti B2 iri mumutsara wechipiri.
=MUTSARA()
Asi kana iwe ukaisa fomura inotevera nenharo, unogashira nhamba yereferensi yesero.
=MUTSARA(C5)
Unogona kuona pano; mhedzisiro ndeye 5 nekuti C5 iri mumutsara wechishanu.
11. Bvisa White Space: TRIM
Kazhinji iwe paunoisa kana kutumira data, ine dzimwe nzvimbo. The TRIM basa inobvisa nzvimbo yakachena.
Iyo syntax ndeye TRIM(reference) nenharo inodiwa sereferensi yesero ine data.
Kuti ubvise dzimwe nzvimbo kubva muchitokisi A1, iwe waizoisa zvinotevera worova Enter:
= CHIMWE (A1)
Iwe unobva waona iyo data musero yako yakanyorwa isina inotungamira uye yekutevera nzvimbo.
12. Verenga Nhamba yeVatambi muRinga: LEN
Zvichida unoda kuwana nhamba yemavara mumutsara wezvinyorwa. Pano, iwe unoshandisa iyo LEN basa muExcel.
Iyo syntax ndeye LEN(reference) nenharo inodiwa pasero rereferenzi rine zvinyorwa.
Kuti uwane huwandu hwemavara muchitokisi A1, isa inotevera fomula uye wodzvanya Enter:
=LEN(A1)
Mhedzisiro yacho ndeye makumi maviri neshanu nekuti "Shandisa iyo data kubva kuMari" ine iyo nhamba yemavara uye ona kuti nzvimbo ndivo vakaverengwa sevatambi.
Kune mamwe akawanda anobatsira mabasa muExcel akadai VLOOKUP yekutsvaga kukosha uye CONCATENATE yekubatanidza tambo dzemavara. Asi iyi rondedzero yezvakakosha inofanirwa kukubatsira iwe nemabasa akareruka iwe uchiwedzera kujairana nekushandisa mabasa.