Umsebenzi umama kwi-Excel

Njengoko uyazi, i-Excel ineezixhobo ezininzi zokusebenza namatriki. Omnye wabo ngumsebenzi we-muffier. Ngomsebenzi, abasebenzisi babonakala ngathi baphindaphinde imatriki ezahlukeneyo. Masifumanise ukuba ungayisebenzisa njani eli nqaku, kwaye yeyiphi eyona nto iphambili yokusebenza nayo.

Sebenzisa uMqhubi weMuffite

Owona msebenzi ophambili wemama uza, njengoko kuchaziwe apha ngasentla, kukwaphindaphinda iimatriki ezimbini. Ibhekisa kudidi lwabaqhubi bezibalo.

I-syntax yeli nqaku yile ilandelayo:

= Umama (uluhlu1; uluhlu2)

Njengoko sibona, umqhubi unempikiswano ezimbini kuphela - "uluhlu1" kunye "norray". Impikiswano nganye ibhekisela kwimatriki, ekufuneka iphindaphindeke. Yile nto kanye le nto ichazwe apha ngasentla.

Imeko ebalulekileyo yokusetyenziswa kwe-mums kukuba inani lemitya yeMatrix yokuqala kufuneka ihambelane nenani leekholamu zesibini. Kwimeko echaseneyo, kuya kukhutshwa impazamo njengesiphumo sokulungiswa. Kananjalo, ukwenzela ukuthintela impazamo, akukho nto yazo yomibini kufuneka ibonakale, kwaye kufuneka iqulekele inani lamanani.

Ukuphindaphinda iMatrix

Ngoku masiqwalasele umzekelo othile, njengoko unokuphindaphinda amatriki amabini, asebenzisa umsebenzi weMuffite.

1. Vula iphepha le-Excel apho i-matric matric sele ikhona. Sibalaselisa indawo yeeseli ezingenanto kuyo, ethi the tye ekubonakaleni kwawo inani lemitya yematriki yokuqala, kwaye ngokuthe nkqo inani leekholamu zeMatrix yesibini. Okulandelayo, sicofa kwi "fack umsebenzi" we-icon, ethathwa kufutshane nomgca wefomula.



2. I-wizard ye-Wizard iqala. Kuya kufuneka siye kudidi "lweMathematics" okanye "Uluhlu olupheleleyo lwe-alfabhethi". Kuluhlu lwabasebenzi, kuyimfuneko ukufumana igama "Muffide", lixabise kwaye ucofe iqhosha "Kulungile", elikwezantsi kule festile.



3. Ifestile yeempikiswano zomsebenzi oPhakathisiweyo. Njengoko sibona, sinamasimi amabini: "Uluhlu1" kunye "norray". Kobokuqala kufuneka bachaze ukulungelelaniswa kweMatrix yokuqala, kwaye okwesibini, ngokwahlukeneyo. Ukuze wenze oku, setha isikhombisi kwicandelo lokuqala. Emva koko sivelisa inkqwitha ngeqhosha lasekhohlo lemouse kwaye ukhethe indawo yeeseli eziqulathe iMatrix yokuqala. Emva kokwenza le nkqubo ilula, izinxibelelanisi ziya kuboniswa kwicandelo elikhethiweyo. Inyathelo elifanayo liqhutywa nentsimi yesibini, kuphela ngeli xesha, ngokubamba iqhosha lemouse lasekhohlo, sibalaselisa iMatrix yesibini.

   Emva kweedilesi zombini ezirekhodiweyo, musa ukungxama ukucinezela iqhosha "Kulungile", ibekwe kwindawo engezantsi yefestile. Inyani yile yokuba sisebenzisana nomsebenzi woluhlu. Inika ukuba iziphumo aziboniswanga kwiseli enye, njengakwimisebenzi eqhelekileyo, kodwa kwangoko kuluhlu olupheleleyo. Ke ngoko, ukukhupha inkqubela phambili yedatha, ukusebenzisa lo msebenzi, akwanele ukucinezela iqhosha lokungena, ukubeka isikhombisi kwiqhosha lefomula, okanye cofa kwifestile yempikiswano yomsebenzi ovulekileyo ngoku ngelo xesha. Kuya kufuneka ufake isicelo sokucinezela i-CTRL + Shift Shift + Ngenisa indibaniselwano yesitshixo. Senza le nkqubo, kwaye iqhosha "Kulungile" alichukumisi.



4. Njengoko sibona, emva kokucinezela ukudityaniswa kwekhibhodi echaziweyo, impikiswano yempikiswano yomqhubi, i-Mumset ivaliwe, kunye noluhlu lweeseli, esalinikwe kwinyathelo lokuqala lalo myalelo, lazaliswa yidatha. La maxabiso esiba sisiphumo sokuphindaphinda imatrix kwenye, eyenze umqhubi weMuffite. Njengoko sibona, kumqolo wefomula, umsebenzi uthathwe kwizibiyeli ezigobileyo, okuthetha ukuba zingabaqhubi beenkonzo.



5. Kodwa ngokuchanekileyo ukuba isiphumo sokwenza umsebenzi kwi-mums luphango oluqinileyo, luthintela utshintsho olungaphezulu ukuba luyimfuneko. Xa uzama ukutshintsha nawaphi na amanani esiphumo somsebenzisi, kuya kuba silinde umyalezo owazisa ukuba akunakwenzeka ukutshintsha indawo yoluhlu. Ukuphelisa oku kuphazamiseka kwaye uguqule uluhlu olungaguqukiyo kuluhlu oluqhelekileyo lwedatha onokuthi usebenze ngayo, yenza la manyathelo alandelayo.

   Sibonisa olu luhlu kwaye, ngelixa kwithebhu yasekhaya, cofa kwi-Icon "Khuphela" i-icon, ethengisa i-buffer "yesixhobo". Kwakhona, endaweni yalo utya, ungayisebenzisa i-CTRL + iseti ye-CTRL.



6. Emva koko, ngaphandle kokususa ukhetho ukusuka kuluhlu, cofa kuyo ngeqhosha lasekunene lemouse. Kwimenyu yomxholo ovulekileyo kwi "Useto lokufaka", khetha eyona nto "yexabiso".



7. Emva kokwenza le ntshukumo, iMatrix yokugqibela ayisayi kuphinda ibonakaliswe njengoluhlu olunye lwe-intextive kwaye lunokwenziwa ngenkuthalo eyahlukeneyo.

Isifundo: Sebenza ngokusebenzisa i-Excel

Njengoko ubona, umqhubi we-mum uvumela ukuba ukhawuleze kwaye uphindeke ngokulula kwi-Excel Matric Try omnye komnye. I-syntax yalo msebenzi ilula kwaye abasebenzisi akufuneki babe neengxaki zokungena kwi-windord yempikiswano. Eyona ngxaki inokwenzeka xa usebenza nalo msebenzi ulele kwinto yokuba imele umsebenzi woluhlu, kwaye ke ineempawu ezithile. Ukubonisa isiphumo, kuyimfuneko ukuba ukhethe uluhlu oluthe kratya ephepheni, emva koko lungenise indibaniselwano ephambili, yenzelwe ukusebenza ngohlobo olunjalo lwedatha - i-SPRL + ingena.