Yintoni ifomula Excel, yaye yintoni na ukuba?

Ukuba ukhe wasebenza spreadsheet kwi computer yakho, ngokuzithemba okukhulu sinokuthi evulekileyo kwaye uhlele kwi Microsoft Excel, wena inkqubo odumileyo. Kwaye oku ayimangalisi, ukususela isicelo wesibini ixhaphakileyo abangakwaziyo lwezixhobo ofisi eqhelekileyo.

Ngelishwa, izinga lolwazi lwabasebenzisi amaxesha liphantsi disappointingly, nto leyo ngokufuthi ekhokelela ezininzi nesohlwayo, okanye ukungakwazi ngokupheleleyo ukwenza imisebenzi esisiseko. Ngokukodwa, ngaba uyazi ukuba Excel nguye ifomula? Ukuba akunjalo, inqaku ebhalwe ngqo!

Ngenxa yoko, le fomyula kwesi sicelo ekubhekiswe imiyalelo iteksti ezizodwa kuvumela abasebenzisi ngendlela elula futhi elula ukuba ukuhlangabezana zibalwa ngendlela entsonkothileyo kakhulu izibalo. Umzekelo, usebenzise izakhono zabo, uyakwazi ukwenza imisebenzi yakho. Hayi ukuba aluhlaza, ukuba ifomula Excel, ebhaliweyo '= SUM (B1: B64) ".

Musa ukubhidanisa umqondiso ":" division, njengokuba kulo mzekelo, oko kuphela kuluhlu. Ukuba eqinile, eli binzana unika umyalelo ukuya summation yeenqobo kwiiseli, esisusela ekwandisweni B1 ukuya B64.

The amathuba ifomula ebanzi kakhulu. Thatha imeko apho kufuneka iphinda ukuzaliswa oluzenzekelayo ezahlukeneyo iiseli. Kakade ke, ungasebenzisa i izibalo edinayo manual (hayi ucetyiswe ukuba wenze njalo!), Kodwa kuthekani ukuba basebenza a spreadsheet? Ukuze wenze oku, zama oku kulandelayo: Vula itafile entsha kwiseli yokuqala (A1) enze nawuphi na umfanekiso. Masithi eyakho Excel ifomula lwakho ngokuzenzekelayo kabini ixabiso kwisisele ngasinye ezilandelayo.

Emva koko nqakraza i ekhohlo iqhosha le mouse kwi iseli A2, uze izakubeka isalathisi kwibhokisi yokufaka ifomula. Faka uphawu "=", uze ubhale "A1 * 2" (ekugqibeleni ufumana "= A1 * 2"). Nqakraza kwi «Ngena», uze emva koko kwikholam yesibini nangoko ubonakala inani "2". Kodwa ufuna Excel formula twa ezinye iiseli? Musa Ungakhathazeki, wenze kube lula.

Ukucofa i ekhohlo iqhosha le mouse kwi kwiseli A2,-INSET yakhe kwikona esezantsi ekunene nge mouse, tsala yona yi uluhlu iiseli ukuba ufuna. Ngoku Ungakhathazeki malunga Conversion: ukuguqula yonke le nkqubo iza kubulawa ngokuzenzekelayo. Ndazi njani indlela ekunene ezichazwe kwi-Excel spreadsheet? Khetha ngokulula i ekhohlo iqhosha le iseli onomdla, ngoko sijonga kumgca yamangenelo: Ukuba kukho ukubonisa into efana "A8 * 2", ngoko ke yonke into entle.

Akunyanzelekanga ukuba elide ukuthetha indlela iluncedo oku kusebenza kwabo rhoqo ukuba basebenze kunye namaxwebhu elektroniki! Wena uya kusinda ngokupheleleyo ekubeni umsebenzi edinayo neqhubekayo kunye "Calculator", ixesha uphumezo imisebenzi zokusebenza ezintsonkothileyo ziya kuwa amaxesha amaninzi. Ukongeza, umtya we neefomula Excel ngokuqinisekileyo lula kakhulu ubomi babafundi, njengoko ngokukhawuleza futhi kwamandla ziya kubalwa phantse nawuphi na umsebenzi elebhu.

Ngokufutshane, funda indlela yokusebenzisa kakuhle le nkqubo, uya lula kakhulu ubomi bakho ngokwandisa ukusebenza kwazo.