Sebenza ezine

Omnye wemisebenzi emxinwa kwenkqubo ye-Excel yi-Dwark. Umsebenzi wayo kukubuyela kwinqanaba legqabi, apho ikhoyo, imixholo yeseli apho ikhonkco kwifomati yombhalo icacisiwe ngendlela yempikiswano.

Ingabonakala ngathi akukho nto ibalulekileyo ngayo, kuba kunokwenzeka ukubonisa iziqulatho zeseli enye kunye neendlela ezilula. Kodwa, njengoko iqala, ezinye izinto ezenza zahlukile zinxulunyaniswa nokusetyenziswa kwalo msebenzi. Ngamanye amaxesha, le fomula iyakwazi ukusombulula imisebenzi enjalo ngezinye iindlela ezingenako ukuyifumana okanye kuya kuba nzima ngakumbi ukwenza. Masifunde ngakumbi, emela umqhubi ophezulu kunye nokuba inokusetyenziswa njani.

Ukusetyenziswa kwe-formula dvssl

Igama lale DVSL le-Operator ligqityiwe njenge "ikhonkco eliphindwe kabini". Ngokwenyani, oku kubonisa injongo yalo-ukubonisa idatha ngesalathiso esichaziweyo ukusuka kwelinye icala ukuya kwenye. Ngaphezu koko, ngokungafaniyo neminye imisebenzi esebenza ngezalathiso, kufuneka icaciswe kwifomathi yokubhaliweyo, leyo ibalaseliswa kumacala omabini kunye neekowuti.

Lo msebenzi ubhekisa kudidi lwe "Amakhonkco kwaye udwelise" imisebenzi kwaye une-syntax elandelayo:

= I-dwarf (ikhonkco_ yegama; [A1])

Ke, ifomula ineempikiswano ezimbini kuphela.

Impikiswano "Ikhonkco kwiseli" ibonakalisiwe njengekhonkco kwinqanaba legqabi, idatha equlethwe kuyo. Kule meko, ikhonkco elichaziweyo kufuneka libe nefom yesicatshulwa, oko kukuthi, 'sisongelwe' ngeekowuti.

Impikiswano "A1" ayinyanzelekanga kwaye ibe sisininzi samatyala amatyala akufuneki abonakaliswe kwaphela. Inokuba neenqobo ezimbini ze "iNyaniso" kunye "Nika". Kwimeko yokuqala, umqhubi umisela amakhonkco kwisitayile se "A1", oko kukuthi, le ndlela inikwe amandla kwi-Excel ngokungagqibekanga. Ukuba ixabiso lempikiswano alichazi konke konke, liya kuqwalaselwa ngokuthe ngqo 'njengenyani ". Kwicala lesibini, iireferensi zimiselwe kwisitayile se-R1C1. Esi sitayile sekhonkco kufuneka sibandakanywe ngokukhethekileyo kwiseto esisesithelini.

Ukuba uthi nje, i-DWARF luhlobo lokulingana kwamakhonkco kwiseli enye ukuya kwenye emva komqondiso "ulingana." Umzekelo, kwiimeko ezininzi ibinzana

= I-Dwarns ("A1")

izakulingana nokuthetha

= A1.

Kodwa ngokuchaseneyo nentetho "= A1", ii-DVSL ze-operator iqhotyoshelwe kwiseli ethile, kodwa ukuya kuthi ga kwi-fanment yenqaku.

Cinga ukuba kuthetha ntoni kumzekelo olula. Kwiiseli B8 kunye ne-B9, ngokulandelelana, ibekwe kwifom erekhodiweyo "=" "" "" "" "" "" "" "" "kunye nomsebenzi we-Dwarf. Zombini iifomula zibhekisa kwi-B4 ye-B4 kwaye zikhuphe imixholo yayo kwiphepha. Ngokwemvelo lo mxholo uyafana.

Yongeza enye into engenanto etafileni. Njengoko ubona, imiqolo ihamba. Kwifomula esebenzisa "ilinganayo", ixabiso lihlala lifana, njengoko libhekisa kwiseli yokugqibela, nokuba izinxibelelanisi zayo zitshintshile, kodwa idatha evela kumqhubi itshintshile. Kungenxa yenyani yokuba ayibhekiseli kwi-amef, kodwa kulungelelwaniso. Emva kongeza umtya, idilesi ye-B4 iqulethe enye into. Umxholo wayo yindlela yokubonisa kunye nemiboniso.

