Basa rakasara kubva mukupatsanurwa muExcel

Pakati pevakasiyana-siyana vekunze vashandisi, basa rinogoverwa nekugona kwavo kugona. Zvinokubvumira kuti uratidze chiyero kubva pakukamura imwe nhamba kune imwe foni yakatarwa kuenda kune imwe. Ngatidzidzei zvakawanda nezvekuti basa iri rinogona kushandiswa sei mukuita, uyezve rinotsanangura izvo nationalances dzekushanda nazvo.

Kushandiswa kwekushanda

Iro zita reizvi basa rinobva kuZita rakapfupikiswa reshoko rekuti "vakasara kubva muboka". Iyi inoshanda yemasvomhu chikamu chemasvomhu inokutendera kuti ubve chikamu chasara chemhedzisiro yekukamura nhamba. Panguva imwecheteyo, chikamu chose chemhedzisiro chakawanikwa chisina kutaurwa. Kana manhamba ehuwandu nechiratidzo chisina kunaka zvaishandiswa muzvikamu, saka mhedzisiro yekugadzirisa icharatidzwa nechiratidzo icho chaive muvativi. Syntax yeiyi opareta inotaridzika seizvi:

= Kuruboshwe (nhamba; kugovera)

Sezvauri kuona, kutaura kunongova nemapakava maviri chete. "Nhamba" inokakavara, yakanyorwa muhuwandu mazwi. Kupokana kwechipiri muvongi, sezvinoonekwa nezita rayo. Iyo yekupedzisira yavo inotsanangura chiratidzo chekuti mhedzisiro yekugadzirisa ichadzoserwa. Basa rekupokana rinogona kuita seyenzi tsika uye mareferensi kumasero avanorimo.

Chimbofunga zvakati wandei sarudzo dzekusuma mazwi uye mibairo yekuparadzanisa:

• Sumo Express

  = Kusara (5; 3)

  Mhedzisiro: 2.

• Kuzivisa kutaura:

  = Kuruboshwe (-5; 3)

  Mhedzisiro: 2 (sezvo mugove uwandu hwakanakisa kukosha).

• Kuzivisa kutaura:

  = Kusara (5; -3)

  Mhedzisiro: -2 (kubva mugodhi ndeye isina kunaka nhamba yehuwandu).

• Kuzivisa kutaura:

  = Zvakasara (6; 3)

  Mhedzisiro: 0 (se6 kusvika ku3 yakakamurwa isina yakasara).

Muenzaniso wekushandisa anoshanda

Zvino pane chaiwo muenzaniso, funga nezvenyaya yekushandiswa kwemushandi uyu.

1. Vhura bhuku reExcel, tinogadzira sero rakatsanangurwa, umo mhedzisiro yekugadzirisa data icharatidzwa, uye tinya pane "isa basa" icon, yakaiswa padhuze neFormula mutsara.



2. Masters activation yemabasa. Isu tinoita iyo yekufamba kuenda kune chikamu "mathematical" kana "yakazara alfabhethi rondedzero". Sarudza zita rekuti "ramba". Isu tinoratidzira uye tinya pane "ok" bhatani riri pasi hafu yepahwindo.



3. Hwindo rekupokana ratangwa. Iyo ine minda maviri inoenderana nekukakavara kwakatsanangurwa nesu zvishoma. Mu "nhamba" munda, pinda kukosha kwehuwandu iyo ichave inoonekwa. Mu "chikamu" chikamu "chinokodzera kukosha kwehuwandu kuti vatange vapikisane. Iwe unogona zvakare kunyora zvinongedzo kumasero umo matsikirwo azvinowanikwa sekupokana. Mushure mekunge ruzivo rwese rwataurwa, tinya pane "OK" bhatani.



4. Kutevera maitiro ekupedzisira anoitwa, muchitokisi, izvo zvatakacherekedza mundima yekutanga yeiyi bhuku, inoratidza mhedzisiro yekugadzirisa kwedatha neanoshanda, iyo yakasara yekuparadzanisa nhamba mbiri idzi.

Chidzidzo: Master of mabasa muExcle

Sezvatinoona, iyo yekudzidza inoshanda inokubvumira kuti ubvise nyore nyore muyero kubva kuChikamu chehuwandu muchitokisi chakataurwa. Panguva imwecheteyo, maitiro anoitwa zvichienderana nemitemo yakaenzana yemamwe mitemo yeimwe inoshanda yekunyorera chikumbiro.