Indlela Zandise elikuluhlu Excel ngu lomhlathi, kwaye ikholam inani

Abo abantu badla ukusebenza kwi computer, kungekudala emva koko kufuneka senze inkqubo efana Excel. Kodwa incoko kweli nqaku iqhubeka yonke nobubi bendlela kule nkqubo, kwaye malunga kwanangamacandelo alo ngabanye, "Formula". Kakade ke, ezikolweni kunye neeyunivesithi kwinzululwazi izifundo abafundi kunye nabafundi ukuba izifundo ngalo mbandela, kodwa abo ndilibele - Inqaku lethu.

Siza kuthetha ukuba phinda ngayo ikholam Excel ukuya kumhlathi. Iza kubonelela imiyalelo eneenkcukacha ezigcweleyo ukwenza njani oku, kunye inyathelo uhlalutyo inyathelo ngombandela ngamnye, khon 'ukuze wonke umntu, nokuba umfundi mfundi uya kukwazi ukujonga lo mbandela.

Phinda-phinda ikholam ngu kumhlathi

Indlela Phinda-phinda ngo ikholam kwikholam Excel, siya kuhlala umzekelo. Masenze ngathi kwi-Excel yomsebenzi uyila itafile kunye nexabiso kunye nobungakanani yempahla. Kwakhona unalo iseli phantsi mali iyonke. Njengoko unokuthekelela, kufuneka zande ngokukhawuleza kwezo ntsika zimbini zokuqala kwaye bawadibanise.

Ngoko ke, apha ke inyathelo imiyalelo step:

1. Phawula indawo olufunwayo uze ucofe umsebenzi icon, apho ingabekwa phezulu kwe Ibar yesixhobo.
2. window "Abanye" baya kukhethwa livela phambi kwakho apho ufuna.
3. Okulandelayo, kufuneka ukhethe ukusuka kwiqela imisebenzi zezibalo.
4. Khetha "SUMPRODUCT".

Emva koko, i window ivela apho uyacelwa ukuba ukhethe uluhlu equlathe i data, ungaya ngeendlela ezimbini. Owokuqala ubonisa ukuba usebenzise isalathisi ukukhetha kwikholam yokuqala (ixabiso), kunye noluhlu yayo obaluliweyo kwiqhosha "Array 1", kwaye eyesibini (ixabiso) - idweliswe kwi "Array 2". Njengoko ubona, uluhlu ochaziweyo ngoonobumba (C2: B6). Indlela yesibini kuthetha ukuba uza kungena ezi amaxabiso ngesandla, umahluko kule no.

Ngoku uyazi indlela enye indlela phinda ngo ikholam kwikholam Excel, kodwa kuphela mnye, kwaye yesibini iya kuxoxwa apha.

Indlela yesibini-phindo

Ukuze phinda ziintsika indlela yesibini, kuya kufuneka ukhethe umsebenzi iqela "izibalo", kodwa ngoku kufuneka sisebenzise 'ukwenza ". Ngoku kukho amasimi ezimbini phambi kwakho, "Number 1" yaye "inani 2". Nqakraza kwi "Number 1" kwaye khetha ixabiso lokuqala ukusuka kwikholam yokuqala, ezifana phinda kunye "Number 2", ukhetha kuphela ixabiso lokuqala kwikholam yesibini.

Emva u- "OK" esiseleni kunye olungumgubo baya kuba udibaniso lwamaxabiso ezikhethiweyo, unako ukuvelisa kuphela iiseli ukugcwalisa ngokuzenzekelayo, kuba oku, hambisa isalathisi ukuya kwikona esezantsi ekunene iseli kwaye yitsale phantsi inani elifunekayo lamanqaku.

Ngoku wafunda indlela yesibini indlela phinda ngo ikholam kwintsika Excel. Ngoku makhe sithethe ukwanda njani inani bomhlathi.

Phinda ngenani lomxholo

Ngoko ke, indlela phinda ikholam e-Excel kwi nombolo? Enyanisweni, ukuba lula. Ukuze wenze oku:

1. Khetha iseli apho aya khona isiphumo.
2. Ngena kuyo umqondiso "okufanayo".
3. Isalathisi kubonakalisa ixabiso yokuqala kwikholam, kodwa kufuneka kwabelwa inani ngazo ukuba phinda phinda ixabiso.
4. Emva koko, hambisa isalathisi inombolo kunye cofa F4.
5. Ngoku uhlala wabeka kuphela isalathisi kwikona esezantsi ekunene impendulo iseli kwaye uyitsale ubuninzi olufunwayo izinto.