Gwiritsani ntchito mafotokozedwe a selo ndikuwonetsa kuti muchuluke mu Excel
Monga momwe zilili ndi masamu onse a masamu ku Excel, kuchulukitsa nambala ziwiri kapena zambiri kumaphatikizapo kupanga mawonekedwe.
Mfundo zofunikira kukumbukira za Excel mawonekedwe:
- Mafomu a Excel nthawi zonse amayamba ndi chizindikiro chofanana ( = ).
- Chizindikiro chofanana nthawi zonse chimalowa mu selo kumene mukufuna yankho liwonetsedwe.
- Chizindikiro chochulukitsa kapena chogwiritsidwa ntchito mu Excel mawonekedwe ndicho chizindikiro cha asterisk ( * ).
Kugwiritsira ntchito zizindikiro za magulu mu mafomu
Ngakhale kuti n'zotheka kuika manambala mwachindunji, ndi bwino kuti mulowetse deta m'maselo ogwirira ntchito ndikugwiritsa ntchito maadiresi kapena maumboni a maselowo.
Njira yaikulu yogwiritsira ntchito ma selolo mu njira, osati deta lenileni, ndi yakuti, ngati patapita nthawi, pakufunika kusintha ndondomeko, ndi chinthu chophweka chotsitsiramo deta mu maselo omwe amaloledwa m'malo molemba ndondomekoyi.
Zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta yomwe ikugwiritsidwa ntchito ikusintha.
Kulowa Mafanizo a Cell Pogwiritsira Ntchito Kujambula
Ndiponso, ngakhale kuti n'zotheka kungolemba zizindikiro za selo zomwe zingagwiritsidwe ntchito mu njirayi, njira yabwino ndiyo kugwiritsa ntchito polozera kuwonjezera mafotokozedwe a selo.
Kufotokozera kumaphatikizapo kusindikiza maselo omwe ali ndi chidziwitso ndi ndondomeko ya mouse kuti awonjeze mawonekedwe a maselowo. Ubwino wogwiritsira ntchito njirayi ndikuti amachepetsa kuthekera kwa zophophonya zomwe zimapangidwa polemba zolakwika za selo.
Kuchulukitsa Chitsanzo Chitsanzo
Monga momwe tawonetsera pa chithunzi pamwambapa, chitsanzo ichi chimapanga ndondomeko mu selo C1 yomwe idzachulukitsa deta mu selo A1 ndi deta mu A2.
Fomu yomalizidwa mu selo E1 idzakhala:
= A1 * A2
Kulowa Deta
- Lembani chiwerengero cha 10 mu selo A1 ndikusindikizira fungulo lolowamo mu kibokosi,
- Lembani chiwerengero 20 mu selo A2 ndikusindikizira fungulo lolowamo ,
Kulowa Mndandanda
- Dinani pa selo C1 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za fomuyi zidzawonetsedwa.
- Mtundu = ( chizindikiro chofanana ) mu selo C1.
- Dinani pa selo A1 ndi ndondomeko ya mbewa kuti mulowetse selolo mu njirayi.
- Mtundu * ( chizindikiro cha asterisk ) pambuyo pa A1.
- Dinani pa selo A2 ndi pointer ya mouse kuti mulowetse selolo.
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- Yankho la 200 liyenera kupezeka mu selo C1.
- Ngakhale yankho likuwonetsedwa mu selo C1, kutsegula pa seloyo kudzawonetsa chiwonekedwe chenicheni = A1 * A2 mu barra yodutsa pamwamba pa tsamba.
Kusintha Dongosolo la Fomu
Kuyezetsa ubwino wogwiritsa ntchito zigawo zapangidwe mu fomu:
- Sinthani chiwerengero mu selo A2 kuyambira 20 mpaka 5 ndikusindikizira Enter key pa makiyi.
Yankho mu selo C1 liyenera kusinthidwa mpaka 50 kuti liwonetse kusintha kwa deta mu selo A2.
Kusintha Fomu
Ngati pakufunika kukonza kapena kusintha fomu, njira ziwiri zabwino kwambiri ndizo:
- Dinani kawiri pangidwe lanu pa tsamba kuti mupange Excel mu Edit mode ndipo pangani kusintha kwa fomu. Izi zimathandiza kwambiri kusintha pang'ono.
- Dinani kamodzi pa selo yomwe ili ndi ndondomekoyi ndi kubweretsanso mndandanda wonsewo. Njira iyi ndi yabwino kwambiri kusintha kwakukulu.
Kupanga Mafomu Ovuta Kwambiri
Kulemba zovuta zambiri zomwe zimaphatikizapo ntchito zambiri - monga kuchotsa, kuwonjezera, ndi kugawa, komanso kuwonjezereka - kungowonjezerani olemba masamu molondola motsatira ndondomeko za selo zomwe zili ndi deta.
Musanayambe kusinthasintha ma masamu osiyanasiyana pamodzi, komabe ndikofunikira kumvetsetsa dongosolo la ntchito yomwe Excel ikutsatila poyesa ndondomekoyi.
Kuchita, yesani chitsanzo ichi ndi sitepe ya njira yovuta kwambiri .