Kuwerengera mu Microsoft Excel

Imodzi mwa ntchito zamakono zofanana ndikumanga galasi lodalira. Zimasonyeza kudalira kwa ntchito pa kusintha kwa mkangano. Papepala, kuchita zimenezi sikophweka nthawi zonse. Koma zida za Excel, ngati zikuyenerera bwino, zimakulolani kuti mukwaniritse ntchitoyi moyenera komanso mwamsanga. Tiyeni tione momwe izi zingachitikire pogwiritsa ntchito deta zosiyanasiyana.

Sungani dongosolo la chilengedwe

Kudalirika kwa ntchito pazokangana ndizofanana ndi kudalira kwa algebra. Kawirikawiri, kukangana ndi kufunika kwa ntchito kumakhala kuwonetsedwa ndi zizindikiro: "x" ndi "y", motsatira. Kawirikawiri muyenera kutulutsa mawonekedwe a kudalira kwa kutsutsana ndi ntchito, zomwe zalembedwa mu tebulo, kapena kuti ndizolembedwa ngati gawo la fomu. Tiyeni tione zitsanzo zenizeni za kumanga graph (chithunzi) pansi pazifukwa zosiyanasiyana.

Njira 1: Pangani galasi lodalira pogwiritsa ntchito deta

Choyamba, tiyeni tiyang'ane momwe tingakhalire galasi lodalira molingana ndi deta yomwe kale idalowa mu tebulo. Gwiritsani ntchito tebulo la kudalira kwa mtunda woyenda (y) kuchokera nthawi (x).

1. Sankhani tebulo ndikupita ku tabu "Ikani". Dinani pa batani "Ndondomeko"lomwe liri kumalo komwe kuli gululo "Zolemba" pa tepi. Zithunzi zosiyana siyana zimatsegulidwa. Zolinga zathu, timasankha zosavuta. Icho chili pampando woyamba m'ndandanda. Ife tikuwomba pa izo.



2. Pulogalamuyi imapanga tchati. Koma, monga tikuonera, mizere iwiri ikuwonetsedwa pa malo omanga, pamene tikusowa imodzi yokha: kudalira nthawi. Choncho, sankhani mzere wa buluu mwa kudinda batani lamanzere ("Nthawi"), chifukwa sichigwirizana ndi ntchitoyo, ndipo dinani pa fungulo Chotsani.



3. Mzere wolimbidwa udzachotsedwa.

Kwenikweni pakumangidwe kwa graph yosavuta kwambiri yokhudzana ndi zowonjezera zingathe kuonedwa kukhala zangwiro. Ngati mukufuna, mukhoza kusintha dzina la tchati, nkhwangwa zake, chotsani nthano ndikupanga zina kusintha. Izi zikufotokozedwa mwatsatanetsatane mu phunziro losiyana.

PHUNZIRO: Tingapange bwanji grafu ku Excel

Njira 2: Pangani galasi lodalira ndi mizere yambiri

Zomwe zimakhala zosiyana kwambiri ndi zida zowonongeka ndizochitika pamene ntchito ziwiri zikugwirizana ndi ndemanga imodzi mwakamodzi. Pankhaniyi, muyenera kumanga mizere iwiri. Mwachitsanzo, tiyeni titenge tebulo limene ndalama zonse za malonda ndi zopindulitsa zake zimaperekedwa chaka.

1. Sankhani tebulo lonse pamodzi ndi mutu.



2. Monga momwe zinalili kale, dinani pa batani. "Ndondomeko" mu gawo la magawo. Apanso, sankhani njira yoyamba yomwe ikupezeka m'ndandanda yomwe imatsegulidwa.



3. Pulogalamuyi imapanga zomangamanga molingana ndi deta yomwe imapezeka. Koma, monga momwe tikuonera, panopa sitili ndi mzere wina wachitatu, komanso malemba pazowunikira zogwirizanitsa sizimagwirizana ndi zofunikira, monga, dongosolo la zaka.

   Yambani mwamsanga mzere wowonjezera. Ndilo lokhalo lolungama mu chithunzichi - "Chaka". Monga mwa njira yapitayi, sankhani mzere mwa kuwonekera pa iwo ndi mbewa ndikusindikiza batani Chotsani.



