I-Adobe Gamma 3.0

Kubasebenzisi be-Excel abavamile, akuyona imfihlo ukuthi izibalo ezahlukene, ubunjiniyela kanye nezibalo zezimali zingenziwa kuloluhlelo. Lesi sici sigcwaliswa ngokusebenzisa amafomu ahlukahlukene nemisebenzi. Kodwa, uma i-Excel isetshenziselwa ukwenza lezi zibalo, umbuzo wokuhlelwa kwamathuluzi afanelekile kulesi sihloko uyafaneleka, okuzokwandisa ngokuphawulekayo isivinini sokubala kanye nezinga lokuhle lomsebenzisi. Ake sizithole ukuthi singenza kanjani i-calculator enjalo ku-Excel.

Inqubo Yokudala I-Calculator

Okubalulekile ngokuphuthumayo lo msebenzi uba, uma kunesidingo, ukuqhuba njalo uhlobo olufanayo lokubala nokubala okuhambisana nomhlobo othize womsebenzi. Ngokuvamile, wonke ama-calculators ku-Excel angahlukaniswa ngamaqembu amabili: jikelele (asetshenziselwa izibalo ezijwayelekile zesibalo) nesiphrofayili esincane. Iqembu lokugcina lihlukaniswe izinhlobo eziningi: ubunjiniyela, ezezimali, imali yokutshala izimali, njll. Ukukhethwa kwe-algorithm yokudalwa kwayo kuxhomeke ekusebenzeni kokubala, okokuqala.

Indlela 1: Sebenzisa ama-Macros

Okokuqala, cabanga ngemibandela yokudala izibalo zokubala. Ake siqale ngokudala i-calculator elula yonke indawo. Leli thuluzi lizokwenza imisebenzi eyisisekelo ye-arithmetic: ukuhlanganisa, ukubuyabuyelela, ukususa, ukwahlukana, njll. Kusetshenziswa ngokusebenzisa i-macro. Ngakho-ke, ngaphambi kokuqhubeka nenqubo yokudala, udinga ukuqinisekisa ukuthi ufake ama-macros nephaneli yonjiniyela. Uma kungenjalo, kumele i-macro ifanele isebenze.

1. Ngemuva kokuthi izilungiselelo zangaphambili ezingenhla zenziwe, hamba kuthebhu "Unjiniyela". Chofoza kusithonjana "Visual Basic"okuyinto efakwe kwi-tape ebhodini lamathuluzi "Ikhodi".



2. Iwindi yokuhlela i-VBA iqala. Uma unendawo ephakathi ekhonjisiwe, hhayi emhlophe, lokhu kusho ukuthi ayikho insimu yokufaka ikhodi. Ukuze unike amandla ukuboniswa kwayo ukuya entweni yemenyu "Buka" bese uchofoze kulotshiwe "Ikhodi" ohlwini oluvela. Ungacindezela ukhiye womsebenzi esikhundleni salezi zenzo. F7. Kunoma yikuphi, inkambu ikhodi izovela.



3. Lapha endaweni ephakathi sidinga ukubhala ikhodi macro ngokwayo. Ifomu elilandelayo:

   I-Sub Calculator ()
Nciphisa strExpr njengezintambo
'Faka idatha yokubala
strExpr = InputBox ("Faka idatha")
'Umphumela Wokubala
MsgBox strExpr & "=" & Isicelo.Qaphela (strExpr)
Qedela ngaphansi

   Esikhundleni semisho "Faka idatha" ungabhala noma yimuphi omunye owamukelekile kuwe. Ukuthi kuzotholakala ngenhla yezinkulumo.

   Ngemuva kokuthi ikhodi ingenwe, ifayela kufanele lifakwe ngaphezulu. Noma kunjalo, kufanele ilondolozwe ngefomethi enokusekelwa kwe-macro. Chofoza kusithonjana ngesimo se-floppy disk kubha yamathuluzi yomhleli we-VBA.



