Excel 2007. Ukuthola izixazululo Excel 2007

Solver Excel 2007 akuyona ejwayelekile. It yenzelwe izibalo eziyinkimbinkimbi, uma kukhona angaphezu kwelilodwa engaziwa. Ngakho-ke, it is hhayi kufakwe afanayo evamile ongakhetha hlelo. Kodwa uma udinga it ngalesosikhathi it uyakwazi ukunikeza umsebenzisi isebenza ngendlela efanele futhi ukhiqizwe kakhulu.

Kuyini ukufuna amakhambi?

Ukuthola izixazululo Excel 2007 wuhlelo isengezo e. Lokhu kusho ukuthi ukuhlelwa ejwayelekile, ekhiqizwa ngumkhiqizi, lokhu iphakethe ayifakiwe. Kufanele ukulayishwa futhi ngokuhlukile. Iqiniso liwukuthi abasebenzisi eningi engayithandi ke. Futhi sengezo uvame ukubizwa ngokuthi 'Solver ", ngoba uyakwazi ukugcina izibalo ezinembile futhi esheshayo, ngokuvamile kungakhathaliseki ukuthi sinzima kangakanani umsebenzi othulwe wakhe.

Uma inguqulo-Microsoft Office iyona yokuqala, ke nezinkinga ukufakwa ngeke kwenzeke. Umsebenzisi idinga ukwenza izinguquko eziningi:

Izilungiselelo → Amathuluzi → Izengezo → Management → Engeza-Ins Excel.

Lokhu kuvula ifasitela lapho kukhona inkinobho Eqa. Ngemva ngokuchofoza kuyo izoveza uhlu zonke ezihlongozwayo izengezo ezifakiwe, futhi ubuningi. Manje udinga ukuthola ukufuna amakhambi, khona-ke wabeka uphawu isheke. Ithuluzi icushiwe, ungasebenzisa noma nini.

Kungani ngidinga sesixazululi?

Ongakwenza ukucinga izixazululo Excel 2007, nokuthi kubalulekile ukuyifaka? Uma umsebenzisi likhona umsebenzi umgomo, okuyinto incike nemingcele amaningana superstructure khetha inkinga izixazululo ngokuhambisana idatha yoqobo. Phakathi lezi zingase zibe ngezomuntu variable noma engaziwa, ezifana ukubaluleka kokugcina. Okungukuthi, umsebenzisi abe nezici kokuqala impendulo, futhi isofthiwe ngeke akhethe inkambo izixazululo, ukuhlinzeka ifomula.

Ngakho-ke, superstructure ingatholakala:

• Ukusatshalaliswa ngempumelelo izinsiza zokusebenza, ukuze kuzuzwe inzuzo esiphezulu kusukela imisebenzi inkampani noma umnyango ngamunye, igatsha.
• Ukusatshalaliswa ukutshalwa nge izingozi lincane.
• Ekuxazululeni izinkinga, lapho kukhona angaphezu kwelilodwa engaziwa (siyonikwa izimpendulo kungenzeka eziningana, lapho umsebenzisi ngokwakhe uyoba ukhethe ezifanele kakhulu).
• Ukulondoloza kanye ukulayisha izixazululo imodeli. Inketho engcono abasebenzi bephoqeleka ukuba njalo ukushintsha kukhompyutha noma i-laptop.
• Isixazululo ezinkingeni eziningana eziguquguqukayo ezahlukene, angaziwa, amafomula integrals.

Uhlelo yithuba elikhulu, kodwa kubalulekile ukuba ufunde indlela yokusebenzisa kahle.

Kanjani Solver?

Ngaphezu sesixazululi Excel has a umsebenzi njengoba ipharamitha Ukukhetha. Kunconywa ukuba isetshenziswe ezimweni lapho kukhona ukubaluleka engaziwa eyodwa kuphela. Lesi sici zohlelo kudinga ingasaphathwa ikhompyutha isisetshenziswa izindleko, ngakho uyonika yi ngokushesha.

izixazululo Ukuthola Excel 2007 isetshenziselwa imisebenzi eyinkimbinkimbi kakhulu, lapho kukhona eziguquguqukayo eziningana engaziwa ngokuvamile zenzeka. Esikhathini isitatimende jikelele kungenziwa kanje:

1. Thola esingaziwa → «x».
2. Kuncike ifomula noma umsebenzi →.
3. → Lapho imingcele ngokuvamile wabonisa ukungalingani, noma okungenani / amagugu esiphezulu.

Kudingeka nokuba ukhombise iseli okuyinto ukubala kufanele sigcwaliswe. Kukhona kungenzeka ukuxazulula imisebenzi eminingana ehlukene, uma uzibekela izilungiselelo uhlelo okuhlobene.

Ukubeka Izinketho zosesho ekwenziweni

Ukuthola izixazululo umsebenzi Excel 2007 wasebenza njengoba izidingo umsebenzisi, udinga ukufaka amasethingi afanele. basuke ngokuvamile kungagcini 1-3 ukusebenza, kodwa ngaphezulu imisebenzi eyinkimbinkimbi adinga izilungiselelo zomhlaba.

Ukucinga ongakhetha Office Excel 2007 amakhambi e-software kungaba kanje:

• Linanikhulu lesikhatsi - isibalo imizuzwana ukuthi umsebenzisi ukukhethela isinqumo hlelo. It kuncike yinkimbinkimbi inkinga.
• Inombolo enkulu nokuhlanganisa. Lena yinombolo uhamba, okwenza uhlelo endleleni eya yokuxazulula le nkinga iyabheda. Uma luyanda, impendulo ingemukelwa.
• Ukunemba noma ukunemba, uvame esetshenziswa ikhambi aya (isib 0.0001).
• Ukubekezelelana. Isetshenziswa uma usebenza nge amaphesenti.
• Amanani Non-negative. Kwakuvamise lapho umsebenzi kufinyelelwa ngezimpendulo ezimbili lesifanele (isib +/- X).
• Ibonisa umphumela ukuhlanganiswa. Le sethingi icacisa uma umphumela izixazululo hhayi kuphela ezibalulekile kodwa inkambo yabo.
• Ukucinga Indlela - Ukukhetha nokwenza algorithm. "Indlela Newton" ngokuvamile lisetshenziselwa.

Uma wonke amasethingi akhethiwe, qiniseka ukuchofoza inkinobho yokulondoloza.

Amapharamitha umsebenzi kule izixazululo search umsebenzi

Ukusebenza superstructure ezifana izixazululo yokusesha Excel, kwenziwe ngokuhambisana ukubala esithile. Into ebaluleke kakhulu lezi iyona ndlela. Kunezinhlobo ezimbili ezahlukeneyo wabo. "Indlela Newton" kufana nokuzikhandla Ukulungiselelwa okuzenzakalelayo. Uyakwazi ukusebenza imemori eningi, kodwa ukuhlanganiswa kancane. Ngakho-ke, kungenye into ehluke kakhulu efanelekayo zibalo eziyinkimbinkimbi kakhulu standard hhayi.

"Conjugate wesilinganiso Indlela" njengoba. Lapha kucelwa inkumbulo kancane, kodwa kudinga ukuhlanganiswa ngaphezulu. Ngakho-ke, uma usebenzisa wona ungakwazi ukuxazulula zibalo kunzima kakhulu ukusebenzisa amafomula emikhulu kanye nemisebenzi.

Ifomula Excel

Kukhona isici saziso, ngaphandle okuyinto ke ayikwazi ukusebenza Solver add-e Excel Uhlelo 2007 - ifomula. Zimelela isisho wenza ukucabanga ethile. Ngaphandle ukulingana akukho ifomula. Ngakho-ke, lolu hlelo kungaqali ukuqaphela ezinjalo, uma kungekho uphawu okuhambisanayo.

Ifomula phakathi okulandelayo:

1. Umsebenzi. Lena indlela ejwayelekile, lapho kukhona Yiqiniso esiqondile ezithile isinyathelo, okuyinto ayikwazi ukushintshwa.
2. Xhumanisa. Ikhombisa inani lamaseli ukuthi okudingeka sizilungise. Kulokhu, amaseli zingahlelwa ngezikhathi noma ukuze.
3. Operator. Liluphawu ecacisa uhlobo ukubala (+ - kwalokho, * - ukubuyabuyelela, njll).
4. Njalo. Inani njalo ukuthi akashintshi. Futhi, ukuthola akudingekile ukwenza izibalo.

Isixazululo amafomula kusuka kwesokunxele kuya kwesokudla uma yonke imithetho zezibalo.

Ukudala ifomula

Amafomula kukhona zibalo anomthelela ukuqaliswa izibalo hlelo. Uma lezi ungafaki, ngeke agijime lo Solver Excel. Imisebenzi, ngokulandelana, futhi ngeke ixazululwe. Ngakho-ke, ukugcwaliseka ngempumelelo imisebenzi kufanele ufake ifomula lesifanele.

Ukubalwa iqala ngokukhuphuka setshwayo. Ngokwesibonelo, uma iseli kuboniswa "= IYAHLUMA (inombolo cell)", umsebenzi okuhambisanayo isetshenziswa.

Uma ifomula eziyisisekelo uphawu "=" iye yanyatheliswa, kubalulekile ukuba aveze idatha nge ngalo basebenzisane. Kungaba amaseli eyodwa noma ngaphezulu. Uma ifomula kufanelekile amaseli 2-3, kungenzeka ukuhlanganisa kubo usebenzisa uphawu "+" le.

Ukuze uthole ulwazi, ungasebenzisa umsebenzi search. Ngokwesibonelo, uma kudingeka ifomula incwadi «A» ke kubalulekile ukuba ucacise futhi. Khona-ke umsebenzisi siyonikwa ukuze yonke idatha sihilela.

isiphetho

Ekuphetheni, Excel 2007, udinga ukulondoloza isethi nemingcele zokuxazulula izinkinga. Ungenza lokhu ngezindlela eziningana. Inguqulo esezingeni ngokuchofoza inkinobho ohambelana izosebenza uma kwenzeka ukuthi indlela yokubala isetshenziselwa yonke idatha.

Lapho kubalulekile ukuba uxazulule izibalo eziningana, isibonelo, ukuthola umsebenzi minimum futhi esiphezulu, udinga ukulondoloza, akuzona zonke ukubala, futhi model yayo. Khona-ke umsebenzisi uzokwazi ukusebenzisa ukuba isinqumo esithile.