4. Mzere wachotsedwa ndipo pamodzi nawo, monga momwe mukuwonera, ziyeso pazitsulo zogwirizanitsa zinasinthidwa. Zakhala zolondola kwambiri. Koma vuto ndi mawonetsedwe osayenerera a mzere wolumikiza wa makonzedwe adakalipobe. Pofuna kuthetsa vutoli, dinani pamalo omanga ndi batani lamanja la mouse. Mu menyu muyenera kusiya kusankhidwa pa malo "Sankhani deta ...".



5. Chotsegula kusankha chitsime chimatsegula. Mu chipika "Zisindikizo zazitali zozungulira" dinani pa batani "Sinthani".



6. Zenera zimatsegula ngakhale zocheperapo kuposa kale. Momwemo muyenera kufotokoza zigawo zomwe zili pa tebulo la mfundo zomwe ziyenera kuwonetsedwa pazowunikira. Pachifukwa ichi, timayika pakhomo lokha pawindo ili. Kenako timagwiritsa ntchito batani lamanzere ndi kusankha zonse zomwe zili m'ndandanda. "Chaka"kupatula dzina lake. Adilesi imangowonekera nthawi yomweyo, dinani "Chabwino".



7. Kubwerera ku zenera zosankha zosankha, timasankhiranso "Chabwino".



8. Pambuyo pake, ma grafu onse omwe ali pa pepala amawonetsedwa molondola.

Njira 3: Kukonza mapulani pogwiritsa ntchito magulu osiyanasiyana

Mu njira yapitayi, tinalingalira za kumanga chithunzi ndi mizere ingapo pa ndege yomweyo, koma panthawi yomweyi ntchito zonse zinali ndi magawo ofanana (zikwi za ruble). Zomwe mungachite ngati mukufunikira kupanga magulu ogonjera pogwiritsa ntchito tebulo limodzi lomwe ntchito zawo zimasiyana? Mu Excel pali njira yothetsera vutoli.

Tili ndi tebulo limene deta yomwe imakhudzidwa ndi malonda a katundu wina mu matani ndi ndalama zomwe zagulitsidwa m'mabuku zikwizikwi zimaperekedwa.

1. Monga momwe zilili m'mbuyo, timasankha deta yonse patebulo pamodzi ndi mutu.



2. Timasankha pa batani "Ndondomeko". Apanso, sankhani njira yoyamba yomanga mndandanda.



3. Mndandanda wa zojambulajambula zimakhazikitsidwa pa malo omanga. Mofananamo momwe tafotokozera m'mawotchudwe apitalo, timachotsa mzere wina "Chaka".



4. Mofanana ndi njira yapitayi, tifunika kusonyeza chaka pazitsulo zosakanikirana. Dinani pa malo omangako ndi mndandanda wa zosankha zomwe mungasankhe "Sankhani deta ...".



5. Muwindo latsopano, dinani pa batani. "Sinthani" mu block "Zolemba" ozungulira osakanikirana.



6. Muzenera yotsatira, ndikupanga zofanana zomwe zafotokozedwa mwatsatanetsatane mu njira yapitayi, timalowa muzolumikizana za chigawochi "Chaka" kumalo "Mbali Yachizindikiro ya Axis". Dinani "Chabwino".



7. Mukabwerera ku zenera lapitayi, dinani pa batani. "Chabwino".



8. Tsopano tikuyenera kuthana ndi vuto limene silinakumanepo ndizochitika zomangamanga, monga vuto la kusagwirizana pakati pa magulu ambiri. Pambuyo pa zonse, mukuwona, sangathe kupezeka pazitsulo zofanana, zomwe nthawi zonse zimatchula ndalama zonse (zikwi za ruble) ndi masi (matani). Kuti tithetse vutoli, tifunika kumanga zowonjezera zowonjezera zogwirizana.

   Kwa ife, kuti tibwerere ku ndalama, timachoka pamzere wokhoma womwe ulipo kale, ndi mzere "Malonda" pangani wothandizira. Timasindikiza pa mzerewu ndi batani lamanja la mouse ndipo sankhani kuchokera pandandanda yomwe mungasankhe "Maonekedwe a mndandanda wa deta ...".



