Kuchinja kesi muExcel

Nyaya muMicrosoft Office Excel ndiko kureba kwemabhii, nzvimbo yavo mumasero etafura yetafura. Excel haipei yakakosha basa rekuchinja nyaya yemavara. Zvisinei, inogona kuchinjwa uchishandisa mafomula. Nzira yekuita izvi nokukurumidza ichakurukurwa munyaya ino.

Maitiro ekuchinja kesi muExcel

Pane zvakawanda zvingasarudzwa zvekuchinja rejista, imwe neimwe inokodzera kutariswa zvakadzama. Zvadaro, tichatarisa nzira dzose dzinokubvumira kuti uchinje nyaya yevatambi.

Nzira 1. Manyorerwo emavara ekutanga muizwi

Itsika kutanga mitsara mumasero etafura ine vara guru. Izvi zvinowedzera aesthetics uye kuoneka kweiyo array. Kuti uchinje nyaya yebhii rekutanga mushoko, uchiita guru, unofanirwa kutevedzera algorithm inotevera:

  1. Nebhatani rekuruboshwe rembeva, sarudza mutsara wemaseru kana chimwe chinhu chakasiyana chetafura array.
  2. Mumutsara wekuisa uri pamusoro peiyo huru yeExcel menyu pasi pechishandiso column, kana mune chero chinhu chetafura, nemaoko isa fomula kubva paPC keyboard. «= PROPRANACH()». Mumaparentheses, mushandisi anofanira kudoma nharo yakakodzera. Aya ndiwo mazita emasero aunoda kushandura chimiro chechimiro chekutanga muzwi.
Kuchinja kesi muExcel
Kunyora fomula kuratidza vara guru rekutanga mumashoko etafura
  1. Mushure mekunyora fomula, tinya "Enter" kuti usimbise chiito.
  2. Tarisa mhinduro. Ikozvino mazwi ese ari muchikamu chakasarudzwa kana huwandu hwemasero anofanira kutanga nebhii guru.
Kuchinja kesi muExcel
Mhedzisiro yekupedzisira
  1. Kana zvichidikanwa, iyo fomula yakanyorwa inogona kutambanudzwa kusvika kumagumo etafura yekuzadza masero asara.
Kuchinja kesi muExcel
Kushandura kesi mumitsara yakasara yetafura nekuwedzera fomula kune yesero yesero

Teerera! Nzira inofungidzirwa yekushandura rejista haigoneki kana mazwi akati wandei akanyorwa musero rimwe kamwechete. Zvadaro fomula yacho inozoisa izwi rimwe nerimwe mukukura.

Formula «= PROPLANCH()» zvinonyanya kukosha kushandisa kana mushandisi anoshanda nemazita chaiwo, ayo anofanira kutanga nebhii guru.

Nzira 2. Maitiro ekugadzira mavara ese musero diki

Iyi nzira inoshandiswa zvakare nekushandisa nzira yakakodzera. Kukurumidza kushandura kesi kuita mavara madiki, unofanirwa kuita zvinotevera manipulations zvinoenderana nealgorithm:

  1. Isa mutsara wembeva muchitokisi, iyo inozoratidza mhedzisiro yefomula.
  2. Muchikamu chakasarudzwa chetafura yetafura, nyora fomu “=KUDZIKA()”. Mumabhuraketi, nenzira imwecheteyo, unofanira kutsanangura kupopotedzana nekudzvanya LMB pane chinodiwa chesero yepakutanga umo nyaya yacho isina kuchinjwa.
Kuchinja kesi muExcel
Kunyora fomula "= LOWER()" mune imwe sero yeExcel tafura array
  1. Dzvanya "Enter" kubva pane keyboard kuti upedze fomula.
  2. Tarisa mhinduro. Kana zviito zvese zvikaitwa nemazvo, ipapo izwi rimwechete kana mutsara wemavara ane mavara madiki anozonyorwa musero rakasarudzwa.
