Pamene mukugwira ntchito ndi matrices, nthawi zina muyenera kuwamasulira, ndiko kuti, ndi mawu osavuta, kuwamasulira. Inde, mukhoza kusokoneza deta, koma Excel imapereka njira zingapo kuti zikhale zosavuta komanso mofulumira. Tiyeni tiwawononge iwo mwatsatanetsatane.
Kusintha njira
Kutumizira matrix ndi njira yosinthira zipilala ndi mizere m'malo. Mu Excel, pali zifukwa ziwiri zosinthira: kugwiritsa ntchito ntchitoyi TRANSPORT ndi kugwiritsa ntchito chidacho. Taganizirani izi mwazomwe mungachite.
Njira 1: NTCHITO YA TRANSPORT
Ntchito TRANSPORT ndi wa gulu la opaleshoni "Zolumikizana ndi zolemba". Chidziwikiratu ndi chakuti, monga ntchito zina zomwe zimagwira ntchito ndizomwe zimatuluka, zotsatira za chigulitsidwe sizomwe zili mu selo, koma deta yonse. Ntchito ya syntax ndi yosavuta ndipo ikuwoneka ngati iyi:
= TRANSPORT (gulu)
Izi ndizo, kukangana kokha kwa ogwiritsira ntchitoyi ndiko kutchulidwa kwa gulu, mwa ife kuti matrix kuti atembenuzidwe.
Tiyeni tiwone momwe ntchitoyi ingagwiritsidwire ntchito pogwiritsa ntchito chitsanzo chokwanira.
- Sankhani selo lopanda kanthu pa pepala, tikukonzekera kupanga matrix osinthika pamwamba pa selo kumanzere. Kenako, dinani pazithunzi "Ikani ntchito"yomwe ili pafupi ndi bar.
- Yambani Oyang'anira ntchito. Tsegulani gululo mmenemo "Zolumikizana ndi zolemba" kapena "Mndandanda wathunthu wa alfabeti". Atapeza dzina "TRANSPORT"Pangani chisankho chake ndipo dinani pa batani "Chabwino".
- Ntchitoyi zenera zowonekera. TRANSPORT. Chotsutsana chokha cha woyendetsa ntchitoyi chikufanana ndi munda "Mzere". Momwemo muyenera kulowa m'zigawo zogonana, zomwe ziyenera kutembenuzidwa. Kuti muchite izi, yikani mtolo mmunda ndipo, mutagwiritsa ntchito batani lamanzere, sankhani mzere wonse wa matrix pa pepala. Pambuyo pa adiresi ya dera lanu, muwonekera pazenera zotsutsana, dinani pa batani "Chabwino".
- Koma, monga momwe tikuwonera, mu selo, lomwe lakonzedwa kuti liwonetse zotsatira zake, mtengo wolakwika suwonetsedwa ngati cholakwika "#VALUE!". Izi zimachokera kuzidziwikiratu za ntchito ya ogwira ntchito. Kuti mukonze cholakwika ichi, sankhani maselo osiyanasiyana omwe nambala ya mizere ikhale yofanana ndi chiwerengero cha zikhomo za chiyero choyambirira, ndi chiwerengero cha zipilala ku nambala ya mizere. Masewu otere ndi ofunika kwambiri kuti zotsatira ziwonetsedwe molondola. Pa nthawi yomweyo, selo liri ndi mawu "#VALUE!" Iyenera kukhala pamwamba pa selo selo lasankhidwa, ndipo kuchokera kumeneko kuti njira yotsatila iyenera kuyamba, kugwira pansi pa batani lamanzere. Mutasankha kusankha, ikani cholozera mu bar lamuzonde nthawi yomweyo TRANSPORTzomwe ziyenera kuonekera mmenemo. Pambuyo pake, kuti muyese kuwerengera, simukuyenera kudina pa batani Lowani, monga mwachizoloŵezi mwa machitidwe ozoloŵera, ndikusakaniza kuphatikiza Ctrl + Shift + Lowani.
- Zitatha izi, chiwerengerochi chimawonetsedwa monga momwe tikufunira, ndiko kuti, mu mawonekedwe osinthidwa. Koma palinso vuto lina. Chowonadi ndi chakuti tsopano chiyero chatsopano ndi mndandanda womangidwa ndi ndondomeko yomwe siingasinthe. Ngati mukuyesera kupanga kusintha kulikonse muzomwekuchitika, vuto lidzawonekera. Ogwiritsa ntchito ena amakhala okhutira ndi zochitika izi, chifukwa sangasinthe mndandanda, pamene ena amafunikira masewera omwe mungagwire nawo mokwanira.
Pofuna kuthetsa vutoli, sankhani mtundu wonse wopangidwa. Kusunthira ku tabu "Kunyumba" dinani pazithunzi "Kopani"yomwe ili pa tepi mu gulu "Zokongoletsera". M'malo mwachitidwe chodziwika, n'zotheka pambuyo pa kusankha kuti mupange mafungulo ofikira ofikira okopera. Ctrl + C.
- Kenaka, popanda kuchotsa kusankha kuchokera kumtundu wotchinga, dinani ndibokosi lakumanja la mouse. M'ndandanda wamakono mu gululo "Njira Zowonjezera" dinani pazithunzi "Makhalidwe", yomwe ili ndi mawonekedwe a chizindikiro ndi fano la nambala.
Potsatira izi ndi ndondomeko yowonjezera TRANSPORT adzachotsedwa, ndipo mtengo umodzi wokha udzatsala m'maselo, omwe mungagwiritse ntchito mofananamo ndi chiyero choyambirira.
Phunziro: Excel ntchito wizara
Njira 2: tumizani matrix pogwiritsa ntchito chipangizo chapadera
Kuphatikiza apo, matrix akhoza kusinthidwa pogwiritsira ntchito gawo limodzi lamasewero, chomwe chimatchedwa "Sakani Mwapadera".
- Sankhani matrix oyambirira ndi chithunzithunzi, ndikugwira batani lamanzere. Chotsatira, pitani ku tabu "Kunyumba", dinani pazithunzi "Kopani"iikidwa pamakonzedwe "Zokongoletsera".
M'malo mwake, mukhoza kuchita mosiyana. Sankhani dera lanu, dinani pamenepo ndi batani labwino la mouse. Ikuthandizira mndandanda wa masewera omwe mumasankha chinthucho "Kopani".
Monga zosiyana ndi zosankha ziwiri zomwe zapitazo, mungathe kupanga osankhidwa a mafungulo otentha mukasankha Ctrl + C.
- Timasankha pa pepala chopanda chopanda kanthu, chomwe chiyenera kukhala chapamwamba kwambiri kumanzere kumbali ya matrix yosinthidwa. Dinani pa ilo ndi batani lamanja la mouse. Pambuyo pake, mndandanda wa masewerawo umasinthidwa. Momwemo timasuntha pa chinthucho "Sakani Mwapadera". Menyu ina yaying'ono ikuwonekera. Limakhalanso ndi chiganizo chotchedwa "Kuika Mwapadera ...". Dinani pa izo. Mukhozanso, mutasankha kusankha, mmalo moitanira mndandanda wamakono, yesani kuphatikiza pa makiyi Ctrl + Alt + V.
- Zowonjezera zowonjezera zenera zatsekedwa. Pali njira zambiri zomwe mungasankhire, momwe mungagwiritsire ntchito deta yomwe inakopedwa kale. Kwa ife, muyenera kusiya pafupifupi zonse zosasintha. Ndi pafupi ndi parameter "Kutumiza" ayenera kukanikiza. Kenaka dinani pa batani. "Chabwino"yomwe ili pansi pazenera ili.
- Pambuyo pazimenezi, chiwerengero choyendetsedwacho chidzawonetsedwa mu gawo lomwe lasankhidwa kale. Mosiyana ndi njira yapitayi, talandira kale matrix, omwe angasinthidwe, komanso gwero. Palibe kukonzanso kopitirira kapena kusinthika kofunikira.
- Koma ngati mukufuna, ngati simukusowa chiyero choyambirira, mukhoza kuchichotsa. Kuti muchite izi, sankhani ndi chithunzithunzi, mukugwira batani lamanzere. Kenaka dinani chinthu chosankhidwa ndi batani yoyenera. Mu menyu a nkhani omwe amatsegulira pambuyo pa izi, sankhani chinthucho "Chotsani Chokhutira".
Zitatha izi, matrix okhawo adzasintha pa pepala.
Ndi njira ziwiri zomwe takambiranazi, ndizotheka kutsegula mu Excel osati matrices okha, komanso magome onse. Njirayi idzakhala yofanana.
Phunziro: Momwe mungapangire tebulo mu Excel
Kotero, tapeza kuti mu Excel, matrix akhoza kusinthidwa, ndiko kuti, kupyolera mwa kusintha mizere ndi mizere m'njira ziwiri. Njira yoyamba ndiyo kugwiritsa ntchito ntchitoyi TRANSPORTndipo yachiwiri ndizowonjezera zowonjezera. Kawirikawiri, zotsatira zomaliza, zomwe zimapezeka pogwiritsira ntchito njira zonsezi, siziri zosiyana. Njira zonsezi zimagwira ntchito pafupifupi. Kotero posankha kusankha kutembenuka, zosankha za munthu wina aliyense zimakhala patsogolo. Ndiko, njira imodzi mwa njirazi ndi yabwino kwa inu nokha, ndikugwiritsira ntchito.
