Ntchito kusankha pa Excel

Mukamagwira ntchito ku Excel, ogwiritsa ntchito nthawi zina amakumana ndi ntchito yosankha pamndandanda wazomwe ndi kutengera index yake kuti apatse mtengo wake. Ndi ntchitoyi, ntchitoyo ikulimbana bwino ndi "kusankha". Tiyeni tiphunzire mwatsatanetsatane momwe tingagwiritsire ntchito ndi wothandizirayo, komanso pamavuto aliwonse omwe angalimbane.

Kugwiritsa ntchito wogwiritsa ntchito

Ntchito chisankho chimatanthawuza gulu la ogwiritsa ntchito "maulalo ndi arrays". Cholinga chake ndikuchotsa mtengo winawake ku selo lotchulidwa, lomwe limafanana ndi nambala ya index mu pepala lina pa pepalalo. Syntax ya wothandizira uyu ali motere:

= Kusankha (nambala_intex; Mtengo 1; Mtengo2; ...)

Mylox Nambala ya nambala ili ndi ulalo wa khungu pomwe kuchuluka kwa chinthucho, omwe gulu lotsatira la ziganizo limaperekedwa mtengo winawake. Nambala yotsatizanayi imatha kukhala yosiyanasiyana 1 mpaka 254. Ngati mungafotokozere cholembera chachikulu kuposa chiwerengerochi, wothandizirayo aziwonetsa cholakwika mu khungu. Ngati mungalowe mu mtengo wambiri monga mkanganowu, ntchitoyo idzawazindikira, monga mtengo wapafupi ndi nambala iyi. Ngati mukhazikitsa "index nambala" yomwe palibe "mtengo" wolingana, wothandizirayo adzabweza cholakwika mu khungu.

Gulu lotsatira la "mtengo" wotsutsa. Itha kufikira zinthu 254. Pankhaniyi, mkangano "wonena za" kutanthauza "" ndi woyenera. Gululi la mikangano limawonetsa malingaliro omwe mutu wakale wokangana adzavomerezedwa. Ndiye kuti, ngati nambalayo "3" ndi "3" monga mkangano, ilinganizo ndi mtengo womwe umapangidwa ngati "mtengo wa mtengo wa" Mtengo3 ".

Zambiri za data zimatha kugwiritsidwa ntchito ngati mfundo:

• Malembedwe;
• Manambala;
• Lemba;
• Njira;
• Ntchito, etc.

Tsopano tiyeni tikambirane zitsanzo za zitsanzo za kugwiritsa ntchito kwa wothandizirayo.

Chitsanzo 1: Zinthu Zotsatira Zida

Tiyeni tiwone momwe mbali iyi ikuyenera chitsanzo chosavuta kwambiri. Tili ndi tebulo lokhala ndi nambala 1 mpaka 12. ndikofunikira malinga ndi manambala otsatila awa pogwiritsa ntchito njira yosankha kuti mufotokozere dzina la mwezi wachiwiri pagome la tebulo lachiwiri.

1. Tikuwonetsa khungu lopanda kanthu la cholembera "dzina la mwezi". Dinani pa "ikani ntchito" pafupi ndi chingwe.



2. Kuyendetsa wizard yantchito. Pitani ku gulu la "Maulalo" ndi Arrays ". Sankhani kuchokera pamndandanda "sankhani" ndikudina batani la "OK".



3. Windo la Ogwiritsa ntchito la ulerment likuyenda. Mu gawo la mndandanda wa index, muyenera kutchula adilesi ya nambala yoyamba ya chiwerengero chowerengera. Njirayi imatha kuchitidwa mwa kuyendetsedwa mwadongosolo. Koma tichita mosavuta. Ikani chotembere m'munda ndikudina batani lakumanzere pa cell yolingana. Monga mukuwonera, magwiridwe ake amawonetsedwa mu gawo la zenera.

   Pambuyo pake, tiyenera kuyendetsa mwadala dzina la miyezi m'gulu la minda. Komanso, munda uliwonse uyenera kufanana ndi mwezi wosiyana, ndiye kuti, m'mutu wa "Trix1" walembedwa m'munda "D. -" February ", ndi zina.

   Pambuyo popereka ntchito yomwe yatchulidwayi, dinani batani la "OK" pansi pazenera.



