Ogwiritsa ntchito ambiri sadziwa nkomwe mphamvu zonse za Excel. Eya, inde, tidamva kuti pulogalamu yogwiritsira ntchito matebulo, inde amawagwiritsa ntchito, amayang'ana zolemba zina. Ndikuvomereza, ndinali wogwiritsa ntchito mofananamo, kufikira nditapunthwa mwangozi pantchito yowoneka ngati yosavuta: kuwerengetsa kuchuluka kwa maselo mu imodzi mwa matebulo anga ku Excel. Ndinkachita izi pa Calculator (tsopano ndikunyoza :-P), koma nthawi iyi tebulo linali lalikulu kwambiri, ndipo ndidaganiza kuti inali nthawi yoti aphunzire njira imodzi kapena ziwiri zosavuta ...
Munkhaniyi ndilankhula za formula kuti ikhale yosavuta kumvetsetsa, lingalirani zitsanzo zingapo zosavuta.
1) Kuti mupeze kuchuluka kwazovuta zilizonse, mutha kudina foni iliyonse ku Excel ndikulemba momwemo, mwachitsanzo, "= 5 + 6", ndiye dinani Enter.
2) Zotsatira sizimatenga nthawi yayitali, mu cell momwe mudalemba formula zotsatira "11" zimawonekera. Mwa njira, ngati mungodina foni iyi (pomwe nambala 11 yalembedwa) - mu fomula formula (onani chithunzi pamwambapa, muvi Nambala 2, kumanja) - simudzawona nambala 11, koma zonse zofanana "= 6 + 5".
3) Tsopano tiyeni tiyese kuwerengetsa kuchuluka kwa manambala kuchokera m'maselo. Kuti muchite izi, gawo loyamba ndikupita ku gawo la "FORMULAS" (menyu pamwambapa).
Kenako, sankhani maselo angapo omwe malingaliro omwe mukufuna kuwerengera (pazithunzithunzi pansipa, mitundu itatu ya phindu ikuwonetsedwa zobiriwira). Kenako dinani kumanzere pa tabu "AutoSum".
4) Zotsatira zake, kuchuluka kwa ma cell atatu apitawo kuwonekera mu cell yapafupi. Onani chithunzi pansipa.
Mwa njira, tikapita ku cell ndi zotsatirazi, tiona mawonekedwe ake: "= SUM (C2: E2)", pomwe C2: E2 ndi momwe maselo amafunikira kuwonjezeredwa.
5) Mwa njira, ngati mukufuna kuwerengera chiwerengero m'mizere yonse yotsalira patebulopo, ingotsitsani formula (= SUM (C2: E2)) ku maselo ena onse. Excel adzawerengera chilichonse pachokha.
Ngakhale fomula yowoneka ngati yosavuta - imapangitsa Excel kukhala chida champhamvu chowerengera data! Tsopano talingalirani kuti Excel siamodzi, koma mazana a mitundu yosiyanasiyana (mwa njira, ndalankhula kale za kugwira ntchito ndi otchuka kwambiri). Chifukwa cha iwo, mutha kuwerengera chilichonse ndi njira iliyonse, mukamapulumutsa nthawi yanu!
Ndizo zonse, zabwino zonse kwa aliyense.