Lo msebenzi uyakwazi ukubonisa nje inqaku, kodwa nesicatshulwa, isiphumo sokubala kwefomula kunye nawaphi na amanye amaxabiso akwindawo ekhethiweyo. Kodwa ekusebenzeni, lo msebenzi ungasetyenziswanga ngokuzimeleyo, kwaye okuninzi kakhulu yinxalenye yefomula entsokothileyo.

Kuya kufuneka kuqatshelwe ukuba umqhubi usebenza kwireferensi kwamanye amaphepha kunye nokuqulunqa ezinye iincwadi ze-Excel, kodwa kule meko kufuneka zisungulwe.

Ngoku makhe siqwalasele imizekelo ethile yokusetyenziswa komqhubi.

Umzekelo 1: Ukusetyenziswa okukodwa komqhubi

Ukuqala, cinga ngowona mzekelo ulula apho ifilimu isebenza khona ngokuzimeleyo ukuze ukwazi ukuyiqonda into yomsebenzi wakhe.

Sinetafile enamaphiko. Kukho umsebenzi wokubonisa idatha yokuqala yekholam yokuqala kwinqaku lokuqala lekholamu nganye usebenzisa ifomula efundwayo.

1. Sibonisa into yokuqala engenanto yekholamu, apho siceba ukufaka ifomula. Cofa kwindawo ethi "Faka umsebenzi" icon.



2. Iwindows yeWizard yeWizard iqala ukusebenza. Sifudukela kudidi "Amakhonkco kunye neCorys". Ukusuka kuluhlu, khetha ixabiso "DVSSL". Cofa kwiqhosha "Kulungile".



3. Ifestile yempikiswano yomsebenzi ochaziweyo. Kwi "Ikhonkco kwintsimi" yeseli, kufuneka uchaze idilesi yeso sixhobo eshiyini, iziqulatho zokuba siza kubonisa kuzo. Ewe kunjalo, inokungeniswa ngesandla, kodwa ilunge ngakumbi kwaye iya kuba lula ukwenza oku kulandelayo. Faka isikhombisi ebaleni, emva koko nqakraza iqhosha leqhosha lasekhohlo kwinqaku elifanelekileyo ephepheni. Njengoko ubona, kwangoko emva koko, idilesi yalo yavela endle. Emva koko sabela ikhonkco kunye neekowuti ezivela kumacala omabini. Njengoko sikhumbula, le yinto yokusebenza ngokuxoxa kwale forala.

   Kwintsimi "ye-A1", kuba sisebenza kuhlobo oluqhelekileyo lokulungelelanisa, unokubeka ixabiso le "Inyaniso", kwaye ungayishiya konke konke esiya kuyenza. Ezi ziya kuba zizenzo ezifanayo.

   Emva koko, cofa kwiqhosha "Kulungile".



4. Njengoko sibona, ngoku ukwenzekiwe kwiseli yokuqala yekholamu yokuqala yetafile iboniswa kwinto yephepha apho ifomula ifumaneka khona.



5. Ukuba sifuna ukusebenzisa lo msebenzi kwiiseli, ezikwezantsi, ke kule meko kuya kufuneka ilungiselelwe kwifomula yendawo nganye. Ukuba sizama ukukopa kusetyenziswa uphawu lokuzalisa okanye enye indlela yokupakisha, igama elifanayo liya kuboniswa kuzo zonke izinto zekholamu. Inyani yile yokuba, njengoko sikhumbula, ireferensi isebenza njengengxabano kwifomu yokubhaliweyo (esongelwe kwizicatshulwa), oko kuthetha ukuba ayinakuba nesalamane.

Isifundo: Imisebenzi yeWizard kwinkqubo ye-Excel

Umzekelo 2: usebenzisa umqhubi kwifomula ebanzi

Kwaye ngoku makhe sijonge umzekelo wokusetyenziswa rhoqo komsebenzisi emibini, xa kuyinxalenye ebalulekileyo yefomula enzima.

