Umsebenzi we-4 Excel

Enye yemisebenzi eshumekiwe yohlelo lwe-Excel yi-Dwarps. Umsebenzi wayo ukubuyela engxenyeni yamaqabunga, lapho itholakala khona, okuqukethwe esitokisini lapho isixhumanisi esisesimweni sombhalo sichazwe ngendlela yengxabano.

Kubukeka sengathi akukho lutho olukhethekile ngakho, ngoba kungenzeka ukubonisa okuqukethwe kweseli elilodwa kwezinye nezindlela ezilula. Kepha, njengoba kuvela, amanye ama-nuances akwenzayo ahlukile ahlotshaniswa nokusetshenziswa kwalolu hlelo. Kwezinye izimo, le formula iyakwazi ukuxazulula imisebenzi enjalo nangezinye izindlela ezingeke zikwazi ukubhekana nazo noma kuzoba nzima kakhulu ukukwenza. Masifunde Okuningi, okumele i-Fast Operator nokuthi ingasetshenziswa kanjani ekusebenzeni.

Ukusetshenziswa kwefomula DVSSL

Lona kanye igama lalesi sihloko se-DVSSL se-DVSSL senziwe phansi njengesixhumanisi esiphindwe kabili ". Empeleni, lokhu kukhombisa inhloso yako - ukubonisa idatha ngereferensi ecacisiwe kusuka kusoli elilodwa kuya kwenye. Ngaphezu kwalokho, ngokungafani neminye imisebenzi eminingi esebenza nezinkomba, kufanele kuchazwe ngefomethi yombhalo, okungukuthi, kuqokonyiswe kusuka ezinhlangothini zombili ngezingcaphuno.

Lo msebenzi ubhekisa esigabeni se- "Links kanye nemicibisholo" imisebenzi futhi une-syntax elandelayo:

= DWARF (isixhumanisi__enanechair; [A1])

Ngakho-ke, ifomula inezimpikiswano ezimbili kuphela.

Isixhumanisi sokuphikisana "esitokisini" sethulwa njengesixhumanisi se-leaf element, imininingwane equkethwe lapho ufuna ukubonisa khona. Kulokhu, isixhumanisi esibekiwe kufanele sibe nefomu lombhalo, okungukuthi, 'ligotshwe' ngezingcaphuno.

Ingxabano "A1" ayiphoqelekile futhi kuningi lamacala amaningi akudingi ukukhonjiswa nhlobo. Kungaba namanani amabili "eqiniso" futhi "amanga". Esimweni sokuqala, opharetha unquma izixhumanisi ngesitayela se- "A1", okungukuthi, lesi sitayela sinikwe amandla kwi-Excel ngokuzenzakalelayo. Uma inani lengxabano alichazi nhlobo, lizobhekwa njengeqiniso ngokuthi "iqiniso". Esimweni sesibili, izinkomba zinqunywa ngesitayela sika-R1c1. Lesi sitayela sesixhumanisi kumele sifakwe ngqo kuzilungiselelo ze-Exel.

Uma usho nje, i-Dwarf uhlobo olufana nezixhumanisi zeseli elilodwa kuya kwenye ngemuva kwesibonakaliso "esilinganayo." Isibonelo, ezimweni eziningi isisho

= DWARNS ("A1")

izolingana nenkulumo

= A1.

Kepha ngokungafani nenkulumo ethi "= A1", ama-DVSL e-opharetha afakwe esitokisini esithile, kodwa kuya kwizixhumanisi zento eshidini.

Cabanga ukuthi kusho ukuthini esibonelweni esilula. Kumaseli B8 ne-B9, ngokulandelana, kubekwe okurekhodiwe ngefomula "=" kanye nomsebenzi we-Dwarf. Womabili la mafomula abhekisela kwi-Element B4 nokukhipha okuqukethwe kuyo eshidini. Ngokwemvelo lokhu okuqukethwe kufana.

Faka enye into engenalutho etafuleni. Njengoba ubona, imigqa yathutha. Efomula usebenzisa "ukulingana", inani lihlala lifana, njengoba lisho iseli lokugcina, noma ngabe izixhumanisi zalo zishintshile, kepha imininingwane evela ku-opharetha isishintshile. Lokhu kungenxa yokuthi iqiniso lokuthi lisho hhayi kwinto yamaqabunga, kepha kwizixhumanisi. Ngemuva kokungeza intambo, ikheli B4 liqukethe enye into eshidi. Okuqukethwe kwalo manje kuyifomula futhi kuboniswa eshidini.