4. Iwindi lwedokhumenti elondolozayo liqala. Iya kusiqondisi ku-hard drive yakho noma imithombo ekhishwayo lapho ufuna ukuyilondoloza. Ensimini "Igama lefayela" nikeza idokhumenti noma yiliphi igama elifunayo noma ushiye lona elinikezwe lona ngokuzenzakalelayo. Kuvunyelwe ensimini "Uhlobo lwefayela" kusuka kuzo zonke amafomethi atholakalayo akhethe igama "Incwadi yokusebenza ye-Excel enikwe amandla macro (* .xlsm)". Emva kwalesi sinyathelo sichofoza inkinobho. "Gcina" phansi kwefasitela.



5. Ngemuva kwalokho, ungavala ifasitela le-editor macro ngokuchofoza isithonjana esivamile esivela ngesigcawu esibomvu ngesiphambano esimhlophe ekhoneni eliphezulu langakwesokudla.



6. Ukusebenzisa ithuluzi lokusebenzisa ulwazi usebenzisa i-macro, ngenkathi kuthebhu "Unjiniyela"chofoza kusithonjana Macros kwi-tape ebhodini lamathuluzi "Ikhodi".



7. Emva kwalokho, iwindi le-macro liqala. Khetha igama le-macro esiyidalile nje, ukhethe bese uchofoza inkinobho Qalisa.



8. Ngemva kokwenza lesi senzo, i-calculator idalwe esekelwe ku-macro.



9. Ukuze senze isibalo kuwo, sibhala isenzo esidingekayo ensimini. Indlela elula kunazo zonke yokusebenzisa le njongo yi-block keypad block, elungile ngakwesokudla. Ngemuva kokuthi le nkulumo ifakiwe, chofoza inkinobho "Kulungile".



10. Khona-ke iwindi elincane livela esikrinini, eliqukethe impendulo kwisisombululo senkulumo ecacisiwe. Ukuyivala, chofoza inkinobho. "Kulungile".



11. Kodwa vumelani ukuthi kungcono kunzima ngaso sonke isikhathi uma udinga ukwenza izenzo zekhompyutha, iya ewindini elikhulu. Masenze lula ukuqaliswa kokusebenzisa iwindi lokubala. Kulokhu, ukube kuthebhu "Unjiniyela", chofoza isithonjana esivele sijwayele kithi Macros.



12. Khona-ke efasiteleni le-macro, khetha igama lezinto oyifunayo. Chofoza inkinobho "Izinketho ...".



13. Emva kwalokho, ifasitela iqaliswe ngisho ncane kunaleyo eyedlule. Kulo, singacacisa inhlanganisela yezikhiye ezishisayo, okuthi, uma zichofoziwe, zizoqala i-calculator. Kubalulekile ukuthi le nhlanganisela ayisetshenziselwa ukubiza ezinye izinqubo. Ngakho-ke, izinhlamvu zokuqala zama-alfabhethi azikhuthazwa. Inhlanganisela yokuqala yekhiye ibeka uhlelo ngokwalo i-Excel. Lesi sici Ctrl. Isihluthulelo esilandelayo sisethiwe ngumsebenzisi. Vumela kube yisihluthulelo V (nakuba ungakhetha enye). Uma lesi sikhiye sesivele sisetshenziswe uhlelo, ikhiye elilodwa ngaphezulu lizofakwa ngokuzenzekelayo ekuhlanganisweni - Si-hift. Faka uhlamvu olukhethiwe ensimini "Isinqamuleli" bese uchofoza inkinobho "Kulungile".



14. Bese uvala ifasitela le-macro ngokuchofoza isithonjana esivamile esiseduze ekhoneni elingakwesokudla.

Manje uma uthayipha inhlanganisela ye-hotkey ekhethiwe (kithi Ctrl + Shift + V) iwindi lokubala lizoqaliswa. Vumelana, kuyashesha futhi kulula kunokuyibiza njalo ngewindi le-macro.

