Mukati
Microsoft Excel inowanzo shandiswa kuita mashandiro nemaperesenti. Izvo zvinonyanya kukosha mukutengesa kuverenga. Semuenzaniso, iwe unofanirwa kuziva kuti ndedzipi shanduko muhuwandu hwekutengesa hwakarongwa. Zvishandiso zveExcel zvinokutendera kuti uwedzere nhamba nemaperesenti uye gadzira mafomula ekukurumidza kuverenga kukwira nekudonha mukutengesa. Ngationei kuti tingawedzera sei chikamu chehuwandu kune kukosha kwayo.
Maitiro ekuwedzera muzana uye nhamba nemaoko
Fungidzira kuti kune kukosha kwenhamba yechimwe chiratidzo, icho chinowedzera nekufamba kwenguva nezana muzana, kana nemakumi akati wandei kubva muzana. Kuwedzera uku kunogona kuverengerwa uchishandisa nyore masvomhu kushanda. Izvo zvinodiwa kutora nhamba uye kuwedzera kwairi chigadzirwa chenhamba imwechete neimwe muzana. Iyo formula inoita seizvi: Huwandu hwenhamba uye chikamu=nhamba+(nhamba*muzana%). Kuti titarise chiito pane muenzaniso, isu tinonyora mamiriro edambudziko. Iyo yekutanga vhoriyamu yekugadzira 500 mayuniti, achikura ne13% mwedzi wega wega.
- Iwe unofanirwa kusarudza sero mutafura yakagadzirwa kana chero imwe yemahara sero. Isu tinonyora mairi chirevo chine data kubva kune mamiriro. Usakanganwa kuisa chiratidzo chakaenzana pakutanga, kana zvisina kudaro chiito hachizoitwa.
- Dzvanya kiyi "Enter" - kukosha kwaunoda kuchaonekwa muchitokisi.
Iyi nzira yekuverenga inosanganisira kuwedzera kuzadza mumasero etafura nemaoko. Kukopa hazvibatsire, nekuti chirevo chacho chine manhamba chaiwo, hachirevi sero.
Tsanangudzo yezvikamu zvenhamba
Dzimwe nguva zvinodikanwa kuti mushumo uratidze kuti kukosha kwechimwe chiratidzo kunokura sei kwete muzana, asi mune yakajairika manhamba fomati. Muchiitiko ichi, muzana yehuwandu hwekutanga hunoverengwa. Shandisa fomula inotevera kuverenga chikamu chenhamba: Percentage=(Nhamba*Nhamba yezvikamu kubva muzana mumanyorerwo enhamba)/100. Ngatitorei nhamba dzakafanana zvakare - 500 uye 13%.
- Iwe unofanirwa kunyora kukosha mune imwe sero, saka sarudza iyo. Isu tinonyora fomula nenhamba dzakaratidzwa, pamberi payo chiratidzo chakaenzana.
- Dzvanya "Enter" pane keyboard uye uwane mhedzisiro.
Zvinoitika kuti chiratidzo chinogara chichikura nemayuniti akati wandei, asi hazvizivikanwe kuti yakawanda sei senge muzana. Pakuverenga kwakadaro, kune zvakare fomula: Percent musiyano=(Musiyano/Nhamba)*100.
Pakutanga zvakaonekwa kuti huwandu hwekutengesa huri kukura nezvikamu makumi matanhatu neshanu pamwedzi. Ngativerengei kuti imarii sechikamu.
- Iwe unofanirwa kuisa nhamba dzinozivikanwa mufomula woinyora musero nechiratidzo chakaenzana pakutanga.
- Mushure mekudzvanya kiyi "Enter", mhedzisiro ichave muchitokisi.
Hazvidikanwi kuwanda nezana kana sero richishandurwa kuva chimiro chakakodzera - "Percentage". Funga kuchinja sero fomati nhanho nhanho:
- Iwe unofanirwa kudzvanya pane yakasarudzwa sero neRMB - menyu yemukati inovhura. Sarudza iyo "Format Cells" sarudzo.
- Hwindo rinovhurika paunogona kusarudza iyo yakakodzera fomati. Isu tinowana yekupinda "Percentage" mune runyorwa kuruboshwe. Kana iwe uchida nhamba, unofanira kuisa zero kukosha mumutsara we "Nhamba yenzvimbo dzedesimali" uchishandisa mabhatani emiseve kana nemaoko. Zvadaro, tinya "OK".
- Zvino kutaura kunogona kuderedzwa kuita chiito chimwe chete.
- Mhedzisiro yacho ichaonekwa muhuwandu hwefomati.
Kuwedzera nhamba uye muzana uchishandisa formula
Kuti uwedzere chikamu chenhamba kunhamba yacho pachayo, unogona kushandisa fomula. Iyi nzira inobatsira mumamiriro ezvinhu apo migumisiro yekuverenga inoda kukurumidza kuzadza tafura.
- Sarudza sero remahara uye rizadze neformula. Iyo data inofanira kutorwa kubva patafura. Formula ndeiyi: Nhamba+Nhamba*Muzana.
- Kutanga, tinonyora chiratidzo chakaenzana, zvino sarudza sero nenhamba, isa kuwedzera, uye zvakare tinya pane sero ine kukosha kwekutanga. Isu tinopinda asterisk sechiratidzo chekuwedzera, shure kwayo - chikamu chehuwandu.
- Dzvanya kiyi ye "Enter" kuti uwane mhedzisiro yekuverenga.
- Zadza masero asara ekoromo. Kuti uite izvi, unofanirwa kukopa fomu yacho ne-offset - izvi zvinoreva kuti mutsara wesero mumutsara uchachinja paunotamira kune sero pazasi.
Pane mucherechedzo wemakona mukona yesero rakasarudzwa. Izvo zvinodiwa kuti uibate pasi uye kutambanudza kusarudzwa kune iyo yose column yetafura.
- Sunungura bhatani rembeva - maseru ese akasarudzwa anozadzwa.
- Kana nhamba dzakakwana dzichidiwa, chimiro chinofanira kuchinjwa. Sarudza maseru ane fomula, tinya-kurudyi paari uye vhura iyo fomati menyu. Iwe unofanirwa kusarudza nhamba yefomati uye kugadzirisa zvakare nhamba yenzvimbo dzedesimali.
- Hukoshi mumaseru ese anozove manhamba.
Maitiro ekuwedzera chikamu kuchikamu
Kune mishumo mune iyi fomati, apo imwe yemakoramu inoratidza kukura kwehuwandu hwechiratidzo nekufamba kwenguva. Iko muzana haisi nguva dzose yakafanana, asi zvinokwanisika kuverenga kuchinja kwezviratidzo uchishandisa kuverenga.
- Isu tinonyora chimiro maererano neiyo musimboti, asi pasina kunyora nhamba nemaoko - chete tafura data inodiwa. Isu tinowedzera kuhuwandu hwekutengesa chigadzirwa chayo nehuwandu hwekukura uye tinya "Enter".
- Zadza maseru ese nesarudzo yekopi. Kana yasarudzwa ine square marker, fomula yacho inokopwa kune mamwe maseru ine offset.
Kugadzira chati ine zvikamu zvehuwandu
Maererano nemigumisiro yekuverenga, zvinokwanisika kugadzira mufananidzo wakaenzana wetafura - dhayagiramu. Pairi unogona kuona kuti ndechipi chigadzirwa chinonyanya kufarirwa kana zvasvika pakutengesa.
- Sarudza maseru ane huwandu hwehuwandu uye woakopa - kuti uite izvi, tinya-kurudyi uye tsvaga chinhu che "Copy" mumenyu kana shandisa kiyi yekubatanidza "Ctrl + C".
- Enda ku "Insert" tab uye sarudza rudzi rwechati, semuenzaniso, pie chati.
mhedziso
Iwe unogona kuwedzera chikamu chenhamba kunhamba yacho pachayo nenzira dzakawanda - nemaoko kana kushandisa fomula. Yechipiri sarudzo inodiwa mune zviitiko apo iwe unofanirwa kuwedzera chikamu kune akati wandei maitiro. Izvo zvakare zvinogoneka kuverenga akati wandei maitiro neakasiyana muzana ekukura uye kugadzira chati yekujekesa zvakanyanya chirevo.