Lo opharetha uyakwazi ukubonisa hhayi kuphela inombolo, kodwa futhi umbhalo, umphumela wokubalwa kwamafomula nanoma yimaphi amanye amanani atholakala eshidini elikhethiwe leshidi. Kepha ekusebenzeni, lo msebenzi awuvamile ukusetshenziswa ngokuzimela, futhi kaningi kuyingxenye ebalulekile yamafomula ayinkimbinkimbi.

Kumele kwaziwe ukuthi opharetha asebenza ngezinkomba kwamanye amashidi futhi ngisho nokuqukethwe kwezinye izincwadi ze-Excel, kepha kulokhu kufanele zethulwe.

Manje ake sibheke izibonelo ezithile zokusetshenziswa kwe-opharetha.

Isibonelo sokuqala: ukusetshenziswa okukodwa kwe-opharetha

Okokuqala, cabanga ngesibonelo esilula kunazo zonke lapho umsebenzi wefilimu uvikela khona ngokuzimela ukuze uqonde ubuhlakani bomsebenzi wakhe.

Sinetafula eliphikisayo. Kunomsebenzi wokubonisa idatha yeseli yokuqala yekholomu yokuqala entweni yokuqala yekholomu yomuntu ngamunye usebenzisa ifomula efundwayo.

1. Sigqamisa into yokuqala engenalutho yekholomu, lapho sihlela ukufaka ifomula. Chofoza isithonjana se- "Insert Function".



2. Iwindows wizard wizard iqala ukusebenza. Sithuthela esigabeni "izixhumanisi kanye nama-arrays". Ukusuka ohlwini, khetha inani "DVSSL". Chofoza inkinobho ethi "KULUNGILE".



3. Iwindi lokuxabana lopharetha elicacisiwe liyasungulwa. Ku-"LINK kwinkambu yeseli" yeseli, kufanele usho ikheli lento eshidini, okuqukethwe okuzobonisa ngalo. Vele, ingafakwa ngesandla, kepha isebenza kakhulu futhi kuzoba lula ngokwengeziwe ukwenza okulandelayo. Faka isikhombisi enkundleni, bese uqhafaza inkinobho yegundane kwesobunxele endaweni efanele eshidini. Njengoba ubona, ngokushesha emva kwalokho, ikheli lalo lavela ensimini. Ngemuva kwalokho sabela isixhumanisi ngezingcaphuno ezivela ezinhlangothini zombili. Njengoba sikhumbula, lesi isici sokusebenza ngengxabano yale formula.

   Ensimini ethi "A1", ngoba sisebenza ngohlobo olujwayelekile lokudidiyelwa, ungabeka ukubaluleka "kweqiniso", futhi ungakushiya nhlobo ungenalutho. Lokhu kuzoba yizenzo ezifanayo.

   Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



4. Njengoba sibona, manje okuqukethwe kweseli lokuqala lekholamu lokuqala letafula liboniswa endaweni yephepha lapho ifomula itholakala khona.



5. Uma sifuna ukusebenzisa lo msebenzi kumaseli, atholakala ngezansi, khona-ke kulokhu kuzodingeka ukuthi uphathwe ifomula yento ngayinye ngokwahlukana. Uma sizama ukukopisha sisebenzisa umaki wokugcwalisa noma enye indlela yokukopisha, igama elifanayo lizokhonjiswa kuzo zonke izinto zekholomu. Iqiniso ngukuthi, njengoba sikhumbula, ireferensi isebenza njengengxabano ngendlela yombhalo (esongelwe izingcaphuno), okusho ukuthi ngeke ikwazi ukulingana.

Isifundo: Imisebenzi yeWizard ohlelweni lwe-Excel

Isibonelo 2: Usebenzisa opharetha efomula ephelele

Futhi manje ake sibheke isibonelo sokusetshenziswa okuvame kakhulu kopharetha womabili, lapho kuyingxenye ebalulekile yefomula eyinkimbinkimbi.

