Umsebenzi ophelele ku-Excel. Ifomula, izidingo zethebula

Imiphumela emaphakathi edinga ukutholwa lapho kuhlanganiswa imibiko ingabalwa kalula ku-Excel. Kukhona inketho efanelekile yalokhu, esizoyicabangela ngokuningiliziwe kulesi sihloko.

Izimfuneko ezisebenza kumathebula ukuze uthole imiphumela emaphakathi

Umsebenzi ophelele ku I-Excel ifaneleka kuphela ezinhlotsheni ezithile zamathebula. Kamuva kulesi sigaba, uzofunda ukuthi yimiphi imibandela okufanele ihlangatshezwe ukuze usebenzise le nketho.

1. Ipuleti akufanele libe namaseli angenalutho, ngalinye lawo kufanele libe nolwazi oluthile.
2. Unhlokweni kufanele ube umugqa owodwa. Ngaphezu kwalokho, indawo yayo kufanele ilungile: ngaphandle kokugxuma namaseli agqagqene.
3. Ukuklanywa kwekhanda kufanele kwenziwe ngokuqinile emgqeni ophezulu, ngaphandle kwalokho umsebenzi ngeke usebenze.
4. Ithebula ngokwalo kufanele limelwe inombolo evamile yamaseli, ngaphandle kwamagatsha engeziwe. Kuvela ukuthi ukuklama kwetafula kumele kuhlanganiswe ngokuqinile nonxande.

Uma uchezukisa okungenani emfuneko eyodwa eshiwo lapho uzama ukusebenzisa umsebenzi othi “Imiphumela Emaphakathi”, amaphutha azovela kuseli elikhethelwe izibalo.

Isetshenziswa kanjani isamba esingaphansi

Ukuze uthole amanani adingekayo, udinga ukusebenzisa umsebenzi ohambisanayo, otholakala phezulu kweshidi le-Microsoft Excel kuphaneli eliphezulu.

1. Sivula ithebula elihlangabezana nezidingo ezishiwo ngenhla. Okulandelayo, chofoza iseli yetafula, lapho sizothola khona umphumela ophakathi. Bese uye kuthebhu ethi “Idatha”, engxenyeni ethi “Isakhiwo”, chofoza okuthi “Ingqikithi encane”.

2. Ewindini elivulayo, sidinga ukukhetha ipharamitha eyodwa, ezonikeza umphumela ophakathi. Ukuze wenze lokhu, kunkambu ethi “Enguqukweni ngayinye”, kufanele ucacise intengo ngeyunithi ngayinye yezimpahla. Ngokuvumelana nalokho, inani libekwa phansi “Intengo”. Bese ucindezela inkinobho ethi "OK". Sicela uqaphele ukuthi kunkambu "Yokusebenza", kufanele usethe "Inani" ukuze ubale kahle amanani aphakathi.

3. Ngemva kokuchofoza inkinobho ethi "KULUNGILE" kuthebula yenani ngalinye, inani elincane lizoboniswa, eliboniswe kusithombe-skrini esingezansi.

Encwadini! Uma usuwatholile amanani adingekayo ngaphezu kokukodwa, kufanele uqoke ibhokisi elithi “Faka esikhundleni samanani amanje”. Kulokhu, idatha ngeke iphindwe.

Uma uzama ukugoqa yonke imigqa ngethuluzi elibekwe kwesokunxele sepuleti, uzobona ukuthi yonke imiphumela emaphakathi isele. Yibo owathola usebenzisa imiyalelo engenhla.

Isamba esincane njengefomula

Ukuze ungabheki ithuluzi lokusebenza elidingekayo kumathebhu wephaneli yokulawula, kufanele usebenzise inketho ethi "Faka umsebenzi". Ake sicabangele le ndlela ngokuningiliziwe.

1. Ivula ithebula lapho udinga ukuthola khona amanani amaphakathi. Khetha iseli lapho amanani amaphakathi azoboniswa khona.

