Buku lozungulira limapezeka mu Excel pamene:
- Fomu ili ndi selo loyang'ana selo liri ndi machitidwe omwewo. Chitsanzo cha mtundu uwu wa zolembedwera chikuwonetsedwa mu chithunzi pamwambapa pamene chiganizo mu selo C1 chiri ndi chilolezo cha selolo mu njira: = A1 + A2 + A3 + C1
- Mafotokozedwe atsatanetsatane ndondomeko ina yomwe pamapeto pake imatanthawuzira ku selo yomwe ili ndi chiyambi choyambirira. Chitsanzo cha mtundu umenewu mwachindunji monga momwe chidziwikiratu chikuwonetsedwa mu chitsanzo chachiwiri mu chithunzi chomwe mitsinje ya buluu ikugwirizanitsa maselo A7, B7, ndi B9 akuwonetsa kuti mayendedwe a maselowa amatsutsana.
Chenjezo Yophiphiritsa
Monga momwe tawonetsera pa chithunzi pamwambapa, ngati kutanthauzira kozungulira kumapezeka pa tsamba la Excel, pulogalamuyi ikuwonetsa bokosi lakulingalira lodziwika bwino lomwe limasonyeza vuto.
Uthenga mu bokosili ndiwongolankhulidwe chifukwa chakuti sizomwe maumboni olembedwa pamabuku angakhale osadziwika monga momwe tafotokozera m'munsimu.
"Mosamala, tapeza chimodzi kapena zambiri maumboni olembedwa mu bukhu lanu la ntchito zomwe zingachititse kuti mayendedwe anu awerengere molakwika"
Zosankha Zamtundu
Zomwe mungasankhe pamene bokosi ili likuwonekera kuti muchotse Cholondola kapena Thandizo, palibe chomwe chingakonze vuto lachinsinsi.
Ngati muwerenga uthenga wautali ndi wotsutsa mu bokosilo mudzapeza kuti:
- kudalira Pulogalamuyo ikuyenera kugwiritsidwa ntchito pamene chidziwitso chosasamala chachitika; izi zimakutengerani ku ma felelo othandizira a Excel pa maumboni ozungulira;
- Kusegula bwino kumagwiritsidwa ntchito powuza Excel kuti zolemba zowonjezera zachitika mwadala ndipo ziyenera kuchoka m'malo mwake.
Mndandanda wosadziwika Wowonjezera
Ngati ndondomeko yozungulirayi idachitika mwangozi, mauthenga othandizira fayilo angakuuzeni momwe mungafunire kupeza ndi kuchotsa maumboni ozungulira.
Fayilo lothandizira lidzakutsogolerani kuti mugwiritse ntchito chida cha Excel's Error Checking chopezeka pansi pa Mafomu> Kulemba Makhalidwe pa Riboni.
Mndandanda wa maselo ambiri osadzimva angakonzedwe popanda kufunikira kolakwika pakuwongolera ndondomeko za selo zomwe zimagwiritsidwa ntchito mu njirayi. M'malo molemba mawonekedwe a selo muzondomeko, gwiritsani ntchito kukopa ------------------ kudalira pazokambirana zomwe muli ndi mbewa -------------- -------- kulowetsa zolembedwera mu fomu.
Zolemba Zowonongeka
Zolemba zowonjezera za Excel sizikukonzekera vuto lachindunji chifukwa chakuti sizowona zolemba zonse zolakwika.
Ngakhale kuti maumboni ovomerezeka mwachangu ndi ochepa kwambiri kuposa omwe sakufuna, angagwiritsidwe ntchito ngati mukufuna Excel kukhazikitsa kapena kuyendetsa maulendo angapo musanapange zotsatira.
Kulimbitsa Kuwerengera Kwambiri
Excel ili ndi mwayi wosankha mawerengedwe awa ngati mukufuna kuigwiritsa ntchito.
Kuti athe kuwerengera:
- Dinani pa tsamba la Fayilo (kapena batani la Office ku Excel 2007)
- Dinani Zosankha kuti mutsegule Zokambirana za Excel Zokambirana
- M'manja lamanzere la bokosi, dinani Mafomu
- Mu dzanja lamanja la bokosi la bokosi, sankhani Makani obwereza kuwunika
Pansi pazitsulo zotsatilazi mulipo:
- kukhazikitsa chiwerengero chazomwe chiwerengero cha maitanidwe: chiwerengero cha nthawi Excel chiyenera kubwezeretsanso ndondomekoyi
- kukhazikitsa kusintha kwakukulu kwa kusintha komwe kumavomerezedwa pakati pa zotsatira za kuwerengera: ndizochepa chiwerengero, chotsatira chake cholondola kwambiri
Kuwonetsa Zeresi Maselo Okhudzidwa
Kwa maselo okhala ndi maumboni ozungulira, Excel amasonyeza zero monga momwe akusonyezera mu selo C1 mu chitsanzo kapena mtengo wotsiriza wowerengedwa mu selo.
Nthawi zina, mayendedwe amatha kuyendetsa bwino asanayese kuwerengera phindu la selo limene ali. Izi zikachitika, selo yomwe ili ndi ndondomekoyi ikuwonetsera mtengo kuchokera ku mawerengedwe omalizira omaliza.
Zambiri pazowonjezereka Zowonjezera
Pambuyo pa choyamba cha ndondomeko yomwe ili ndi zolemba zozungulira m'buku, Excel sichidzawonetsanso uthenga wochenjeza. Zimadalira zochitika za momwe komanso zowonjezeramo maumboni ovomerezeka apangidwira.
Zitsanzo za bokosi lodziwitsira lomwe liri ndi uthenga wochenjeza lidzawonetsedwa kwa maumboni otsogolera otsatirawa ndi awa:
- Nthawi yoyamba ya zolembera zozungulira mu bukhu lililonse lotseguka;
- Pambuyo pochotsa maumboni onse ozungulira m'mabuku onse ogwira ntchito, chidziwitso chatsopano chidachitika;
- Pambuyo kutseka mabuku onse ogwira ntchito, ndondomeko yomwe ili ndi zolemba zozungulira imalengedwa mu bukhu latsopano la ntchito;
- Buku lothandizira lomwe lili ndi zolemba zozungulira likutsegulidwa.