Kuchinja kesi muExcel
Mhedzisiro yekupedzisira yeformula yekuratidza mavara madiki musero retafura
  1. Tambanudza chigumisiro kusvika kumagumo etafura yetafura kuti uzadze zvinhu zvakasara. Iyi ficha inobvumira mushandisi kusaisa fomula yeimwe sero nguva yega yega.
Kuchinja kesi muExcel
Kuzadza otomatiki kwemitsara yasara mutafura nekutambanudza fomula yepakutanga kune yese data array

Zvinokosha! Nehurombo, iyo yakajairwa vhezheni yeExcel haina yakakosha sarudzo ine basa rekushandura kesi, senge muMicrosoft Office Word, nekuti. Excel yakagadzirirwa kushanda nematafura, kwete zvinyorwa.

Nzira 3. Manyorerwo emavara ese muzwi

Dzimwe nguva, kana uchigadzira tafura muMS Excel, mushandisi anoda kuti bhii rega rega musero izwi rive nemavara makuru. Izvi zvakakosha kuti uratidze zvakakosha zvimedu zvetafura yetafura, kuisa pfungwa.

Kuti utsungirire basa iri munguva pfupi inokwanisika, unofanirwa kushandisa nhanho-ne-nhanho rairo:

  1. Sarudza sero umo mhedzisiro yekuchinja kwenyaya icharatidzwa nekuisa mbeva cursor mairi.
  2. Isa iyo fomula "=" pakhibhodi yekombutaMURAIRIRO()». Mumaparentheses, nekuenzanisa nezvirongwa zviri pamusoro, iwe unofanirwa kutsanangura nharo - iyo sosi sero kwaunoda kushandura kesi.
Kuchinja kesi muExcel
Kunyora fomula "UPPER ()"
  1. Pedzisa kunyora fomula nekudzvanya bhatani rekuti "Enter".
  2. Ita shuwa kuti mavara ese ari muchitokisi ane capitalized.
Kuchinja kesi muExcel
Mhedzisiro yekuratidza mavara makuru muchikamu chekupedzisira chetafura

Nzira 4. Kushandura nyaya yemavara ega ega muzwi

MuMicrosoft Office Excel, unogona zvakare kushandura saizi yebhii rimwe kana akawanda mushoko. Semuenzaniso, nekuvaita mahombe, uye nekusiya mamwe madiki. Kuti uite maitiro aya, haufanire kushandisa fomula, ingotevera mashoma matanho ari nyore:

  1. Sarudza chero sero yetafura array nekudzvanya pairi nebhatani rekuruboshwe.
  2. Mumutsara wekupinda mafomula kumusoro kwemenu huru yechirongwa, zviri mukati mechinhu chakasarudzwa zvicharatidzwa. Zviri nyore kugadzirisa data mumutsara uyu.
  3. Isa chitubu chegonzo padhuze nechero mavara madiki mushoko uye woridzima nekudzvanya bhatani re "Backspace" kubva pakhibhodi yekombuta.
  4. Nyora mavara mamwechete nemaoko, asi chete nekuita kuti rive guru. Kuti uite izvi, iwe uchafanirwa kubata pasi chero ye "Shift" makiyi uye tinya pane yaunoda tsamba.
  5. Tarisa mhinduro. Kana zvinhu zvose zvakanaka, ipapo nyaya yetsamba ichachinja.
  6. Ita zvimwechete kune mamwe mavara ezwi.
Kuchinja kesi muExcel
Kuchinja nyaya yemabhii ega ega izwi

Mamwe Mashoko! Iwe unogona zvakare kushandura kesi yeese mavara mune izwi nemaoko kubva kukhibhodi. Nekudaro, izvi zvinotora nguva yakareba pane kushandisa chaiyo formula.

mhedziso

Saka, unogona kushandura nyaya yemavara muMicrosoft Office Excel kungave uchishandisa mafomula akakodzera, kana nemaoko nekushandura saizi yemavara paPC keyboard. Nzira mbiri idzi dzakakurukurwa zvakadzama pamusoro apa.

Leave a Reply