2. Bese uchofoza inkinobho ethi "Faka Umsebenzi". Ewindini elivulayo, khetha ithuluzi elidingekayo. Ukuze wenze lokhu, kunkambu ethi "Isigaba", sifuna ingxenye ethi "Uhlu olugcwele lwama-alfabhethi". Bese, efasiteleni elithi "Khetha umsebenzi", chofoza okuthi "SUB.TOTALS", chofoza inkinobho "KULUNGILE".

3. Ewindini elilandelayo "Izimpikiswano zomsebenzi" khetha "Inombolo yomsebenzi". Sibhala phansi inombolo engu-9, ehambisana nenketho yokucubungula ulwazi esiyidingayo - ukubalwa kwenani.

4. In the next data field "Reference", khetha inombolo yamaseli ofuna ukuthola kuwo amanani angaphansi. Ukuze ungafaki idatha mathupha, ungavele ukhethe uhla lwamaseli adingekayo ngekhesa, bese uchofoza inkinobho ethi KULUNGILE efasiteleni.

Ngenxa yalokho, kuseli elikhethiwe, sithola umphumela ophakathi nendawo, olingana nesamba samaseli esiwakhethile ngedatha yezinombolo ebhaliwe.. Ungasebenzisa umsebenzi ngaphandle kokusebenzisa i-"Function Wizard", kulokhu kufanele ufake ifomula ngesandla: =SUBTOTALS(inombolo yokucubungula idatha, izixhumanisi zamaseli).

Nakani! Uma uzama ukuthola amanani aphakathi nendawo, umsebenzisi ngamunye kufanele akhethe inketho yakhe, ezoboniswa njengomphumela. Ngeke kube isamba kuphela, kodwa futhi isilinganiso, ubuncane, amanani aphezulu.

Ukusebenzisa Umsebenzi kanye Nokucubungula Amaseli Mathupha

Le ndlela ihlanganisa ukusebenzisa umsebenzi ngendlela ethe ukuhluka kancane. Ukusetshenziswa kwayo kuvezwe ku-algorithm engezansi:

1. Yethula i-Excel futhi uqiniseke ukuthi ithebula liboniswa ngendlela efanele eshidini. Bese ukhetha iseli ofuna ukuthola kulo ivelu emaphakathi yenani elithile kuthebula. Bese uchofoza inkinobho ngaphansi kwephaneli yokulawula "Faka umsebenzi".

2. Ewindini elivelayo, khetha isigaba "Imisebenzi eyi-10 esanda kusetshenziswa" bese ubheka "Amathothali amaphakathi" phakathi kwawo. Uma ungekho umsebenzi onjalo, ngakho-ke kuyadingeka ukuthi ubeke esinye isigaba - "Uhlu olugcwele lwezinhlamvu".

3. Ngemuva kokuvela kwewindi le-pop-up eyengeziwe lapho udinga ukubhala khona "Izimpikiswano Zomsebenzi", sifaka lapho yonke idatha eyayisetshenziswe endleleni yangaphambilini. Esimeni esinjalo, umphumela wokusebenza kwe-“Subtotals” uzokwenziwa ngendlela efanayo.

Kwezinye izimo, ukufihla yonke idatha, ngaphandle kwamanani aphakathi nendawo ahlobene nohlobo olulodwa lwenani kuseli, kuvunyelwe ukusebenzisa ithuluzi lokufihla idatha. Kodwa-ke, udinga ukuqiniseka ukuthi ikhodi yefomula ibhalwe ngendlela efanele.

Ukufingqa

Izibalo eziphelele zisebenzisa i-Excel spreadsheet algorithms zingenziwa kuphela kusetshenziswa umsebenzi othile, kodwa zingafinyelelwa ngezindlela ezihlukahlukene. Izimo eziyinhloko ukwenza zonke izinyathelo ukuze ugweme amaphutha, futhi uhlole ukuthi ithebula elikhethiwe liyahlangabezana yini nezidingo ezidingekayo.