I-Microsoft Excel isebenza ngemininingwane yamanani. Lapho wenza ukwahlukana noma usebenza ngezinombolo ezingqamuzanayo, imijikelezo yohlelo. Lokhu kubangelwa ikakhulukazi ukuthi izinamba ezingenakunqununu ezinembile azidingeki kakhulu, kodwa akusizi kahle ukusebenzisana ngenkulumo enamandla enezindawo eziningana zesimanje. Ngaphezu kwalokho, kunezinombolo ezingahambisani kahle. Kodwa, ngesikhathi esifanayo, ukuzungeza okungenakulinganisela kungaholela emaphutha amakhulu ezimweni lapho kudingeka khona ukunemba. Ngenhlanhla, ku-Microsoft Excel, abasebenzisi ngokwabo bangabeka ukuthi izinombolo zizobe zenziwe kanjani.
Izinombolo zokugcina ku-Memory ye-Excel
Zonke izinombolo lapho i-Microsoft Excel isebenza ngayo ihlukaniswe ibe yiyona ngqo futhi iseduze. Izinombolo ezifika kumadijithi angu-15 zilondolozwe enkumbulweni, futhi ziboniswe kuze kube yidijithi umsebenzisi ngokwakhe abonisa. Kodwa, ngesikhathi esifanayo, zonke izibalo zenziwa ngokwemininingwane egcinwe kwimemori, futhi ingaboniswa kumqapha.
Ukusebenzisa ukujikeleza, i-Microsoft Excel ilahla inombolo ethile yezindawo zedesimali. Esikhathini se-Excel, indlela ejwayelekile yokuqoqa isetshenziswa, lapho inombolo engaphansi kwezingu-5 ihlanganisiwe, futhi ingaphezu kuka-5-up.
Ukujikeleza nezinkinobho ku-ribbon
Indlela elula yokushintsha ukuzungeza kwenombolo ukukhetha iseli noma iqembu lamaseli, kanti ngenkathi kuthebhu yaseKhaya, chofoza i-Ribbon ku-"Ukwandisa Digitality" noma "Nciphisa Digitality" inkinobho. Zombili izinkinobho zitholakala ebhokisini le-"Number". Kulesi simo, inombolo kuphela ekhonjisiwe iyokwenziwa, kepha uma kubalwa, uma kunesidingo, izinombolo zezinombolo ezingu-15 zizobandakanyeka.
Uma uchofoza inkinobho "Khulisa ububanzi bent", inani lezinhlamvu ezifakiwe ngemva kokuba i-comma ikhuphuke ngenye.
Uma uchofoza inkinobho "Nciphisa ukujula kancane" inani lamadijithi ngemuva kwephuzu lesimanje liyehliswa ngenye.
Ijikeleza ngefomethi yeseli
Ungase futhi usethe ukujikeleza usebenzisa izilungiselelo zefomethini. Ngalokhu, udinga ukukhetha ububanzi bamaseli eshidi, chofoza inkinobho yesokudla yegundane, futhi kwimenyu evelayo khetha into ethi "Ifomethi yamaseli".
Ewindini evuliwe yezilungiselelo zefomathi, iya kuthebhu ethi "Inombolo". Uma ifomethi yedatha ayilona inamba, kuzomele ukhethe ifomethi yezinombolo, ngaphandle kwalokho ngeke ukwazi ukulungisa ukuzungeza. Ezingxenyeni eziphakathi kwefasitela eduze nombhalo othi "Inani lezindawo zedesimali" sisho nje ngenombolo inani lezinhlamvu esizifunayo uma sizungezile. Ngemva kwalokho, chofoza inkinobho ethi "Kulungile".
Setha ukunemba kokubala
Uma kumacala angaphambilini, imingcele ehleliwe yathinta kuphela ukubukwa kwedatha yangaphandle, nezinkomba ezinembile kakhulu (izinhlamvu ezingu-15) ezisetshenzisiwe ekubaleni, manje sizokutshela ukuthi ungashintsha kanjani ukunemba kwezibalo.
Ukuze wenze lokhu, iya kuthebhu ethi "Ifayela". Okulandelayo, hamba kusigaba se "Parameters".
Iwindi yezinketho ze-Excel ivula. Kulo iwindi, iya esigatshaneni esithi "Okuthuthukisiwe". Sifuna ibhulogi yezilungiselelo ezibizwa ngokuthi "Uma uqala kabusha le ncwadi." Izilungiselelo ngalolu cala zisetshenzisiwe kunoma yiliphi lamashidi, kodwa kulo lonke ibhuku lonke, okungukuthi, kuwo wonke amafayela. Sibeka uphawu ngaphambi kwepakrameter "Beka ukunemba njengesikrini." Chofoza inkinobho ethi "Kulungile" ekhoneni elingezansi elingakwesokunxele kwewindi.
Manje, uma ubala idatha, inani elibonisiwe lenombolo esikrinini lizocatshangelwa, futhi akulona eligcinwe kwimemori ye-Excel. Ukulungiswa kwenombolo ebonisiwe kungenziwa nganoma iyiphi yezindlela ezimbili, esixoxwe ngenhla.
Ukusebenza kwemisebenzi
Uma ufuna ukuguqula inani lokubuthwa uma ubala ngokuqondene nelinye lamaseli amaningana, kodwa awufuni ukwehlisa ukuchithwa kokubala kwedokhumenti lonke, ngakho-ke kulesi simo, kungcono ukusebenzisa amathuba anikezwe umsebenzi we-ROUND kanye nokuhluka kwawo okuhlukahlukene, kanye ezinye izici.
Phakathi kwemisebenzi esemqoka elawula ukujikeleza, okulandelayo kufanele kugcizelelwe:
- ROUND - ukuzungeza inombolo ecacisiwe yezindawo zamadesimali, ngokusho kwemithetho evumelanisiwe evamile;
- I-ROUND-UP - ijikeleza kuze kube yilapho inomboro eseduzane uphezulu;
- ROUNDDOWN - ukuzungeza kwinombolo eseduzane ngaphansi kwe module;
- I-RING - ijikelezisa inombolo ngenani elinikeziwe;
- I-OKRVVERH - izungeza inombolo ngenani elinikeziwe phezulu kwesikhulumi;
- I-OKRVNIZ - ijikelezisa inombolo phansi kwe module ngencazelo enikeziwe;
- Idatha ye-OTBR - ukujikeleza ku-integer;
- I-CHETN - ijikelezisa idatha enombolweni noma eseduze;
- Idatha - ijikeleza idatha enombolweni engavamile eseduze.
Imisebenzi ye-ROUNDUP ne-ROUNDDOWN, ifomu lokufaka elilandelayo: "Igama lomsebenzi (inombolo; amadijithi). Lokhu, uma, isibonelo, ufuna ukuzungeza inombolo 2.56896 kuya kumadijithi amathathu, bese usebenzisa i-ROUND (2.56896; 3). Okukhiphayo yinombolo 2.569.
Ifomula elandelayo yokujikeleza isetshenziselwa imisebenzi ye-ROUNDCASE, OKRVVER ne-OKRVNIZ: "Igama lomsebenzi (inombolo; ukunemba)". Isibonelo, ukuzungeza inani le-11 ukuya ku-multiple of 2 eseduze, faka umsebenzi we-ROUND (11; 2). Okukhiphayo yinombolo 12.
Imisebenzi ye-OTBR, i-CHETN ne-OUT of the use ifomethi elandelayo: "Igama lomsebenzi (inombolo)". Ukuze ujikeleze inombolo engu-17 kuze kube yilapho eseduzane, sebenzisa umsebenzi CHETN (17). Sithola inombolo engu-18.
Umsebenzi ungangena kokubili esitokisini nasemgqeni womsebenzi, ngemuva kokukhetha iseli lapho kuzotholakala khona. Umsebenzi ngamunye kufanele ulandelwe "uphawu" = ".
Kunendlela ehlukile yokwethulwa kwemisebenzi yokujikeleza. Kuwusizo ngokukhethekile uma kukhona itafula elinamagugu adinga ukuguqulwa abe izinombolo ezihlangene kukholomu ehlukile.
Ukuze wenze lokhu, iya kuthebhu "Amafomula". Chofoza inkinobho "Isibalo". Okulandelayo, kuhlu oluvula, khetha umsebenzi ofunayo, isibonelo ROUND.
Ngemuva kwalokho, i-window ye-arguments function ivula. Esikhathini "Inombolo", ungangena inombolo ngesandla, kodwa uma sifuna ukuzulazula idatha yonke ithebula, bese uchofoza inkinobho ngakwesokunene kwewindi lokufaka idatha.
Ifasitelana lokuphikisana lomsebenzi linciphiswa. Manje udinga ukuchofoza esitokisini esiphezulu sekholomu, idatha esizoyivala kuyo. Ngemuva kokuthi inani lingene efasiteleni, chofoza inkinobho ngakwesokudla sale nani.
Iwindi lempikiswano yokusebenza ivula futhi. Esikhathini esithi "Inani lamadijithali" sibhala phansi ukujula okudingekayo ukuthi sinciphise izingxenyana. Ngemva kwalokho, chofoza inkinobho ethi "Kulungile".
Njengoba ubona, inomboro ihlangene. Ukuze uqoqe yonke enye idatha yekholomu oyifunayo ngendlela efanayo, sithuthela isikhombisi ekhoneni elingezansi elingakwesokunxele leseli ngenani elizungezile, chofoza inkinobho yegundane lesokunxele, bese uyihudula phansi ekugcineni kwetafula.
Ngemuva kwalokho, zonke izindinganiso kukholomu oyifunayo zizohlanganiswa.
Njengoba ungabona, kunezindlela ezimbili eziyinhloko zokuzungeza isibonakaliso esibonakalayo senombolo: usebenzisa inkinobho ku-tape, nangokushintsha imingcele yefomethi yeseli. Ngaphezu kwalokho, ungashintsha ukugoqa kwedatha ebhaliwe empeleni. Lokhu kungenziwa futhi ngezindlela ezimbili: ngokushintsha izilungiselelo zencwadi yonke, noma ngokusebenzisa imisebenzi ekhethekile. Ukuzikhethela indlela ethile kuxhomeke ukuthi uzosebenzisa lolu hlobo lokujikeleza kuwo wonke idatha efayeleni, noma kuphela uhla oluthile lwamaseli.
