Uhlelo lweMicrosoft Excel lusebenza nedatha yezinombolo. Lapho wenza ukwahlukanisa noma ukusebenza ngezinombolo ezihlakazekile, uhlelo luyazungeza. Okokuqala, okokuqala, iqiniso lokuthi izinombolo eziqonde ngqo eziqoqiwe azidingeki kangako, kepha akulula kakhulu ukusebenza ngenkulumo enobuningi enezindawo ezimbalwa zedesimali. Ngaphezu kwalokho, kunezinombolo ukuthi, ngokomgomo, azihlanganisiwe ngokuqondile. Kepha ngasikhathi sinye, ukujikeleza ngokunemba okungafanele kungaholela kumaphutha amakhulu ezimweni lapho ukunemba kudingeka khona. Ngenhlanhla, iMicrosoft Excel inamandla abasebenzisi ukusetha ukuthi izinombolo zijikelezwa kanjani.
Ukugcina izinombolo kwimemori ye-Excel
Zonke izinombolo ezisebenza neMicrosoft Excel nazo zihlukaniswe izinombolo eziqondile nezilinganiswayo. Ama-bits afika ku-15 agcinwe kwimemori, futhi ayakhonjiswa kuze kukhiqizwe umsebenzisi ngokwakhe. Kepha, ngasikhathi sinye, zonke izibalo zenziwa ngokuya ngedatha egcinwe kwimemori, futhi ayikhonjiswa kumqaphi.
Isebenzisa umsebenzi wokujikeleza, iMicrosoft Excel ilahla inani elithile lezindawo ezinedesimali. I-Excel isebenzisa indlela eyamukelekayo ejwayelekile, lapho inani elingaphansi kuka-5 lisungulwe phansi, futhi likhulu kune- noma lilingana no-5 liphezulu.
Ukujikeleza ngezinkinobho zeRibbon
Indlela elula yokushintsha ukujikeleza kwenombolo ukukhetha iseli noma iqembu lamaseli, futhi ngenkathi kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Khulisa i-Bit" noma "Yehlisa i-Bit" kubambo. Zombili izinkinobho zitholakala kubhokisi lamathuluzi leNombolo. Kulokhu, inombolo kuphela ekhonjisiwe ezokalwa, kepha ukuthola izibalo, uma kunesidingo, kuze kufinyelele kumadijithi ezinombolo eziyi-15 azobandakanyeka.
Uma uqhafaza inkinobho "Yenyusa ukujula kancane", inani lezindawo ezifakiwe ezinedesimali lenyuka ngeyodwa.
Uma uchofoza inkinobho "Yehlisa ukujula kancane" inani lamadijithi ngemuva kokuthi iphoyinti ledesimali lincishiswe munye.
Ukujikeleza ngefomethi yeseli
Ungasetha futhi ukujikeleza usebenzisa amasethingi efomethi yeseli. Ukuze wenze lokhu, khetha uhla lwamaseli eshidi, chofoza ngakwesokudla, bese ukhetha u- "Fomula Amaseli" kumenyu evela.
Ewindini elivulayo, izilungiselelo zamaseli owadingayo ukuya kuthebhu "Inombolo". Uma ifomethi yedatha ingeyona eyamanani, khona-ke kufanele ukhethe ifomethi yezinombolo, ngaphandle kwalokho ngeke ukwazi ukuguqula ukujikeleza. Engxenyeni ephakathi yewindows eduze nombhalo "Inombolo yezindawo zamadesimali" sibonisa nje inombolo nenombolo yezinhlamvu esifuna ukuzibona lapho zizungeza. Ngemuva kwalokho chofoza inkinobho "Kulungile".
Ukubalwa kokulungiswa kokubala
Uma ezimweni ezedlule, amapharamitha asetwayo athinta kuphela ukuboniswa kwangaphandle kwedatha, kanye nezinkomba ezinembayo (kufika kumadijithi ayi-15) ezisetshenzisiwe ekubalweni, manje sizokutshela ukuthi ungakuguqula kanjani ukunemba kwezibalo.
Ukuze wenze lokhu, iya kuthebhu ethi "Ifayela". Okulandelayo, sithuthela esigabeni "Samapharamitha".
Kuvulwa iwindows ongakhetha kukho. Kuleli windi, iya esigabeni "Kuthuthukile". Sifuna ibhulokhi yezilungiselelo ebizwa ngokuthi "Lapho kulandiswa le ncwadi." Izilungiselelo ezikuleli cala azisebenzisi eshidini elilodwa, kodwa kuyo yonke le ncwadi, okuyiwo wonke amafayili. Sibeka umkhaza phambi kwepharamitha ethi "Setha ukunemba njengesihenqo". Chofoza inkinobho "OK" etholakala ekhoneni elingezansi kwesobunxele lewindi.
Manje, lapho kubalwa idatha, inani elikhonjisiwe lenombolo esikrinini lizocatshangelwa, hhayi eligcinwe kwimemori ye-Excel. Ukusetha inombolo ekhonjisiwe kungenziwa nganoma iyiphi yezindlela ezimbili, esikhulume ngazo ngaphezulu.
Umsebenzi Umsebenzi
Uma ufuna ukushintsha inani lokujikeleza lapho ubala maqondana neseli elilodwa noma eziningana, kepha ungafuni ukwehlisa ukunemba kwezibalo zizonke zedokhumenti, khona-ke kuleli cala, kungcono ukusebenzisa amathuba owanikezwa umsebenzi we-Round nokuhlukahluka kwawo okuhlukahlukene, ezinye izici.
Phakathi kwemisebenzi esemqoka elawula ukujikeleza, okulandelayo kufanele kuqokonyiswe:
- I-Round - imijikelezo iye kwinombolo ecacisiwe yezindawo zezimali, ngokuya ngemithetho ejikelezayo evunyelwe njalo;
- Round - ukujikeleza kunombolo eliseduze phezulu;
- I-RoundDOWN - ukujikeleza kunombolo eliseduze phansi modulo;
- Round - uzungeza inombolo ngokunemba okunikezwe;
- I-OKRVeverH - izungeza inombolo ngenombolo enikeziwe yokunikela;
- I-OKRVNIZ - izungeza inombolo phansi ngobukhulu ngokunemba okunikezwe;
- I-OTDB - idatha izungeza inani;
- I-EVEN - idatha ejikeleza kunombolo eliseduze kakhulu;
- I-odd - idatha ejikeleza inombolo eyinqaba eseduze.
Ngemisebenzi ye-Round, Round UP ne-Round DOWN, ifomethi yokufaka elandelayo yile: "Igama lomsebenzi (inombolo; inombolo yamabhithi). Lokho kusho ukuthi, uma ufuna, uzungeze inombolo engu-2,56896 kuya kuma-bits amathathu, bese usebenzisa umsebenzi we-Round (2.56896; 3). Imiphumela iyinombolo 2,569.
Ngemisebenzi Round, OKRVVERH ne-OKRVNIZ kufakwa ifomula yokujikeleza elandelayo: "Igama lomsebenzi (inombolo; ukunemba)". Isibonelo, ukuzungeza inani le-11 liye kwele-2 eliseduze, sethula umsebenzi Round (11; 2). Imiphumela iyinombolo 12.
Imisebenzi KHETHA, EVEN ne-Odd zisebenzisa ifomethi elandelayo: "Igama lomsebenzi (inombolo)". Ukuze uzungeleze inombolo engu-17 uye eliseduze kakhulu, sisebenzisa umsebenzi ongu-NUMBER (17). Sithola inombolo 18.
Ungafaka umsebenzi ngaphakathi kweseli nakulayini wokusebenza, ngemuva kokukhetha iseli ezotholakala kulo. Umsebenzi ngamunye kufanele wandulelwe isibonakaliso "=".
Kunendlela ehlukile kancane yokwazisa imisebenzi yokujikeleza. Kulula kakhulu ukuyisebenzisa uma kunetafula elinamanani adinga ukuguqulwa abe izinombolo eziyindilinga kukholamu ehlukile.
Ukuze wenze lokhu, iya kuthebhu "yamaFomula". Chofoza inkinobho "Math". Okulandelayo, ohlwini oluvulayo, khetha umsebenzi owuthandayo, isibonelo Round.
Ngemuva kwalokho, iwindi lokuphikisana komsebenzi liyavula. Emkhakheni "Inombolo", ungafaka inombolo ngesandla, kepha uma sifuna ukuzungeza ngokuzenzakalelayo idatha yetafula lonke, bese uchofoza inkinobho ngakwesokudla kwewindi lokungenisa idatha.
Iwindi lokuphikisana komsebenzi linciphisa. Manje sidinga ukuthi chofoza kuseli eliphezulu kakhulu lekholomu elizothola idatha yalo. Ngemuva kokuthi inani lifakiwe efasiteleni, chofoza inkinobho ngakwesokunene saleli nani.
Iwindi lokuphikisana ngomsebenzi liyavula futhi. Emkhakheni "Inani lamadijithi" sibhala ukujula okuncane, lapho sidinga ukunciphisa izingxenyana. Ngemuva kwalokho chofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, inombolo iyasongwa. Ukuze uzungeze yonke enye idatha yekholamu oyifunayo ngendlela efanayo, hambisa isikhombisi ekhoneni elingezansi kweseli ngenani eliyindilinga, chofoza inkinobho yegundane kwesobunxele, bese ulidonsela phansi ekugcineni kwetafula.
Ngemuva kwalokho, wonke amanani kwikholomu oyifunayo azoyiswa.
Njengoba ukwazi ukubona, kunezindlela ezimbili eziphambili zokufaka isibonisi esibonakalayo senombolo: usebenzisa inkinobho kubambo, nangokuguqula isimo samaseli. Ngaphezu kwalokho, ungashintsha ukujikeleza kwedatha yangempela ebaliwe. Lokhu kungenziwa futhi ngezindlela ezimbili: ngokushintsha izilungiselelo zencwadi zizonke, noma ngokusebenzisa imisebenzi ekhethekile. Ukukhethwa kwendlela ethize kuncike ekutheni uhlose ukufaka lolu hlobo lokuzungeza ngayo yonke idatha efayilini, noma uhla oluthile lamaseli kuphela.