Isifundo: Indlela yokudala i-macro ku-Excel

Indlela 2: Ukusebenzisa Imisebenzi

Manje ake sicabangele ukhetho lokudala i-calculator encane-profile. Izoklanywa ukwenza imisebenzi ethize, ethize futhi ibekwe ngokuqondile kwi-Excel sheet. Imisebenzi eyakhelwe ngaphakathi kwe-Excel izosetshenziselwa ukudala leli thuluzi.

Isibonelo, yakha ithuluzi lokuguqula amanani amaningi. Endleleni yokudalwa kwayo, sizosebenzisa lo msebenzi I-Preob. Lo opharetha ubhekisela kwiyunithi yobunjiniyela eyakhelwe imisebenzi excel. Umsebenti wakhe ukuguqula amanani wezinga elilodwa kwesinye. I-syntax yalo msebenzi ilandelayo:

= PREVENT (inombolo; ish_ed_izm; con_ed_izm)

"Inombolo" - Le ngxabano enesimo senani lezinombolo zexabiso elidinga ukuguqulwa libe yisinye isilinganiso sokulinganisa.

"Umthombo Wezandla" - impikiswano ebonisa ukuthi iyunithi yokukala yenani elizoguqulwa. Isethwe ikhodi ekhethekile ehambelana neyunithi ethile yokulinganisa.

"Iyunithi yokugcina yesilinganiso" - impikiswano echaza i-unit of measurement of the quantity in which the original original is converted. Ibuye isethwe ngokusebenzisa amakhodi akhethekile.

Kufanele sichaze ngalezi zimakhodi, ngoba sizozidinga kamuva ekudalweni komshini wokubala. Ngokuqondile, sidinga amakhodi wezingunithi zobuningi. Nasi uhlu lwazo:

• g - igremu;
• kg - kilogram;
• mg - milligram;
• lbm - ipayipi yesiNgisi;
• i-ozm - ounce;
• sg - slag;
• u - iyunithi ye-athomu.

Kudingeka futhi ukuthi zonke izimpikiswano zalolu msebenzi zingacaciswa kokubili ngamagugu kanye nokubhekisela kwamaseli lapho atholakala khona.

1. Okokuqala, senza ukulungiselela. Ithuluzi lethu lekhompyutha lizoba nezinkambu ezine:
   • Inani eliguquguqukayo;
   • Umthombo Wezandla;
   • Umphumela wokuguqulwa;
   • Iyunithi yokugcina.

   Sibeka izinhloko ezizofakwa kuzo lezi zinsimu, bese ukhetha ngokufometha (faka nemingcele) ukuze ubone okubonakalayo okubonakalayo.

   Emasimini "Convertible", "Umkhawulo wokukala umthombo" futhi "Umkhawulo Wokulinganisa" sizofaka idatha, nasensimini "Umphumela wokuguqulwa" - okukhipha umphumela wokugcina.



2. Masiwenze ukuze kusensimini "Convertible" umsebenzisi angangena amanani asebenzayo kuphela, okungukuthi, izinombolo ezinkulu kunazo zonke. Khetha iseli lapho inani lokuguqulwa lizofakwa khona. Iya kuthebhu "Idatha" futhi ebhodini lamathuluzi "Ukusebenza nedatha" chofoza kusithonjana "Ukuqinisekiswa kwedatha".



3. Iwindi lamathuluzi liqala. "Ukuqinisekiswa kwedatha". Okokuqala, yenza izilungiselelo kuthebhu "Izinketho". Ensimini "Uhlobo Lwedatha" khetha ipharamitha ohlwini "Real". Ensimini "Value" futhi kusukela ohlwini siyeka ukukhethwa kupharamitha "Okunye". Ensimini "Okuncane" setha inani "0". Ngakho-ke, izinamba zangempela kuphela (kufaka phakathi i-fractional), ezingaphezu kwe-zero, zingangena kule seli.



