ICandelo leFomula le-Excele: Iinketho ezi-6 ezilula

Kwi-Microsoft Excel, iCandelo lingenziwa zombini ngoncedo lwefomula kunye nokusebenzisa imisebenzi. Ukuphakama kunye nokuqhawula iZenzele amanani kunye needilesi zeeseli.

Indlela yoku-1: Inombolo yeCandelo lenombolo

Iphepha le-Excel lingasetyenziswa njengohlobo lweClactor, ukwabelana ngenani elinye. Umqondiso weCandelo luphuphuma islash (umgca wokubuyela umva) - "/".

1. Siba nayo nayiphi na iseli ekhululekileyo yephepha okanye kwi-formula umtya. Sibeka uphawu "ngokulinganayo" (=). Sifumana inombolo eyahlukileyo kwikhibhodi. Beka uphawu lweCandelo (/). Siqalisa ukwahlulahlulahlula ikhibhodi. Ngamanye amaxesha, izahlulo zingaphezulu kwesinye. Emva koko, ngaphambi kweqela ngalinye, sibeka islash (/).



2. Ukwenzela ukuba ubalo kunye nokukhutshelwa kwaso ngenjongo yokubeka esweni, senza ucofe iqhosha le-ENTER.

Emva koko, i-Excel i-Excel ibala ifomula kunye neseli ezichaziweyo ziya kuba zibandakanyiwe kubalo.

Ukuba ubalo lwenziwe ngoonobumba abaliqela, emva koko iodolo yokuphunyezwa kwayo yenziwa yiNkqubo ngokwemithetho yeMathematics. Oko kukuthi, okokuqala, ukwahlulwa kunye nokuphinda kwenziwa, kwaye emva koko wongeze kunye nokuthabatha.

Njengoko iyaziwa, ukwahlula kwi-0 yisenzo esingachanekanga. Ke ngoko, ngomzamo onjalo wokwenza ukubalwa okunjalo kwi-degle kwiseli, isiphumo "# del / 0!" Ziya kuvela.

Isifundo: Sebenza ngefomula kwi-Excel

Indlela 2: Ukwahlula imixholo yeeseli

Kananjalo kwi-Excel, unokwahlulahlula idatha kwiiseli.

1. Sabela isisele esiya kuboniswa ngenxa yokubala. Sibeka kuwo umqondiso "= =. Ngakumbi, cofa kwindawo apho ikhoyo u-desimi. Le dilesi ivela kwifomula yoMgaqo emva komqondiso "ulinganayo." Emva koko, useta i "/" uphawu oluvela kwikhibhodi. Cofa kwiseli apho i-Didiadia ifumaneka khona. Ukuba izabelo zithile, njengakwindlela edlulileyo, sibacacisela bonke, kwaye phambi kokuba iidilesi zabo babeka uphawu lweCandelo.



2. Ukwenzela ukwenza isenzo (ukwahlulahlula), cofa kwiqhosha elithi "Ngena".

Ungayidibanisa, njengesahlulelo okanye umahluko usebenzisa iidilesi zeselfowuni kunye neenombolo ezikhoyo.

Indlela 3: Icandelo lekholamu kwikholamu

Ukubala kwiitheyibhile, amaxabiso ekholamu enye ahlala efuna ukwahlula idatha yesibini yekholamu. Ewe kunjalo, ungabelana ngexabiso leseli nganye ngendlela eboniswe apha ngasentla, kodwa ungayenza le nkqubo ngokukhawuleza ngokukhawuleza.

1. Khetha iseli yokuqala kwikholamu apho isiphumo kufuneka siboniswe khona. Sibeka uphawu "=". Cofa kwiseli eyahlula-hlula. Siqesha uphawu "/". Cofa kwiseli ye-wadiider.



2. Cofa kwiqhosha le-ENTER ukubala iziphumo.



3. Ke, iziphumo zibaliwe, kodwa kuphela kumqolo omnye. Ukuze ubale eminye imigca, kufuneka wenze la manyathelo angentla nganye. Kodwa ungalindiswa kakhulu ixesha lakho ngokwenza nje ukonwaba. Cwangcisa isikhombisi kwikona esezantsi ngasekunene kwesisele kunye nefomula. Njengoko ubona, i icon ivela ngohlobo lomnqamlezo. Ibizwa ngokuba ngumphawu ophawulekayo. Cofa iqhosha lemouse lasekhohlo kwaye utsala ngokugqogqa gcwalisa ukuya esiphelweni setafile.

Njengoko sibona, emva kweli nyathelo, inkqubo yokwahlulahlula-hlula ikholamu yangowesibini iya kumiliselwa ngokupheleleyo, kwaye isiphumo sisuswe kwikholamu eyahlukileyo. Inyani yile yokuba ngokugcwalisa imarike, ifomula ikhutshelwe kwiiseli ezisezantsi. Kodwa, kuthathelwa ingqalelo into yokuba ngokungagqibekanga, zonke iireferensi zisalamane, kwaye zingapheli, emva koko kwifomula, njengoko ihamba, iidilesi zeeseli zitshintshiwe kwi-vertiment yokuqala. Oko kukuthi, oku kuyimfuneko kuthi kwimeko ethile.

Isifundo: Ungayenza njani i-autogram kwi-Excel

Indlela yesi-4: Ikholamu yeSigqibo kwi-Host

Kukho iimeko xa kufuneka sahlule ikholamu kwinombolo efanayo-rhoqo, kwaye irhoxise isixa-mali kwikholamu eyahlukileyo.

