Macewar aiki a fice

Kamar yadda kuka sani, Fif yana da kayan aiki da yawa don aiki tare da matrices. Ofayansu shine aikin muffer. Tare da wannan ma'aikaci, masu amfani suna bayyana matakai daban-daban. Bari mu gano yadda ake amfani da wannan fasalin a aikace, kuma menene babban abubuwan aiki tare da shi.

Yin amfani da kayan aiki na Muffer

Babban aikin mahaifiyar ta zo, kamar yadda aka ambata a sama, shine ninka matrices biyu. Yana nufin rukuni na masu aiki na lissafi.

Da syntax na wannan fasalin kamar haka:

= Uwa (Array1; Array2)

Kamar yadda muke gani, mai aiki yana da muhawara biyu kawai - "tsararren1 da" tsararru ". Kowane ɗayan muhawara alama ce ta ɗaya daga cikin matries, wanda ya kamata ya ninka. Wannan shine ainihin abin da ma'aikaci ya ayyana bisa.

Yanayi mai mahimmanci don aikace-aikacen aikace-aikacen shine cewa yawan kirtani na farkon matrix ya kamata ya yi daidai da yawan ginshiƙai na biyu. A cikin lamarin, za a bayar da kuskure a sakamakon aiki. Hakanan, don guje wa kuskure, babu ɗayan abubuwan duka abokan gaba su zama fanko, kuma dole ne su kunshi lambobi.

Matrix yayi yawa

Yanzu bari muyi la'akari da takamaiman misali, kamar yadda zaku iya ninka matrixes biyu, da amfani da ma'aikacin hoto.

1. Bude takardar mai kyau wanda aka riga aka samo matakai biyu. Muna haskaka yankin da sel mara amfani a kanta, wanda a kwance yana da daidaitattun adadin matrix na farko, kuma a tsaye yawan ginshiƙai na biyu matrix. Bayan haka, danna aikin "saka aiki" gunkin "wanda yake kusa da layin dabaru.



2. Wizard ɗin yana farawa. Yakamata mu je rukuni "lissafi" ko "cikakken jerin haruffa". A cikin jerin masu aiki, ya zama dole don nemo sunan "Muffer", mai ba da damar shi kuma danna maɓallin "Ok" a ƙasan wannan taga.



3. Tufafin muhawara na mai aiki mumbette an ƙaddamar. Kamar yadda muke gani, yana da fannoni biyu: "Array1" da "tsararru". A cikin farkon wanda ya samo daidaitattun matrix na farko, kuma a cikin na biyu, bi da bi, na biyu. Don yin wannan, saita siginan kwamfuta a filin farko. Sannan muna samar da matsa tare da maɓallin linzamin kwamfuta na hagu kuma zaɓi yankin da ƙwayoyin da ke ɗauke da matrix na farko. Bayan aiwatar da wannan hanya mai sauƙi, za a nuna masu daidaitawa a filin da aka zaɓa. Ana yin irin wannan aiki tare da filin na biyu, wannan lokacin, ta hanyar riƙe maɓallin linzamin kwamfuta na hagu, muna haskaka matrix na biyu.

   Bayan adiresoshin matriries an rubuta su, kar a hanzari ka latsa maɓallin "Ok", sanya shi a cikin ƙananan taga. Gaskiyar ita ce, muna ma'amala da aikin tsararru. Yana bayar da cewa ba a nuna sakamakon a cikin sel guda ba, kamar yadda ayyukan al'ada, amma kai tsaye zuwa kewayon gaba ɗaya. Saboda haka, a fitar da aikin sarrafa bayanai, ta amfani da wannan mai aiki, bai isa ba don latsa maɓallin Shigar, ko danna maballin da ake ciki yayin da a cikin gardamar da ake ciki a halin yanzu yake buɗe a yanzu. Kuna buƙatar amfani da latsa Ctrl + Shift + Shigar da key hade. Muna aiwatar da wannan hanyar, kuma "Ok" ba ya taɓa.



4. Kamar yadda muke gani, bayan an ƙayyade haɗewar keyboard ɗin, mahimman hujjojin maganganun maganganu, an rufe a rufe a farkon sel, wanda muka sanya shi da bayanai. Wadannan dabi'u ne sakamakon ci gaba da rage matrix zuwa wani, wanda yayi aikin hoto. Kamar yadda muke gani, a cikin tsari na dabara, ana ɗaukar aikin a cikin bracks, wanda ke nufin nasa ga masu aiki.



5. Amma daidai ne cewa sakamakon aiwatar da aikin zuwa Mums tsararre ne, yana hana ƙarin canjinsa idan ya cancanta. Lokacin da kayi kokarin canza kowane lambar sakamako na karshe na mai amfani, zai jira saƙo wanda ya sanar da cewa bashi yiwuwa a canza bangare na tsararru. Don kawar da wannan rashin damuwa da kuma sauya sassauƙa zuwa mahaɗan bayanan bayanai waɗanda zaku iya aiki, gudanar da matakan masu zuwa.

   Muna haskaka wannan kewayon kuma, yayin da a cikin gida shafin, danna kan "kwafin" wato, wanda yake musayar kayan aiki "musayar ku. Hakanan, maimakon wannan aikin, zaku iya amfani da maɓallin Ctrl + c.



6. Bayan haka, ba tare da cire zaɓin daga kewayon ba, danna kan shi tare da maɓallin linzamin kwamfuta na dama. A cikin menu na menu a cikin "saka saitunan" toshe, zaɓi abubuwan "dabi'un".



7. Bayan aiwatar da wannan aikin, ba za a sake gabatar da matrix na karshe a matsayin kewayon yanki ba kuma ana iya yin shi da magidanta daban-daban.

Darasi: Yi aiki tare da Arrays a Excel

Kamar yadda kake gani, ma'aikacin Mumin yana ba ku damar sauri da sauri a cikin matricies biyu akan juna. Syntax na wannan aikin abu ne mai sauki sosai kuma masu amfani kada su sami matsaloli tare da shigar da bayanai a cikin taga. Matsalar kawai da zata iya faruwa yayin aiki tare da wannan ma'aikacin ya kasance a cikin gaskiyar cewa yana wakiltar aikin abubuwan da aka tsara, sabili da haka yana da wasu fasali. Don nuna sakamakon, ya zama dole don pre-Zaɓi da yawaitar da ya dace a kan takarda, sannan kuma bayan shigar da mahimmin haɗin, amfani da don aiki tare da irin wannan nau'in - Ctrl + Shiga.