Mavuto ndi mafomula mu Excel spreadsheet

Mawonekedwe a Excel amakupatsani mwayi wowerengera pafupifupi zovuta zilizonse chifukwa cha mafomu ndi ntchito. Komabe, nthawi zina ogwiritsa ntchito amatha kukumana ndi mfundo yakuti fomula likukana kugwira ntchito kapena limapereka zolakwika m'malo mwazotsatira zomwe akufuna. M'nkhaniyi, tiwona chifukwa chake izi zimachitika, komanso zomwe mungachite kuti tithane ndi vutoli.

Yankho 1: Sinthani mawonekedwe a cell

Nthawi zambiri, Excel imakana kuwerengera chifukwa chakuti ma cell olakwika amasankhidwa.

Mwachitsanzo, ngati malemba atchulidwa, m'malo mwa zotsatira zake tidzawona ndondomeko yokhayokha ngati malemba osavuta.

Nthawi zina, mawonekedwe olakwika akasankhidwa, zotsatira zake zitha kuwerengedwa, koma ziziwonetsedwa mwanjira yosiyana kwambiri ndi momwe timafunira.

Mwachiwonekere, mawonekedwe a selo ayenera kusinthidwa, ndipo izi zimachitika motere:

1. Kuti mudziwe mawonekedwe amtundu wamakono (maselo osiyanasiyana), sankhani ndipo, pokhala pa tabu "Kunyumba", tcherani khutu ku gulu la zida "Nambala". Pali gawo lapadera pano lomwe likuwonetsa mawonekedwe omwe akugwiritsidwa ntchito pano.
2. Mutha kusankha mtundu wina pamndandanda womwe udzatsegulidwe tikadina muvi wapansi pafupi ndi mtengo wapano.

Mawonekedwe a cell amatha kusinthidwa pogwiritsa ntchito chida china chomwe chimakulolani kuti muyike makonda apamwamba kwambiri.

1. Mukasankha selo (kapena mutasankha maselo angapo), dinani kumanja kwake ndipo pamndandanda womwe ukutsegulidwa, dinani pa lamulo. "Cell Format". Kapena mmalo mwake, mutatha kusankha, yesani kuphatikiza Ctrl + 1.
2. Pazenera lomwe limatsegulidwa, tipeza tabu "Nambala". Pano mu mndandanda kumanzere ndi zonse zilipo akamagwiritsa kuti tingasankhe. Kumanzere, zoikidwiratu zomwe mwasankha zikuwonetsedwa, zomwe tingathe kusintha mwakufuna kwathu. Dinani pamene mwakonzeka OK.
3. Kuti zosinthazo ziwonekere patebulo, timayambitsa njira yosinthira imodzi ndi imodzi pamaselo onse momwe fomula silinagwire ntchito. Mukasankha chinthu chomwe mukufuna, mutha kupitiliza kukonza ndikudina batani F2, podina kawiri pa izo, kapena podina mkati mwa kapamwamba kapamwamba. Pambuyo pake, popanda kusintha chilichonse, dinani Lowani.

Zindikirani: Ngati pali deta yambiri, zidzatenga nthawi yaitali kuti mumalize sitepe yotsiriza pamanja. Pankhaniyi, mutha kuchita mosiyana - kugwiritsa ntchito lembani chikhomo. Koma izi zimangogwira ntchito ngati njira yomweyo ikugwiritsidwa ntchito m'maselo onse.

1. Timachita sitepe yotsiriza kokha kwa selo lapamwamba kwambiri. Kenako timasuntha cholozera cha mbewa kukona yake yakumanja yakumanja, chizindikiro chakuda chophatikiza chikawonekera, gwirani batani lakumanzere ndikulikokera kumapeto kwa tebulo.
2. Timapeza gawo ndi zotsatira zowerengedwa pogwiritsa ntchito mafomu.

Yankho 2: zimitsani "Show mafomula" mode

Tikawona mafomuwo m'malo mwazotsatira, izi zitha kukhala chifukwa chakuti mawonekedwe owonetsera atsegulidwa, ndipo amayenera kuzimitsidwa.

1. Sinthani ku tabu "Mitundu". Mu gulu la zida "Kudalira formula" dinani batani "Onetsani Mafomula"ngati ikugwira ntchito.
2. Zotsatira zake, ma cell okhala ndi ma formula awonetsa zotsatira za kuwerengetsa. Zoona, chifukwa cha izi, malire a mizati akhoza kusintha, koma izi ndizokhazikika.

Yankho 3: Yambitsani kuwerengeranso kwa ma formula

Nthawi zina zinthu zitha kuchitika pamene chilinganizocho chawerengera zotsatira zina, komabe, ngati titasankha kusintha mtengo mu imodzi mwamaselo omwe fomula imatanthawuza, kuwerengeranso sikungachitike. Izi zimakhazikitsidwa muzosankha za pulogalamu.

