Indlela yokukhipha i-Android ngokusebenzisa ukutakula

Lapho wenza ezinye izibalo ezidingekayo ukuze uthole inani lemisebenzi. Lolu hlobo lokubala luvame ukuqhutshwa ngabaxhasi, onjiniyela, abahleli, abafundi bezikhungo zemfundo. Isibonelo, le ndlela yokubala iyadingeka ngolwazi ngenani eliphelele leholo lokusebenza izinsuku. Yenza lesi senzo kungadingeka kwezinye izimboni, ngisho nezidingo zasekhaya. Ake sithole ukuthi ku-Excel ungabala kanjani lemisebenzi.

Ukubala inani lomsebenzi

Kusuka egameni lezenzo kucacile ukuthi inani lemisebenzi ukushiswa kwemiphumela yokuphindaphinda izinombolo zomuntu ngamunye. Ku-Excel, lesi senzo singenziwa ngokusebenzisa ifomula elula yezibalo noma ngokusebenzisa umsebenzi okhethekile. SUMPRODUCT. Ake sibheke lezi zindlela ngokuningiliziwe ngokwehlukana.

Indlela 1: Sebenzisa ifomati yamathematika

Abasebenzisi abaningi bayazi ukuthi ku-Excel ungenza inani elikhulu lemisebenzi yezibalo nje ngokubeka uphawu "=" esitokisini esingenalutho, bese ubhala inkulumo ngokwemithetho yezibalo. Le ndlela ingasetshenziswa ukuthola inani lemisebenzi. Lolu hlelo, ngokusho kwemithetho yemathempeli, libala ngokushesha imisebenzi, futhi kuphela luyenezela inani eliphelele.

1. Setha uphawu olulinganayo (=) esitokisini lapho imiphumela yokubala izoboniswa khona. Sibhala lapho ukuveza inani lemisebenzi ngokulandela isifanekiso esilandelayo:

   = a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...

   Isibonelo, ngale ndlela ungabala inkulumo:

   =54*45+15*265+47*12+69*78



2. Ukubala nokubonisa umphumela walo esibukweni, chofoza inkinobho yokungena kukhibhodi.

Indlela 2: sebenzisa ngezixhumanisi

Esikhundleni sezinombolo ezithile kule fomula, ungacacisa izixhumanisi zama-cell lapho zitholakala khona. Izixhumanisi zingangenwa ngesandla, kodwa kulula kakhulu ukwenza lokhu ngokugqamisa ngemuva kwesibonakaliso "=", "+" noma "*" iseli elihambelanayo eliqukethe inombolo.

1. Ngakho-ke, masinyane bhala le nkulumo, lapho kunokuba izinombolo zibhekisele kumaseli.



2. Khona-ke, ukuze wenze isibalo, chofoza inkinobho Ngena. Umphumela wokubala uzoboniswa esikrinini.

Yiqiniso, lolu hlobo lokubala lulula futhi luyinkimbinkimbi, kodwa uma itafula linamanani amaningi adinga ukwandiswa bese wanezelwa, le ndlela ingathatha isikhathi eside kakhulu.

Isifundo: Sebenzisa ngamafomula ku-Excel

Indlela 3: Ukusebenzisa umsebenzi we-SUMPRODUCT

Ukuze ubale inani lomsebenzi, abanye abasebenzisi bakhetha umsebenzi oklanyelwe lolu hlelo - SUMPRODUCT.

Igama lalo opharetha likhuluma ngenhloso yalo ngokwayo. Inzuzo yale ndlela ngaphezu kwalowo owedlule ukuthi ingasetshenziswa ukucubungula yonke imidwebo ngesikhathi esisodwa, hhayi ukwenza izenzo ngenombolo ngayinye noma ngeseli ngokwahlukana.

I-syntax yalo msebenzi ilandelayo:

= I-SUMPRODUCT (i-array1; i-array2; ...)

Iziphakamiso zalolu opharetha yizintambo zemininingwane. Ngesikhathi esifanayo bahlelwe ngamaqembu ezici. Okungukuthi, uma siqala kusukela kwiphrofayli esayikhulume ngenhla (a1 * b1 * ... + a2 * b2 * ... + a3 * b3 * ... + ...), khona-ke ekuhambeni kokuqala yizici zeqembu aeqenjini lesibili beqenjini lesithathu c nokunye Lezi zigaba kumele zibe nezinhlobo ezifanayo futhi zilingane ngobude. Zingafakwa kokubili ngokuzenzekelayo nangokwemvelo. Okuphelele, lo opharetha angasebenza nenombolo yezimpikiswano kusuka ku-2 kuya ku-255.

Ifomu SUMPRODUCT Ungakwazi ukubhala ngokushesha esitokisini ukubonisa umphumela, kodwa abasebenzisi abaningi bakuthola kulula futhi okulula kakhulu ukwenza izibalo nge-Function Wizard.