4. Monga mukuwonera, nthawi yomweyo mu khungu lomwe tidazindikira poyambirira, zotsatira zake zidawonetsedwa, dzina "Januware", lolingana ndi chiwerengero choyamba cha mwezi chaka chatha.



5. Tsopano, pofuna kuti asalowe mu fomula ya maselo ena onse a "dzina la mwezi" mzere, tiyenera kuchita kuti tiwakotse. Kuti tichite izi, timakhazikitsa cholozera kwa kona yapansi pa cell yomwe ili ndi formula. Chizindikiro chodzaza chikuwonekera. Dinani batani lakumanzere ndikukoka chizindikiro chakumapeto kwa mzere.



6. Monga mukuwonera, formula idakopera pamlingo womwe timafunikira. Pankhaniyi, mayina onse a miyezi yomwe anawonetsedwa m'maselo amafanana ndi nambala yawo yotsatira kuchokera kumanzere.

Phunziro: Master of Nurctions

Chitsanzo 2: Zipangizo Zoyeserera

M'mbuyomu, tinkagwiritsa ntchito njirayo kusankha nthawi zonse za manambala omwe alozerako zidakonzedwa kuti. Koma kodi wothandizira uyu amagwira ntchito bwanji ngati mfundo zomwe zafotokozedwazo zimasakanikirana? Tiyeni tiwone izi pa chitsanzo cha tebulo ndi magwiridwe antchito asukulu. Mu mzere woyamba wa tebulo, dzina la wophunzirayo akuwonetsedwa, muyeso wachiwiri (kuyambira 1 mpaka 5 mfundo), ndipo mu chachitatu tidzasankha kusankha kuti tisanthule (")" "Oipa", "okhutiritsa", "zabwino", "wangwiro").

1. Tigawane m'chipinda choyambirira mu "gawo" ndikuyenda mothandizidwa ndi njira yomwe zokambirana zakhala zikutsutsidwa kale, kusankha zenera losankhidwa la zokangana.

   Mu "gawo la nambala ya" Lowani, tchulani ulalo wa foni yoyamba ya "mzere" wounikira, womwe umakhala ndi gawo.

   Gulu la minda "kutanthauza" lembani motere:

   • "Mtengo1" - "zoyipa kwambiri";
   • "Khoti2" - "zoyipa";
   • "Cholinga" "-" Kukhutiritsa ";
   • "Mtengo4" - "zabwino";
   • "Mtengo5" - "wabwino kwambiri."

   Pambuyo poyambitsa deta yomwe ili pamwambapa imapangidwa, dinani batani la "Ok".



2. Mtengo wa Score wa gawo loyamba lawonetsedwa mu khungu.



3. Pofuna kupanga njira yofananira kwa zinthu zotsalazo, koperani zomwe zili m'maselo ake pogwiritsa ntchito cholembera, monga momwe timakhalira, ndipo nthawi ino ntchitoyo idagwira ntchito mogwirizana ndi algorithm yomwe yatchulidwa.

Chitsanzo 3: Gwiritsani ntchito kuphatikiza ndi ena ogwiritsa ntchito

Koma zambiri zopindulitsa zomwe wopanga sakanasintha akhoza kugwiritsidwa ntchito limodzi ndi ntchito zina. Tiyeni tiwone momwe izi zimachitikira pachitsanzo cha kugwiritsa ntchito kwa ogwiritsa ntchito ndi ndalama.

Pali tebulo logulitsa malonda. Lagawidwa m'magawo anayi, iliyonse yomwe imafanana ndi njira inayake. Revenue imawonetsedwa mosiyana ndi mzere wapadera. Ntchito yathu ndikupangitsa kuti mulowetse chiwerengero cha malo ogulitsira mu selo la pepalalo, kuchuluka kwa ndalama za masiku onse a malo ogulitsira adawonetsedwa. Pa izi tidzagwiritsa ntchito kuphatikiza kwa ogwiritsa ntchito boma ndikusankha.

