Izinombolo zokujikeleza ku-Excel: 4 Imfashini Yokusebenza

Lapho wenza ukuhlukaniswa noma usebenza ngamanani ahlukahlukene, i-Excel ikhiqiza ukuzungeza. Lokhu kufanele, okokuqala, iqiniso lokuthi amanani anembe anembe ngokuphelele ayaqabukela lapho kunesidingo lapho kunesidingo, kepha akukubi kakhulu ukusebenza ngenkulumo eningi enezimpawu eziningana ngemuva kwekhefana ngemuva kwekhefana. Ngaphezu kwalokho, kunezinombolo zokuthi ngokwesimiso akuzungezwe kahle. Ngasikhathi sinye, ukujikeleza okunembile ngokungafanele kungaholela emaphutheni amabi ezimweni lapho kudingeka khona ukunakwa. Ngenhlanhla, uhlelo unethuba ukufaka abasebenzisi bebodwa, kanjani izinombolo uzobe waphetha.

Izici zezinombolo zokujikeleza i-Excel

Zonke lezi zinombolo ezenziwa yiMicrosoft Excel Orks ehlukaniswe zihlukaniswe zinembile nangokulinganiselwa. Imemori igcinwa kwimemori yokukhipha okufika ku-15, futhi ikhonjiswe ngaphambi kokukhishwa, okuzokhombisa umsebenzisi uqobo. Zonke izibalo zenziwa ngokuya ngokugcinwa kwimemori, futhi akuboniswanga ekuqaphisweni kwedatha.

Kusetshenziswa umsebenzi wokujikeleza, i-Excel ilahla inani lama-semicolons. Isebenzisa indlela yokujikeleza eyamukelwa ngokuvamile, lapho inombolo ingaphansi kuka-5 izungezwe ohlangothini oluncane, futhi ingaphezulu noma ilingana no-5 - ohlangothini oluningi kakhulu.

Ukujikeleza ngezinkinobho ku-Ribbon

Indlela elula yokushintsha ukujikeleza ukugqamisa iseli noma iqembu lamaseli futhi, ngenkathi kuthebhu yasekhaya, chofoza inkinobho ethi "QHAFAZA KAKHULU" noma "Yehlisa ibhayiniki". Zombili izinkinobho zitholakala kumathuluzi "ezinombolo". Inombolo ekhonjisiwe kuphela ezoyindilinga, kepha ukuze ihlanganiswe, uma kunesidingo, kufika amadijithi afinyelela kwayi-15.

Uma uqhafaza inkinobho ethi "Enwerreage Big", inani lezinhlamvu ezenziwe ngemuva kokukhuphuka kwekhefana ngoyedwa.

Inkinobho ethi "Yehlisa", ngokulandelana, yehlisa inani elithile lezinombolo ngemuva kwekhefana.

Ukujikeleza ngefomethi yeseli

Kungenzeka futhi ukusetha ukujikeleza usebenzisa izilungiselelo zefomethi yeselula. Ukuze wenze lokhu, khetha ibanga lamaseli eshidini, chofoza inkinobho yegundane kwesokudla bese ukhetha "Cell Ifomethi" entweni imenyu kuvela.

Ewindini lezilungiselelo zefomethi yeselula elivula, liye kwithebhu ethi "Numbe,". Uma ifomethi yedatha ayicaciswanga, kuyadingeka ukuyibeka ngaphandle, ngaphandle kwalokho ngeke ukwazi ukulawula ukujikeleza. Engxenyeni ephakathi yewindi eduze kombhalo "Inani lezimpawu zedesimali" vele likhombise inani lezimpawu ofuna ukuzibona lapho ziyindilinga. Ngemuva kwalokho faka izinguquko.

Ukubeka izibalo ukunemba

Uma kulezi zimo langaphambilini, isethi nemingcele abathintekayo kuphela zangaphandle idatha ukubonisa, futhi phakathi izibalo, izinkomba esinembile yasetshenziswa (ezingu-15), manje sizokutshela kanjani ukushintsha ukunemba izibalo.

1. Chofoza ithebhu Ifayela ukusuka lapho waya "Amapharamitha" sigaba.



2. I-Excel imingcele iwindi kuvula. Kulesi ifasitela, iya esigatshaneni "Akuphoqelekile". Lay izilungiselelo ukuvimba ngokuthi "lapho recalculating le ncwadi." Amasethingi kule block kungukuthi isetshenziswa ishidi elilodwa, kodwa incwadi iyonke, okungukuthi, ukuba wonke ifayela. Beka ibhokisi lokuhlola phambi "Setha yokunemba esikrinini" ipharamitha bese uqhebeza OK.



3. Manje, lapho kubalwa idatha, inombolo eboniswa eskrinini ngeke kucatshangelwe, futhi kungeyena lowo lilondolozwe imemori Excel. I sokushona inani ukuboniswa kungaba kwenziwe ngokwanoma yikuphi yezindlela ezimbili sakhuluma ngenhla.

Isicelo imisebenzi

