Ungayicoca njani idatha yokugqwesa ngombala

KwiOfisi ye-Microsoft e-Excel, ukuqala ngo-2007, inamandla okuhlela kunye nokucoca iiseli zoluhlu lwetafile ngombala. Lo msebenzi uvumela ngokukhawuleza ukuba ungene etafileni, enyusa ukuthumeka kunye ne-aesthetics. Eli nqaku liza kuqwalasela iindlela ezisisiseko zokucoca ulwazi nge-Excel ngombala.

Ukucoca ukugcwala

Ngaphambi kokutshintsha ekuqwalaselweni kweendlela zokucoca idatha ngombala, kubalulekile ukuhlalutya izibonelelo ezinikwa le nkqubo:

• Ukuqulunqwa kunye nokulungisa ulwazi, okuvumela ukuba ukhethe isiqwenga esinqwenelekayo seplate kwaye ngokukhawuleza uyifumane kuluhlu olukhulu lweeseli.
• Iiseli ezigxinisiweyo zeselula ezinolwazi olubalulekileyo zinokuhlaziywa kwixesha elizayo.
• Ukucoca ngombala okwazisa ulwazi oloneliseki iikhrayitheriya ezithile.

Ungayicoca njani idatha yemibala usebenzisa ukhetho lwe-Excel

I-algorithm ye-algorithm yombala kwitheyibhile ye-Excel Uluhlu lwahlulahlulwe la manyathelo alandelayo:

1. Khetha uluhlu olufunayo lweeseli ezinesitshixo sasekhohlo se-wipulator kwaye sifudukele kwithebhu "yasekhaya" esentloko yebar yenkqubo.
2. Kwindawo ebonakala kwicandelwana, ukuhlela kuya kufuneka ufumane iqhosha elithi "hy kunye ne-filter" kwaye hlula ngokunqakraza kulapho phantsi.

Ukukhetha ukuhlelwa kunye nokucoca idatha ye-tabuster kwi-Excel

1. Kwimenyu ebonisiweyo, cofa kumgca wokucoca.

Kwifestile yokhetho, cofa iqhosha "lesihluzi"

1. Xa ifiltha yongezwa, emva koko iintolo ezincinci ziya kuvela kwiikholamu zetafile. Okwangoku, ngalo naluphi na iintolo, umsebenzisi kufuneka acofe i-LKM.

I-Arrogo yavela kwiintloko zekholamu zetafile emva kongeza isihluzo

1. Emva kokucinezela utolo kwigama lekholamu, imenyu efanayo iyaboniswa, apho kufuneka ucofe kumtya wokucoca ucocekile. Ithebhu eyongezelelweyo eneempawu ezimbini ezikhoyo ziya kutyhilwa:

Izinketho ezifanelekileyo kwi-Excel. Apha ungakhetha nayiphi na imibala ukuba ibekwe ngaphezulu kwetafile

1. Kwicandelo elithi "ICELS ICOLOT", khetha umthunzi ofuna ukucoca itafile yomthombo ngokucinezela i-LKM kuyo.
2. Jonga iziphumo. Emva kokuchitha la manyange, kuphela iiseli kunye nombala obekiweyo oza kuhlala etafileni. Izinto ezisele ziyanyamalala, kwaye iplate incitshisiwe.

Imbonakalo yeplate eguqulweyo emva kwedatha yokucoca kuyo

Idatha yokucoca kwindawo ye-Excel inokubakho ngesandla, icime imitya kunye neekholamu ngemibala engafunekiyo. Nangona kunjalo, umsebenzisi kuya kufuneka achithe ixesha elongezelelweyo kule nkqubo.

Ukuba ukhetha umthunzi onqwenelekayo kwicandelo leFondi leFortal Plain, kuphela imigca kuphela eya kuhlala kwitheyibhile, umbhalo wefonti apho ubhalise kumbala okhethiweyo.

Indlela yokuhlela idatha kwimibala emininzi kwi-Excel