4. Ngemva kwalokho kuthutha kuthebhu yewindi elifanayo. "Umlayezo ongena". Lapha ungakwazi ukunikeza incazelo yalokho okudingayo ukufaka umsebenzisi. Uzoyibona uma ukhetha amanani weseli wokufaka. Ensimini "Umlayezo" bhala lokhu okulandelayo: "Faka inani lobungako ukuguqula".



5. Bese uthuthela kuthebhu "Umlayezo Wephutha". Ensimini "Umlayezo" kufanele sibhale izincomo ukuthi umsebenzisi ubona uma engena idatha engalungile. Bhala okulandelayo: "Ukufaka kufanele kube inombolo enhle." Ngemuva kwalokho, ukuze uqedele umsebenzi ku-window yokuhlola inani lokufakwayo bese ulondoloza izilungiselelo ezifakwe kithi, chofoza inkinobho "Kulungile".



6. Njengoba ungabona, uma ukhetha iseli, i-hint ibonakala.



7. Ake sizame ukungena lapho inani elingalungile, isibonelo, umbhalo noma inombolo engalungile. Njengoba ungabona, umlayezo wephutha uvela futhi okokufaka kuvinjelwe. Sicindezela inkinobho "Khansela".



8. Kodwa inani elilungile lifakiwe ngaphandle kwezinkinga.



9. Manje hamba ensimini "Umthombo Wezandla". Lapha sizokwenza umsebenzisi akhethe inani elivela ohlwini oluqukethe lawo maxabiso ayisikhombisa, uhlu lwaphiwa ngenhla uma kuchaza izimpendulo zomsebenzi. I-Preob. Faka amanye amanani angeke asebenze.

   Khetha iseli elingaphansi kwegama "Umthombo Wezandla". Chofoza futhi kusithonjana "Ukuqinisekiswa kwedatha".



10. Kuwindidi yokuqinisekisa idatha evula, iya kuthebhu "Izinketho". Ensimini "Uhlobo Lwedatha" setha ipharamitha "Bhala". Ensimini "Umthombo" ngokusebenzisa i-semicolon (;) sibhala amakhodi wamagama amaningi ngobuningi bomsebenzi I-Preobmayelana nokuthi kwakukhona ingxoxo ngenhla. Okulandelayo, chofoza inkinobho "Kulungile".



11. Njengoba ungabona, manje, uma ukhetha insimu "Umthombo Wezandla", isithonjana sezinxantathu sibonakala ngakwesokudla. Uma uchofoza kuso, uhlu luvula ngamagama amayunithi wokulinganisa ubukhulu.



12. Inqubo efana nhlobo efasiteleni "Ukuqinisekiswa kwedatha" sifeza futhi sinegama ngegama "Iyunithi yokugcina yesilinganiso". Ibuye ifane ncamashi uhlu olufanayo lwamayunithi.



13. Emva kwalokho iya esitokisini "Umphumela wokuguqulwa". Izoqukatha umsebenzi I-Preob futhi ubonise umphumela wokubala. Khetha lesi sici seshidi bese uchofoza isithonjana "Faka umsebenzi".



14. Iqala Umsebenzi weWebhu. Siya kuwo kusigaba "Ubunjiniyela" bese ukhetha igama lapho "PREOBR". Bese uchofoza inkinobho. "Kulungile".



15. Iwindi lempikiswano ye-Operator ivuleka I-Preob. Ensimini "Inombolo" kufanele ufake izixhumanisi zeseli ngaphansi kwegama "Convertible". Ukwenza lokhu, faka isikhombisi endle bese uchofoza inkinobho yegundane lesokunxele kule seli. Ikheli lakhe liboniswa masinyane ensimini. Ngendlela efanayo siyafaka izixhumanisi emasimini. "Umthombo Wezandla" futhi "Iyunithi yokugcina yesilinganiso". Kuphela lesi sikhathi sichofoza kumaseli anegama elifanayo njengalezi zinsimu.

    Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".



