Kunezimo lapho ufuna ukwazi imiphumela yokubala umsebenzi ngaphandle kwendawo eyaziwayo. Le ndaba ibaluleke kakhulu kwinqubo yokubikezela. Kunezindlela eziningana ku-Excel ezingasetshenziswa ukwenza lo msebenzi. Ake sibabheke ngezibonelo ezithile.
Kusetshenziswa i-extraperals
Ngokuphikisana nokutolika, umsebenzi okuwukuthola inani lomsebenzi phakathi kwezimpikiswano ezimbili ezaziwayo, ukubhala kabusha kufaka ukuthola isisombululo ngaphandle kwendawo eyaziwayo. Kungakho le ndlela inesidingo sokubikezela isibikezeli.
Ku-Excel, ukuqeda okungaphezulu kungasebenza kuwo womabili amanani we-tabular namagrafu.
Indlela yoku-1: ukuphindaphindwa kwedatha ye-tabular
Okokuqala, sisebenzisa indlela engaphezulu kokuqukethwe ebangeni lethebula. Isibonelo, thatha itafula lapho kunezinombolo eziningi zokuphikisana (X) kusuka 5 ngaphambili 50 nochungechunge lwamanani wokusebenza ahambisanayo (f (x)). Sidinga ukuthola inani lomsebenzi wengxabano 55elingaphandle kochungechunge lwedatha olubekiwe. Ngalezi zinhloso sisebenzisa umsebenzi ISIVIVINYO.
- Khetha iseli okuzokhonjiswa kulo umphumela wokubala. Chofoza isithonjana "Faka umsebenzi", ebekwe emugqeni wamafomula.
- Iwindows liqala Umsebenzi Wizards. Iya esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi". Kuluhlu oluvulayo, sesha igama "PREDICTION". Uma usitholile, khetha bese uchofoza inkinobho "Kulungile" phansi kwewindi.
- Sithutha siye ewindini lokuphikisana lomsebenzi ongaphezulu. Inezimpikiswano ezintathu kuphela nenombolo ehambisanayo yezinkambu ukungena kwazo.
Ensimini "X" kufanele sikhombise ukubaluleka kwengxabano, umsebenzi okufanele silibale. Ungamane ushayela inombolo oyifunayo kusuka kukhibhodi, noma ungacacisa izixhumanisi zeseli uma ingxabano ibhaliwe ephepheni. Inketho yesibili iyakhetheka. Uma senza idiphozi ngale ndlela, khona-ke ukuze sibuke inani lomsebenzi kwenye impikiswano, akudingeki siguqule ifomula, kodwa kuzokwanela ukushintsha okokufaka kuseli ehambisanayo. Ukuze ukhombise izixhumanisi zalesi seli, uma ngabe kukhethwe indlela yesibili, kwanele ukubeka ikhesa enkambini ehambisanayo bese ukhetha lesi seli. Ikheli lakhe lizovela ngokushesha kuwindi wokuphikisana.
Ensimini Izindinganiso ezaziwayo kufanele uchaze lonke uhla lwamanani wokusebenza esinawo. Kuboniswa kukholamu. "f (x)". Ngakho-ke, sibeka isikhombisi enkambeni ehambisanayo bese ukhetha le kholamu yonke ngaphandle kwegama layo.
Ensimini Ama-x aziwayo wonke amanani wokuphikisana kufanele akhonjiswe, ahambelana namavelu womsebenzi wethulwe ngenhla. Le datha ikukholamu. x. Ngendlela efanayo nesikhathi esedlule, khetha ikholamu esiyidingayo kuqala ngokubeka isikhombisi emkhakheni wewindi lokuphikisana.
Ngemuva kokuthi yonke imininingwane ifakiwe, chofoza inkinobho "Kulungile".
- Ngemuva kwalezi zinyathelo, umphumela wesibalo ngokuqothula uzokhonjiswa kuseli eliqokonyiswe esigabeni sokuqala salo myalelo ngaphambi kokuqala Umsebenzi Wizards. Kulokhu, inani lomsebenzi wengxabano 55 okulinganayo 338.
- Uma, noma kunjalo, inketho ikhethwe ngokufakwa kwesixhumanisi esiseleni equkethe impikiswano oyifunayo, singakushintsha kalula bese sibheka inani lomsebenzi nganoma iyiphi enye inombolo. Isibonelo, inani lokucinga kwengxabano 85 balingane 518.
Isifundo: Umsebenzi Wizard e-Excel
Indlela 2: Ukuchithwa kwegrafu
Ungenza inqubo yokuncishiselwa kweshadi ngokwakha uhla lwenkambiso.
- Okokuqala, sakha uhlelo ngokwalo. Ukuze wenze lokhu, ngesikhombisi esiphethwe yinkinobho yegundane kwesobunxele, khetha yonke indawo yetafula, kufaka phakathi ukuphikisana namanani wokusebenza ahambisanayo. Ngemuva kwalokho, uye kuthebhu Fakachofoza inkinobho Ishadi. Lesi sithonjana sisebhlokini. Amashadi iribhoni yethuluzi. Uhlu lwezinketho ezikhona zeshadi liyavela. Sikhetha ezifanele kunazo zonke ngokubona kwethu.
- Ngemuva kokuthi igrafu yakhiwe, susa umugqa owengeziwe wokuphikisana kuyo, ukhethe bese uchofoza inkinobho Susa kukhibhodi yekhompyutha.
- Okulandelayo, kudingeka siguqule ukwahlukaniswa kwesilinganiso esisezingeni, njengoba kungakhombisi amanani ezinto eziphikisanayo, njengoba sizidinga. Ukuze wenze lokhu, chofoza ngakwesokudla eshadini nakuhlu oluvele, yeka "Khetha idatha".
- Ewindini elivulayo, khetha umthombo wedatha, chofoza inkinobho "Shintsha" ebhlokini lokuhlela ukusayinda kwe-eksisi evundlile.
- Kuvulwa iwindows yokusetha isisayino. Beka isikhombisi emkhakheni waleli windi, bese ukhetha yonke imininingwane yekholamu "X" ngaphandle kwegama laso. Bese uchofoza inkinobho "Kulungile".
- Ngemuva kokubuyela kuwindi lokukhetha imithombo yedatha, phinda inqubo efanayo, okungukuthi, chofoza inkinobho "Kulungile".
- Manje ishadi lethu selilungiselelwe futhi ungakwazi, ngokuqondile, ukuqala ukwakha umugqa wokuthambekela. Sichofoza kusheduli, emva kwalokho isethi ethile yamathebhu icushiwe ku iribhoni - "Ukusebenza namashadi". Hambisa kuthebhu "Isakhiwo" bese uchofoza inkinobho Umugqa Wendlela ebhlokini "Ukuhlaziywa". Chofoza entweni "Ukuqagela kwe-Linear" noma "Ukucacisa okucacisiwe".
- Umugqa wethenda ungeziwe, kepha ungaphansi komugqa weshadi ngokwayo, ngoba asikhombisanga inani lempikiswano okufanele ihlose kulo. Ukwenza lokhu futhi, chofoza inkinobho ngokulandelana Umugqa Wendlelakepha manje khetha "Ezinye izinhlaka zomugqa wethrendi".
- Iwindi lokufomatha umugqa wethenda liqala. Esigabeni Amathrendi Omugqa Wendlela kukhona block izilungiselelo "Isimo sezulu". Njengendlela eyedlule, ake sithathe impikiswano yokuphuma eceleni 55. Njengoba ukwazi ukubona, kuze kube manje igrafu inobude obungafika ekungqubuzeni 50 kuhlangene. Kuyavela ukuthi kuzodingeka ukuthi sikwandise okunye 5 amayunithi. On the axis ovundlile kubonakala ukuthi 5 amayunithi alingana ukwahlukaniswa esisodwa. Ngakho-ke le yinkathi eyodwa. Ensimini "Dlulisela ku-" faka inani "1". Chofoza inkinobho Vala ekhoneni elingezansi kwesokudla sewindi.
- Njengoba ukwazi ukubona, ishadi lalulwa ubude obucacisiwe kusetshenziswa umugqa wethenda.
Isifundo: Ungawakha kanjani umugqa wokuthambekela e-Excel
Ngakho-ke, sihlole izibonelo ezilula kakhulu zokwenziwa ngamatafula namagrafu. Esimweni sokuqala, umsebenzi uyasetshenziswa ISIVIVINYO, futhi kwesibili - umugqa wesitayela. Kepha ngokususelwa kulezi zibonelo, izinkinga ezibanzi kakhulu zokuqagela zingaxazululwa.