Ngokuhlelwa ngemibala kwi-Excel, kuhlala kungekho ngxaki. Yenziwe ngendlela efanayo:

1. Ngomfanekiso wenqaku elidlulileyo, Yongeza isihluzo kwitafile yetafile.
2. Cofa kwi-krow evele kwigama lekholamu, kwaye kwimenyu eyehlayo ukhetha "Hlela ngombala".

Ukukhetha umbala wokuhlela

1. Chaza uhlobo olufunwayo lokuhlelwa, umzekelo, khetha umthunzi ofunekayo kwikholamu ye-"l ".
2. Emva kokugqiba ukufefazane kwangaphambili, imigca yetafile ene-tint ekhethiweyo eyakhiwe ngaphambili iya kuba kwindawo yokuqala yoluhlu ngolungelelwano. Unokuyilungisa imibala eseleyo.

Iziphumo zokucwangcisa zokuhlela iiseli ngombala kuluhlu lwetafile

Indlela yokucoca ulwazi kwitafile ngombala usebenzisa umsebenzi womsebenzisi

Ukukhetha isihluzo kwiOfisi yeMicrosoft Excel ukubonisa imibala emininzi ngexesha elinye kwitheyibhile, kufuneka wenze iparameter eyongezelelweyo ngomthunzi wokugcwalisa. Ngokomthunzi owenzileyo, idatha kwixa elizayo iya kuhlulwa. Umsebenzi womsebenzisi e-Excel wenziwa ngokwemiyalelo elandelayo:

1. Yiya kwicandelo "labaphuhlisi", elibekwe ngaphezulu kwemenyu ephambili yenkqubo.
2. Kwithebhu evulekileyo ngoku, cofa kwiqhosha "elisisiseko" esisiseko ".
3. Inkqubo eyakhiweyo iya kuvulwa, kuya kufuneka wenze imodyuli entsha kwaye ibhalisele ikhowudi.

Ikhowudi yenkqubo enemisebenzi emibini. Eyokuqala ichaza umbala wokugcwalisa into, kwaye yesibini inoxanduva lombala ngaphakathi kwiseli

Ukufaka umsebenzi odaliweyo, uyafuna:

1. Buyela kwiphepha lokusebenza kwe-Excel kwaye wenze iikholamu ezimbini ezintsha ecaleni kwetafile yomthombo. Banokubizwa ngokuba yi "mbala weseli" kunye "nombala wesibhalo", ngokwahlukeneyo.

Yenziwe iikholamu ezincedisayo

1. Kwikholamu yokuqala, bhala ifomula "= i-cologull ()". Iibrakethi zibonisa impikiswano. Kuya kufuneka ucofe iseli ngayo nayiphi na imibala kwiplate.

Ifomula kwikholamu "Umbala weseli"

1. Kwikholamu yesibini, chaza impikiswano efanayo, kodwa kuphela kunye "= umbala ()" umsebenzi.

Ifomula kwikholamu "Umbala wetekisi"

1. Yolula amaxabiso eziphumo zokuphelisa itafile, icima ifomula yoluhlu lonke. Idatha efunyenweyo inoxanduva lombala weseli nganye etafileni.

Idatha ebangela ukolula ifomula

1. Yongeza isihluzo kwitafile ngokuchanekileyo ngokwesi sikimu ngasentla. Idatha iya kulungiswa ngombala.

Ukuqukumbela

Ke, kwi-MS PERS, ungayicoca ngokukhawuleza umthombo wetheyibhile Uluhlu lweeseli ngeendlela ezahlukeneyo. Iindlela eziphambili zokucoca kunye nokuhlelwa, ezicetyiswayo ukuzisebenzisa xa kusenziwa umsebenzi, zaqwalaselwa ngasentla.

Umyalezo Ungayicoca njani idatha kwi-Excel ngombala wabonakala kuqala kwitekhnoloji yolwazi.