1. Sankhani foni yomwe zotsatirazi zikhala zotulutsa. Pambuyo pake, dinani pa zomwe mukuzidziwa kale "ikani ntchito".



2. ZABWINO ZOPHUNZITSIRA BWINO. Pakadali pano timasamukira ku gulu la "masamu". Timapeza ndikugawa dzina "Sum". Pambuyo pake, dinani batani la "OK".



3. Zenera la malingaliro a ntchito amayambitsidwa. Wogwiritsa ntchitoyu amagwiritsidwa ntchito kuwerengera kuchuluka kwa manambala m'maselo. Syntax yake ndi yosavuta komanso yomveka:

   = Sum (nambala1; nambala2; ...)

   Ndiye kuti, zotsutsana za wothandizirayo nthawi zambiri zimakhala manambala kapena ambiri, nthawi zambiri, zomwe zimafotokoza maselo omwe ali ndi manambala omwe amafunikira kufupikitsidwa. Koma kwa ife, mu mawonekedwe a mkangano umodzi, osati nambala osati ulalo, koma zomwe zimagwira ntchito.

   Ikani cholozera mu "nambala ya" nambala1 ". Kenako dinani chithunzicho, chomwe chikuwonetsedwa ngati makona atatu. Chizindikiro ichi chili mu mzere womwewo womwewo uja pomwe "ikani ntchito" ndi chingwe cha fomulatifi chimapezeka, koma kumanzere kwawo. Mndandanda wazinthu zomwe zalembedwa kumene zimapezeka. Popeza kusankha njirayi sikunagwiritsidwe ntchito posachedwa, kumapezeka pamndandandawu. Chifukwa chake, ndikokwanira dinani chinthu ichi kuti mupite pawindo. Koma ndizotheka kuti simudzakhala mndandanda wa dzinali. Pankhaniyi, muyenera dinani pa "ntchito zina ..." udindo.



4. Mfiti ya ntchito imayambitsidwa, yomwe mu "maulalo ndi arrays" tiyenera kupeza dzinalo "ndikusankha. Dinani pa batani la "OK".



5. Windo lotsutsa lapa utoto limayambitsidwa. Mu "gawo la nambala ya" Lowani, tchulani ulalo wa foni ya pepalalo, pomwe timalemba chiwerengero cha njira yosinthira njira yonse ya ndalama.

   Mu "Trite1" Munda, muyenera kulowa ogwirizira a "1 shopu". Pangani zosavuta. Ikani cholozera m'munda wotchulidwa. Kenako, atanyamula batani lakumanzere, timagawa maselo onse a mzati "1 malo ogulitsira". Adilesiyo idzaonekera nthawi yomweyo pawindo.

   Momwemonso, m'munda wa "Ubwino2", onjezani zogwirizana za "malo ogulitsira awiri", m'mutu wa "Mtengo 3", ndipo mu "mtengo" ".

   Pambuyo pochita izi, kanikizani batani la "OK".



6. Koma, monga tikuwona, mawonekedwewo amawonetsa tanthauzo lolakwika. Izi zikuchitika chifukwa chakuti sitinalowetsebe kuchuluka kwa malo ogulitsira mu khungu loyenerera.



7. Timalowetsa kuchuluka kwa malo ogulitsira m'zipinda zomwe akufuna kuti akwaniritse izi. Kuchuluka kwa ndalama zokhala ndi mzati woyenera nthawi yomweyo kumawonetsedwa mu gawo lomwe formula adayikidwa.

Ndikofunikira kulingalira kuti mutha kungoyambitsa manambala kuchokera pa 1 mpaka 4, omwe adzafanane ndi kuchuluka kwa malo ogulitsira. Ngati mungalowe nambala ina iliyonse, ndiye kuti njirayi ibwezeranso cholakwika.

Phunziro: Momwe mungawerengere ndalamazo

Monga mukuwonera, ntchito zosankha ndi ntchito yoyenera zimatha kukhala mthandizi wabwino kwambiri kuti achite ntchitoyo. Mukamagwiritsa ntchito limodzi ndi ogwiritsa ntchito ena, kuthekera kowonjezereka.