Chitsogozo cha Woyambitsa kwa Ma Excel Form

Kungophunzira za ma fomu? Ichi ndi chitsogozo kwa inu

Mafomu apadera amakulolani kuti muchite mawerengero pa chiwerengero cha chiwerengero chomwe chinapangidwira pa tsamba .

Mafomu omwe angagwiritsidwe ntchito angagwiritsidwe ntchito pazinthu zowonongeka, monga kuwonjezerapo kapena kuchotsa, komanso kuwerengera kovuta, monga kuchotsera malipiro, kupeza chiwerengero cha ophunzira pa zotsatira za mayesero, ndi kuwerengera ndalama zogulira ngongole.

Kuwonjezera apo, ngati ndondomekoyi imalowa molondola ndipo deta yomwe ikugwiritsidwa ntchito mumasinthidwe amasintha, mwachindunji, Excel idzabwezeretsanso ndikuyankhira yankho.

Maphunzirowa akufotokoza mwatsatanetsatane mmene angapangire ndi kugwiritsa ntchito maonekedwe, kuphatikizapo chitsanzo choyendetsedwera cha mndandanda wa Basic Excel.

Ikuphatikizapo chitsanzo chovuta kwambiri chomwe chimadalira dongosolo la ntchito ya Excel kuti apeze yankho lolondola.

Maphunzirowa amapangidwa kwa anthu omwe ali ndi zochepa kapena zosavuta kugwira ntchito ndi mapulogalamu a spreadsheet monga Excel.

Zindikirani: Ngati mukufuna kuwonjezera chigawo kapena nambala ya nambala, Excel yakhazikitsidwa mu fomu yomwe imatchedwa ntchito SUM yomwe imapangitsa ntchito mosavuta ndi yosavuta.

Zomwe Zing'onozing'ono Zamakhalidwe

© Ted French

Kulemba fomu ya spreadsheet ndi kosiyana kwambiri kusiyana ndi kulemba limodzi mu masamba a masamu.

Nthawizonse Yambani ndi Chizindikiro Chofanana

Kusiyana kwakukulu kwambiri ndiko kukhala mu Excel, ma formula akuyamba ndi chizindikiro chofanana ( = ) m'malo molimbana nawo.

Zomwe mawonekedwe akuwoneka ngati awa:

= 3 + 2

m'malo moti:

3 + 2 =

Mfundo Zowonjezera

Kugwiritsira ntchito zizindikiro za magulu ku Excel Formulas

© Ted French

Ngakhale kuti ndondomeko ya tsamba lapitayi ikugwira ntchito, imakhala ndi vuto lalikulu - Ngati mukufuna kusintha deta yogwiritsidwa ntchito muyeso, muyenera kusintha kapena kulembetsanso ndondomekoyi.

Kupititsa patsogolo Makhalidwe: Kugwiritsa Ntchito Mafotokozedwe a Maselo

Njira yabwino ingakhale kulemba ndondomeko kuti deta ikhale yosasinthika popanda kusintha mawonekedwe omwewo.

Izi zikhoza kuchitika mwa kulowa mu deta kumaselo ogwira ntchito ndikudziwitse pulogalamu yomwe maselo ali ndi deta yomwe ingagwiritsidwe ntchito mu njirayi.

Mwanjira iyi, ngati deta ya fomuyo iyenera kusinthidwa, ikuchitidwa mwa kusintha ma deta m'maselo apakompyuta, osati kusintha machitidwewo.

Kuti muuze Excel zomwe maselo ali ndi deta yomwe mukufuna kugwiritsa ntchito, selo lirilonse liri ndi adiresi kapena selo .

About References Cell

Kuti mupeze mawonekedwe a selo, ingoyang'anani mmwamba kuti muwone ndime yomwe selo ilimo, ndiyeno yang'anani kumanzere kuti mupeze mzere womwe uli.

Selo yamakono - kutanthauzira kwa selo yomwe ili pododometsedwa - imasonyezanso mu Bokosi la Dzina lomwe lili pamwamba pa ndime A mu tsambalo.

Kotero, mmalo molemba fomu iyi mu selo D1:

= 3 + 2

Zingakhale bwino kulumikiza deta mu maselo C1 ndi C2 ndikulembera fomu iyi mmalo mwake:

= C1 + C2

Excel Basic Formula Example

© Ted French

Chitsanzo ichi chimapereka ndondomeko malangizo kuti apange fomu yoyambirira ya Excel yomwe ili mu chithunzi pamwambapa.

Chitsanzo chachiwiri, chovuta kugwiritsa ntchito pogwiritsa ntchito masamu ambiri ndikugwiritsira ntchito dongosolo la ntchito ya Excel chili pamapeto pa tsambali.