Sinetafile yenyanga yengeniso yeshishini. Kufuneka sibale inani lengeniso kangangexesha elithile, umzekelo, ngoMeyi-Meyi okanye ngoJuni-Novemba - Novemba. Ewe kunjalo, ngenxa yoko, kunokwenzeka ukuba usebenzise ifomula yokungqinelana okulula, kodwa kule meko, ukuba kuyimfuneko, ukubala le fomula ngalo lonke ixesha. Kodwa xa usebenzisa le msebenzi, i-Dwarf inokutshintshwa ngoluhlu olunokuququzelela, ukuchaza nje inyanga ehambelanayo kwiiseli nganye. Masizame ukusebenzisa olu khetho lokuziqhelanisa kuqala ukubala isixa sexesha ukusuka ku-Matshi ukuya. Oku kuya kusebenzisa ifomula ngendibaniselwano yabasebenzi bakarhulumente kunye ne-dash.

1. Okokuqala, kwizinto ezizodwa kwiphepha legama leenyanga zokuqala nasekupheleni kwexesha, apho ubalo luya kubalwa, ngokulandelelana, ngoMatshi "kunye" noMatshi "kunye" noMeyi.



2. Ngoku sinika igama kuzo zonke iiseli kwikholam "yengeniso", eya kufana negama lenyanga ehambelanayo. Oko kukuthi, into yokuqala kwikholam "yeNgeniso", equkethe ubungakanani bengeniso, kufuneka ibizwe "ngoJanuwari", yesibini kaFebruwari, njEFemub ", nje.

   Ke, ukunika igama kwinto yokuqala yekholamu, khetha kwaye cinezela iqhosha lemouse lasekunene. Imenyu yemeko ivula. Khetha into ethi "Yabela igama ...".



3. Iwindows yegama elithiwe. Kwi "Igama" Intsimi ifanelekile igama "Januwari". Akusekho lutshintsho kwifestile akufuneki lwenziwe, nangona kunokwenzeka ukuba ungayijonga into yokuba ulungelelwaniso kwindawo "yoluhlu" luhambelana nedilesi yeseli equkethe ubungakanani bengeniso ngoJanuwari. Emva koko, cofa kwiqhosha "Kulungile".



4. Njengoko ubona, ngoku, xa usabela le nto kwigama lefestile, ayiboniswanga kwidilesi yayo, kwaye ke igama lam limnike lona. Umsebenzi ofanayo wenziwa ngazo zonke ezinye izinto zekholam "yeNgeniso", ebanika amagama angaguqukiyo "," Matshi ",", njl. kude kube kuxutyushwe ngoDisemba.



5. Khetha iseli apho inani lamaxabiso exesha lesithuba esichaziweyo liya kuboniswa kwaye alifumane. Emva koko cofa kwi "fack umsebenzi" ". Ibekwe ngasekhohlo komgca wefomula kunye nasekunene kwentsimi apho igama leeseli liyaboniswa khona.



6. Kwiwindow eqholiweyo, iiMasters zemisebenzi zihamba ziye kudidi "lweMathematics". Apho khetha igama "Izibalo". Cofa kwiqhosha "Kulungile".



7. Emva kokuphunyezwa kwesi senzo, impikiswano ye-Operator isungulwe, kuphela umsebenzi ongumququzelo wexabiso elichaziweyo. I-syntax yalo msebenzi ilula kakhulu:

   = Izibalo (inombolo1; inombolo2; ...)

   Ngokubanzi, inani leempikiswano zinokufikelela kwiinqobo zokuziphatha ezingama-255. Kodwa zonke ezi mpikiswano zithandabuza. Balinani okanye ukulungelelaniswa kweseli apho inani liqula khona. Bangenza nendlela yefomula eyakhelweyo enika inombolo oyifunayo okanye ibonisa idilesi yendawo yegqabi apho ibekwe khona. Kukwinqanaba lomsebenzi owakhiweyo kunye nomqhubi wethu uya kusetyenziswa kule meko.

   Faka isikhombisi kwintsimi "yeNombolo1". Emva koko nqakraza kwi icon ngohlobo lonxantathu ongaphakathi uye ngasekunene koluhlu lwe-ranges. Uluhlu lwemisebenzi yakutshanje ichaziwe. Ukuba kukho igama elithi "DVSSL" phakathi kwalo, emva koko ucofe kwangoko ukuba uye kwifestile yempikiswano yalo msebenzi. Kodwa kusenokwenzeka ukuba kolu luhlu aluyi kuyifumana. Kule meko, kufuneka ucofe igama "eminye imisebenzi ..." ezantsi koluhlu.