1. Pitani ku menyu "Fayilo".
2. Sankhani gawo kuchokera pamndandanda womwe uli kumanzere "Parameters".
3. Pazenera lomwe likuwoneka, sinthani ku gawo laling'ono "Mitundu". Kumanja kwa zenera mu gulu "Computation Options" chongani bokosi pafupi njira "Automatic"ngati njira ina yasankhidwa. Dinani mukakonzeka OK.
4. Zonse zakonzeka, kuyambira pano zotsatira zonse za fomula zidzawerengedwanso zokha.

Yankho 4: kukonza zolakwika mu fomula

Ngati zolakwika zapangidwa mu fomula, pulogalamuyo imatha kuwona ngati mtengo wosavuta, chifukwa chake, kuwerengera sikungachitike. Mwachitsanzo, chimodzi mwa zolakwika zodziwika bwino ndi malo omwe amaikidwa patsogolo pa chizindikiro "zofanana". Pa nthawi yomweyo, kumbukirani kuti chizindikiro "=" iyenera kubwera nthawi zonse patsogolo pa njira iliyonse.

Komanso, nthawi zambiri zolakwika zimapangidwa m'mawu ogwirira ntchito, chifukwa kudzaza sikophweka nthawi zonse, makamaka pamene mikangano ingapo imagwiritsidwa ntchito. Chifukwa chake, tikulimbikitsidwa kugwiritsa ntchito Wizard ntchito kuyika ntchito mu selo.

Kuti fomulayo igwire ntchito, muyenera kungoyang'ana mosamala ndikuwongolera zolakwika zilizonse zomwe zapezeka. Kwa ife, mumangofunika kuchotsa danga kumayambiriro kwenikweni, zomwe sizikufunika.

Nthawi zina zimakhala zosavuta kufufuta fomula ndikuyilembanso kuposa kuyesa kuwona zolakwika muzomwe zidalembedwa kale. Zomwezo zimapitanso ku ntchito ndi mikangano yawo.

Zolakwa zambiri

Nthawi zina, wogwiritsa ntchito akalakwitsa polemba fomula, mfundo zotsatirazi zitha kuwonetsedwa mu cell:

• #DIV/0! ndi zotsatira za kugawanika ndi ziro;
• #N/A - kuyika kwa zinthu zosavomerezeka;
• #NUMBER! - nambala yolakwika;
• #VALUE! - mkangano wolakwika umagwiritsidwa ntchito;
• #ZOCHITA! - adilesi yolakwika;
• #KULUMIKIZANA! - cell yotchulidwa ndi formula yachotsedwa;
• #DZINA? - dzina lolakwika mu fomula.

Ngati tiwona chimodzi mwa zolakwika zomwe zili pamwambazi, choyamba timayang'ana ngati zonse zomwe zili m'maselo omwe akugwira nawo ntchitoyi zadzazidwa molondola. Kenako timayang'ana chilinganizo chokha ndi kukhalapo kwa zolakwika mmenemo, kuphatikizapo zomwe zimatsutsana ndi malamulo a masamu. Mwachitsanzo, kugawa ndi ziro sikuloledwa (zolakwika #DEL/0!).

Pazochitika zomwe muyenera kuthana ndi ntchito zovuta zomwe zimatchula maselo ambiri, mungagwiritse ntchito zida zovomerezeka.

1. Timayika chizindikiro pa cell yomwe ili ndi cholakwika. Mu tabu "Mitundu" mu gulu la zida "Zodalira pa formula" kanikizani batani "Kuwerengera formula".
2. Pazenera lomwe limatsegulidwa, chidziwitso chatsatane-tsatane pakuwerengera chidzawonetsedwa. Kuti muchite izi, dinani batani "Kuwerengera" (katolankhani iliyonse ikupita ku sitepe yotsatira).
3. Choncho, mukhoza younikira sitepe iliyonse, kupeza cholakwika ndi kukonza.

Mukhozanso kugwiritsa ntchito zothandiza chida "Kuwona Zolakwika", yomwe ili mu chipika chomwecho.

Zenera lidzatsegulidwa momwe choyambitsa cholakwikacho chidzafotokozedwera, komanso zochita zingapo zokhudza izo, kuphatikizapo. kukonza bar formula.

Kutsiliza

Kugwira ntchito ndi mafomu ndi ntchito ndi chimodzi mwazinthu zazikulu za Excel, ndipo, zachidziwikire, chimodzi mwazinthu zazikulu zogwiritsira ntchito pulogalamuyi. Chifukwa chake, ndikofunikira kudziwa zovuta zomwe zingachitike mukamagwiritsa ntchito ma formula, komanso momwe angawongolere.