Sinthani "Taskbar" mu Windows 7

Monga zimadziwika, pali mitundu iŵiri ya kulankhulana pazithunzi za Excel: zogwirizana ndi zenizeni. Pachiyambi choyamba, chiyanjano chimasintha motsatira kutsanzira ndi kuchuluka kwa kusintha kwake, ndipo chachiwiri, chikhazikitsidwa ndipo sichisintha pamene mukujambula. Koma mwachisawawa, maadiresi onse ku Excel ali omveka. Pa nthawi yomweyi, nthawi zambiri pamakhala zofunikira kugwiritsa ntchito mndandanda wa zofunikira. Tiyeni tione momwe izi zingathere.

Gwiritsani ntchito mwapadera

Tingafunikire kutchula mwachidwi, mwachitsanzo, ngati tikulemba fomu, mbali imodzi yomwe ili ndi kusintha kwawonetsedwa mu manambala angapo, ndipo yachiwiri ili ndi mtengo wapatali. Izi zikutanthauza kuti nambalayi imagwira ntchito yokhala yowonjezera, yomwe muyenera kuchita ntchito (kuwonjezereka, magawano, ndi zina zotero) ku mndandanda wonse wa manambala osinthika.

Mu Excel, pali njira ziwiri zomwe mungakhazikitsire pazinthu: pokonza zolemba zonse ndikugwiritsa ntchito ntchito ya DFSS. Tiyeni tiwone njira iliyonse mwachindunji.

Njira 1: kutanthauzira kwathunthu

Inde, njira yotchuka kwambiri komanso yogwiritsidwa ntchito mobwerezabwereza kuti muyambe kulumikiza ndi kugwiritsa ntchito mgwirizano weniweni. Zolumikizo zomveka zimasiyana osati zokhazikika, komanso zomangamanga. Adilesi yachilendo ili ndi mawu ofanana awa:

= A1

Kwa adiresi yokhazikika, chizindikiro cha dola chimayikidwa kutsogolo kwa mtengo wogwirizana:

= $ A $ 1