1. Khetha iseli kushidi lapho umphumela wokugcina uzoboniswa khona. Sicindezela inkinobho "Faka umsebenzi". Ihlanganiswa njengesithonjana futhi itholakala ngakwesokunxele kwenkambu yebha yamasombululi.



2. Ngemuva kokuthi umsebenzisi enze lezi zenzo, vula Umsebenzi weWebhu. Ivula uhlu lwawo wonke opharetha, ngezinye izinto ezimbalwa, ongasebenza nabo ku-Excel. Ukuthola umsebenzi esiwudinga, hamba kusigaba "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi". Ngemva kokuthola igama "SUMMPROIZV"ukhethe bese uchofoza inkinobho "Kulungile".



3. Iwindi lempikiswano yokusebenza iqala. SUMPRODUCT. Ngenombolo yezimpikiswano, ingaba nezinkambu ezimbili kuya kwezingu-255. Amakheli ebhanti angaqhutshwa ngesandla. Kodwa kuzothatha isikhathi esithile esibalulekile. Ungenza okuthile okuhlukile. Faka isikhangiso ensimini yokuqala bese ukhetha uhlu lwempikiswano yokuqala eshadini ngenkathi ubambe inkinobho yegundane lesokunxele. Senza okufanayo ngeyesibili nakuzo zonke izigaba ezilandelayo, izixhumanisi zazo eziboniswa ngokushesha ensimini ehambelanayo. Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile" phansi kwefasitela.



4. Emva kwalezi zenzo, lolu hlelo luzimela ngokuzimela zonke izibalo ezidingekayo futhi lubonise umphumela wokugcina esitokisini okhethiwe esigabeni sokuqala sale mfundiso.

Isifundo: I-Excel Function Wizard

Indlela 4: sebenzisa umsebenzi ngesimo

Umsebenzi SUMPRODUCT kuhle futhi ukuthi ingasetshenziswa ngesimo. Ake sihlole ukuthi lokhu kwenziwa kanjani ngesibonelo sokhonkolo.

Sinetafula lemiholo nezinsuku ezenziwa abasebenzi bebhizinisi izinyanga ezintathu ngenyanga. Sidinga ukuthola ukuthi umsebenzi kaParfenov DF uzuze kangakanani ngalesi sikhathi.

1. Ngendlela efanayo nangesikhathi esidlule, sibiza ifasitela lempikiswano yokusebenza SUMPRODUCT. Emasimini amabili okuqala, sibonisa njengama-arrays, ngokulandelana, imigqa lapho isilinganiso sabasebenzi nenani lezinsuku abasebenza ngazo kuboniswa. Okusho ukuthi, senza konke njengokwesimo sangaphambilini. Kodwa emkhakheni wesithathu sabeka izixhumanisi ze-array, equkethe amagama abasebenzi. Ngokushesha ngemva kwekheli esilungeza ukungena:

   = "Parfenov D.F."

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



2. Isicelo senza isibalo. Imigqa kuphela negama iyabalwa "Parfenov D.F.", yilokho esikudingayo. Umphumela wokubala uboniswa kuseli elanduliwe. Kodwa umphumela u-zero. Lokhu kungenxa yokuthi ifomula ngendlela ekhona manje ayisebenzi kahle. Sidinga ukuguqula kancane.



3. Ukuze uguqule ifomula, khetha iseli ngenani eliphelele. Yenza izenzo kubha yefomula. Ukungqubuzana nesimo kuthathwa kubakaki, futhi phakathi kwalo nezinye izimpikiswano sishintsha i-semicolon ngesibonakaliso sokuphindaphinda (*). Sicindezela inkinobho Ngena. Uhlelo lwenza ukubala futhi manje lunikeza inani elifanele. Sithole inani lemali lezinyanga ezintathu, okudalwa yiParfenov D.F.

Ngendlela efanayo, izimo zingasetshenziswa hhayi kuphela kumbhalo, kodwa futhi nezinombolo ezinamakhasi, wanezela izimpawu zomzimba "<", ">", "=", "".

Njengoba ungabona, kunezindlela ezimbili eziyinhloko zokubala inani lemisebenzi. Uma kungekho idatha eningi kakhulu, ke kulula ukusebenzisa ifomula elula yezibalo. Uma inani lenani elikhulu lihilelekile ekubalweni, umsebenzisi uzolondoloza inani elibalulekile lesikhathi namandla akhe uma esebenzisa amathuba okusebenza okukhethekile. SUMPRODUCT. Ngaphezu kwalokho, usebenzisa opharetha ofanayo, kungenzeka ukuba wenze isibalo esimweni sokuthi ifomula evamile ayikwazi ukuyenza.