1. Sibeka uphawu "ngokulinganayo" kwisisele sokuqala sekholamu iyonke. Cofa kwiseli eyahluliweyo yale ntambo. Beka uphawu lweCandelo. Emva koko ngesandla kunye nekhibhodi Beka inombolo oyifunayo.



2. Cofa kwiqhosha lokungena. Iziphumo zokubala ukubambisa zomtya wokuqala ziboniswe kwi-Pedoni.



3. Ukwenzela ukubala amaxabiso eminye imigca, njengakwixesha elidlulileyo, tsalela umnxeba ngokuzalisa. Ngendlela efanayo, yolula phantsi.

Njengoko sibona, ngeli xesha icandelo lichanekile. Kule meko, xa kutsala idatha, ireferensi iphinde yahlala ihambelana. Idilesi yokwahlulwa kumqolo ngamnye itshintshwe ngokuzenzekelayo. Kodwa umzi-hlunu kule meko inamba engapheliyo, ethetha ukuba ipropathi yokwabelana nayo isebenza kuyo. Ngenxa yoko, sahlulahlulahlulahlulahlula iileyile zekholamu.

Indlela yesi-5: Isigqibo sekholamu kwiseli

Kodwa yintoni omele uyenze ukuba ufuna ukwahlula ikholamu malunga neziqulatho zeseli enye. Emva kwayo yonke loo nto, ngokomgaqo-siseko wokufumana izingqinisiso, ukulungelelaniswa kwesahlulo kunye ne-diaders ziya kutshintshwa. Kufuneka senze idilesi yeseli kunye neqela elimisiweyo.

1. Faka isikhombisi kwiselfowuni ephezulu yokubonisa iziphumo. Sibeka uphawu "=". Cofa kwindawo eyahlulahlulo, apho kukho ixabiso eliguquguqukayo. Sibeka islash (/). Cofa kwiseli apho kukho khona ukwahlula isigxina.



2. Ukuze wenze ireferensi yeli qela liqinisekileyo, oko kukuthi, rhoqo, faka uphawu ledola ($) kwifomula phambi kokulungelelaniswa kweseli ngokuthe nkqo nangokungathethekiyo. Ngoku le dilesi iza kuhlala xa ukukopa iMarker eguquguqukayo ayiguqukanga.



3. Sicofa kwiqhosha le-ENTER ukubonisa ukubala iziphumo ezikhoyo kumgca wokuqala kwiscreen.



4. Sebenzisa uphawu lokuzalisa, ikopi yefomula kwiiseli ezisele zekholamu ezinesiphumo esiqhelekileyo.

Emva koko, isiphumo sikulungele yonke ikholamu. Njengoko sibona, kule meko, ikholamu yahlulwa yaba sisisele ngedilesi eqingqiweyo.

Isifundo: Ngokupheleleyo kunye nezihlobo zokudibanisa

Indlela yesi-6: Umsebenzi wabucala

Ukuhanjiswa kwe-Presele kunokwenziwa kusetyenziswa umsebenzi okhethekileyo obizwa ngokuba yimfihlo. I-pecality yeli nqaku kukuba iyahlula, kodwa ngaphandle kwentsalela. Oko kukuthi, xa usebenzisa le ndlela yokuhlulela iziphumo, kuya kuhlala kukho inani elipheleleyo. Kwangelo xesha, ukujikeleza kwenziwa ngokokumiswa kwemithetho yemathematics eyamkelweyo kwinani elikufutshane, kodwa kwimodyuli encinci. Oko kukuthi, inani le-5.8 lokujikeleza kungabikho kwi-6, kunye ne-5.

Masibone ukusetyenziswa kwale nqaku kumzekelo.

1. Cofa kwiseli, apho iziphumo zobalo ziya kubonakala. Cofa kwindawo ethi "Faka umsebenzi" ukuya ngasekhohlo kwe-formula yomtya.



2. I-Wizard ivula. Kuluhlu lwemisebenzi esisinikayo, sifuna into "yabucala". Siyibonisa kwaye sicinezela iqhosha u "Kulungile".



3. Ivuliwe iimpikiswano zewindows. Eli nqaku lineziphoso ezimbini: amanani kunye ne-dinominetor. Zisiwe kumasimi kunye namagama ahambelanayo. Kwi "manani" singene kwi-delimi. Kwintsimi ethi "Ingozi" - umahluko. Ungangenisa amanani athile kunye needilesi zeeseli apho idatha ifumaneka khona. Emva kokuba onke amaxabiso angeniswa, cinezela iqhosha u "Kulungile".

Emva kwezi zenzo, into yabucala yenza ukuba idatha iqhube kwaye inike impendulo kwiseli, eyayibonisiwe kwinyathelo lokuqala lendlela yecandelo.

Eli nqaku linokungeniswa ngesandla ngaphandle kokusebenzisa iwizard. I-syntax yayo ijongeka ngolu hlobo:

= Yabucala (amanani; I-Denominetor)

Isifundo: I-Wizard imisebenzi kwi-Excel

Njengoko sibona, eyona ndlela iphambili yokuhlisela kwiNkqubo yeOfisi ye-Microsoft kukusetyenziswa kwefomula. Isimboli ecekecekileyo kubo yi-slash - "/". Kwangelo xesha, ngeenjongo ezithile, kunokwenzeka ukuba usebenzise umsebenzi wabucala kwiCandelo. Kodwa, kuyimfuneko ukuba uthathele ingqalelo ukuba xa ubalwa ngale ndlela, umahluko ufunyanwa ngaphandle kwentsalela, inani elipheleleyo. Kwangelo xesha, ukujikeleza kwenziwa ngemigangatho eyamkelekileyo ngokubanzi, kodwa kwimodyuli encinci kwinani elipheleleyo.