9. Mawindo a mawonekedwe a mzere akuyamba. Tiyenera kusuntha ku gawoli. "Zowonjezera Zowonjezera"ngati ilo linatsegulidwa mu gawo lina. Kumanja kwawindo ndiwindo "Mangani mzere". Amafuna kusintha kosintha "Mzere wothandizira". Klaatsay ndi dzina "Yandikirani".



10. Pambuyo pake, mzere wothandizira wothandizira udzamangidwa, ndi mzere "Malonda" anakhazikitsiranso ku makonzedwe ake. Choncho, ntchitoyi pa ntchitoyo yatha.

Njira 4: Pangani galasi lodalira pogwiritsa ntchito algebraic ntchito

Tsopano tiyeni tikambirane njira yopangira galasi lodalira lomwe liperekedwa ndi algebraic ntchito.

Tili ndi ntchito yotsatirayi: y = 3x ^ 2 + 2x-15. Pachifukwa ichi, muyenera kumanga ma graf of values y kuchokera x.

1. Tisanayambe kumanga chithunzichi, tidzakonza tebulo pogwiritsa ntchito ntchitoyi. Makhalidwe a mtsutso (x) mu tebulo lathu adzakhala osiyana -15 mpaka 30 mu increments of 3. Kufulumizitsa ndondomeko yolowera deta, tidzatha kugwiritsa ntchito chida chodzidzimutsa. "Kupitirira".

   Timafotokoza mu selo yoyamba ya mzere "X" tanthauzo "-15" ndipo musankhe. Mu tab "Kunyumba" dinani pa batani "Lembani"adaikidwa mu chipika Kusintha. M'ndandanda, sankhani kusankha "Kupita patsogolo ...".



2. Kugwiritsa ntchito zenera "Kupita patsogolo"Mu block "Malo" tcherani dzina "Ndi ndondomeko", chifukwa tikuyenera kudzaza ndendende. Mu gulu Lembani " chotsani mtengo "Masamu"yomwe imayikidwa ndi chosasintha. Kumaloko "Khwerero" ayenera kuika mtengo "3". Kumaloko "Pezani mtengo" ikani chiwerengerocho "30". Dinani pang'onopang'ono "Chabwino".



3. Pambuyo pochita izi, ndondomeko yonseyi "X" adzadzaza ndi malingana ndi ndondomekoyi.



4. Tsopano tikufunika kukhazikitsa mfundo Yzomwe zikugwirizana ndi mfundo zina X. Choncho kumbukirani kuti tili ndi njira y = 3x ^ 2 + 2x-15. Icho chiyenera kutembenuzidwira ku fomu ya Excel, momwe zikhalidwe X adzasinthidwa ndi maumboni a masebulo a tebulo okhala ndi zifukwa zofanana.

   Sankhani selo yoyamba m'mbali. "Y". Kuwona kuti mwa ife ife adiresi ya kutsutsana koyamba X amaimiridwa ndi makonzedwe A2ndiye mmalo mwa ndondomeko yomwe ili pamwambapa timapeza mawu otsatirawa:

   = 3 * (A2 ^ 2) + 2 * A2-15

   Lembani mawu awa ku selo yoyamba m'ndandanda. "Y". Kuti mutenge zotsatira za chiwerengero, dinani Lowani.



