Abasebenzisi abaningi abazi ngisho namandla amakhulu e-Excel. Yebo, yebo, sizwile ukuthi uhlelo lokusebenzisana namatafula, yebo bayayisebenzisa, babheke eminye imibhalo. Ngiyavuma, ngangingumsebenzisi ofanayo, kwaze kwaba yilapho ngiphutha ngephutha, ebonakalayo umsebenzi: bala inani lamaseli kwelinye lamatafula ami ku-Excel. Ngangivame ukukwenza ku-calculator (manje kuyamangalisa :-P), kodwa manje leli tafula lalikhulu kakhulu, futhi nganquma ukuthi sekuyisikhathi sokutadisha okungenani eyodwa noma ezimbili amafomula alula ...
Kulesi sihloko ngizokhuluma ngesamba samanani, ukuze kube lula ukuqonda, sizobuka izibonelo ezimbalwa ezilula.
1) Ukubala noma yiliphi inani lezinombolo eziyinhloko, ungachofoza kunoma iyiphi iseli ku-Excel bese ubhala kuso, isibonelo, "= 5 + 6", bese ucindezela u-Enter.
2) Umphumela awuthathi isikhathi eside, esitokisini lapho ubhala khona umphumela umphumela uvela "11". Ngendlela, uma uchofoza kule seli (lapho inombolo 11 ibhaliwe) - kubha yefomula (bona umfanekiso wesithombe ngenhla, umcibisholo inombolo 2, ngakwesokudla) - ngeke ubone inombolo 11, kodwa okufanayo "= 6 + 5".
3) Manje sizozama ukubala inani lezibalo kusuka kumaseli. Ukuze wenze lokhu, qala ukuya esigabeni esithi "FORMULA" (imenyu engenhla).
Okulandelayo, khetha amangqamuzana amaningana amanani amanani ofuna ukuwabala (ku-skrini engezansi, izinhlobo ezintathu zenzuzo zigqanyiswa eluhlaza). Bese uchofoza ngakwesobunxele kuthebhu ethi "AutoSum".
4) Ngenxa yalokho, inani lamaseli amathathu angaphambilini azovela esitokisini esiseduze. Bona umfanekiso wesithombe ngezansi.
Ngendlela, uma siya esitokisini ngomphumela, sizobona ifomula ngokwalo: "= SUM (C2: E2)", lapho i-C2: E2 kulandelana kwamaseli adinga ukufakwa.
5) Ngendlela, uma ufuna ukubala isamba kuzo zonke imigqa esele etafuleni, bese nje ukopisha ifomula (= SUM (C2: E2)) kuwo wonke amanye amaseli. I-Excel izobala konke ngokuzenzekelayo.
Ngisho nale ndlela ebonakalayo elula yenza i-Excel ithuluzi elinamandla lokubala idatha! Manje ake ucabange ukuthi i-Excel ayiyodwa, kodwa amakhulu amafomu ahlukene kakhulu (ngendlela, sengikhuluma kakade ngokusebenza nabantu abadumile kakhulu). Siyabonga, ungabala noma yini nanoma yini, ngenkathi usindisa isikhathi sakho esiningi!
Yilokho konke, inhlanhla yonke.
