Kunesimo lapho kuhlu lwamanani owaziwayo udinga ukuthola imiphumela ephakathi. Kumathematics, lokhu kubizwa ngokuthi ukuguqulwa. Ku-Excel, le ndlela ingasetjenziswa kokubili idatha ye-tabular kanye ne-graphing. Sizohlaziya ngayinye yalezi zindlela.
Kusetshenziswa ukutolika
Isimo esiyinhloko lapho ukuhumusha kungasetjenziswa khona ukuthi inani elifunayo kufanele libe ngaphakathi kokuhlelwa kwedatha, futhi lingadluleli ngaphezu komkhawulo walo. Isibonelo, uma sinesethi yezimpikiswano 15, 21, no-29, lapho-ke lapho sithola umsebenzi wokuphikisana 25, singasebenzisa ukutolika. Futhi ukucinga inani elihambisanayo lokuphikisana 30, akusekho lapho. Lokhu ngumehluko omkhulu phakathi kwale nqubo nokuqanjwa kabusha.
Indlela yoku-1: ukutolika ngemininingwane ye-tabular
Okokuqala, cabanga ngokusetshenziswa kokuhumusha imininingwane etholakala etafuleni. Isibonelo, sithatha uhlu lwezimpikiswano namanani wokusebenza ahambisanayo, ubudlelwano babo bungachazwa yi-equation eqondile. Le mininingwane ibekwe etafuleni elingezansi. Sidinga ukuthola umsebenzi ofanele wokuphikisana 28. Indlela elula yokwenza lokhu nge-opharetha. ISIVIVINYO.
- Khetha noma isiphi isitokisi esingenalutho eshidini lapho umsebenzisi ahlela ukubonisa umphumela wezenzo ezithathiwe. Okulandelayo, chofoza inkinobho. "Faka umsebenzi", etholakala kwesobunxele sebha yefomula.
- Iwindows liyasebenza Umsebenzi Wizards. Esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi" ngifuna igama "PREDICTION". Ngemuva kokuthi inani elihambelanayo selitholiwe, likhethe bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyaqala ISIVIVINYO. Inezici ezintathu:
- X;
- Izindinganiso ezaziwayo;
- Ama-x aziwayo.
Ensimini yokuqala, sidinga nje ukufaka ngesandla amanani wokuphikisana kusuka kukhibhodi, umsebenzi okufanele utholakale. Kithi, lokhu 28.
Ensimini Izindinganiso ezaziwayo udinga ukucacisa izixhumanisi zobubanzi bethebula eliqukethe amanani womsebenzi. Lokhu kungenziwa ngesandla, kepha kulula kakhulu futhi kulula kakhulu ukusetha ikhesa endle bese ukhetha indawo ehambisanayo ephepheni.
Ngokufanayo kusethwe enkundleni Ama-x aziwayo uhla luxhumanisa nokuphikisana.
Ngemuva kokuthi yonke imininingwane edingekayo ifakiwe, chofoza inkinobho "Kulungile".
- Ivelu yomsebenzi oyifunayo izoboniswa kuseli esikukhethile kusinyathelo sokuqala sale ndlela. Umphumela uyinombolo 176. Kuzoba umphumela wenqubo yokutolika.
Isifundo: I-Excel Feature Wizard
Indlela 2: hlanganisa igrafu usebenzisa izilungiselelo zayo
Inqubo yokutolika ingasetshenziswa futhi lapho kuhlelwa imisebenzi. Kuyafaneleka uma ithebula ngesisekelo okwakhelwe kulo igrafu alibonisi inani elihambisanayo lomsebenzi kwenye yezimpikiswano, njengasesithombeni esingezansi.
- Sihlela ukusebenzisa indlela ejwayelekile. Lokho wukuthi, kuthebhu Faka, khetha uhla lwethebula ngesisekelo okwenziwe ngalo ukwakhiwa. Chofoza isithonjana Ishadiibekwe kwibhulokhi yamathuluzi Amashadi. Kuluhlu lwamagrafu avelayo, sikhetha lena esicabanga ukuthi ilungile kakhulu kulesi simo.
- Njengoba ubona, uhlelo lwakhiwa, kepha hhayi ngendlela esifuna ngayo. Okokuqala, kwephulwe, ngoba ngokuxabana okukodwa umsebenzi ohambelana nawo awutholakalanga. Okwesibili, kukhona umugqa owengeziwe kuwo X, okuthi kulokhu akudingeki, futhi naku-eksisi elivundlile ngamaphuzu nje ngokulandelana, hhayi inani lempikiswano. Ake sizame ukulungisa konke lokhu.
Okokuqala, khetha umugqa oqinile ohlaza okwesibhakabhaka ofuna ukuwususa bese uchofoza inkinobho Susa kwikhibhodi.
- Khetha yonke indiza ebekwe kuyo ishadi. Kumenyu yokuqukethwe evela, chofoza inkinobho "Khetha idatha ...".
- Iwindi lokukhetha imithombo yedatha liqala. Ebhlokini elungile Amasiginesha axis ovundlile chofoza inkinobho "Shintsha".
- Iwindi elincane liyavula lapho udinga ukucacisa izixhumanisi zobubanzi, amanani azokhonjiswa kuzo esikalini eli-axis elivundlile. Setha isikhombisi esigangeni I-Axis Label Range bese ukhetha indawo ehambelana ephepheni, equkethe izimpikiswano zomsebenzi. Chofoza inkinobho "Kulungile".
- Manje kufanele siqedele umsebenzi osemqoka: ukususa igebe kusetshenziswa ukutolika. Ukubuyela ewindini lokukhetha ibanga ledatha, chofoza inkinobho Amaseli afihliwe angenaluthoetholakala ekhoneni elingezansi kwesobunxele.
- Iwindi lezilungiselelo zamaseli afihlekile angenalutho liyavuleka. Ipharamitha Khombisa amaseli angenalutho beka inkinobho eshintshiwe "Umugqa". Chofoza inkinobho "Kulungile".
- Ngemuva kokubuyela kuwindi lokukhetha umthombo, qinisekisa lonke ushintsho olwenziwe ngokuchofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, igrafu iyalungiswa, negebe elisebenzisa ukutolika liyasuswa.
Isifundo: Ungahlela kanjani e-Excel
Indlela 3: hlanganisa igrafu usebenzisa umsebenzi
Ungase futhi uhumushe igrafu usebenzisa umsebenzi okhethekile ND. Ibuyisa amanani angachazwanga kuseli elicacisiwe.
- Ngemuva kokuthi ishadi lenziwe futhi lihlelwe, njengoba udinga, kufaka nokubekwa okufanele kwesiginesha, ungavala kuphela igebe. Khetha iseli elingenalutho etafuleni lapho imininingwane idonswa khona. Chofoza isithonjana esivele sisazi "Faka umsebenzi".
- Iyavula Isici Wizard. Esigabeni "Ukuqinisekisa Izakhiwo Namanani" noma "Uhlu oluphelele lwe-alfabhethi" thola bese uqokomisa ukungena "ND". Chofoza inkinobho "Kulungile".
- Lo msebenzi awunangxabano, njengoba kubikwa iwindi lolwazi elivelayo. Ukuyivala, vele uchofoze inkinobho "Kulungile".
- Ngemuva kwalesi senzo, inani lephutha livele kuseli elikhethiwe "# N / A", kodwa-ke, njengoba ubona, ikhefu ohlelweni lwasuswa ngokuzenzakalelayo.
Kungenziwa lula ngisho nangaphandle kokuqala Isici Wizard, kodwa vele usebenzise ikhibhodi ukushayela inani kuseli engenalutho "# N / A" ngaphandle kwezingcaphuno. Kepha sekuncike ekutheni imuphi umsebenzisi olungele ukwedlula zonke.
Njengoba ukwazi ukubona, ohlelweni lwe-Excel, ungatolika njengedatha ye-tabular usebenzisa umsebenzi ISIVIVINYO, kanye nemidwebo. Endabeni yokugcina, lokhu kungenzeka usebenzisa izilungiselelo zesheduli noma usebenzisa umsebenzi Ndkudala iphutha "# N / A". Ukuzikhethela kokuthi iyiphi indlela yokusebenzisa kuncike kwisitatimende senkinga, nasekuthandweni komuntu siqu.
