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
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
- Chizindikiro chofanana nthawi zonse chimapita mu selo kumene mukufuna yankho la funsolo kuti liwonekere.
- Chizindikiro chofanana chimamuuza Excel kuti zomwe zikutsatira ndizo gawo la ndondomeko, osati dzina kapena nambala chabe.
- Monga momwe zasonyezedwera mu chithunzi pamwambapa, kamodzi chitafika, selo liri ndi ndondomeko likuwonetsa yankho, osati chiganizo.
- Fomuyi imatha kuwonedwa muzenera yapamwamba yomwe ili pamwamba pa tsamba.
Kugwiritsira ntchito zizindikiro za magulu ku Excel Formulas
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
- Selo ndilopakati lozungulira pakati pa khola loyikika ndi mzere wosakanizika pa tsamba.
- Mzere uliwonse umadziwika ndi kalata pamwamba pa ndime - monga A, B, C.
- Mzere uliwonse umadziwika ndi nambala yomwe ili kumanzere pamzerewu - 1, 2, 3.
- Mndandanda wa selo, ndiye, ndi kuphatikiza kwa mzere wa kalata ndi mzere wa mzere womwe umadutsa pa malo a selo - monga A1 , B2 , C3 , kapena W345.
- Mukamalemba ma selo, kalata ya kalata nthawi zonse imabwera poyamba.
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 + 2Zingakhale bwino kulumikiza deta mu maselo C1 ndi C2 ndikulembera fomu iyi mmalo mwake:
= C1 + C2Excel Basic Formula Example
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:
- Lembani deta mu selo.
- Lembani fungulo lolowani mukhiyo kapena dinani pa selo lina. ndi ndondomeko ya mouse kuti mutsirizitse cholowera.
Maphunziro Otsogolera
- Dinani pa selo C1 kuti mupange selo yogwira ntchito.
- Lembani 3 mu selo ndikusindikizira fungulo lolowani mukhiyi.
- Ngati ndi kotheka, dinani pa cell C2 .
- Lembani 2 mu selo ndikusindikizira fungulo lolowamo mukibokosi.
Kulowa Mndandanda
- Dinani pa selo D1 - ili ndi malo kumene zotsatira za fomuyi zidzawonekera.
- Lembani ndondomeko zotsatirazi mu selo D1: = C1 + C2
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- Yankho lachisanu liyenera kuoneka mu selo D1.
- 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
Gawo ili mu phunziro limagwiritsa ntchito pointer la mouse kuti mulowetse mafotokozedwe a selo kuti mulowe mu selo D2.
- Dinani pa selo D2 kuti mupange selo yogwira ntchito.
- Lembani chizindikiro chofanana ( = ) mu selo D2 kuti muyambe mwambo.
- Dinani pa selo C1 ndi ndondomeko ya mbewa kuti mulowetse selolo mu njirayi.
- Lembani chizindikiro chowonjezera ( + ).
- Dinani pa selo C2 ndi ndondomeko ya mbewa kuti mulowetse selo lachiwiri mu mawonekedwe.
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- 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 ubtractionMomwe Ntchito Yogwirira Ntchito imagwirira ntchito
- Ma opaleshoni aliwonse omwe ali nawo mabakita adzakonzedwa koyambirira kutsatiridwa ndi zovumbulutsidwa zilizonse.
- Pambuyo pake, Excel imawonetsa kuti magawano kapena kuchulukitsa ntchito ndi ofunika kwambiri, ndipo amachita ntchitozi mwadongosolo kuti zikhalepo kumanzere.
- Zomwezo zimaphatikizapo kuwonjezereka kwachiwiri ndi kuchotsa. Amaonedwa kuti ndi ofanana mu dongosolo la ntchito. Chilichonse chimene chimawoneka choyambirira mu mgwirizano, kuphatikizapo kuwonjezera kapena kuchotsa, ntchitoyi idzachitidwa yoyamba.
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
Chitsanzo chachiwiri ichi, chomwe chikuwonetsedwa pa chithunzi pamwambapa, chimafuna Excel kugwiritsa ntchito dongosolo la ntchito kuti awerengere yankho.
Kulowa Deta
- 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 / C5Pewani 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.
- Dinani pa selo D1 kuti mupange selo yogwira ntchito.
- Sakani chizindikiro chofanana ( = ) mu selo D1.
- Lembani mzere wotseguka wozungulira " ( " pambuyo pa chizindikiro chofanana.
- Dinani pa selo C2 ndi pointer ya mouse kuti mulowetsere selolo mu njirayi.
- Lembani chizindikiro chochepa ( - ) pambuyo pa C2.
- Dinani pa selo C4 kuti mulowetse selo ili mu njirayi.
- Lembani mzere womaliza wobisika " ) " pambuyo pa C4.
- Lembani chizindikiro chochulukitsa ( * ) pambuyo pa bwalo lomaliza.
- Dinani pa selo C1 kuti mulowetse selo ili mu njirayi.
- Lembani chizindikiro chowonjezera ( + ) pambuyo pa C1.
- Dinani pa selo C3 kuti mulowetse selo ili mu njirayi.
- Lembani chizindikiro chogawa ( / ) pambuyo pa C3.
- Dinani pa selo C5 kuti mulowetse selo ili mu njirayi.
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- Yankho -4 liyenera kuoneka mu selo D1.
- 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:
- Choyamba choyamba chimachotsa ntchito yochotsa (C2-C4) kapena (5-6), popeza ili ndi maboda, ndipo imapeza zotsatira za -1.
- Kenaka pulogalamuyi ikuwonjezereka kuti -1 ndi 7 (zomwe zili mu selo C1) kupeza yankho la -7.
- Kenaka Excel ikudumpha patsogolo kuti igawikane 9/3 (zomwe zili mu C3 / C5) chifukwa zisanafike kuwonjezera pa BEDMAS, kupeza zotsatira za 3.
- Ntchito yotsiriza yomwe ikufunika kuchitidwa ndiyo kuwonjezera -7 + 3 kuti mupeze yankho la chigawo chonse cha -4.