Ogwiritsa ntchito ambiri sakudziwa ngakhale za mphamvu yonse ya Excel. Eya, tinamva kuti pulogalamu yogwira ntchito ndi matebulo, inde amagwiritsa ntchito, yang'anani pa zolemba zina. Ndikuvomereza, ine ndinali wogwiritsa ntchito mofananamo, mpaka ine mwangozi ndinapunthwa pa chophweka, chowoneka ngati ntchito: kuwerengera chiwerengero cha maselo mu imodzi mwa matebulo anga mu Excel. Ndinkakonda kuchita podula (tsopano ndizoseketsa :-P), koma nthawiyi tebulo linali lalikulu kwambiri, ndipo ndinaganiza kuti ndi nthawi yophunzira osachepera imodzi kapena ziwiri zosavuta ...
M'nkhaniyi ndikukambirana za chiwerengero cha ndalama, kuti chikhale chosavuta kumvetsa, tiwone zitsanzo zosavuta.
1) Kuti muwerenge chiwerengero cha nambala zapadera, mukhoza kudinkhani pa selo iliyonse ku Excel ndi kulemba mmenemo, mwachitsanzo, "= 5 + 6", ndipo ingoyanikizani Enter.
2) Zotsatira sizikutenga nthawi yayitali, mu selo yomwe mwalemba chikhocho zotsatira zake zikuwoneka "11". Mwa njira, ngati mutsegula selo ili (komwe chiwerengero cha 11 chinalembedwa) - mu barra yolozera (onani chithunzi pamwambapa, nambala ya 2, kumanja) - simudzawona chiwerengero cha 11, koma chimodzimodzi "= 6 + 5".
3) Tsopano tiyesera kuwerengera chiwerengero cha manambala kuchokera ku maselo. Kuti muchite izi, choyamba pitani ku gawo "FORMULA" (menyu pamwambapa).
Kenaka, sankhani maselo angapo omwe mumafuna kuwerengera (mu chithunzi pansipa, mitundu itatu ya phindu ikuwonetsedwa muwuni). Kenaka pindani pamanzere pa tabu "AutoSum".
4) Zotsatira zake, chiwerengero cha maselo atatu apitalo chidzawonekera m'seri yoyandikana nayo. Onani chithunzi pansipa.
Mwa njira, ngati tipita ku selo ndi zotsatira zake, tidzawona mawonekedwe ake enieni: "= SUM (C2: E2)", kumene C2: E2 ndi mndandanda wa maselo omwe amafunika kuponyedwa.
5) Mwa njira, ngati mukufuna kuwerengera mndandanda mumzere uliwonse womwe uli pa tebulo, ndiye mungoponyera fomu (= SUM (C2: E2)) kwa maselo ena onse. Excel idzawerengetsa chirichonse pokhapokha.
Ngakhale njirayi yowoneka yophweka imapangitsa Excel kukhala chida champhamvu chowerengera deta! Tsopano talingalirani kuti Excel si imodzi, koma mazana a mitundu yosiyana kwambiri (mwa njira, ine ndayankhula kale za kugwira ntchito ndi otchuka kwambiri). Zikomo kwa iwo, mukhoza kuwerengera chirichonse ndi chirichonse, pamene mukusunga nthawi yanu yambiri!
Ndizo zonse, mwayi wonse.