Chizindikiro cha dola chingalowetsedwe pamanja. Kuti muchite izi, yikani mtolowo asanayambe kuyanjana kwa adiresi (m'munsi) mu selo kapena mu bar. Chotsatira, mu chingerezi chachingelezi cha Chingerezi, dinani pa fungulo "4" Zowonjezera (zokhala ndi zovutazo Shift). Ndi apo apo chizindikiro cha dola chiri. Ndiye muyeneranso kuchita chimodzimodzi ndi zochitika motsatira.

Pali njira yofulumira. Muyenera kuyika ndondomeko mu selo imene adilesi ilipo, ndipo dinani pa f4 ntchito yofunikira. Pambuyo pake, chizindikiro cha dola chidzawonekera panthaŵi yomweyo pamakonzedwe osakanikirana ndi ofukula a adilesi.

Tsopano tiyeni tiyang'ane momwe mtheradi yomvera imagwiritsidwira ntchito pakuchita mwa kugwiritsa ntchito mgwirizano wamtheradi.

Tengani tebulo momwe malipiro a antchito akuwerengedwera. Kuwerengera kumapangidwira powonjezera phindu la malipiro awo ndi chiwerengero chokhazikika, chomwe chiri chofanana kwa antchito onse. Coefficient palokha ili mu selo losiyana la pepala. Ife tikuyang'anizana ndi ntchito yowerengera malipiro a antchito onse mofulumira kwambiri.

1. Kotero, mu selo yoyamba ya chigawocho "Malipiro" timayambitsa ndondomeko yowonjezera mlingo wa wogwira ntchitoyo mogwirizana ndi coefficient. Kwa ife, fomu iyi ili ndi mawonekedwe otsatirawa:

   = C4 * G3



2. Kuti muwerenge zotsatira zomaliza, dinani Lowani pabokosi. Chiwonetsero chonse chikuwonetsedwa mu selo yomwe ili ndi mayendedwe.



3. Tinawerengetsera mtengo wa malipiro kwa wogwira ntchito yoyamba. Tsopano tikuyenera kuchita izi kwa mizere ina yonse. Inde, opaleshoni ingalembedwe ku selo iliyonse ya mndandandawo. "Malipiro" mwapadera, kufalitsa njira yofananamo, yokonzedweratu kuchitapo kanthu, koma tili ndi ntchito, mwamsanga momwe tingachitire mawerengedwe, ndi kuitanitsa mwatsatanetsatane kudzatenga nthawi yochuluka. Inde, ndipo n'chifukwa chiyani mumayesetsa kugwiritsa ntchito njirayi, ngati njirayi ingangoponyedwa kwa maselo ena?

   Kuti mufanizire fomuyi, gwiritsani ntchito chida monga cholemba chodzaza. Timakhala chithunzithunzi m'ngodya ya kumunsi ya selo yomwe ilipo. Pachifukwa ichi, thumbalolololo liyenera kusinthidwa kukhala chizindikiro chodzaza kwambiri mwa mawonekedwe a mtanda. Gwiritsani batani lamanzere la khomo ndikukoka khola mpaka kumapeto kwa tebulo.



4. Koma, monga momwe tikuonera, mmalo mwa malipiro oyenera kwa antchito onse, tinalandira zeros okha.



5. Timayang'ana chifukwa cha zotsatirazi. Kuti muchite izi, sankhani selo lachiwiri m'mbali "Malipiro". Bwalo lamakono limasonyeza mawu ofanana ndi selo ili. Monga mukuonera, chinthu choyamba (C5) zimagwirizana ndi mlingo wa wogwira ntchito, yemwe timamuyembekezera. Kusintha kwa makomiti oyerekeza poyerekezera ndi selo yapitayi kunali chifukwa cha kugwirizana. Komabe, mu nkhaniyi, tikufunikira. Chifukwa cha ichi, mlingo wa wantchito amene tikufunikira ndiwo chinthu choyamba. Koma kusintha kwa makonzedwe kunachitika ndi kuwonjezereka kwachiwiri. Ndipo tsopano adiresi yake sikutanthauza coefficient (1,28), ndi selo yopanda kanthu m'munsimu.

   

   Ichi chinali chifukwa chake malipiro a ogwira ntchito omwe analembedwa pa mndandandawo sakhala olakwika.

6. Pofuna kuthetsa vutolo, tifunika kusinthira kuyankhulana kwachigawo chachiwiri kuchokera kufupi ndi kukhazikika. Kuti muchite izi, bwererani ku selo yoyamba m'mbali. "Malipiro"pozifotokoza. Kenaka, timasamukira ku bar, kumene mawu omwe tikusowa amawonetsedwa. Sankhani chinthu chachiwiri ndi chithunzithunzi (G3) ndi kukanikiza fungulo la ntchito pa makiyi.



7. Monga momwe tikuonera, chizindikiro cha dola chinawonekera pafupi ndi zigawo zachiwiri, ndipo izi, monga tikukumbukira, ndizofunikira kuti tithe kuyankhula. Kuti muwonetse zotsatira, pindikizani fungulo Lowani.



8. Tsopano, monga kale, timayitanitsa chodzaza ndi kuika chithunzithunzi m'makona a kumunsi kwa gawo loyambirira. "Malipiro". Gwirani botani lamanzere lamanzere pansi ndi kulikwezera.



9. Monga momwe mukuonera, pankhaniyi, chiwerengerochi chinkachitika molondola ndipo malipiro a ogwira ntchito onse akuwerengedwa molondola.



10. Onani mmene fomuyi inakopera. Kuti muchite izi, sankhani chinthu chachiwiri cha ndimeyi "Malipiro". Timayang'ana mawu omwe ali mu bar. Monga momwe mukuonera, makonzedwe a chinthu choyamba (C5), yomwe ikadali yachilendo, yosinthidwa imodzi imakhala pansi pamzere poyerekeza ndi selo yapitayi. Koma chinthu chachiwiri ($ G $ 3), adiresi imene tinapanga, sanasinthe.

Excel imagwiritsanso ntchito zomwe zimatchulidwa kusakanikirana. Pankhaniyi, adiresi ya elementyo imasankhidwa kukhala mzere kapena mzere. Izi zikukwaniritsidwa mwakuti chizindikiro cha dola chimayikidwa patsogolo pa imodzi mwazolumikizana za adilesi. Pano pali chitsanzo cha mgwirizano wotsalira womwe umakhala nawo:

= $ 1

Adilesiyi imayambanso kusakanikirana:

= $ A1

Izi zikutanthauza kuti mndandanda wa zolembedwerazo umagwiritsidwa ntchito pokhapokha pa chikhalidwe chimodzi chogwirizana.

Tiyeni tiwone momwe izi zingagwiritsidwe ntchito pogwiritsa ntchito chitsanzo cha misonkho yofanana ya antchito a kampani.

1. Monga momwe mukuonera, poyamba tinalipanga kuti zonse zogwirizanitsa zachiwiri zikhale zolembera. Koma tiyeni tiwone ngati mu nkhaniyi zonse ziyenera kukhazikitsidwa? Monga momwe mukuonera, pamene kujambula kumachitika, kusamuka kwathu kumachitika molunjika, ndipo mipangidwe yopingasa imasintha. Choncho, ndizotheka kugwiritsa ntchito mndandanda wa makonzedwe a mzerewu, ndipo makonzedwe a chigawocho amakhalabe momwe iwo aliri osasintha - wachibale.

   Sankhani chinthu choyamba m'ndandanda. "Malipiro" ndipo mu barrale yopangira machitidweyo amachititsa zolakwikazo pamwambapa. Timapeza njira yotsatirayi:

   = C4 * G $ 3

   Monga momwe mukuonera, kukonzedwa koyambitsidwa kwachiwiri kumagwiritsidwa ntchito pokhapokha potsata ndondomeko ya chingwe. Kuti muwonetse zotsatira mu selo, dinani pa batani. Lowani.



2. Pambuyo pake, pogwiritsa ntchito chikhomo chodzaza, lembani fomu iyi kumaselo angapo pansipa. Monga mukuonera, malipiro kwa ogwira ntchito onse amachita molondola.



3. Timayang'ana momwe mndandanda wamakopi umasonyezera mu selo yachiwiri ya mndandanda yomwe tidachita. Monga momwe mungathe kuwonera muzenera zamakono, mutasankha chisankho cha pepala, ngakhale chinthu chachiwiri chokha chimakhala ndi mndandanda wa zolemba, mndandanda wa makalatawo sunasinthe. Izi ndizo chifukwa chakuti sitimakopera, koma pamtundu. Ngati tingaphunzire mozengereza, ndiye mofanana ndi zimenezo, m'malo mwake, tifunika kukonza zolembera zazitsulo zazitsulo, ndipo mizereyi ingakhale yotheka.

PHUNZIRO: Mtheradi ndi wachibale zimalumikizana ku Excel

Njira 2: ntchito ya FLOSS

Njira yachiwiri yolinganiza mtheradi ku tablete ya Excel ndiyo kugwiritsa ntchito operekera FLOSS. Ntchito yeniyeniyo ndi ya gulu la ogwira ntchito. "Zolumikizana ndi zolemba". Ntchito yake ndi kupanga chiyanjano ku selo yomwe yafotokozedwa ndi zotsatira za zotsatirazo ku gawo la pepala limene woyendetsa mwiniwakeyo ali. Pachifukwa ichi, chigwirizanochi chimagwirizanitsidwa ndi makonzedwewo ngakhale olimba kuposa pamene akugwiritsa ntchito chizindikiro cha dola. Chifukwa chake, nthawi zina amavomerezedwa kutchula kugwirizana ntchito FLOSS "super-absolute". Mawu awa ali ndi zizindikiro zotsatirazi:

= FLOSS (kulumikizana ndi selo; [a1])

Ntchitoyi ili ndi zifukwa ziwiri, zoyamba zake ziri ndi udindo wovomerezeka, ndipo chachiwiri sichiyenera.

Kutsutsana Chiyanjano cha Cell ndikulumikizana ndi gawo la pepala la Excel mu mawonekedwe a mauthenga. Ndiko, ichi ndichilumikizano chachizolowezi, koma chatsekedwa muzolemba. Izi ndizo zomwe zimapangitsa kuti zitheke kutumiza katundu.

Kutsutsana "a1" - mwadzidzidzi ndipo mumagwiritsidwa ntchito nthawi zambiri. Kugwiritsa ntchito kwake n'kofunika kokha pamene wosuta akusankha njira yothetsera vutoli, m'malo mogwiritsa ntchito makonzedwe a mtunduwo "A1" (zipilala zili ndi kalata, ndipo mizere ndizowerengeka). Njira ina imatanthauza kugwiritsa ntchito kalembedwe "R1C1"muzomwe zipilala, ngati mizera, zimatchulidwa ndi manambala. Pitani kuntchito iyi ndi zotheka kudzera pawindo la Excel zosankha. Kenako, mugwiritse ntchito woyendetsa FLOSS, ngati mkangano "a1" ayenera kusonyeza mtengo "ZINTHU". Ngati mukugwira ntchito yowonetsera maulumikizi, monga ena ambiri ogwiritsa ntchito, ndiye ngati mkangano "a1" akhoza kufotokoza mtengo "WOONA". Komabe, mtengo umenewu umatanthauzidwa ndi chosasinthika, choncho kutsutsana pa nkhaniyi kuli kovuta kwambiri pa nkhaniyi. "a1" musanenere.

Tiyeni tiwone momwe kuthetsera mtheradi kumagwirira ntchito, koyendetsedwa ndi ntchitoyo FLOSS, mwachitsanzo cha tebulo lathu la malipiro.

1. Sankhani chinthu choyamba m'ndandanda. "Malipiro". Ife timayika chizindikiro "=". Pamene mukukumbukira, chochulukitsa choyamba mu njira yeniyeni yowerengera malipiro ayenera kuimiridwa ndi adiresi yachibale. Choncho, dinani pa selo yomwe ili ndi malipiro ofanana.C4). Potsatira momwe adiresi yake ikuwonetsedwa mu chinthucho kuti muwonetse zotsatira, dinani pa batani wonjezerani (*) pa makiyi. Ndiye tifunika kusuntha kugwiritsa ntchito woyendetsa FLOSS. Dinani pazithunzi. "Ikani ntchito".



2. Pawindo lomwe limatsegula Oyang'anira ntchito pitani ku gulu "Zolumikizana ndi zolemba". Pakati pa mndandanda wa mayinawo mumasankha dzina "DVSSYL". Kenaka dinani pa batani. "Chabwino".



3. Imagwiritsa ntchito zokhudzana ndi zenera zowonetsera FLOSS. Icho chimapangidwa ndi madera awiri omwe akugwirizana ndi zifukwa za ntchitoyi.

   Ikani cholozera mmunda Chiyanjano cha Cell. Ingolani pa chigawo cha pepala, chomwe chiri coefficient kuti chiwerengero cha malipiro (G3). Adilesi idzawonekera nthawi yomweyo mu bokosi lotsutsana. Ngati tinkakhala ndi ntchito yowonongeka, ndiye kuti kulembedwa kwa adiresiyo kungakhale koyenera, koma timagwiritsa ntchito ntchitoyi FLOSS. Pamene tikukumbukira, maadiresi mmenemo ayenera kukhala ngati malemba. Choncho, timagwirizanitsa makonzedwe, omwe ali m'munda wawindo, muzolemba.

   Popeza timagwira ntchito muyezo wamakono owonetsera, munda "A1" chokani chopanda kanthu. Dinani pa batani "Chabwino".



4. Mapulogalamuwa amachititsa kuwerengera ndipo amasonyeza zotsatira muzitsulo zomwe zili ndi ndondomekoyi.



5. Tsopano ife timatsanzira fomu iyi kwa maselo ena onse a ndimeyo. "Malipiro" kupyolera mu chilemba chodzaza, monga ife tinkachitira kale. Monga mukuonera, zotsatira zonse ziwerengedwa molondola.



6. Tiyeni tiwone momwe mawonekedwe amasonyezera mu imodzi mwa maselo omwe adajambulidwa. Sankhani chinthu chachiwiri cha ndimeyi ndipo yang'anani pa bar. Monga mukuonera, chinthu choyambirira, chomwe chiri chofanana, chinasintha makonzedwe ake. Pa nthawi yomweyi, kutsutsana kwa chinthu chachiwiri, chomwe chikuyimiridwa ndi ntchitoyo FLOSS, sanasinthe. Pachifukwa ichi, njira yogwiritsira ntchito maadiresi inagwiritsidwa ntchito.

PHUNZIRO: DETSE Yogwira Ntchito ku Excel

Kusakayikira ku Excel spreadsheets kungapezeke mwa njira ziwiri: kugwiritsa ntchito ntchito yozizwitsa yosavuta ndi kugwiritsa ntchito mgwirizano. Pachifukwa ichi, ntchitoyi imapereka chilolezo cholimba ku adiresi. Kulumikizana mwamtheradi kumatha kugwiritsidwanso ntchito pogwiritsa ntchito malumikizano osakanikirana.