16. Ngokushesha lapho sesiqedile isenzo sokugcina, efasiteleni leseli "Umphumela wokuguqulwa" ngokushesha wabonisa umphumela wokuguqulwa kwenani, ngokusho kwedatha yangena ngaphambilini.



17. Ake sishintshe idatha kumaseli "Convertible", "Umthombo Wezandla" futhi "Iyunithi yokugcina yesilinganiso". Njengoba ungabona, lo msebenzi uvuselela ngokuzenzakalelayo umphumela uma ushintsha imingcele. Lokhu kusikisela ukuthi i-calculator yethu isebenza ngokugcwele.



18. Kodwa asizange senze into eyodwa ebalulekile. Amaseli wokungena kwedatha avikelwe ekufakweni kwezindinganiso ezingalungile, kodwa into yokukhishwa kwedatha ayivikelwe nhlobo. Kodwa ngokuvamile akunakwenzeka ukungena lutho kuwo, ngaphandle kwalokho ifomula yokubala izosuswa kuphela futhi i-calculator ngeke ikwazi ukusebenza. Ngephutha, ungaphinda ungene idatha kule seli, ungawasebenzisi abasebenzisi beqembu lesithathu. Kulesi simo, kufanele ubhale kabusha yonke ifomula. Kudingeka uvimbele noma yikuphi ukungena kwedatha lapha.

    Inkinga yukuthi ukukhiya kuhlelwe kushidi lonke. Kodwa uma sivimbela ishidi, ngeke sikwazi ukungena idatha emasimini wokufaka. Ngakho-ke, kuzodingeka sisuse ithuba lokuvimbela kuzo zonke izakhi zeshidi ezindaweni zefomethi yeseli, bese ubuyela lokhu kungenzeka kuphela kuseli ukubonisa umphumela futhi ngemuva kwalokho uvimbele ishidi.

    Sokuchofoza ngakwesokunxele kulesi sici emkhakheni wezingqimba ezizungezile neziqondile zezixhumanisi. Lokhu kugcizelela lonke ishidi. Khona-ke sichofoza ngakwesokudla ekukhethweni. Imenyu yomongo ivulwa lapho sikhetha khona isikhundla. "Fometha amaseli ...".



19. Ifasitela lokufometha iqala. Yiya kuso kuthebhu "Isivikelo" futhi ungahloli ipharamitha "Iseli elivikelwe". Bese uchofoza inkinobho. "Kulungile".



20. Emva kwalokho, khetha kuphela iseli ukubonisa umphumela bese uchofoze kuso nge inkinobho yegundane kwesokudla. Emenyu yomongo, chofoza entweni "Fometha amaseli".



21. Nakuphinde efasiteleni lokufometha, iya kuthebhu "Isivikelo"kodwa ngalesi sikhathi, ngokuphambene nalokho, sibeka uphawu ngokuseduze kwepharamitha "Iseli elivikelwe". Bese uchofoza inkinobho. "Kulungile".



22. Ngemva kwalokho kuthutha kuthebhu "Ukubukeza" bese uchofoza isithonjana "Vikela ishidi"esitholakala kwibhulogi yamathuluzi "Izinguquko".



23. Iwindi yokuvikela ishidi livula. Ensimini "Iphasiwedi yokukhubaza ukuvikelwa kweshidi" faka iphasiwedi lapho, uma kunesidingo, esikhathini esizayo kuyokwenzeka ukususa ukuvikelwa. Izilungiselelo ezisele zingashiywa zingashintshi. Sicindezela inkinobho "Kulungile".



24. Khona-ke elinye iwindi elincane livula lapho kufanele uphinde khona iphasiwedi. Yenza lokhu bese uchofoza inkinobho. "Kulungile".



