Uma usebenza nama-spreadsheets e-Excel, kuvame ukudingeka ukusebenza ngezindawo eziphelele zedatha. Ngesikhathi esifanayo, ezinye imisebenzi zisho ukuthi lonke iqembu lamaseli kumele liguqulwe ngokoqobo ngokuchofoza okukodwa. Ku-Excel kunamathuluzi avumela ukwenza okunjalo. Ake sithole ukuthi singaphatha kanjani izici zedatha kulolu hlelo.
Hlela ukusebenza
I-array iyinhlangano yedatha etholakala eshidi kumaseli aseduze. Ngokubanzi, noma yiliphi itafula lingabhekwa njengelungu, kepha hhayi ngalinye liyitafula, ngoba lingaba ibanga nje. Empeleni, lezo zindawo zingaba eyodwa-dimensional noma ezimbili-dimensional (matrix). Esikhathini sokuqala, yonke idatha itholakala kukholomu eyodwa kuphela noma umugqa.
Kwesibili - ngamaningana ngesikhathi esifanayo.
Ngaphezu kwalokho, izinhlobo ezingezansi nezamehlo zihlukaniswe kusuka kumakhomitha owodwa, kuncike ukuthi zingumugqa noma ikholomu.
Kumele kuqashelwe ukuthi i-algorithm yokusebenza ngezigaba ezinjalo ihluke kakhulu ekusebenzeni okujwayelekile nakwamaseli angashadile, nakuba kunezinto eziningi ezifanayo phakathi kwazo. Ake sibuke ama-nuances wemisebenzi enjalo.
Ukudala i-Formula
Ifomula yamagama iyinkulumo esetshenziselwa ukucubungula ibanga ukuze uthole umphumela wokugcina uboniswe kusigaba esisodwa noma kuseli elilodwa. Isibonelo, ukuze ukwandise ububanzi obunye nomunye, ifomula isetshenziswe ngokulandela iphethini elilandelayo:
= i-array_address1 * i-array_address2
Ungaphinda wenze okungeziwe, ukususa, ukuhlukaniswa, nokunye ukusebenza kwe-arithmetic kumadatha wedatha.
Izixhumanisi zezinhlobo zisesimo samakheli eseli lokuqala nokugcina, ehlukaniswe ikholoni. Uma ububanzi buyi-two-dimensional, khona-ke amaseli wokuqala nowagcina atholakala ngokulandelana kusuka komunye nomunye. Isibonelo, ikheli lesigaba esisodwa esisodwa singaba: I-A2: A7.
Isibonelo sekheli lesikhangiso sezinhlangothi ezimbili kanje: I-A2: D7.
- Ukubala ifomula efanayo, udinga ukukhetha eshadini indawo lapho umphumela uzoboniswa khona, bese ufaka inkulumo ekubaleni kubha yamatomu.
- Emva kokungena akufanele uchofoze inkinobho Ngenanjengokujwayelekile, bese uthayipha inhlanganisela yokhiye Ctrl + Shift + Faka. Ngemuva kwalokho, inkulumo ebhawulini yefomula izothathwa ngokuzenzakalelayo kubakaki abahamba ngekhanda, futhi amaseli eshidi azogcwaliswa ngemininingwane etholakala ngenxa yokubala, ngaphakathi kobubanzi obukhethiwe.
Lungisa okuqukethwe okuhlanganisiwe
Uma uqhubeka uzama ukususa okuqukethwe noma ukushintsha noma yiliphi lamaseli, elisebubanzi lapho umphumela uboniswa, khona-ke isenzo sakho sizophela ekuhlulekeni. Akusebenzi futhi uma uzama ukuhlela idatha kulayini lomsebenzi. Kulokhu, umlayezo olwaziswa uzovela lapho kuzoshiwo ukuthi akunakwenzeka ukushintsha ingxenye yohlu. Lo mlayezo uzovela ngisho noma ungenalo umgomo wokwenza noma yikuphi ushintsho, futhi uchofoze kabili iseli elibanzi ngengozi.
Uma uvala lo mlayezo ngokuchofoza inkinobho "Kulungile", bese uzama ukuhambisa isikhombisi ngegundane, noma mane ucindezele inkinobho "Faka", umyalezo wolwazi uzovela futhi. Akunakwenzeka ukuvala iwindi lohlelo noma ukugcina idokhumenti. Lo mlayezo ocasulayo uzovela ngaso sonke isikhathi, uvimbele noma yikuphi izenzo. Futhi indlela yokuphuma futhi ilula kakhulu.
- Vala iwindi lwazi ngokuchofoza inkinobho. "Kulungile".
- Bese uchofoza inkinobho "Khansela", elitholakala eqenjini lezithonjana ngakwesobunxele bhotela yefomula, futhi liyisithonjana ngendlela yesiphambano. Ungachofoza futhi inkinobho. Esc kwikhibhodi. Ngemuva kwanoma yikuphi kwalokhu kusebenza, lesi senzo sizokhanselwa, futhi uzokwazi ukusebenza ngeshidi njengangaphambili.
Kodwa kuthiwani uma udinga ukususa noma ukushintsha ifomula? Kulesi simo, landela izinyathelo ezingezansi.
- Ukuze ushintshe ifomula, khetha inkinobho, ubambe inkinobho yegundane lesokunxele, lonke uhla eshadini lapho kuboniswa khona umphumela. Lokhu kubaluleke kakhulu, ngoba uma ukhetha iseli elilodwa kuphela, akukho lutho olwenzekayo. Bese wenze ukulungiswa okudingekayo kubha yefomula.
- Ngemuva kokuthi ushintsho lwenziwa, thayipha inhlanganisela Ctrl + Shift + Esc. Ifomula izoguqulwa.
- Ukuze ususe ifomula ejwayelekile, udinga, ngendlela efana neyesikhathi esedlule, ukhethe lonke uhla lwamaseli atholakala ngalo ngesikhombisi. Bese ucindezela inkinobho Susa kwikhibhodi.
- Emva kwalokho, ifomula izosuswa kuyo yonke indawo. Manje ungangena noma iyiphi idatha kuwo.
Imisebenzi ehleliwe
Indlela elula kunazo zonke yokusebenzisa amafomula ukusebenzisa imisebenzi esebenziwe kakade ye-Excel. Ungakwazi ukufinyelela kuwo Umsebenzi weWebhungokucindezela inkinobho "Faka umsebenzi" ngakwesokunxele kwebha yefomula. Noma kuthebhu "Amafomula" Kule tape, ungakhetha enye yezigaba lapho opharetha onentshisekelo khona khona.
Ngemuva kokungena kumsebenzisi Umsebenzi wizard noma kubha yamathuluzi, ukhetha igama lomqhubi othile, ifasitelana lesivumelwano sokusebenza livula, lapho ungangena khona idatha yokuqala yokubala.
Imithetho yokufaka nokuhlela imisebenzi, uma ibonisa umphumela kumaseli amaningana ngesikhathi esisodwa, ifana nefomula ejwayelekile. Okungukuthi, ngemuva kokufaka inani, kufanele ubeke isikhombisi kubha yefomula bese uthayipha inhlanganisela yokhiye Ctrl + Shift + Faka.
Isifundo: I-Excel Function Wizard
Umsebenzisi we-SUM
Esinye sezici eziceliwe kakhulu ku-Excel SUM. Ingasetshenziswa kokubili ukuhlanganisa okuqukethwe kwamaseli ngabanye, nokuthola isamba semikhakha ephelele. I-syntax yalolu opharetha ngezigaba zilandelayo:
= ISUM (i-array1; i-array2; ...)
Lo opharetha ubonisa umphumela esitokisini esisodwa, ngakho-ke, ukuze wenze isibalo, ngemuva kokufaka idatha yokufaka, mane ucindezela inkinobho "Kulungile" ewindini lempikiswano yokusebenza noma ukhiye Ngenauma okokufaka kwenziwa ngesandla.
Isifundo: Indlela yokubala inani ku-Excel
UMSEBENZI WEZITHUTHI
Umsebenzi IZITHUTHUKO ungumqhubi womsebenzisi ojwayelekile. Ikuvumela ukuba ufake amatafula noma amatrices, okungukuthi, shintsha imigqa namakholomu kwezinye izindawo. Ngesikhathi esifanayo, isebenzisa kuphela ukukhishwa komphumela kubanga lamaseli, ngakho-ke ngemuva kokusungulwa kwalena opharetha, kubalulekile ukusebenzisa inhlanganisela Ctrl + Shift + Faka. Kumele kuqashelwe ukuthi ngaphambi kokusungula inkulumo ngokwayo, kubalulekile ukukhetha indawo eshadini elinenombolo yamaseli kukholomu elingana nenani lamaseli emgqeni wethebula lomthombo (matrix) futhi, ngokuphambene, inani lamaseli emgqeni kufanele lilingane nenombolo yalo kukholomu yomthombo. I-syntax ye-Operator ingendlela elandelayo:
= TRANSPORT (i-array)
Isifundo: Transpose Matrices ku-Excel
Isifundo: Ungafake kanjani itafula ku-Excel
Umsebenzisi we-MOBR
Umsebenzi MOBR ikuvumela ukuthi ubale i-matrix engenayo. Yonke imithetho yokufaka amanani walokhu opharetha afana ncamashi neyaphambilini. Kodwa kubalulekile ukwazi ukuthi ukubalwa komthamo we-inverse kungenzeka kuphela uma kuqukethe inani elilinganayo lemigqa namakholomu, futhi uma i-determinant yayo ingalingani ne-zero. Uma usebenzisa lo msebenzi endaweni enenani elihlukile lemigqa namakholomu, esikhundleni somphumela oqondile, umkhiqizo uzoboniswa "#VALUE!". I-syntax yale fomula ngu:
= MBR (i-array)
Ukuze ubale ukuthi unquma, sebenzisa lo msebenzi nge-syntax elandelayo:
= MEPRED (i-array)
Isifundo: I-Excel Reverse Matrix
Njengoba ungabona, ukusebenza ngezindawo kusiza isikhathi sokulondoloza ekubalweni, kanye nendawo yokukhululeka yeshidi, ngoba asikho isidingo sokwengeza idatha ehlanganisiwe ebangeni ukuze kamuva usebenze nabo. Konke lokhu kwenziwa ngendiza. Futhi ngenxa yokuguqulwa kwamatafula namatrices, imisebenzi kuphela yemishini ehambisana nayo, ngoba amafomula avamile awakwazi ukubhekana nemisebenzi efanayo. Kodwa ngesikhathi esifanayo, kubalulekile ukucabangela ukuthi imithetho eyengeziwe yokufakwayo nokuhlela isetshenziselwa izinkulumo ezinjalo.