Uma ufuna ukushintsha ukubaluleka ukuqoqa kulesi sibalo amaseli eyodwa noma ngaphezulu, kodwa musa ufuna nokwehlisa ukuqonda izibalo jikelele kudokhumende, kuleso simo kungcono ukusebenzisa amakhono okufakazela ukuthi "oyindilinga" umsebenzi nezincazelo zayo ezihlukahlukene ezihlukahlukene, kanye namanye imisebenzi.

Phakathi imisebenzi esemqoka elawula ukuqoqa kufanele zabelwe kanje:

• "Oyindilinga" - imizuliswano ukuze isibalo esithile izimpawu ledesimali ngokuvumelana olwamukelwa imithetho ukuqoqa;
• "District Phezulu" - imizuliswano kuze kube inombolo eliseduze i-module;
• "Roundedlice" - imizuliswano kuze kube inombolo eseduze phansi module;
• "Oyindilinga" - uphetha le nombolo ukunemba inikezwe;
• "OKRWP" - uphetha le nombolo ukunemba badela module;
• "OKRVNIS" - uphetha inombolo phansi module nge ukunemba inikezwe;
• "Otbr" - uphetha idatha inenombolo;
• "INkantolo" - uphetha idatha eseduze ngisho inombolo;
• "Challenge" - uphetha idatha inombolo eliseduze aphambene.

Ukuze imisebenzi "oyindilinga", "roundlower" futhi "roundedlice" sisebenzisa ifomethi input elandelayo: igama umsebenzi (inombolo; inani amayunithi). Okusho ukuthi, uma, isibonelo, ufuna elizofinyezwa inombolo 2,56896 ukuba amadijithi amathathu, bese zisebenza umsebenzi "Oyindilinga (2,56896; 3)". Ngenxa yalokho, kuvela inombolo 2,569.

Ukuze imisebenzi "Districtlt", "OKRWP" futhi "OKRVIS" Lokhu isetshenziswa onjalo ukuqoqa ifomula: igama umsebenzi (inombolo; ukunemba). Ngakho, elizofinyezwa inombolo 11 enombolweni eliseduze, amaningi 2, singena umsebenzi "District (11; 2)". Okuphuma ithola umphumela 12.

I "Otbr" imisebenzi, "ngisho" futhi "umfaniswano" zisebenzisa ifomethi elandelayo: igama umsebenzi (inombolo). Ukuze wokuqoqa inani 17 eseduze ngisho, sisebenzisa umsebenzi "Inkantolo (17)". Sithola umphumela 18.

Umsebenzi angafakwa kokubili esitokisini kumugqa imisebenzi, ngemuva kokukhetha iseli lapho kuyoba. Ngaphambi umsebenzi ngamunye kufanele usethe "=".

Kunendlela kuyiwa ukwethula imisebenzi ukuqoqa. Kuyinto elula kakhulu ukusebenzisa uma kukhona itafula namagugu ezidinga ukuba ukuguqula ku izinombolo oyindilinga e ikholomu ehlukile.

1. Yiya kuthebhu ethi "amafomula" bese uchofoza inkinobho ethi "ezibalo". Ohlwini esivula, ukhetha umsebenzi ofanele, isibonelo, "babanjwa".



2. Ngemva kwalokho, iwindi kwemisebenzi liyavuleka. Esikhathini "Inombolo" ensimini, ungafaka inamba ngokwakho, kodwa uma sifuna ngokuzenzakalela round idatha lonke etafuleni, bese uchofoza inkinobho kwesokudla sewindi idatha isingeniso.



3. Iwindi ukungqubuzana umsebenzi is eligoqiwe. Manje uchofoze iseli engenhla kukholamu yemininingwane siyaphi oyindilinga. Ngemva ukubaluleka wangena ewindini, chofoza inkinobho kuya kwesokudla kwaleli nani.



4. Iwindi kwemisebenzi kuvula futhi. Esikhathini "Inani esithweni" ensimini, bhala kancane lapho sidinga usike amafraktjhini futhi ukusebenzisa izinguquko.



5. Inombolo babanjwa. Ukuze round phansi kanye nabo bonke abanye idatha kwekholomu oyifunayo, ukuletha isikhombisi ekhoneni engezansi kwesokudla iseli nge value oyindilinga, chofoza inkinobho yesinxele, awelulele kuze kube sekupheleni etafuleni.



6. Manje zonke Amanani kukholomu uzobe waphetha.

usebenzisa inkinobho tape ngokushintsha kwemigomo format cell: Njengoba ubona, kunezindlela ezimbili eziyinhloko round isibonisi ebonakalayo inombolo kukhona. Ngaphezu kwalokho, ungakwazi ukushintsha ukuqoqa idatha empeleni ibalwa. Ingase futhi kwenziwe ngezindlela ezahlukene: ukushintsha izilungiselelo yencwadi iyonke noma ukusetshenziswa imisebenzi ekhethekile. Kukhethwa indlela ethile kuxhomeke ekutheni uyakusebenzisa bayahamba ukusebenzisa uhlobo olufanayo ukuqoqa ngoba yonke idatha ku ifayela noma kuphela ibanga eqondile amaseli.