Mafomu amtundu wa cell mu Excel

Mu phunziro ili, tidziwa njira yamtundu umodzi wa cell ndikusanthula chitsanzo chabwino chakugwiritsa ntchito kwake mu Excel. Ngati simunadziwebe mafomu osiyanasiyana, tikukulimbikitsani kuti mutembenuzire phunzirolo, lomwe limafotokoza mfundo zoyambira zogwirira ntchito ndi masanjidwe mu Excel.

Kugwiritsa Ntchito Maselo Amodzi Amodzi

Ngati muwerenga phunziro lamitundu yambiri yama cell, ndiye kuti chithunzi chomwe chili pansipa chikuwonetsa tebulo lomwe mukulidziwa kale. Nthawi ino ntchito yathu ndikuwerengera ndalama zonse zamtengo wapatali.

Zachidziwikire, titha kuchita zachikale ndikungowerengera kuchuluka kwa ma cell a D2:D6. Zotsatira zake, mupeza zotsatira zomwe mukufuna:

Mafomu amtundu wa cell mu Excel

Koma pali zinthu zina pamene kuchita mawerengedwe wapakatikati (kwa ife, ichi ndi osiyanasiyana D2: D6) sikumveka, n'kovuta kapena zosatheka nkomwe. Pamenepa, ndondomeko ya selo imodzi imathandiza, yomwe ingakuthandizeni kuwerengera zotsatira ndi fomula imodzi yokha. Kuti mulowetse fomula mu Excel, tsatirani izi:

  1. Sankhani selo lomwe mukufuna kuti zotsatira ziwonekere:Mafomu amtundu wa cell mu Excel
  2. Lowetsani njira iyi:Mafomu amtundu wa cell mu Excel
  3. Popeza iyi ndi njira yotsatsira, kulowetsako kuyenera kumalizidwa ndikukanikiza kuphatikiza Ctrl + Shift + Lowani. Zotsatira zake, tipeza zotsatira zofanana ndi zomwe zidawerengedwa poyamba.Mafomu amtundu wa cell mu Excel

Kodi ndondomekoyi imagwira ntchito bwanji?

  1. Fomulayi imachulukitsa kaye milingo yofananira yamitundu iwiriyi:Mafomu amtundu wa cell mu Excel
  2. Ndipo kutengera zomwe zalandilidwa, zimapanga mndandanda watsopano woyimirira womwe umapezeka mu RAM ya kompyuta yokha:Mafomu amtundu wa cell mu Excel
  3. Ndiye ntchito SUM imawerengera mtengo wagululi ndikubwezeretsa zotsatira zake.Mafomu amtundu wa cell mu Excel

Mitundu yambiri - Ichi ndi chimodzi mwazovuta kwambiri, ndipo nthawi yomweyo zothandiza, zida mu Microsoft Excel. Mafomu amtundu umodzi amakulolani kuti muwerenge zomwe simungathe kuchita mwanjira ina iliyonse. M’maphunziro otsatirawa, tiwona zitsanzo zingapo zoterozo.

Chifukwa chake, muphunziro ili, mwadziwa ma fomula amtundu umodzi wa cell ndikusanthula chitsanzo chothana ndi vuto losavuta. Ngati mukufuna kuphunzira zambiri za masanjidwe mu Excel, werengani nkhani zotsatirazi:

  • Chiyambi cha mafomula osiyanasiyana mu Excel
  • Mafomu a Multicell mu Excel
  • Mndandanda wa zosinthika mu Excel
  • Kusintha mitundu yosiyanasiyana mu Excel
  • Kugwiritsa ntchito mitundu yosiyanasiyana mu Excel
  • Njira zosinthira masanjidwe amitundu mu Excel

Siyani Mumakonda