Sinethebula lenyanga lemali engenayo yebhizinisi. Sidinga ukubala inani lemali engenayo isikhathi esithile, ngokwesibonelo Mart - Meyi noma ngoJuni - Novemba. Vele, kulokhu, kungenzeka ukusebenzisa ifomula ukuthola i-adicial engqungqutheli, kepha kulokhu, uma kunesidingo, kubalwa, kubalwa umphumela ojwayelekile isikhathi ngasinye, kuzofanela sishintshe le formula ngaso sonke isikhathi. Kepha uma usebenzisa umsebenzi, i-Dwarf ingashintshwa ibanga elihlangene, vele ucacise inyanga ehambisanayo kumaseli ngamanye. Ake sizame ukusebenzisa le nketho ekusebenzeni kuqala ukubala inani lesikhathi kusuka ngoMashi kuya kuMay. Lokhu kuzosebenzisa ifomula ngenhlanganisela yabasebenzi bezwe kanye ne-dash.

1. Okokuqala, ezintweni ngazinye eshidini legama lezinyanga zokuqala nokuphela kwesikhathi, lapho ukubalwa khona kuzobalwa, ngokulandelana, "Mashi" no- "Meyi" kanye "noMeyi" kanye "noMeyi".



2. Manje sinikeza igama kuwo wonke amaseli kukholamu "engenayo", okuzofana negama lenyanga ehambisanayo. Okungukuthi, into yokuqala kwikholamu "engenayo", equkethe usayizi wemali engenayo, kufanele ibizwe ngokuthi "Januwari", owesibili - "NgoFebhuwari", njll.

   Ngakho-ke, ukunikeza igama kwinto yokuqala yekholomu, likhethe bese ucindezela inkinobho yegundane elifanele. Imenyu yomongo iyavula. Khetha into ethi "Nikeza Igama ...".



3. Iwindi lokudala igama liyasungulwa. Ensimini "yegama" ilingana negama elithi "Januwari". Azisekho izinguquko ewindini ezingadingi ukuthi zenziwe, yize uma kwenzeka ungabheka ukuthi izixhumanisi zensimu "ebanga" zihambelana nekheli leseli eliqukethe usayizi wemali equkethe imali enambili ngoJanuwari. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



4. Njengoba ukwazi ukubona, manje, lapho unikeza le nto ewindini legama, alikhonjiswa ikheli layo, bese igama esimnikeze lona. Ukusebenza okufanayo kwenziwa nazo zonke ezinye izinto zekholomu "yengeniso", zibapha ngokungafani "ngoFebhuwari", "Mashi", "Ephreli", njll. kuze kube nguDisemba okubandakanya.



5. Khetha iseli lapho isamba samanani esikhathi esibekiwe sizokhonjiswa futhi sinikezele. Bese uchofoza isithonjana esithi "Insert Function". Kubekwa ngakwesobunxele komugqa wamafomula nakwesokudla kwensimu lapho kuboniswa khona igama lamaseli.



6. Ewindini elicishiwe, amakhosi emisebenzi athuthela esigabeni esithi "Mathematical". Lapho ukhetha igama elithi "amanani". Chofoza inkinobho ethi "KULUNGILE".



7. Ngemuva kokubulawa kwalesi senzo, kusungulwa iwindi le-Operactor Arger, umsebenzi walo yi-quing of the amanani acacisiwe. I-syntax yalo msebenzi ilula kakhulu:

   = Amanani (inombolo1; inombolo2; ...)

   Ngokuvamile, inani lezimpikiswano lingafinyelela amanani angu-255. Kepha zonke lezi zingxabano zingenazinkulungwane. Ziyinombolo noma izixhumanisi zeseli lapho le nombolo itholakala khona. Bangenza futhi ngendlela yefomula eyakhelwe ngaphakathi ebalwa inombolo oyifunayo noma ikhombisa ikheli lento yeqabunga lapho ibekwe khona. Kukule khwalithi umsebenzi owakhelwe ngaphakathi futhi opharetha wethu uzosetshenziswa kuleli cala.

   Faka isikhombisi endle "Inombolo1". Bese uchofoza isithonjana ngesimo sonxantathu ongenele ngakwesokudla kobubanzi bamabanga. Uhlu lwemisebenzi yakamuva esetshenzisiwe luyadalulwa. Uma kukhona igama elithi "DVSSL" phakathi kwabo, bese uchofoza ngokushesha kulo ukuze uye ewindini lokuphikisana ngalo msebenzi. Kepha kungenzeka ukuthi kulolu hlu ngeke uluthole. Kulokhu, udinga uchofoze igama elithi "Eminye imisebenzi ..." ezansi kohlu.



