Imodzi mwa ntchito zowonjezera za Excel ndi FLOSS. Ntchito yake ndi kubwerera ku tsamba lamasamba, komwe kuli, zomwe zili mu selo, zomwe zimagwirizanitsidwa ndi malembawo zimatsatiridwa ngati mkangano.
Zikuwoneka kuti palibe chinthu chapadera pa izi, chifukwa n'zotheka kusonyeza zomwe zili mu selo imodzi kwa ena m'njira zosavuta. Koma, monga zikugwiritsidwira ntchito, pogwiritsira ntchito wogwiritsira ntchitoyi kumagwirizanitsidwa ndi maonekedwe amodzi omwe amachititsa kuti ikhale yapadera. Nthawi zina, njirayi ikhoza kuthana ndi mavuto omwe njira zina sitingathe kuzipirira kapena zidzakhala zovuta kwambiri. Tiyeni tiphunzire zambiri za amene operekerayo ali. FLOSS komanso momwe angagwiritsire ntchito pochita.
Kugwiritsa ntchito njira ya dvssyl
Dzina la woyendetsa FLOSS amaimira momwe "Double Link". Kwenikweni, izi zikuwonetsa cholinga chake - kutulutsa deta kupyolera mu chilankhulo chomwe chimatchulidwa kuchokera ku selo imodzi kupita ku ina. Komanso, mosiyana ndi zina zambiri zomwe zimagwirizanitsa ndi maulumikizi, ziyenera kufotokozedwa mu malemba, ndiko kuti, zikufotokozedwa ndi ndemanga kumbali zonse.
Woyendetsa ntchitoyo ali m'gulu la ntchito "Zolumikizana ndi zolemba" ndipo ali ndi mawu ofanana awa:
= FLOSS (kulumikizana ndi selo; [a1])
Choncho, njirayi ili ndi zifukwa ziwiri zokha.
Kutsutsana Chiyanjano cha Cell imayimilidwa ngati kulumikizana ndi mfundo za pepala, deta yomwe mukufuna kuwonetsera. Pankhaniyi, chiyanjano choyenera chiyenera kukhala ndi mawonekedwe a chilembo, ndiko kuti, "atakulungidwa" muzolemba.
Kutsutsana "A1" Sizowonjezereka ndipo nthawi zambiri siziyenera kufotokozedwa. Icho chingakhale ndi matanthauzo awiri. "WOONA" ndi "ZINTHU". Pachiyambi choyamba, wogwiritsira ntchitoyo amamasulira zomwe zikugwirizana ndi kalembedwe "A1", chomwechi chimaphatikizidwa mu Excel mwachisawawa. Ngati ndondomeko yamtengo wapatali siinatchulidwe konse, ndiye kuti idzaonongeka chimodzimodzi "WOONA". Pachifukwa chachiwiri, maulumikizi amafotokozedwa mu kalembedwe "R1C1". Mndandanda wa maulumikiziwa uyenera kukhala ophatikizidwa ku Excel.
Mwachidule, ndiye FLOSS Ndi mtundu wofanana ndi kutchulidwa kwa selo imodzi kwa wina pambuyo pa chizindikiro chofanana. Mwachitsanzo, nthawi zambiri mawuwa
= FLOSS ("A1")
adzakhala ofanana ndi mawu
= A1
Koma mosiyana ndi mawu "= A1" woyendetsa FLOSS samangogwiritsa ntchito selo yeniyeni, koma ku makonzedwe a chinthu chomwe chili pa pepala.
Talingalirani zomwe izi zikutanthauza mu chitsanzo chosavuta. Mu maselo B8 ndi B9 Momwemo amalembedwa "=" malemba ndi ntchito FLOSS. Mafomu onsewa amatanthawuza mfundo. B4 ndikuwonetseratu zomwe zili mu pepala. Mwachibadwa izi zili zofanana.
Onjezerani chinthu china chopanda kanthu ku tebulo. Monga mukuonera, mizere yasuntha. Mu njirayi ndi zofanana mtengowo umakhalabe wofanana, chifukwa umatanthawuza selo lotsiriza, ngakhale zogwirizanitsa zake zasintha, koma deta yomwe imatulutsidwa ndi woyendetsa FLOSS zasintha. Ichi ndi chifukwa chakuti sichikutanthauza kuyika mapepala, koma ku makonzedwe. Pambuyo poonjezera mzere wa mzere B4 ili ndi chinthu china cha pepala. Zomwe zili mkatiyi ndizo ndondomekoyi ndikuwonetsera pa pepala.
Wogwiritsira ntchitoyi amatha kupititsa ku selo lina osati nambala chabe, komanso malemba, zotsatira za kuwerengera mafomu ndi mfundo zina zilizonse zomwe zili muzomwe zasankhidwa pa pepala. Koma pakuchita, ntchitoyi siigwiritsidwa ntchito mobwerezabwereza, koma nthawi zambiri imakhala mbali yovuta kwambiri.
Tiyenera kukumbukira kuti woyendetsa ntchitoyo amagwiritsidwa ntchito pamabuku ena komanso ngakhale m'mabuku ena a Excel, koma pa nkhaniyi ayenera kukhala akuthamanga.
Tsopano tiyeni tiwone zitsanzo zenizeni za kugwiritsiridwa ntchito kwa woyendetsa.
Chitsanzo 1: Kugwiritsa ntchito osakwatira
Poyamba, ganizirani chitsanzo chosavuta chomwe ntchitoyo ikuyendera FLOSS chitani kuti musamvetsetse kufunika kwa ntchito yake.
Tili ndi tebulo losasinthika. Ntchitoyi ndi kusonyeza deta ya selo yoyamba ya chigawo choyamba mu gawo loyambirira la mzere wosiyana pogwiritsa ntchito njira yophunziridwa.
- Sankhani choyamba chopanda chidutswa chazomwe timakonzekera kukhazikitsa ndondomekoyi. Dinani pazithunzi "Ikani ntchito".
- Zenera likuyamba. Oyang'anira ntchito. Pitani ku gawo "Zolumikizana ndi zolemba". Kuchokera pandandanda, sankhani mtengo "DVSSYL". Dinani pa batani "Chabwino".
- Fenera la otchulidwayo likuyambitsidwa. Kumunda Chiyanjano cha Cell muyenera kufotokoza adiresi ya chinthucho pa pepala, zomwe zili mkati mwake. Inde, izo zikhoza kulowetsedwa pamanja, koma zidzakhala zothandiza kwambiri komanso zothandiza kuchita zotsatirazi. Ikani malonda mmunda, kenako dinani ndi batani lamanzere pa tsamba lomwe likugwirizana pa pepala. Monga mukuonera, patatha izi, adiresi yake inawonetsedwa kumunda. Ndiye kuchokera kumbali zonse ziwiri sankhani kugwirizana ndi ndemanga. Pamene tikukumbukira, izi ndizochitika pogwiritsa ntchito mfundoyi.
Kumunda "A1", popeza tikugwira ntchito yowonongeka, tikhoza kuika mtengo "WOONA"kapena mukhoza kusiya izo popanda kanthu, zomwe titi tichite. Izi zidzakhala zofanana.
Pambuyo pake dinani pa batani "Chabwino".
- Monga momwe mukuonera, tsopano zomwe zili mu selo yoyamba ya ndime yoyamba ya tebulo zikuwonetsedwa muzitsulo zomwe zikupezeka. FLOSS.
- Ngati tikufuna kugwiritsa ntchito ntchitoyi m'maselo omwe ali pansipa, ndiye kuti tifunika kulowa mu chigawo chilichonse payekha. Ngati tiyesa kuikopera pogwiritsa ntchito chikhomo chodzaza kapena njira yotsanzira, ndiye kuti zonse zomwe zili m'kalembedwe zidzasonyeza dzina lomwelo. Chowonadi ndi chakuti, monga tikumbukira, chigwirizanocho chimakhala ngati mkangano mu malemba (wokutidwa ndi zilembo), choncho sangakhale wachibale.
Phunziro: Excel ntchito wizara
Chitsanzo chachiwiri: kugwiritsira ntchito wogwiritsa ntchito njira yovuta
Ndipo tsopano tiyang'ane pa chitsanzo cha ntchito yogwiritsira ntchito mobwerezabwereza FLOSSpamene ilo liri gawo la zovuta kupanga.
Tili ndi tebulo ya mwezi uliwonse. Tiyenera kuwerengera kuchuluka kwa ndalama kwa nthawi inayake, mwachitsanzo, March - May kapena June - November. Inde, kuti muchite izi, mungagwiritse ntchito njira yophweka ya summation, koma panopa, ngati mukufuna kuwerengera zotsatira zonse pa nthawi iliyonse, tidzasintha fomu iyi nthawi zonse. Koma mukamagwiritsa ntchito ntchitoyo FLOSS Zidzatheka kusintha masambawo, mwa maselo omwe amasonyeza mwezi womwewo. Tiyeni tiyese kugwiritsa ntchito njirayi pakuchita, poyamba kuwerengera kuchuluka kwa nthawi kuyambira March mpaka May. Izi zimagwiritsa ntchito njirayi ndi kuphatikiza kwa ogwira ntchito SUM ndi FLOSS.
- Choyamba, mu zinthu zosiyana pa pepala timalowa maina a miyezi ya chiyambi ndi mapeto a nthawi yomwe chiwerengerocho chidzapangidwe, motero "March" ndi "May".
- Tsopano tiyeni titchule maselo onse omwe ali m'mbali. "Ndalama"zomwe zidzafanana ndi dzina la mwezi womwewo. Ndiko, chinthu choyamba m'ndandanda "Ndalama"yomwe ili ndi kuchuluka kwa ndalama zomwe ziyenera kutchedwa "January"wachiwiri - "February" ndi zina zotero
Choncho, kuti muike dzina ku gawo loyambirira la khola, sankhani ilo ndipo dinani pakanja lamanja la mouse. Mndandanda wamakono umatsegulidwa. Sankhani chinthu mmenemo "Lembani dzina ...".
- Dzina lakuti kulenga zenera likuyamba. Kumunda "Dzina" lowetsani dzina "January". Palibe kusintha kwenera pawindo, ngakhale kuti mungathe kuwona kuti zogwirizanitsa m'munda "Mtundu" amalembedwa ndi adiresi ya selo yomwe ili ndi ndalama za January. Pambuyo pake dinani pa batani "Chabwino".
- Monga mukuonera, tsopano pamene chinthu ichi chasankhidwa, dzina lake siliwonekera pawindo lawindo, koma m'dzina lomwe tinalipereka. Timachita ntchito yofananako ndi zinthu zina zonse za m'mbali. "Ndalama"powapatsa mayina otsatila "February", "March", "April" ndi zina zotero mpaka mwezi wa December.
- Sankhani selo yomwe mawerengero a zikhalidwe za nthawi yapadera iwonetsedwe, ndipo musankhe. Kenaka dinani pazithunzi. "Ikani ntchito". Ili kumbali yakumanzere ya bar lachonde ndi kumanja komwe kumatchedwa maselo.
- Muzenera chotsegulidwa Oyang'anira ntchito Pitani ku gawo "Masamu". Kumeneko timasankha dzina "SUMM". Dinani pa batani "Chabwino".
- Pambuyo pochita izi, festile yotsutsana yowonjezera imayambika. SUMamene ntchito yake ndikutchula mfundo izi. Chidule cha ntchitoyi ndi chophweka:
= SUM (nambala1; nambala2; ...)Kawirikawiri, chiwerengero cha zifukwa chingakhale chokwanira 255. Koma zifukwa zonsezi ndi zofanana. Zimayimira chiwerengero kapena makonzedwe a selo omwe muli nambalayi. Zitha kukhalanso ngati mawonekedwe omwe amapanga chiwerengero chomwe amafunikirako kapena malingaliro ku adiresi ya pepala yomwe imayikidwa. Ndili mu khalidwe ili la ntchito yomangidwa yomwe woyendetsa ntchitoyo adzagwiritsiridwa ntchito. FLOSS panopa.
Ikani cholozera mmunda "Number1". Kenaka dinani pa chithunzicho mwa mawonekedwe a katatu yosinthidwa kupita kumanja kwa munda wamtundu wamtunduwu. Mndandanda wa ntchito zomwe wagwiritsidwa ntchito posachedwa zikuwonetsedwa. Ngati pali dzina pakati pawo "DVSSYL"ndiye nthawi yomweyo dinani pa izo kuti mupite kuwindo lazitsulo la ntchitoyi. Koma zikhoza kukhala kuti mndandanda uwu simudzawupeza. Pankhaniyi, dinani pa dzina. "Zina ..." pansi pa mndandanda.
- Zenera zomwe tidziwa kale zimayambika. Oyang'anira ntchito. Pitani ku gawo "Zolumikizana ndi zolemba" ndipo sankhani dzina la wogwira ntchito kumeneko FLOSS. Zitatha izi dinani pa batani. "Chabwino" pansi pazenera.
- Wowonjezera zotsutsana zenera akuyambitsidwa. FLOSS. Kumunda Chiyanjano cha Cell tchulani adiresi ya pepala yomwe ili ndi dzina la mwezi woyambirira wa malire omwe amawerengera ndalamazo. Chonde dziwani kuti pakali pano sikofunika kulumikizana mu zizindikiro za quotation, popeza pakadali pano, adilesi siidzakhala zigawo za selo, koma zomwe zili, zomwe zili kale ndi malemba (mawuwo "March"). Munda "A1" chokani chopanda kanthu, popeza timagwiritsa ntchito mtundu wovomerezeka.
Pambuyo pa adiresi yomwe ikuwonetsedwa m'munda, musafulumize kukanikiza pakani "Chabwino", chifukwa ichi ndi chisa chochita, ndizochita ndi izo zikusiyana ndi kachitidwe kachitidwe kawirikawiri. Dinani pa dzina "SUMM" mu bar.
- Pambuyo pake tibwerera kuwindo latsutso SUM. Monga mukuonera, kumunda "Number1" owonetsa kale FLOSS ndi zomwe zili. Ikani cholozera mmunda womwewo mutangotha khalidwe lomaliza mu mbiri. Ikani chikhalidwe cha koloni (:). Chizindikiro ichi chimasonyeza chizindikiro cha adilesi yamtundu wambiri. Kenaka, popanda kuchotsa mtolowo kumtunda, dinani kachiwiri pa chithunzicho mwa mawonekedwe a katatu kuti musankhe ntchito. Nthawiyi mumndandanda wa oyendetsa ntchito posachedwa dzina "DVSSYL" ayenera kukhalapo, popeza posachedwapa tinagwiritsa ntchito izi. Dinani pa dzina.
- Wenera wotsutsana wenera akugulanso. FLOSS. Timabweretsa munda Chiyanjano cha Cell adiresi ya chinthucho pa pepala limene dzina la mwezi uli, lomwe limatsiriza nthawi yobweza. Apanso, makonzedwewa ayenera kulowa popanda ndemanga. Munda "A1" chokani chopanda kanthu kachiwiri. Pambuyo pake dinani pa batani "Chabwino".
- Monga momwe mukuonera, pambuyo pa zochitikazi, pulogalamuyi ikuwerengera ndipo imapereka zotsatira za kuwonjezera kwa ndalama za kampaniyo pa nthawi yoyikidwa (March - May) ku chinthu chomwe chasankhidwa kale pa pepala chomwe chimapangidwira.
- Ngati titasintha m'maselo omwe maina a miyezi yoyambirira ndi mapeto a nthawi yobwezera alowetsedwa, kwa ena, mwachitsanzo "June" ndi "November"ndiye zotsatira zidzasintha molingana. Adzawonjezeredwa ku kuchuluka kwa ndalama kwa nthawi yeniyeniyo.
Phunziro: Momwe mungawerengere ndalama mu Excel
Monga mukuonera, ngakhale kuti ntchitoyo FLOSS sangathe kutchulidwa kuti ndi otchuka kwambiri ndi ogwiritsa ntchito, komabe, zimathandiza kuthetsa mavuto a zovuta zosiyana mu Excel mosavuta kwambiri kusiyana ndi zomwe zingatheke pothandizidwa ndi zipangizo zina. Koposa zonse, wogwiritsira ntchitoyi ndi othandiza ngati mbali ya zovuta zomwe zimakhala mbali ya mawu. Koma komabe ziyenera kudziwika kuti mwayi wonse wa woyendetsa FLOSS zovuta kumvetsa. Izi zikutanthawuza kutchuka kwa mbali yofunikira pakati pa ogwiritsa ntchito.