Kulowa Datorial Data

Kawirikawiri ndibwino kuti muyambe kulowetsa deta zonse mu tsamba loyamba musanayambe kupanga mawonekedwe. Izi zimapangitsa kuti zikhale zosavuta kudziwitsa kuti ndi malemba ati omwe akuyenera kuti akhale nawo mu ndondomekoyi.

Kulowetsa deta mu selo yogwirira ntchito ndi njira ziwiri:

  1. Lembani deta mu selo.
  2. Lembani fungulo lolowani mukhiyo kapena dinani pa selo lina. ndi ndondomeko ya mouse kuti mutsirizitse cholowera.

Maphunziro Otsogolera

  1. Dinani pa selo C1 kuti mupange selo yogwira ntchito.
  2. Lembani 3 mu selo ndikusindikizira fungulo lolowani mukhiyi.
  3. Ngati ndi kotheka, dinani pa cell C2 .
  4. Lembani 2 mu selo ndikusindikizira fungulo lolowamo mukibokosi.

Kulowa Mndandanda

  1. Dinani pa selo D1 - ili ndi malo kumene zotsatira za fomuyi zidzawonekera.
  2. Lembani ndondomeko zotsatirazi mu selo D1: = C1 + C2
  3. Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
  4. Yankho lachisanu liyenera kuoneka mu selo D1.
  5. Ngati inu mutsegula pa selo D1 kachiwiri, ntchito yonse = C1 + C2 ikuwoneka muzenera yapamwamba pamwamba pa tsamba.

Kupititsa patsogolo Makhalidwe - Powonjezeranso: Kulowetsa Mafelelo a Cell ndi Kuwonetsera

Kulemba muzokambirana za selo monga gawo la ndondomeko ndi njira yolondola yolowamo - monga zatsimikiziridwa ndi yankho la 5 mu selo D1 - si njira yabwino kwambiri yochitira izo.

Njira yabwino yolumikizira ma seloloyi ndi njira yogwiritsira ntchito.

Kujambula kumaphatikizapo kutsegula maselo okhala ndi ndondomeko ya mouse kuti alowe mu selo lawo. Chinthu chachikulu chomwe chimagwiritsidwa ntchito pogwiritsira ntchito kukuthandizani kuthetsa zophophonya zomwe zimapezeka chifukwa cholemba zolakwika za selo.

Malangizo omwe ali patsamba lotsatira amagwiritsira ntchito kuloza mafotokozedwe a maselowo mu selo D2.

Kugwiritsa Ntchito Kulowetsa Kuloweza Ma Cell mu Excel Form

© Ted French

Gawo ili mu phunziro limagwiritsa ntchito pointer la mouse kuti mulowetse mafotokozedwe a selo kuti mulowe mu selo D2.

  1. Dinani pa selo D2 kuti mupange selo yogwira ntchito.
  2. Lembani chizindikiro chofanana ( = ) mu selo D2 kuti muyambe mwambo.
  3. Dinani pa selo C1 ndi ndondomeko ya mbewa kuti mulowetse selolo mu njirayi.
  4. Lembani chizindikiro chowonjezera ( + ).
  5. Dinani pa selo C2 ndi ndondomeko ya mbewa kuti mulowetse selo lachiwiri mu mawonekedwe.
  6. Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
  7. Yankho lachisanu liyenera kuoneka mu selo D2.

Kusintha Makhalidwe

Poyesa ubwino wogwiritsa ntchito ma selolo mu Excel fomu, sintha deta mu selo C1 kuchokera 3 mpaka 6 ndipo yesani kulowera mu Enter key pa makiyi.

Mayankho aŵiri m'maselo onse D1 ndi D2 ayenera kusintha kuchokera pa 5 mpaka 8, koma mayendedwe onse awiriwo asasinthe.

Mathematical Operators ndi Order of Operations

Monga mwawonetsedwa ndi chitsanzo cholungamitsidwa, kupanga ma fomu ku Microsoft Excel sivuta.

Ndi nkhani yokhala pamodzi, mwadongosolo, mafotokozedwe a maselo a deta yanu ndi olemba masamu oyenera.

Masamu Ogwira Ntchito

Olemba masamu omwe amagwiritsidwa ntchito mu Excel mawonekedwe ali ofanana ndi omwe amagwiritsidwa ntchito pa masamu.

  • Kuchotsa - kusayina chizindikiro ( - )
  • Kuwonjezera - kuphatikiza chizindikiro ( + )
  • Gawani - kutsogolo kutsogolo ( / )
  • Kuwonjezeka - asteriski ( * )
  • Kutsatsa - chisamaliro ( ^ )

