Maitiro ekushandisa iyo Function Wizard muExcel. Kudana, kusarudza mabasa, kuzadza nharo, kuita basa

Iyo Microsoft Excel Function Manager inoita kuti zvive nyore kushanda nekuverenga. Inobvisa kukosha kwekuisa fomura hunhu humwe panguva, uyezve tsvaga zvikanganiso mukuverenga kwamuka nekuda kwetypos. Raibhurari yakapfuma yeExcel Function Manager ine matemplate ekushandisa kwakasiyana, kunze kwekunge iwe uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge urwo. Kuita kuti kushanda nematafura kushomeka nguva, isu tichaongorora kushandiswa kwechishandiso ichi nhanho nhanho.

Nhanho #1: Vhura iyo Basa Wizard

Usati wawana chishandiso, sarudza sero yekunyora fomura - tinya negonzo kuitira kuti furemu yakakora ioneke yakatenderedza sero. Pane nzira dzinoverengeka dzekuvhura iyo Function Wizard:

  1. Dzvanya bhatani re "Fx", iro riri kuruboshwe rwemutsara wekushanda nemafomati. Iyi nzira ndiyo inokurumidza, saka inozivikanwa pakati pevaridzi veMicrosoft Excel.
  2. Enda kune "Formulas" tab uye tinya bhatani hombe rine zita rimwechete "Fx" kuruboshwe rwepaneru.
  3. Sarudza chikamu chaunoda mu "Library yemabasa" uye tinya pane chinyorwa "Isa basa" pakupera kwemutsara.
  4. Shandisa kiyi musanganiswa Shift + F Iyi zvakare iri nyore nzira, asi pane njodzi yekukanganwa musanganiswa waunoda.
Maitiro ekushandisa iyo Function Wizard muExcel. Kudana, kusarudza mabasa, kuzadza nharo, kuita basa
Interface zvinhu zvinopa mukana kune Function Manager

Nhanho #2: Sarudza Chinhu

Iyo Function Maneja ine huwandu hukuru hwemafomula akakamurwa muzvikamu gumi neshanu. Zvishandiso zvekutsvaga zvinokutendera kuti uwane nekukurumidza kupinda kwaunoda pakati pevakawanda. Kutsvaga kunoitwa netambo kana nemapoka ega. Imwe neimwe yenzira idzi inoda kuongororwa. Pamusoro pehwindo reManeja pane mutsara "Tsvaga basa". Kana iwe uchiziva zita reformula yaunoda, isa iyo uye tinya "Tsvaga". Masevhisi ese ane zita rakafanana neizwi rakaiswa achaonekwa pazasi.

Kutsvaga kwechikwata kunobatsira kana iyo fomula zita muExcel raibhurari isingazivikanwe. Dzvanya pamuseve uri kumagumo ekurudyi kwemutsara we "Chikamu" uye sarudza boka raunoda remabasa nemusoro.

Maitiro ekushandisa iyo Function Wizard muExcel. Kudana, kusarudza mabasa, kuzadza nharo, kuita basa
Mapoka akanyorwa

Pane dzimwe tambo pakati pemapoka mazita. Kusarudza "Yakazara alfabheti runyorwa" kunoguma mune rondedzero yeese mabasa eraibhurari. Iyo "10 Ichangobva Kushandiswa" sarudzo inobatsira avo vanowanzo sarudza maitiro akafanana ekushanda nawo. Boka re "Kuenderana" irondedzero yemafomula kubva kushanduro dzekare dzechirongwa.

Kana basa raunoda richiwanikwa muchikamu, tinya pairi nebhatani rekuruboshwe, mutsara unoshanduka kuva bhuruu. Tarisa kana sarudzo yacho yakarurama uye tinya "OK" muhwindo kana "Pinda" pane keyboard.

Nhanho #3: zadza nharo

Hwindo rekunyora mapection arguments richaonekwa pascreen. Huwandu hwemitsara isina chinhu uye rudzi rwegakava rega rega zvinoenderana nekuoma kwefomura yakasarudzwa. Ngationgororei nhanho tichishandisa zvine musoro basa "IF" semuenzaniso. Iwe unogona kuwedzera kukosha kwekupokana mukunyora uchishandisa keyboard. Nyora nhamba yaunoda kana rumwe rudzi rweruzivo mumutsara. Iyo purogiramu zvakare inobvumidza iwe kuti usarudze maseru ane zviri mukati zvinova nharo. Hedzino nzira mbiri dzekuzviita:

  1. Isa zita resero mutambo. Sarudzo yacho haina kunaka kana ichienzaniswa neyechipiri.
  2. Dzvanya pasero raunoda nebhatani rekuruboshwe rembeva, ratidziro ine doti ichaonekwa kumucheto. Pakati pemazita emasero, unogona kupinda zviratidzo zvemasvomhu, izvi zvinoitwa nemaoko.

Kuti utsanangure huwandu hwemasero, bata rekupedzisira uye woridhonzera parutivi. Iyo inofambisa ine madoti rondedzero inofanirwa kutora ese anodiwa maseru. Unogona kukurumidza kushandura pakati pemitsara yekupokana uchishandisa kiyi yeTab.

Maitiro ekushandisa iyo Function Wizard muExcel. Kudana, kusarudza mabasa, kuzadza nharo, kuita basa
Interface zvinhu zvinoshandiswa pakusarudza nharo

Dzimwe nguva nhamba yenharo inowedzera pachayo. Hapana chikonzero chekutya izvi, sezvo zvichiitika nekuda kwezvinoreva rimwe basa. Izvi zvinowanzoitika kana uchishandisa Maneja masvomhu mafomula. Iyo nharo haifanire kuve nenhamba - kune zvinyorwa zvinyorwa apo zvikamu zveshoko zvinoratidzwa mumashoko kana mitsara.

Nhanho #4: Ita Basa racho

Kana hunhu hwese hwaiswa uye nekusimbiswa kuti hwakarurama, tinya OK kana Enter. Nhamba yaidiwa kana izwi rinozoonekwa muchitokisi umo formula yakawedzerwa, kana wakaita zvese nemazvo.

Kana pane kukanganisa, unogona kugara uchigadzirisa kusarurama. Sarudza sero rine basa uye pinda kuManeja, sezvakaratidzwa munhanho #1. Iwindo rinozoonekwa zvakare pachiratidziro paunoda kushandura hunhu hwenharo mumitsetse.

Maitiro ekushandisa iyo Function Wizard muExcel. Kudana, kusarudza mabasa, kuzadza nharo, kuita basa
Hwindo rekushandura kukosha kwenharo

Kana iyo fomula isiriyo yakasarudzwa, bvisa zviri mukati mesero uye dzokorora matanho apfuura. Ngationei kuti tingabvisa sei basa kubva patafura:

  • sarudza sero yaunoda uye tinya Delete pane keyboard;
  • dzvanya kaviri pasero neformula - kana chirevo chikaonekwa mukati maro pane kukosha kwekupedzisira, sarudza uye dzvanya kiyi yeBackspace;
  • tinya kamwe chete pachitokisi chawanga uchishanda paBasa Maneja uye wodzima ruzivo kubva paformula bar - iri pamusoro petafura.

Ikozvino basa racho rinozadzisa chinangwa charo - rinogadzira otomatiki kuverenga uye rinokusunungura iwe zvishoma kubva kune monotonous basa.

Leave a Reply