8. Isuswe sele iqhelene nemisebenzi yeWizard yase-US. Sifudukela kwicandelo "Amakhonkco kunye CORYS" kwaye ukhethe igama le-DVSLl. Emva koko, cofa iqhosha "Kulungile" emazantsi efestile.



9. Ifestile yempikiswano yomqhubi isungulwe. "Ikhonkco kwintsimi" yeseli ", chaza idilesi yento yegqabi, elinegama lenyanga yokuqala yoluhlu olucetyiswayo. Nceda uqaphele ukuba kule meko awudingi kuthatha ikhonkco kwizicatshulwa, kuba kule meko akuyi kubakho sinxibelelanisi seseli, kodwa sinemixholo yaso, esele inefomathi yetekisi (igama elithi "Matshi"). Intsimi "A1" ishiywe ingenanto, kuba sisebenzisa uhlobo lolungelelwaniso olusezantsi.

   Emva kokuba idilesi iboniswe ebaleni, ungangxami kwiqhosha "Kulungile", njengoko lo ngumsebenzi odibeneyo, kwaye iintshukumo zayo zahlukile kwi-algorithm eqhelekileyo. Cofa kwigama "Imali" kumgca wefomula.



10. Emva koko, sibuyela kwimpikiswano yezibalo. Njengoko ubona, "Inombolo ye" Number1 "sele inyamalala umqhubi ejijekile ngomxholo wayo. Faka isikhombisi kwicandelo elinye ngokukhawuleza emva kophawu lokugqibela kwingxelo. Beka uphawu lwekolon (:). Olu phawu luthetha uphawu lwedilesi ye-SIT yeseli. Okulandelayo, ngaphandle kokususa isikhombisi kwintsimi, kwakhona Cofa kwi icon njengenxantathu yokukhetha imisebenzi. Ngeli xesha kuluhlu lwabasebenzi abasetyenziswa ngokukhawuleza, igama elithi "DVSLl" kufuneka lithathwe njengezichanekileyo, njengoko sisanda kusetyenziswa le nqaku. Cofa ngegama.



11. Iimpikiswano zempikiswano yomqhubi we-operator ivula kwakhona. Singena "ikhonkco kwintsimi" yedilesi yenqaku lenqaku elikwiphepha apho igama lenyanga lilungile, eligqiba ixesha eliqikelelweyo. Kwakhona ukulungelelaniswa kufuneka kubhalwe ngaphandle kokucaphula. Intsimi "A1" Shiya uphinda udle. Emva koko, cofa kwiqhosha "Kulungile".



12. Njengoko ubona, emva kwezi zenzo, le nkqubo yenza ukubalwa kwaye inike iziphumo zongezwa kwengeniso yeshishini ngexesha elichaziweyo (Matshi-I-Meyi) kwi-formula yona .



13. Ukuba sitshintsha kwiiseli, apho amagama okuqala nokuphela kwexesha eliqikelelweyo abhalwe, kwabanye, umzekelo, ngoJuni nangoNovemba, kwaye umphumo uza kutshintsha ngokufanelekileyo. Inani lengeniso yexesha elichaziweyo liya kusongelwa.

Isifundo: INDLELA YOKUXELISA INDLELA YOKUXHASA

Njengoko sibona, ngaphandle kwento yokuba umsebenzi we-FVS awunakubizwa ngomnye wabasebenzisi abathandwa kakhulu, nangona kunjalo, kuyanceda ukusombulula imisebenzi eyahlukeneyo e-Excel kulula kakhulu kunokuba kungenziwa kwezinye izixhobo. Uninzi lwayo yonke le ndlela isebenza njengenxalenye yefomula entsokothileyo apho iyinxalenye yentetho. Kodwa kusekukukufanele ukuba kuqatshelwe ukuba zonke izinto ezinokwenzeka ze-dosk yomqhubi ziqatha kakhulu ekuqondeni. Oku kuchaza nje eyona nto iphantsi yalo msebenzi uluncedo kubasebenzisi.