Chimodzi mwazinthu zodziwika bwino za Excel ndikugwira ntchito ndi mafomula. Chifukwa cha ntchitoyi, pulogalamuyi imachita mosawerengera pamagulu osiyanasiyana. Koma nthawi zina zimachitika kuti wogwiritsa ntchito amalowetsa fomuyo mu cell, koma samakwaniritsa cholinga chake chachindunji - kuwerengetsa zotsatirazo. Tiyeni tiwone zomwe izi zitha kulumikizidwa komanso momwe mungathetsere vutoli.
Kuthetsa Nkhani Zowerengera
Zomwe zimayambitsa zovuta pakuwerengera njira mu Excel zitha kukhala zosiyana kotheratu. Zitha kuchitika chifukwa cha zolemba za buku linalake kapena maselo osiyanasiyana, kapena zolakwitsa zingapo.
Njira 1: sinthani ma cell
Chimodzi mwazifukwa zodziwika bwino chomwe Excel samawerengera kapena samawerengera zolondola konse ndi mtundu wa maselo. Ngati mtunduwo uli ndi mawonekedwe, ndiye kuti mawuwo sawerengedwa konse, ndiye kuti amawonetsedwa ngati mawu omveka. Nthawi zina, ngati mtunduwo sugwirizana ndi zomwe mawerengedwa awerengera, zotsatira zomwe zikuwonetsedwa mu foni siziwonetsedwa. Tiyeni tiwone momwe tingathetsere vutoli.
- Kuti muwone mtundu womwe khungu kapena mtundu uli ndi, pitani pa tabu "Pofikira". Pa nthiti yomwe ili m'bokosi la chida "Chiwerengero" Pali malo owonetsera amtundu wapano. Ngati phindu lasonyezedwa pamenepo "Zolemba", ndiye kuti formula siziwerengedwa molondola.
- Kuti musinthe mawonekedwe, dinani patsamba ili. Mndandanda wosankha mawonekedwe umatsegulidwa, pomwe mungasankhe mtengo womwe umagwirizana ndi tanthauzo la fomuloli.
- Koma kusankha mitundu yamitundu kudzera pa tepi sikokwanira ngati kudzera pawindo lapadera. Chifukwa chake, ndibwino kugwiritsa ntchito njira yachiwiri yosinthira. Sankhani malo omwe mukufuna. Timadulira pomwepo ndi batani la mbewa. Pazosankha zofanizira, sankhani Mtundu Wa Cell. Mutha kusindikiza kuphatikiza kiyi mutatsindikiza mtundu Ctrl + 1.
- Tsamba losintha likutsegulidwa. Pitani ku tabu "Chiwerengero". Mu block "Mawerengero Amanambala" sankhani mawonekedwe omwe tikufuna. Kuphatikiza apo, mbali yoyenera ya zenera ndikotheka kusankha mtundu wamawonekedwe a mtundu winawake. Pambuyo kusankha kwapangidwa, dinani batani "Zabwino"ili pansipa.
- Sankhani maselo omwe ntchitoyo sanayigwiritse ntchito, ndikuti mufotokozere, ndikanikiza batani la ntchito F2.
Tsopano chilinganizo chiziwerengedwa mu dongosolo loyenera ndipo zotsatira zake zikuwonetsedwa mu foni yotsimikizidwa.
Njira 2: Lemekezani Ma Foromala
Koma mwina chifukwa chomwe m'malo kuwerengera zotsatira zomwe mwawerengera ndi chifukwa pulogalamuyo ili ndi Onetsani Machitidwe.
- Kuti muzitha kuwonetsa zonse, pitani ku tabu Mawonekedwe. Pa nthiti yomwe ili m'bokosi la chida Kudodometsa Kwambiringati batani Onetsani Machitidwe yogwira, ndiye dinani pa izo.
- Pambuyo pa izi, maselo amawonetsanso zotsatirazo m'malo mwa syntax ya ntchito.
Njira 3: zolakwika za syntax
Fomula imathanso kuwonetsedwa ngati zolembedwa ngati zolakwika zidapangidwa mu kapangidwe kake, mwachitsanzo, kalata ikusowa kapena kusinthidwa. Ngati mudalowa pamanja, osadutsa Fotokozerani Wizardndiye izi zitha. Chovuta chodziwika kwambiri chomwe chimakhudzana ndikuwonetsa mawu ngati malembedwe ndi malo pamaso pa wolemba "=".
Zikatero, muyenera kuunikanso mosamala mapangidwe a mitunduyo omwe sanawonetsedwe moyenera, ndikusintha moyenera kwa iwo.
Njira 4: onetsetsani kuti mwawerengetsanso njira
Pali zoterezi zomwe mawonekedwe ake amawoneka kuti akuwonetsa phindu, koma ma cell omwe amaphatikizidwa ndikusintha, iwowo sasintha, ndiye kuti, sizotsatira zake. Izi zikutanthauza kuti mwakonza molakwika magawo a m'bukuli.
- Pitani ku tabu Fayilo. Pokhala mu icho, dinani chinthucho "Zosankha".
- Zenera lotsegulira limatsegulidwa. Muyenera kupita ku gawo Mawonekedwe. Mu makatani Mawerengi Magawo, yomwe ili pamwamba penipeni pazenera, ngati paliponse "Kuwerengera m'buku", kusinthaku sikunayikidwire "Basi", ndiye ichi ndi chifukwa chake zotsatira za kuwerengera sizothandiza. Timasinthana ndikusintha momwe mungafunire. Mukapanga zoikidwazo pamwambapa, kuti muwasunge pansi pazenera, dinani batani "Zabwino".
Tsopano ndemanga zonse za m'bukuli zidzasinthidwa zokha pomwe phindu lililonse lomwe likugwirizana nalo lisintha.
Njira 5: cholakwika pamawonekedwe
Ngati pulogalamuyo ikuthandizabe kuwerengera, koma chifukwa chake chikuwonetsa cholakwika, ndiye kuti zotheka zikuchitika kuti wosuta anangolakwitsa polowa mawuwo. Mitundu yolakwika ndi yomwe, ikawerengedwa, zotsatirazi zotsatirazi zimawonekera mu cell:
- # NUMBER!;
- #VALUE !;
- # EMPTY !;
- #DEL / 0!;
- # N / A.
Pankhaniyi, muyenera kuwona ngati zomwe zili mu maselo otchulidwa ndi mawu zalembedwa molondola, ngati pali zolakwika zina mu syntax kapena ngati cholakwika china (mwachitsanzo, kugawidwa ndi 0) kumayikidwa mu formula yomwe.
Ngati ntchitoyo ndi yolimba, yokhala ndi maselo ambiri olumikizidwa, ndizosavuta kutsata kuwerengera pogwiritsa ntchito chida chapadera.
- Sankhani khungu ndi cholakwacho. Pitani ku tabu Mawonekedwe. Pa nthiti yomwe ili m'bokosi la chida Kudodometsa Kwambiri dinani batani "Werengani njira".
- Windo limatsegulidwa pomwe amawerengera kwathunthu. Dinani batani "Werengani" ndikuyang'ana magawo awiri ndi pang'ono. Timafunafuna cholakwika ndikuchichotsa.
Monga mukuwonera, zifukwa zomwe Excel siziganizira kapena sawerengera molondola njira zitha kukhala zosiyana kotheratu. Ngati, m'malo mwa kuwerengera, wogwiritsa ntchitoyo akuwonetsa ntchitoyo, ndiye kuti, motere, foni yonse imapangidwira zolemba kapena mawonekedwe awotchulidwe. Komanso, pakhoza kukhala cholakwika cha syntax (mwachitsanzo, danga pamaso pa munthu "=") Ngati mutasintha ma data mu ma cell omwe amatha kulumikizidwa zotsatira sizosinthidwa, muyenera kuyang'ana momwe zosintha zokha zimapangidwira muzosintha buku. Komanso, nthawi zambiri m'malo motengera cholondola, cholakwika chimawonetsedwa mu foni. Apa muyenera kuwona zonse zomwe ntchitoyo imatanthawuza. Ngati cholakwa chapezeka, konzekerani.
