U-Excel wenza izibalo ezahlukahlukene ezihlobene nedatha ye-matrix. Uhlelo lubacubungula njengobubanzi beseli, lusebenzisa amafomula afanayo kubo. Enye yalezi zenzo ukuthola i-matrix ephikisanayo. Ake sibheke ukuthi yini i-algorithm yale nqubo.
Ukuhlaliswa phansi
Ukubalwa kwe-matrix okungafani ku-Excel kungenzeka kuphela uma i-matrix eyinhloko isikwele, okungukuthi, inani lemigqa namakholomu kuyo. Ngaphezu kwalokho, isikhombisi saso akufanele silingane no-zero. Umsebenzi we-array usetshenziselwa ukubala MOBR. Ake sibheke ukubalwa okufanayo ngokusebenzisa isibonelo esilula.
Ukubalwa kwesikhombisi
Okokuqala, sibala isichasiselo ukuze siqonde ukuthi ububanzi obuyinhloko bunayo i-matrix ephambene noma cha. Leli nani libalwa kusetshenziswa umsebenzi KUPHELILE.
- Khetha noma isiphi iseli elingenalutho eshidini lapho kuzobukiswa khona imiphumela yokubala. Chofoza inkinobho "Faka umsebenzi"ibekwe eduze kwebha yefomula.
- Kuqala Isici Wizard. Uhlu lwamarekhodi amelele, silufuna KUPHELILE, khetha le nto bese uchofoza inkinobho "Kulungile".
- Iwindi lokuphikisana liyavula. Faka ikhesa endle Array. Khetha lonke uhla lwamaseli lapho i-matrix itholakala khona. Ngemuva kokuthi ikheli lakhe livele enkundleni, chofoza inkinobho "Kulungile".
- Uhlelo lubala inani. Njengoba ubona, ngecala lethu elithile lilingana no - 59, okungukuthi, alifani ne-zero. Lokhu kusivumela ukuthi sithi le matrix inehlukile.
Ukubalwa kwe-matrix okungafani
Manje ungaqhubeka ekubalweni okuqondile kwe-matrix ephambene.
- Khetha iseli okufanele libe iseli elingaphezulu kwesobunxele se-matrix ephambene. Iya ku Isici Wizardngokuchofoza isithonjana ngakwesokunxele sebha yefomula.
- Kuluhlu oluvulayo, khetha umsebenzi MOBR. Chofoza inkinobho "Kulungile".
- Ensimini Array, iwindi lokuphikisana komsebenzi liyavula, setha ikhesa. Hlukanisa lonke uhla oluyinhloko. Ngemuva kokuvela kwekheli lakhe enkundleni, chofoza inkinobho "Kulungile".
- Njengoba ubona, inani lavela kuseli elilodwa kuphela lelo formula lalikuyo. Kepha sidinga ukusebenza okuphelele kokubuyela emuva, ngakho-ke kufanele silingise ifomula kwamanye amaseli. Khetha ibanga elilingana ngokuvundlile nangokuqondile ngokuhlelweni lwedatha yoqobo. Chofoza ukhiye wokusebenza F2, bese ushayela inhlanganisela I-Ctrl + Shift + Faka. Yinhlanganisela yakamuva eklanyelwe ukuphatha ama-array.
- Njengoba ubona, ngemuva kwalezi zenzo, i-matrix ephikisanayo ibalwa kumaseli akhethiwe.
Kulesi sibalo kungabhekwa njengokuqediwe.
Uma ubala inani elichazayo ne-matrix elingafani kuphela ngepeni nephepha, khona-ke kulesi sibalo, esimeni sokusebenza kwisibonelo esiyinkimbinkimbi, ungadonsa isikhathi eside kakhulu. Kepha, njengoba ubona, ohlelweni lwe-Excel, lezi zibalo zenziwa ngokushesha okukhulu, noma ngabe umsebenzi unzima kangakanani. Kumuntu ojwayelene ne-algorithm yokubala okunjalo kulolu hlelo lokusebenza, ukubalwa konke kwehlela ezenzweni ezenziwe ngomshini.