Kuskuren Matsaran da ke cikin Microsoft Excel

Excel yayi nau'in lissafi da ya danganci bayanai na matrix. Shirin yana tafiyar da su a matsayin kewayon kwayoyin halitta, yana amfani da matakan tsararraki zuwa gare su. Ɗaya daga cikin waɗannan ayyuka shine gano matrix mara kyau. Bari mu gano menene algorithm na wannan hanya.

Yin lissafi

Kira na matrix mara kyau a cikin Excel zai yiwu ne kawai idan matrix na farko shi ne square, wato, yawan layuka da ginshiƙai a ciki iri ɗaya ne. Bugu da ƙari, ƙayyadewar bai zama ba kome ba. Ana amfani da aikin tsararra don lissafi. MOBR. Bari muyi la'akari da lissafi irin wannan ta hanyar amfani da misali mafi sauki.

Kirar mai ƙayyadewa

Da farko, bari mu lissafta mai ƙayyade domin mu fahimci ko matakan farko na da nauyin matsala ko a'a. An kiyasta darajar ta amfani da aikin SANTA.

1. Zaɓi kowane ɗakin maras amfani a kan takardar, inda za'a nuna sakamakon sakamakon lissafi. Muna danna maɓallin "Saka aiki"sanya a kusa da wannan tsari bar.



2. Fara Wizard aikin. A cikin jerin sunayen da ya wakilta, muna neman MOPREDzaɓi wannan abu kuma danna maballin "Ok".



3. Maganin gardama ya buɗe. Sa siginan kwamfuta a filin "Array". Zaɓi dukkanin jinsunan da aka samo matrix. Bayan da adireshinsa ya bayyana a fagen, danna maballin "Ok".



4. Shirin ya ƙayyade ma'auni. Kamar yadda muka gani, saboda shari'armu daidai yake da - 59, wato, ba daidai ba ne da sifilin. Wannan yana ba ka damar faɗi cewa wannan matrix yana da rikici.

Matsalar matrix ba daidai ba

Yanzu za mu iya ci gaba zuwa lissafin kai tsaye na matrix mara kyau.

1. Zaɓi tantanin halitta, wanda ya zama babban hagu na hagu na matrix mara kyau. Je zuwa Wizard aikinta latsa icon zuwa gefen hagu na tsari.



2. A cikin jerin da ya buɗe, zaɓi aikin MOBR. Muna danna maɓallin "Ok".



3. A cikin filin "Array", daftarwar gardamar aikin da ta buɗe, saita siginan kwamfuta. Zaži dukan jeri na farko. Bayan bayyanar adireshinsa a fagen, danna maballin "Ok".



4. Kamar yadda kake gani, darajar ta bayyana ne kawai a cikin tantanin halitta daya wanda akwai wata maƙira. Amma muna buƙatar aiki mai banƙyama, saboda haka ya kamata mu kwafin dabarun zuwa wasu kwayoyin. Zaži kewayon da ke daidaitawa a fili kuma a tsaye zuwa ainihin jigilar asali. Mun danna kan maɓallin aiki F2sa'an nan kuma rubuta haɗin Ctrl + Shigar + Shigar. Yana da haɗin haɗin da ake amfani dashi don aiwatar da kayan aiki.



5. Kamar yadda kake gani, bayan waɗannan ayyukan, ana lissafta matrix mara kyau a cikin sel da aka zaɓa.

A wannan lissafin za'a iya la'akari da cikakken.

Idan kuna lissafta ma'auni da matakan da ba tare da haɓaka ba kawai tare da alkalami da takarda, to, zaku iya tunani game da wannan lissafi, idan kunyi aiki akan misalin misalin, don dogon lokaci. Amma, kamar yadda muka gani, a cikin shirin na Excel, waɗannan lissafin suna da sauri sosai, ba tare da la'akari da ƙwarewar aikin ba. Ga mutumin da ya saba da algorithm na irin wannan lissafi a cikin wannan aikace-aikacen, an ƙidaya dukan lissafi zuwa ayyukan ƙira.