8. Yethulwe vele ujwayele imisebenzi yewindows Wizard ye-US. Sithuthela esigabeni "izixhumanisi kanye nama-arrays" bese ukhetha igama le-opharetha DVSSLL. Ngemuva kwalokho, uchofoza inkinobho ethi "Kulungile" ezansi kwewindi.



9. Iwindi lezimpikiswano zomsebenzisi we-opharetha lethulwa. Esixhumanisi esithi "Xhumanisa kwinkambu yeseli", chaza ikheli lento yeqabunga, eliqukethe igama lenyanga yokuqala yebanga elihloselwe ukubala inani. Uyacelwa uqaphele ukuthi kuleli cala awudingi ukuthatha isixhumanisi ngezingcaphuno, ngoba kulokhu ngeke kube khona izixhumanisi zeseli, kodwa okuqukethwe okuvele zinefomethi yombhalo (igama elithi Mashi "). Inkambu ye- "A1" ishiywe ingenalutho, ngoba sisebenzisa uhlobo lokuqokwa okujwayelekile.

   Ngemuva kokuthi ikheli liboniswe ensimini, ungagijimeli enkombeni ethi "KULUNGILE", ngoba lokhu kuwumsebenzi ohleliwe, futhi izenzo nazo ziyehluka ku-algorithm ejwayelekile. Chofoza igama elithi "amanani" kulayini wamafomula.



10. Emva kwalokho, sibuyela ezimpikiswaneni zezibalo. Njengoba ubona, inkambu ye- "Number1" isivele yanyamalala opharetha osontekile nokuqukethwe kwawo. Faka isikhombisi emkhakheni ofanayo ngokushesha ngemuva kophawu lokugcina kwirekhodi. Beka uphawu lwekoloni (:). Lolu phawu lusho uphawu lwekheli lobubanzi beseli. Okulandelayo, ngaphandle kokususa isikhombisi kusuka emkhakheni, phinda uchofoze isithonjana njengonxantathu wokukhetha imisebenzi. Ngalesi sikhathi ohlwini lwabasebenzi abasanda kusetshenziswa, igama elithi "DVSSL" kufanele libhekwe njengelinembile, njengoba nje sisebenzisa lesi sici. Chofoza ngegama.



11. Izimpikiswano zezimpikiswano zomsebenzisi ze-opharetha ziphinde zivule. Sifaka i- "Xhumanisa kwinkambu yeseli" Inkambu ye-Element ephepheni lapho igama lenyanga likhona, oluqeda isikhathi esilinganiselwe. Futhi izixhumanisi kufanele zibhalwe ngaphandle kwezingcaphuno. Insimu "A1" Shiya futhi. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".



12. Njengoba ukwazi ukubona, ngemuva kwalezi zenzo, uhlelo lwenza ukubalwa futhi lunikeze umphumela wokufakwa kwemali engenayo yebhizinisi isikhathi esibekiwe (Mashi - Meyi) endaweni enikeziwe yephepha lapho ifomula ngokwalo itholakala khona .



13. Uma sishintsha amaseli, lapho amagama okuqala nokuphela kwesikhathi esilinganiselwayo kubhalwe, kwabanye, ngokwesibonelo, ngoJuni nangoNovemba, futhi umphumela uzoshintsha ngokufanele. Inani lemali engenayo lesikhathi esibekiwe lizogoqwa.

Isifundo: Indlela yokubala inani le-Excel

Njengoba sikwazi ukubona, yize umsebenzi wokusebenza kwe-FVS awunakubizwa ngokuthi omunye wabasebenzisi abathandwa kakhulu, kodwa-ke, kuyasiza ukuxazulula imisebenzi yobunzima obuhlukahlukene ku-Excel kulula kakhulu kunokuba kungenziwa ngamanye amathuluzi. Iningi lawo wonke opharetha liwusizo njengengxenye yamafomula ayinkimbinkimbi lapho kuyingxenye ebalulekile yenkulumo. Kepha noma kunjalo kufanele kuqashelwe ukuthi wonke amathuba edokodo le-opharetha likhulu ngokuqonda. Lokhu kuchaza nje ukuthandwa okuphansi kwalo msebenzi owusizo kubasebenzisi.