5. Chotsatira cha ntchitoyi kwa kutsutsana koyambirira kwa chiwerengerocho chiwerengedwa. Koma tifunika kuwerengera zikhulupiliro zake pazifukwa zina. Lowani ndondomeko ya mtengo uliwonse Y Ntchito yayitali komanso yovuta. Kuthamanga mofulumira komanso mosavuta. Vutoli likhoza kuthetsedwa mothandizidwa ndi chizindikiro chodzaza ndi chifukwa cha katundu wotchulidwa mu Excel, monga kugwirizana kwawo. Pamene mukujambula njira yodutsa mndandanda wina Y mfundo X mu njirayi idzasintha mwachindunji mogwirizana ndi makonzedwe awo oyambirira.

   Timaika chithunzithunzi pamphepete mwachindunji cha chinthu chomwe chidalembedwa kale. Pankhaniyi, kusinthika kuyenera kuchitika ndi chithunzithunzi. Idzakhala mtanda wakuda, umene uli ndi dzina la chizindikiro chodzaza. Gwirani batani lamanzere la mouse ndipo yesani chizindikiro ichi pansi pa tebulo m'dandanda "Y".



6. Ntchito yomwe ili pamwambayi inachititsa kuti chigawochi chikhale "Y" anali wodzaza kwathunthu ndi zotsatira za chiganizocho y = 3x ^ 2 + 2x-15.



7. Tsopano ndi nthawi yomanga chithunzi chomwecho. Sankhani deta yonse. Apanso mu tabu "Ikani" pressani batani "Ndondomeko" magulu "Zolemba". Pankhaniyi, tiyeni tizisankha pazinthu zomwe mungasankhe "Tchati ndi zizindikiro".



8. Tchati chokhala ndi zizindikirocho chikuwonetsedwa pa malo a chiwembu. Koma, monga momwe zilili kale, tidzasintha zina kuti zikhale zolondola.



9. Choyamba chotsani mzere "X"yomwe imayikidwa kutsogolo pa chizindikiro 0 makonzedwe. Sankhani chinthu ichi ndipo dinani pa batani. Chotsani.



10. Sitikusowa nthano, popeza tili ndi mzere umodzi ("Y"). Choncho, sankhani mwatsatanetsatane komanso dinani pa fungulo Chotsani.



11. Tsopano tifunika kusinthira zikhulupiliro muzong'onong'ono kophatikizana ndi zomwe zikugwirizana ndi chigawochi "X" mu tebulo.

    Dinani botani lamanja la mouse kuti musankhe mzere wa mzere. Mu menyu ife timayenda ndi mtengo. "Sankhani deta ...".



12. Muwindo lasankhidwa la chitsime chotsitsimutsa ife timasankha pa batani lomwe tidziwa kale. "Sinthani"ili pambali "Zisindikizo zazitali zozungulira".



13. Zenera likuyamba. Zikwangwani Zojambula. Kumaloko "Mbali Yachizindikiro ya Axis" timafotokozera zogwirizanitsa za ndondomeko ndi gawo la deta "X". Ikani chotsalacho pamtunda wa munda, ndiyeno, popanga chophimba chofunikira cha batani lamanzere, sankhani zamtundu uliwonse wa ndondomeko yoyenerayo patebulo, osatchula dzina lake lokha. Momwe makonzedwewa akuwonetsedwa kumunda, dinani pa dzina "Chabwino".



14. Kubwerera ku zenera zosankha zosankha, dinani batani. "Chabwino" mmenemo, monga momwe zakhalira kale muzenera lapitalo.



15. Pambuyo pake, pulogalamuyo idzasintha chithunzi chomwe chinapangidwa kale malingana ndi kusintha komwe kunapangidwira m'makonzedwe. Gulu la kudalira pamaziko a ntchito ya algebraic ikhoza kuganiziridwa potsiriza.

PHUNZIRO: Tingapange bwanji autocomplete mu Microsoft Excel

Monga momwe mukuonera, mothandizidwa ndi Excel, ndondomeko yokonza zidalira ndizosavuta poyerekeza ndi kuzipanga pamapepala. Zotsatira za zomangamanga zingagwiritsidwe ntchito palimodzi pa ntchito yophunzitsa komanso mwachindunji. Ntchito yeniyeniyi imadalira chomwe chithunzichi chimachokera pa: tebulo kapena ntchito. Pachifukwa chachiwiri, musanamange tchati, muyenera kupanga tebulo ndi zifukwa komanso zoyenera kuchita. Kuphatikiza apo, ndondomeko ikhoza kumangidwa pamaziko a ntchito imodzi kapena zingapo.