25. Emva kwalokho, uma uzama ukwenza noma yikuphi ushintsho kumakhalekhukhwini ophumayo, izenzo zizovinjelwa, okubikiwe ebhokisini lebhokisi elivela.

Ngakho-ke, sidale ukubala okugcwele ukuguqula izindinganiso zamanani ezinyunithi ezihlukahlukene zokulinganisa.

Ngaphezu kwalokho, isihloko esihlukile sichaza ukudalwa kolunye uhlobo lwe-calculator encane e-Excel ukubala izinkokhelo zemalimboleko.

Isifundo: Ukubalwa kokukhokhwa kwemali ku-Excel

Indlela ye-3: Nika amandla i-Excel yokufaka i-calculator

Ngaphezu kwalokho, i-Excel inomshini wayo wokubala wokuzakhela ngaphakathi. Iqiniso, ngokuzenzakalelayo, inkinobho yayo yokuqaliswa ayikho ebhodini noma kwibha yezinqamuleli. Cabanga ukuthi ungayisebenzisa kanjani.

1. Ngemuva kokusebenza i-Excel, thuthela kuthebhu "Ifayela".



2. Okulandelayo, efasiteleni evula, iya esigabeni "Izinketho".



3. Ngemuva kokuqala iwindi yezinketho ze-Excel, hamba esigatshaneni "Ibha yamathuluzi okufinyelela ngokushesha".



4. Ngaphambi kwethu kuvulwa iwindi, ohlangothini olungakwesokudla lwayo luhlukaniswe ezindaweni ezimbili. Engxenyeni yayo efanele kukhona amathuluzi asevele afakwe kwiphaneli yokufinyelela esheshayo. Ngakwesokunxele yisethi yonke yamathuluzi atholakalayo ku-Excel, kufaka phakathi nalawo alahlekile ku-tape.

   Ngenhla kwenkambu engakwesokunxele "Khetha amaqembu" khetha into evela ohlwini "Amaqembu awasekho etafuleni". Ngemuva kwalokho, kuhlu lwamathuluzi ngakwesokunxele, bheka igama. "I-Calculator". Kuyoba lula ukuthola, ngoba wonke amagama ahlelwe nge-alfabhethi. Bese senza ukhetho laleli gama.

   Ngaphezulu kwendawo efanele yinsimu "Ukwenza ngokwezifiso ibha yamathuluzi okusheshayo". Inemingcele emibili:

   • Yonke imibhalo;
   • Kule ncwadi.

   Ukulungiselelwa okuzenzakalelayo kungokwamanye amadokhumenti. Le pharamitha inconywa ukuba ishiywe ingashintshi uma kungekho okudingekayo okuphambene nalokho.

   Ngemuva kokuthi zonke izilungiselelo zenziwe kanye negama "I-Calculator" kuqokonyiswe, chofoza inkinobho "Engeza"okuyinto ephakathi kwendawo kwesokudla nesobunxele.



5. Ngemuva kwegama "I-Calculator" uboniswa ngakwesokudla, chofoza inkinobho "Kulungile" phansi ngezansi.



6. Emva kwalokhu, iwindi yezinketho ze-Excel izovala. Ukuze uqale i-calculator, udinga ukuchofoza esithombeni segama elifanayo, elisesibhalweni sesinqamuleli manje.



7. Emva kwalesi thuluzi "I-Calculator" izoqaliswa. Isebenza njenge-analog evamile ngokomzimba, kuphela izinkinobho zidinga ukucindezelwa isikhombisi segundane, inkinobho yayo yesokunxele.

Njengoba ubona, ku-Excel kunezinketho eziningi zokudala ababala izidingo ezihlukahlukene. Lesi sici siwusizo ngokukhethekile lapho senza izibalo ezincane zephrofayela. Yebo, ngezidingo ezivamile, ungasebenzisa ithuluzi elakhelwe kulolu hlelo.