Order of Operations

Ngati oposa angapo akugwiritsidwa ntchito mwachindunji, pali dongosolo lomwe Excel lidzawatsatira kuti lichite masabata awa.

Kukonzekera uku kwa ntchito kungasinthidwe mwa kuwonjezera makina ku equation. Njira yosavuta kukumbukira dongosolo la ntchito ndikugwiritsa ntchito mawu ofotokozera:

BEDMAS

Order of Operation ndi:

B rackets E xponents D kuvomereza Mkulumbirira Chidziwitso cha S ubtraction

Momwe Ntchito Yogwirira Ntchito imagwirira ntchito

Chitsanzo: Kugwiritsira Ntchito Ogwira Ntchito Ambiri ndi Order of Operation mu Excel Form

Patsamba lotsatila muli malangizo opanga machitidwe omwe amaphatikizapo masamu ambiri ogwiritsa ntchito masamu ndikugwiritsa ntchito dongosolo la ntchito ya Excel kuti apeze yankho.

Kugwiritsira Ntchito Multiple Operators mu Excel Formula

© Ted French

Chitsanzo chachiwiri ichi, chomwe chikuwonetsedwa pa chithunzi pamwambapa, chimafuna Excel kugwiritsa ntchito dongosolo la ntchito kuti awerengere yankho.

Kulowa Deta

  1. Tsegulani pepala losalemba lokha ndipo lembani deta yosonyezedwa m'maselo C1 mpaka C5 mu chithunzi pamwambapa.

Mndandanda Wowonjezereka Wovuta Kwambiri

Gwiritsani ntchito kukopa pamodzi ndi makina oyenera ndi othandizira masamu kuti mupange njira yotsatirayi mu selo D1.

= (C2-C4) * C1 + C3 / C5

Pewani makiyi a Kulowa pa khibhodi mukamaliza ndipo yankho -4 liyenera kuoneka mu selo D1. Tsatanetsatane wa momwe Excel ikuwerengera yankho ili:

Zambiri Zowonjezera Kulowa Mndandanda

Ngati mukufuna thandizo, gwiritsani ntchito ndondomeko zotsatirazi kuti mulowe muyeso.

  1. Dinani pa selo D1 kuti mupange selo yogwira ntchito.
  2. Sakani chizindikiro chofanana ( = ) mu selo D1.
  3. Lembani mzere wotseguka wozungulira " ( " pambuyo pa chizindikiro chofanana.
  4. Dinani pa selo C2 ndi pointer ya mouse kuti mulowetsere selolo mu njirayi.
  5. Lembani chizindikiro chochepa ( - ) pambuyo pa C2.
  6. Dinani pa selo C4 kuti mulowetse selo ili mu njirayi.
  7. Lembani mzere womaliza wobisika " ) " pambuyo pa C4.
  8. Lembani chizindikiro chochulukitsa ( * ) pambuyo pa bwalo lomaliza.
  9. Dinani pa selo C1 kuti mulowetse selo ili mu njirayi.
  10. Lembani chizindikiro chowonjezera ( + ) pambuyo pa C1.
  11. Dinani pa selo C3 kuti mulowetse selo ili mu njirayi.
  12. Lembani chizindikiro chogawa ( / ) pambuyo pa C3.
  13. Dinani pa selo C5 kuti mulowetse selo ili mu njirayi.
  14. Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
  15. Yankho -4 liyenera kuoneka mu selo D1.
  16. Ngati inu mutsegula pa selo D1 kachiwiri, ntchito yeniyeni = (C2-C4) * C1 + C3 / C5 imapezeka muzenera zamatabwa pamwamba pa tsamba.

Momwe Excel ikuwerengera Fomu Yankho

Excel akufika pa yankho la -4 la ndondomeko pamwambapa pogwiritsa ntchito malamulo a BEDMAS kuti achite masamu osiyanasiyana osiyanasiyana mwa zotsatirazi:

  1. Choyamba choyamba chimachotsa ntchito yochotsa (C2-C4) kapena (5-6), popeza ili ndi maboda, ndipo imapeza zotsatira za -1.
  2. Kenaka pulogalamuyi ikuwonjezereka kuti -1 ndi 7 (zomwe zili mu selo C1) kupeza yankho la -7.
  3. Kenaka Excel ikudumpha patsogolo kuti igawikane 9/3 (zomwe zili mu C3 / C5) chifukwa zisanafike kuwonjezera pa BEDMAS, kupeza zotsatira za 3.
  4. Ntchito yotsiriza yomwe ikufunika kuchitidwa ndiyo kuwonjezera -7 + 3 kuti mupeze yankho la chigawo chonse cha -4.