Ntchito yoyendetsa ndi ntchito yopezera njira yabwino kwambiri yobweretsera katundu wofanana kuchokera kwa ogulitsa kwa ogulitsa. Maziko ake ndi chitsanzo chomwe chimagwiritsidwa ntchito mosiyanasiyana m'masamu ndi zachuma. Mu Microsoft Excel, pali zida zomwe zimathandiza kwambiri kuthetsera vuto la vuto. Pezani momwe mungagwiritsire ntchito muzochita.
Kufotokozera kwakukulu kwa vuto la kayendedwe
Cholinga chachikulu cha kayendetsedwe ka kayendetsedwe ka kayendetsedwe ka kayendetsedwe ka katundu ndicho kupeza njira yabwino yoyendetsera kayendetsedwe kuchokera kwa wogulitsa kupita kwa wogula pa mtengo wochepa. Makhalidwe a ntchito yoterewa amalembedwa mwa dongosolo la chiwembu kapena matrix. Kwa Excel, mtundu wa matrix umagwiritsidwa ntchito.
Ngati chiwerengero cha katundu mu malo osungiramo katundu akufanana ndi kukula kwa zofunidwa, ntchito yoyendetsa amatchedwa yotsekedwa. Ngati zizindikirozi sizili zofanana, ntchito yotereyi imatseguka. Pofuna kuthetsa izo, zikhalidwe ziyenera kuchepetsedwa kukhala mtundu wotsekedwa. Kuti muchite izi, yonjezerani wogulitsa wonyenga kapena wogula wonyenga omwe ali ndi masitomu kapena zosowa zofanana ndi kusiyana pakati pa kupezeka ndi zofunikila muzochitika zenizeni. Pa nthawi yomweyi, gawo lina kapena mzere wokhala ndi zero zowonjezera ndiwonjezeredwa pa tebulo mtengo.
Zida zothetsera mavuto oyendetsa mu Excel
Kuti athetse vuto la kayendedwe ka Excel, ntchitoyi imagwiritsidwa ntchito "Fufuzani yankho". Vuto ndilo kuti mwachindunji ndilolemale. Kuti mulole chida ichi, muyenera kuchita zinthu zina.
- Pitani ku tabu "Foni".
- Dinani pa chaputala "Zosankha".
- Muwindo latsopano, pitani ku zolembazo Zowonjezera.
- Mu chipika "Management"yomwe ili pansi pazenera yomwe imatsegulidwa, mundandanda wotsika pansi, lekani kusankha pa chinthucho Zowonjezeretsa Zolemba. Dinani pa batani. "Pitani ...".
- Zowonjezerapo zowonjezera zenera zikuyamba. Onani bokosi pafupi ndi chinthucho "Kupeza yankho". Dinani pa batani "Chabwino".
- Chifukwa cha zochitika izi mu tab "Deta" mu bokosi lokhalamo "Kusanthula" batani likuwonekera pa katoni "Kupeza yankho". Tidzafunikira pamene tikufuna yankho la vuto la kayendedwe.
Phunziro: Fufuzani njira yothetsera ku Excel
Chitsanzo chothandizira kuthetsa vuto la kayendedwe ka Excel
Tsopano tiyeni tiwone chitsanzo chapadera cha kuthetsa vuto la kayendedwe.
Mkhalidwe wa vutoli
Tili ndi ogulitsa 5 ndi ogula 6. Zowonjezera zopangidwa ndi ogula mapepalawa ndi 48, 65, 51, 61, 53, mayunitsi 53. Ogula amafuna: 43, 47, 42, 46, 41, 59 maunite. Choncho, chiwerengero chonse cha chakudya chikufanana ndi kuchuluka kwafunidwa, ndiko kuti, tikulimbana ndi ntchito yotsekedwa.
Kuonjezera apo, chikhalidwechi chimapatsidwa ndalama zoyendetsera galimoto kuchokera kumalo osiyanasiyana kupita kumalo ena, zomwe zimawonetsedwa zobiriwira mu fanizo ili m'munsiyi.
Kuthetsa mavuto
Ife tikuyang'anizana ndi ntchitoyo, pansi pa zifukwa zomwe tatchula pamwambapa, kuchepetsa ndalama zoyendetsa mtengo mpaka osachepera.
- Pofuna kuthetsa vutolo, timapanga tebulo ndi maselo ofanana omwe maselo omwe ali pamwambawa amawerengera ndalama.
- Sankhani selo iliyonse yopanda kanthu pa pepala. Dinani pazithunzi "Ikani ntchito"kumanzere kwa bar.
- "Ntchito yowonjezera" imayamba. Mndandanda umene akupereka, tiyenera kupeza ntchitoyo SUMPRODUCT. Sankhani ndipo dinani pa batani. "Chabwino".
- Foni yowunikira zowonjezera imatsegula. SUMPRODUCT. Monga kutsutsana koyamba, lowetsani maselo osiyanasiyana pamtengo wamakono. Kuti muchite izi, mungosankha deta yanu ndi ndondomeko. Kukangana kwachiwiri ndi maselo osiyanasiyana mu tebulo omwe anali okonzekera kuwerengera. Kenako, dinani pa batani "Chabwino".
- Dinani mu selo yomwe ili kumanzere kwa selo kumtunda wakumzere pa tebulo kuti ziwerengedwe. Monga poyamba, timatcha Mbuye wa Ntchito, kutsegula zifukwa zogwirira ntchito. SUM. Pogwiritsa ntchito mndandanda wa kutsutsana koyamba, sankhani mzere wonse wa maselo mu tebulo kuti muwerengere. Pambuyo pazowonjezereka zawo zikulowetsedwa mmalo oyenera, dinani pa batani "Chabwino".
- Timakhala mu ngodya ya kumanja ya selo ndi ntchito SUM. Chizindikiro chodzaza chikuwonekera. Dinani ku batani lamanzere lakumanja ndikukoka gwiritsani kudzala kumapeto kwa tebulo kuti muwerengere. Kotero ife tinakopera njirayi.
- Dinani mu selo yomwe ili pamwamba pa selo lakumtunda lakumanzere la tebulo kuti ziwerengedwe. Monga kale, timatcha ntchitoyi. SUM, koma nthawi ino ngati mkangano timagwiritsa ntchito chigawo choyamba cha tebulo kuti ziwerengedwe. Timakanikiza batani "Chabwino".
- Lembani chizindikirocho chodzaza ndondomeko yonse ya mzere.
- Pitani ku tabu "Deta". Pali chida cha zipangizo "Kusanthula" dinani pa batani "Kupeza yankho".
- Njira yothetsera njirayi imatsegulidwa. Kumunda "Konzekerani Ntchito Yoyenera" tchulani selo yomwe ili ndi ntchito SUMPRODUCT. Mu chipika "Mpakana" ikani mtengo "Osachepera". Kumunda "Kusintha maselo a mitundu" ife timasonyeza lonse lonse la tebulo la kuwerengera. Mu bokosi lokhalamo "Mogwirizana ndi malamulo" pressani batani "Onjezerani"kuwonjezera zochepa zofunikira.
- Fenje yowonjezera yowonjezera ikuyamba. Choyamba, tifunika kuwonjezera chikhalidwe kuti chiwerengero cha deta m'mizere ya tebulo chiyenera kukhala chofanana ndi chiwerengero cha deta m'mizere ya tebulo ndi chikhalidwe. Kumunda Chiwerengero cha Cell tchulani kuchuluka kwa ndalamazo m'mizere ya tebulo. Kenaka ikani chizindikiro chofanana (=). Kumunda "Kuletsedwa" tchulani ndalama zambiri mumzere wa tebulo ndi chikhalidwe. Pambuyo pake, dinani pa batani "Chabwino".
- Mofananamo, tikuwonjezera chikhalidwe chakuti zipilala za magome awiri ziyenera kukhala zofanana. Onjezerani kuti chiwerengero cha maselo onse omwe ali patebulo la chiwerengerochi chiyenera kukhala chachikulu kapena chofanana ndi 0, komanso chikhalidwe chomwe chiyenera kukhala chiwerengero chachikulu. Malingaliro onse a zoletsedwa ayenera kukhala ofanana ndi momwe asonyezedwera mu chithunzi pansipa. Onetsetsani kuti mutsimikiza kuti pafupi ndi mfundoyi "Pangani zosiyanasiyana popanda malire osakhala oipa" panali chongerezi, ndipo njira yothetsera idasankhidwa "Fufuzani kuthetsa mavuto osagwirizana ndi njira OPG". Pambuyo pazomwe makonzedwe akunenedwa, dinani pa batani. "Pezani yankho".
- Pambuyo pake, kuwerengera kumachitika. Deta imawonetsedwa m'maselo a tebulo kuti awerengedwe. Zowatsekera zotsatira zowonjezera zotsatira. Ngati zotsatira zikukhutitsani inu, dinani pa batani. "Chabwino".
Monga mukuonera, njira yothetsera vutoli mu Excel ikufika pa kulumikizana kolondola kwa deta. Pulogalamuyo inachita mawerengero m'malo mwa wogwiritsa ntchito.
