Aikace-aikacen MUMINOG a cikin Microsoft Excel

Kamar yadda kuka sani, Excel yana da kayan aiki da yawa don aiki tare da matrices. Ofayansu shine aikin MUMNOSE. Amfani da wannan mai amfani, masu amfani suna da damar da za su ninka lambobi da yawa. Bari mu gano yadda za mu iya amfani da wannan aikin a aikace, kuma menene manyan abubuwa na aiki da shi.

Yin amfani da injin MUMNOZH

Babban maƙasudin aikin MULKINkamar yadda muka ambata a sama, shine adadin matrices biyu. Ya kasance ga rukuni na manajan lissafi.

Ginin kalma na wannan aikin kamar haka:

= MULKI (array1; array2)

Kamar yadda kake gani, mai aikin yana da hujja biyu ne kawai - "Array1" da Shirya2. Kowane ɗayan huɗan jigo ne ga ɗayan matrices, waɗanda ya kamata a ninka. Wannan shi ne ainihin abin da mai aiki na sama ke yi.

Kyakkyawan yanayin don aikace-aikace MULKIN shine cewa adadin layuka a farkon matrix dole ne ya dace da adadin ginshiƙai a cikin na biyu. In ba haka ba, za a haifar da kuskure sakamakon aiki. Hakanan, don guje wa kurakurai, babu ɗayan abubuwan biyun da ya kamata su zama wofi, kuma ya kamata su ƙunshi gaba ɗaya lambobi.

Yawan Matrix

Yanzu bari mu bincika takamaiman misali na yadda zaku iya ninka matrices biyu ta hanyar amfani da mai aiki MULKIN.

1. Bude takardar Excel, wanda a halin yanzu matrices biyu suke. Mun zabi kan shi fannonin sel marasa kan gado, wanda ya haɗu da adadin layuka na matrix na farko, kuma a tsaye adadin ginshiƙai na matrix na biyu. Bayan haka, danna kan gunkin "Saka aikin"wanda aka sanya shi kusa da layin tsari.



2. Farawa Wizards na Aiki. Yakamata mu shiga rukuni "Ilmin lissafi" ko "Cikakken jerin haruffa". A cikin jerin masu aiki kana buƙatar nemo sunan MUMNOZH, zaɓi shi kuma danna maballin "Ok", wanda yake a kasan wannan taga.



3. Shafin Hujja Mai Furewa Mai Aiki MULKIN. Kamar yadda kake gani, yana da filaye biyu: "Array1" da Shirya2. A farkon, kuna buƙatar tantance daidaitawar farkon matrix, kuma a na biyu, bi da bi, biyun. Don yin wannan, saita siginan kwamfuta a farkon filin. Sannan muna yin shirin bidiyo tare da maɓallin linzamin kwamfuta na hagu kuma zaɓi yankin tantanin halitta wanda ya ƙunshi matrix na farko. Bayan aiwatar da wannan hanya mai sauƙi, masu gabatarwar za a nuna su a filin da aka zaɓa. Muna aiwatar da irin wannan aiki tare da filin na biyu, wannan lokacin kawai, riƙe maɓallin linzamin kwamfuta na hagu, zaɓi matrix na biyu.

   Bayan an rubuta adreshin matrices guda biyu, kada a ruga don danna maɓallin "Ok"wanda yake a gindin taga. Abu daya shine, muna ma'amala da tsarin aiki. Yana bayar da cewa ba a bayyanar da sakamakon ba a cikin sel ɗaya, kamar yadda yake a cikin ayyuka na yau da kullun, amma nan da nan cikin kowane fanni. Saboda haka, don nuna sakamakon sarrafa bayanai ta amfani da wannan mai amfani, bai isa ya danna maɓallin ba Shigarta hanyar sanya siginar siginan kwamfuta a cikin masarar dabara, ko ta danna maɓallin "Ok", kasancewa cikin taga muhawara na aikin da a yanzu yake buɗe mana. Buƙatar amfani da keystroke Ctrl + Shift + Shigar. Muna yin wannan hanya, da maɓallin "Ok" kar a taba.



4. Kamar yadda kake gani, bayan danna maɓallin keɓaɓɓen haɗuwa, taga mahawara na mai aiki MULKIN rufe, da kuma kewayon sel waɗanda muka zaba a farkon matakin wannan koyarwar sun cika da bayanai. Waɗannan ƙimar waɗannan sakamakon sakamakon ninka ɗaya ne ta hanyar wani, wanda ma'aikacin ya yi MULKIN. Kamar yadda kake gani, a cikin layin dabarun aiki ana ɗauka aikin a cikin takalmin katako, wanda ke nufin cewa yana cikin masu gudanar da ayyukan.



5. Amma daidai abin da sakamakon sarrafa aikin MULKIN muhimmin tsari ne, yana hana gaba da canji idan ya cancanta. Lokacin ƙoƙarin canza kowane lambobin sakamako na ƙarshe, mai amfani zai jira saƙon da ya sanar da cewa ba shi yiwuwa a canza wani ɓangare na tsarin. Don kawar da wannan rashin daidaituwa da canza tsarin rigakafi zuwa cikin kewayon bayanan yau da kullun da zaku iya aiki tare, muna aiwatar da matakan masu zuwa.

   Zaɓi wannan kewayon kuma, kasance cikin shafin "Gida"danna alamar Kwafawanda yake a cikin shinge na kayan aiki Clipboard. Madadin wannan aikin, zaku iya amfani da saita gajerun hanyoyin keyboard Ctrl + C.



6. Bayan haka, ba tare da cire zaɓi daga kewayon ba, danna kan shi tare da maɓallin linzamin kwamfuta na dama. A cikin menu na mahallin da zai buɗe, a cikin toshe Saka Zabi zaɓi abu "Dabi'u".



7. Bayan aiwatar da wannan aikin, ba za a sake gabatar da sakamakon matrix ba a matsayin kewayon da ba zai yuwu ba kuma ana iya yin amfani da hanyoyi iri iri tare da shi.

Darasi: Aiki tare da arrays a cikin Excel

Kamar yadda kake gani, mai aiki MULKIN ba ku damar sauri da kuma sauƙi ninka a cikin manyan matatun biyu na Excel a saman juna. Ginin wannan aikin yana da sauƙi kuma masu amfani kada su sami matsala shigar da bayanai cikin taga mahawara. Matsalar kawai da za ta iya tasowa lokacin aiki tare da wannan ma'aikacin ita ce ɗaukar hoto, wanda ke nufin yana da wasu fasaloli. Don nuna sakamakon, da farko zaba zaɓin da ya dace akan takardar, sannan bayan shigar da hujjoji don ƙididdigar, yi amfani da haɗe maɓallin na musamman da aka tsara don aiki tare da wannan nau'in bayanan - Ctrl + Shift + Shigar.