Pamalo a spreadsheets, Excel yakhala chida chofunikira kwambiri kwa akatswiri ambiri ndi ophunzira chimodzimodzi. Ntchito zake zambiri zapamwamba ndi luso zimalola mawerengedwe ovuta kuchitidwa bwino. Chimodzi mwazochita zodziwika kwambiri pakusanthula manambala ndikukweza nambala ku mphamvu inayake. M'nkhaniyi, tiwona momwe tingakwezere mphamvu mu Excel, pogwiritsa ntchito ntchito zoyenera ndi mafomu kuti tipeze zotsatira zolondola komanso zodalirika. Tiphunzira njira zofunika kuti tichite ntchitoyi, kukulitsa kugwiritsa ntchito kwake ndikupewa zolakwika zomwe zingachitike. Konzekerani kukulitsa luso lanu la Excel!
1. Chiyambi cha ntchito za mphamvu mu Excel
Ntchito zamphamvu mu Excel ndi chida chothandiza kwambiri pakuwerengera ndi kusanthula deta. Ntchitozi zimakupatsani mwayi wokweza nambala ku mphamvu yomwe mwapatsidwa, kuwerengera mizu, ndikuchita masamu ena. M'nkhaniyi, ndikutsogolerani sitepe ndi sitepe momwe mungagwiritsire ntchito izi njira yothandiza.
Poyambira, pali ntchito zingapo zamphamvu zomwe zikupezeka ku Excel, monga POWER, POWER.MATRIY, ROOT, CUBICROOT, BETWEEN, PRODUCT, ndi zina. Ntchitozi zimagwiritsidwa ntchito kutengera mtundu wa mawerengedwe omwe muyenera kuchita. Mwachitsanzo, ngati mukufuna kukweza nambala ku mphamvu inayake, mutha kugwiritsa ntchito mphamvu ya MPHAMVU. Ngati mukufuna kuwerengera muzu lalikulu la nambala, mutha kugwiritsa ntchito ROOT.
Kuti mugwiritse ntchito izi, choyamba muyenera kusankha cell komwe mukufuna kuti zotsatira ziwonekere. Kenako, lembani dzina la ntchitoyo ndikutsatiridwa ndi mabatani. M'kati mwa makolo, tchulani zikhalidwe kapena ma cell omwe mukufuna kugwiritsa ntchito powerengera. Onetsetsani kuti mulekanitsa zikhalidwe ndi ma koma. Mwachitsanzo, ngati mukufuna kukweza nambala 2 ku mphamvu ya 3, mukhoza kulemba =MPHAMVU(2,3). Mukangolowa ntchitoyi, dinani Enter ndipo Excel idzawerengera zotsatira zokha.
2. Momwe mungagwiritsire ntchito wogwiritsa ntchito mphamvu mu Excel
Wogwiritsa ntchito mphamvu ku Excel ndi chida chothandiza powerengera ma exponential. Kuti mugwiritse ntchito opareshoni, muyenera kutsatira izi:
1. Sankhani selo lomwe mukufuna kuwerengera mokulirapo. Onetsetsani kuti selo ilibe kanthu ndipo mwakonzeka kulandira zotsatira.
2. Lembani nambala yoyambira, yotsatiridwa ndi chizindikiro cha nyenyezi ziwiri (), ndiyeno nambala ya exponent. Mwachitsanzo, ngati mukufuna kukweza 2 ku mphamvu ya 3, mungalembe "23″ mu cell.
3. Dinani batani la Enter ndipo Excel idzawerengera zotsatira zake. Pankhaniyi, mupeza 8 chifukwa chake 2 yokwezedwa ku mphamvu ya 3 ikufanana ndi 8.
Ndikofunikira kukumbukira kuti wogwiritsa ntchito magetsi amakhala patsogolo kuposa ogwiritsa ntchito ena mu Excel. Ngati muli ndi ndondomeko yovuta kwambiri yomwe imaphatikizapo kuwerengera kwina, ndibwino kuti mugwiritse ntchito mabatani kuti muwonetse dongosolo la ntchito.
Kumbukirani kuti wogwiritsa ntchito mphamvu ku Excel atha kugwiritsidwanso ntchito potengera ma cell ena. Mwachitsanzo, ngati mukufuna kukweza nambala yosungidwa mu selo A1 ku mphamvu ya nambala ina mu selo B1, mungalembe "=A1**B1" mu selo limene mukufuna zotsatira. Excel idzawerengera zotsatira kutengera ma cell omwe atchulidwa.
3. Njira zokwezera nambala ku mphamvu mu Excel
Kuti mukweze nambala ku mphamvu mu Excel, mutha kugwiritsa ntchito ntchitoyi POW. Ntchitoyi imafuna mikangano iwiri: nambala yoyambira ndi exponent yomwe mukufuna kukweza. Nachi chitsanzo chogwiritsa ntchito ntchito ya POW:
=POW(A1, B1)
Kumene A1 ndi cell yomwe ili ndi nambala yoyambira ndi B1 ndi cell yomwe ili ndi exponent.
Kuphatikiza pa kugwiritsa ntchito ntchito ya POW, mutha kugwiritsanso ntchito wogwiritsa ntchito mphamvu (^) kukweza nambala ku mphamvu mu Excel. Othandizira magetsi amagwiritsidwa ntchito motere:
=A1^B1
Kumene A1 ndi cell yomwe ili ndi nambala yoyambira ndi B1 ndi cell yomwe ili ndi exponent.
Ngati mukufuna kukweza nambala ku mphamvu yosalekeza yomwe siili mu selo, mutha kugwiritsa ntchito mwachindunji ntchito ya POW kapena wogwiritsa ntchito mphamvu. Mwachitsanzo:
=POW(3, 2)
Chitsanzo ichi chikhala ndi nambala 3, yomwe idzafanana ndi 9.
4. Zitsanzo zothandiza zamomwe mungakwezere mphamvu mu Excel
Chimodzi mwazinthu zomwe zimagwiritsidwa ntchito kwambiri mu Excel ndikukweza mphamvu. Kutha kuwerengera izi ndikofunikira kuti muzichita masamu osiyanasiyana ndikuwerengera zotsatira zolondola. M'nkhaniyi, tifotokoza zina, potsatira njira imodzi ndi sitepe.
Musanayambe ndi zitsanzo, ndikofunikira kukumbukira kuti mu Excel ^ chizindikiro chimagwiritsidwa ntchito kutanthauza ntchito yokweza mphamvu. Mwachitsanzo, kukweza nambala 2 ku mphamvu 3, ndondomekoyi imagwiritsidwa ntchito =2^3. Izi zikamveka, tingayambe ndi zitsanzo zothandiza.
Chitsanzo 1: Tiyerekeze kuti tikufuna kuwerengera zotsatira zokweza chiwerengero cha 5 ku mphamvu ya nambala 1 mpaka 5. Kuti tichite izi, tingagwiritse ntchito ntchito ya MPHAMVU mu Excel. Mu cell yopanda kanthu, titha kuyika fomula =MPHAMVU(5, A1), pomwe A1 ndi cell yomwe ili ndi nambala yomwe tikufuna kukweza mphamvu. Pokokera fomulayi m'maselo oyandikana nawo, tidzapeza zotsatira za mphamvu zotsatizana.
5. Ntchito Zamphamvu Zapamwamba mu Excel
Ndi chida chothandiza kwambiri posanthula ndikuwongolera bwino deta. Ntchitozi zimatithandiza kuwerengera zovuta ndikupeza zotsatira zolondola m'malemba athu a Excel. Nazi zina mwazinthu zotsogola zomwe zimagwiritsidwa ntchito kwambiri komanso momwe mungagwiritsire ntchito pamaspredishiti anu.
SUM NGATI KUKHALA: Ntchitoyi imatithandiza kuti tiwerengere kuchuluka kwazinthu zomwe zimakwaniritsa zofunikira zina. Mwachitsanzo, ngati tili ndi mndandanda wa malonda ndi malonda ndipo tikufuna kuwonjezera malonda okha cha chinthu makamaka, tingagwiritse ntchito ntchitoyi. Kuti tigwiritse ntchito, tiyenera kufotokoza kuchuluka kwazinthu zomwe tingawonjezere komanso zosefera.
WOGWIRITSA NTCHITO: Ndi ntchitoyi titha kupeza avareji yamitengo mumitundu yomwe imakwaniritsa zofunikira zina. Mwachitsanzo, ngati tili ndi tebulo lokhala ndi magiredi a ophunzira ndipo tikufuna kupeza avareji ya ophunzira okha omwe adapambana mayeso, titha kugwiritsa ntchito ntchitoyi. Monga momwe zinalili m'mbuyomu, timangofunika kufotokoza mtundu wa mtengo ndi zosefera.
6. Kuwerengera mphamvu ndi maumboni a cell mu Excel
Kuti tichite zimenezi, m'pofunika kutsatira njira zina kuti atsogolere ndondomekoyi. Choyamba, ndikofunikira kumvetsetsa momwe mphamvu imawerengedwera mu Excel. Njira yowerengera mphamvu ndi = MPHAMVU(nambala, wowonjezera). Apa, "nambala" ikuyimira maziko ndipo "exponent" ikuyimira mphamvu yomwe mazikowo adzakwezera.
Njira yoyambira ikamvetsetseka, ndikofunikira kudziwa magwiridwe antchito omwe angathandize kuwerengera mosavuta. Mwachitsanzo, ntchito =MPHAMVU.YES Amagwiritsidwa ntchito mukafuna kuwerengera mphamvu pazofunikira zina zomwe zimakwaniritsa zofunikira zina. Ntchitoyi iliponso =MPHAVU YAMATRIX, zomwe zimakupatsani mwayi wowerengera mphamvu za manambala osiyanasiyana ndi ma exponents zonse ziwiri.
Kuphatikiza apo, Excel imapereka zida zowoneka bwino zowerengera mphamvu. Mwachitsanzo, mutha kugwiritsa ntchito formula bar kuti muyike zolozera ku selo lomwe lili ndi nambala yoyambira ndi selo lina lomwe lili ndi chowonjezera. Izi zimapangitsa kuti zikhale zosavuta kusintha zinthu ndikupewa zolakwika mukamalemba manambala pamanja. Pivot tables itha kugwiritsidwanso ntchito kusanthula ndi kuwonetsa zotsatira za mawerengedwe amphamvu mumtundu wosavuta kumva.
7. Malangizo ndi zidule kuti mukweze ku mphamvu mu Excel
Mu Excel, kukweza nambala ku mphamvu ndi ntchito yomwe imagwiritsidwa ntchito powerengera masamu ndi kusanthula deta. Mwamwayi, pulogalamuyi imapereka njira zingapo zochitira opaleshoniyi mwachangu komanso molondola. M'munsimu muli ena:
1. Wothandizira mphamvu (^): Wogwiritsa ntchito mphamvu ndi imodzi mwa njira zosavuta zokwezera nambala mu Excel. Chizindikiro cha "caret" (^) chimangogwiritsidwa ntchito kusonyeza mphamvu yomwe mukufuna kukweza nambala. Mwachitsanzo, kuti mukweze nambala 2 ku mphamvu yachitatu, lembani "=2^3" mu selo ndikusindikiza Enter. Zotsatira zake zikhala 8.
2. Mphamvu yamphamvu: Excel imaperekanso ntchito yapadera yowerengera mphamvu. Ntchito ya POWER imakupatsani mwayi wokweza nambala ku mphamvu iliyonse yodziwika. Kuti mugwiritse ntchito ntchitoyi, lembani «=POWERNUM; MPHAMVU)» m'chipinda chomwe mukufuna kupeza zotsatira. Mwachitsanzo, kuti mukweze nambala 4 ku mphamvu yachisanu, lembani "= MPHAMVU(4,5)", ndipo zotsatira zake zidzakhala 1024.
3. Maumboni osiyanasiyana: Kuphatikiza pa kukweza nambala ku mphamvu yokhazikika, ndizothekanso kuchita ntchitoyi pogwiritsa ntchito maumboni osakanikirana mu Excel. Izi zimalola mphamvu yosiyana kuti igwiritsidwe ntchito pa selo iliyonse mumtundu womwe waperekedwa. Kuti muchite izi, ntchito ya MPHAMVU ingagwiritsidwe ntchito limodzi ndi maumboni a maselo ena. Mwachitsanzo, ngati muli ndi zikhalidwe zamaselo A1: A5 ndipo mukufuna kukweza iliyonse mwa manambalawa ku mphamvu yotchulidwa mu selo B1, mumalemba "= MPHAMVU(A1,B$1)" mu selo. C1 ndikukokera fomula ku selo C5. Mwanjira iyi, nambala iliyonse idzakwezedwa ku mphamvu ina kutengera mtengo wa cell B1.
Izi malangizo ndi machenjerero Adzakuthandizani kuti mukweze ku nyumba yamagetsi ku Excel bwino komanso molondola. Kaya mukugwiritsa ntchito woyendetsa magetsi, mphamvu ya POWER, kapena maumboni osakanikirana, mutha kuwerengera mphamvu mwachangu komanso mosavuta. Yesani ndi izi ndikupeza yomwe ikukwaniritsa zosowa zanu pakuwunika kwanu ndi masamu. Musaiwale kuyesa ndikugwiritsa ntchito chidziwitsochi m'malo osiyanasiyana kuti muwongolere luso lanu la Excel.
8. Kusanthula zolakwika wamba pakukweza mphamvu mu Excel
Mukakweza mphamvu mu Excel, ndizofala kulakwitsa ngati njira yoyenera siyitsatiridwa. Apa tikuwonetsa zolakwika zomwe zimachitika kwambiri komanso momwe tingathere:
1. Cholakwika cha kalembedwe: Ndikofunika kuzindikira kuti pokweza mphamvu mu Excel, "^" wogwiritsa ntchito amagwiritsidwa ntchito. Ngati mugwiritsa ntchito chizindikiro china kapena kusiya zolembera molondola, Excel itulutsa uthenga wolakwika. Mwachitsanzo, m'malo molemba "=A12A^2", njira yoyenera ingakhale "=A1^2". Onetsetsani kuti mumatsatira mawu olondola kuti mupewe cholakwika ichi.
2. Vuto lolakwika: Vuto lina lodziwika bwino ndikulozera pa selo yolakwika. Mwachitsanzo, ngati mukufuna kupanga masikweya cell B2, onetsetsani kuti mwalemba "=B2^2" m'malo mwa "=B3^2." Yang'anani mosamala maumboni a ma cell mu fomula yanu kuti mupewe zolakwika zamtunduwu.
3. Cholakwika pakusakaniza zofananira mtheradi ndi wachibale: Excel imakupatsani mwayi wogwiritsa ntchito maumboni amtheradi komanso achibale mukamakweza mphamvu. Ngati mukufuna kusunga kalozera wa selo nthawi zonse pokopera fomula, onetsetsani kuti mwagwiritsa ntchito chizindikiro cha "$" pamaso pa chilembo ndi nambala. Mwachitsanzo, ngati mukufuna kukulitsa selo B2 ndikukopera fomula pansi, mungagwiritse ntchito "=B$2^2" m'malo mwa "=B2^2." Izi zidzatsimikizira kuti kutchulidwa kwa cell B2 kumakhalabe kosasintha.
9. Zida zowonjezera zowonjezera mphamvu mu Excel
Mu Excel, pali zida zina zowonjezera zomwe zitha kukhala zothandiza kwambiri kukulitsa luso lanu ndikuwongolera kasamalidwe ka data. Zida izi zimakupatsani mwayi wochita zinthu zapamwamba komanso zovuta, zomwe zingakuthandizeni kukonza zokolola zanu komanso kuchita bwino. Pansipa, tilemba zina mwazida zodziwika bwino zokulitsa luso lanu la Excel.
1. Wothetsa mavuto: Ndi chida chothandiza kwambiri kupeza njira yothetsera vuto lalikulu. Ikhoza kugwiritsidwa ntchito kuthetsa mavuto kukhathamiritsa kapena kupeza phindu lalikulu kapena lochepera la ntchito yoperekedwa kutengera zoletsa zingapo. Kupyolera mu Solver, mutha kufotokozera cholinga chomwe mukufuna kukwaniritsa ndi zoletsa zomwe ziyenera kukwaniritsidwa, kenako ndikupeza yankho labwino kwambiri.
2. Kusanthula deta: Excel ili ndi zida zingapo zowunikira zomwe zingakuthandizeni kupeza zidziwitso zofunika za deta yanu. Zida izi zimachokera ku ntchito zowerengera zowerengera mpaka kusanthula kwanthawi yayitali, kusanthula kusiyanasiyana ndi kusanthula zomwe zikuchitika. Kuphatikiza apo, mutha kupanga ma graph osinthika ndi matebulo osinthika kuti muwonetsetse deta yanu bwino.
3. Kufunsa Mphamvu: Chida ichi chidzakuthandizani kuitanitsa, kusintha ndi kuyeretsa deta kuchokera kuzinthu zosiyanasiyana mofulumira komanso moyenera. Mukhoza kuphatikiza deta zosiyanasiyana owona kapena malo osungiramo deta zokha, chitani zosefera, gawani mizati, pakati pa zinthu zina zoyeretsa ndikusintha. Power Query ndiyothandiza makamaka mukamagwira ntchito ndi ma data ambiri kapena mukafuna kusinthiratu deta yanu pafupipafupi.
Izi ndi zina mwa zida zowonjezera zomwe zimapezeka mu Excel zomwe zingakuthandizeni kupititsa patsogolo luso lanu ndikupeza zambiri pazambiri zanu. Onani zida izi ndikuwona momwe zingasinthire ntchito zanu ndikupangitsa kuti ntchito yanu ndi Excel ikhale yosavuta!
10. Kuyerekeza kwa ntchito za mphamvu mu Excel: MPHAMVU vs. ^ woyendetsa
Mu Excel, pali njira zingapo zogwirira ntchito zowonjezera. M'nkhaniyi, tifanizira njira ziwiri zodziwika bwino zochitira izi: kugwiritsa ntchito ntchitoyi MPHAMVU ndi woyendetsa ^. Zosankha zonse ziwirizi zimatilola kukweza nambala ku mphamvu inayake, koma aliyense ali ndi ubwino wake ndi zomwe akuyenera kuziganizira.
Ntchito MPHAMVU Excel ndi ntchito ya masamu yomwe imatilola kuchita ntchito zowonjezera m'njira yosavuta. Kuti tigwiritse ntchito ntchitoyi, tiyenera kungoyika nambala yoyambira ndi mphamvu yomwe tikufuna kuyikweza. Mwachitsanzo, ngati tikufuna kukweza nambala 2 kuti ikhale 3, tingagwiritse ntchito ndondomekoyi =MPHAMVU(2,3). Ntchitoyi ndi yothandiza makamaka tikafuna kukweza manambala ku mphamvu zomwe sizinthu zonse, chifukwa zimatilola kugwira ntchito ndi ma exponents ang'onoang'ono kapena a decimal.
M'malo mwake, wogwiritsa ntchito ^ Imatithandizanso kuchita ntchito zowonjezera mu Excel. Wogwiritsa ntchitoyu amagwiritsidwa ntchito mofanana ndi ochita masamu ena, monga kuwonjezera kapena kuchotsa. Tiyenera kungoyika nambala yoyambira, ndikutsatiridwa ndi woyendetsa ^, ndipo potsiriza mphamvu yomwe tikufuna kuikweza. Mwachitsanzo, kuti tikweze nambala 2 ku mphamvu 3, tingagwiritse ntchito ndondomekoyi =2^3. Ndikofunika kukumbukira kuti wogwiritsa ntchitoyo amalola kugwira ntchito ndi ma exponents okwanira, kotero ngati tikufuna kugwira ntchito ndi ma exponents ang'onoang'ono, tiyenera kugwiritsa ntchito ntchitoyi. MPHAMVU.
11. Momwe mungawerengere mizu ya square ndi cube mu Excel
Kuwerengera mizu ya square ndi cube mu Excel ndi ntchito yosavuta yomwe ingathe kuchitidwa pogwiritsa ntchito mafomu ndi ntchito zinazake. Pansipa, ndikuwonetsani masitepe ofunikira kuti muwerenge izi molondola komanso moyenera.
Kuwerengera muzu square mu Excel, mutha kugwiritsa ntchito SQRT (). Ntchitoyi imatenga mkangano umodzi, womwe ndi nambala yomwe mukufuna kuwerengera sikweya mizu. Mwachitsanzo, ngati mukufuna kuwerengera masikweya a 9, mutha kugwiritsa ntchito fomula =SQRT(9), ndipo zotsatira zake zidzakhala 3. Ndikofunika kuzindikira kuti ntchito ya SQRT () nthawi zonse imabweretsa phindu la square root.
Kuti muwerenge muzu wa cube mu Excel, mutha kugwiritsa ntchito ntchitoyi CBRT (). Monga SQRT () ntchito, ntchito ya CBRT () imatenga mkangano umodzi, womwe ndi nambala yomwe mukufuna kuwerengera muzu wa cube. Mwachitsanzo, ngati mukufuna kuwerengera muzu wa cube wa 27, mutha kugwiritsa ntchito fomula =CBRT(27), ndipo zotsatira zake zidzakhala 3. Ndikofunika kunena kuti ntchito ya CBRT() imabweretsa zonse zabwino ndi zoipa za muzu wa cube. Kuti mupeze phindu lokhalo, mutha kugwiritsa ntchito ntchito ya ABS () kuti mupeze phindu lenileni lazotsatira.
12. Kugwiritsa Ntchito Boost Functions for Data Analysis mu Excel
Ntchito zamagetsi mu Excel ndi zida zothandiza kwambiri pakusanthula deta. Ndi ntchito izi, titha kuchita masamu pakukweza mphamvu mwachangu komanso moyenera. Kenako, ndikuwonetsani momwe mungagwiritsire ntchito izi pamasamba anu.
Kuti tiyambe, tiyenera kusankha selo limene tikufuna kusonyeza zotsatira za kuwongola. Kenako, timayika fomula ili: = MPHAMVU(nambala, wowonjezera). Mu "nambala" muyenera kuyika mtengo womwe mukufuna kukweza ku mphamvu ndipo mu "exponent" muyenera kulemba mtengo wa mphamvu yomwe mukufuna kukweza chiwerengerocho.
Kuphatikiza pa ntchito ya POWER, Excel ilinso ndi ntchito zina zofananira monga POWER.IF, POWER.MATRIX, ndi POWER.ERROR. Ntchitozi zimakupatsani mwayi wowonjezera zokhazikika, kukulitsa magulu onse, ndikuwongolera zolakwika, motsatana. Musazengereze kufufuza njira izi kuti muwonjezere kuthekera kwa kusanthula mumaspredishiti anu.
13. Kupititsa patsogolo mu Excel: makiyi a kuwerengera kolondola komanso koyenera
Powering ndi njira yodziwika bwino ya masamu pakuwerengera kwa Excel ndipo imatha kukhala yothandiza kwambiri kufewetsa mafomu ndikufulumizitsa njira. M'gawoli, tikuwonetsani makiyi owerengera molondola komanso moyenera pogwiritsa ntchito kupatsa mphamvu mu Excel.
Kuti muwonjezere nambala mu Excel, mutha kugwiritsa ntchito ntchitoyi POW kapena woyendetsa ^. Mwachitsanzo, ngati mukufuna kuwerengera 2 ku mphamvu ya 3, mutha kuyika formula =POW(2,3) kapena mophweka 2^3. Njira zonsezi zikupatsani zotsatira za 8.
Ngati mukufunika kulimbikitsa kwambiri ndi cell reference m'malo mwa nambala yeniyeni, ingophatikizaninso ma cell mu fomula. Mwachitsanzo, ngati muli ndi nambala 2 mu selo A1 ndipo mukufuna kuwerengera 2 ku mphamvu ya 3, mungagwiritse ntchito njira = A1 ^3. Mwanjira iyi, ngati mutasintha mtengo mu selo A1, zotsatira zowonjezera zidzasinthidwa zokha.
14. Njira zabwino kwambiri zopezera mphamvu mu Excel
Mukakweza mphamvu mu Excel, ndikofunikira kutsatira njira zina zabwino kuti mupeze zotsatira zolondola ndikupewa zolakwika zomwe zingachitike. M'munsimu muli malingaliro ena kuti mugwire ntchitoyi moyenera.
1. Sankhani selo yoyenera: Musanakweze ku mphamvu, onetsetsani kuti mwasankha selo yoyenera komwe mukufuna kuwonetsa zotsatira. Izi zitha kukhala cell yopanda kanthu kapena yomwe ili ndi nambala yomwe mukufuna kuyikapo ntchito yowonjezera.
2. Gwiritsani ntchito mphamvu ya POWER: Excel imapereka ntchito yapadera kuti ikweze ku mphamvu. Mutha kulemba mwachindunji fomula mu cell yomwe mwasankha kapena kugwiritsa ntchito ntchitoyi mwanjira yovuta kwambiri. Mwachitsanzo, kukulitsa nambala 2, mutha kugwiritsa ntchito chilinganizo "= MPHAMVU(2, 2)" kapena kungolemba "2^2" mu cell yomwe mwasankha.
3. onani zotsatira: Pambuyo pogwiritsira ntchito mphamvuyi, ndi bwino kutsimikizira zotsatira zake kuti muwonetsetse kuti ndizolondola. Nthawi zonse ndizotheka kulakwitsa polemba fomula kapena mikangano mu Excel, fufuzani kawiri! Komanso, onetsetsani kuti mwazindikira njira zomwe Excel imawonetsera zotsatira, monga mtundu wa manambala kapena zolemba zasayansi.
Pomaliza, ntchito yamagetsi mu Excel imayimira chida chofunikira powerengera masamu moyenera komanso molondola. Mwa kuphatikiza ntchito ya POWER ndi malamulo ena a Excel ndi ma formula, ndizotheka kugwiritsa ntchito mwachangu ntchito zamagetsi pamitundu yambiri.
Podziwa bwino izi, ogwiritsa ntchito azitha kusunga nthawi ndi khama powerengera mobwerezabwereza, motero amachepetsa ntchito zawo zatsiku ndi tsiku. Kuphatikiza apo, kusinthasintha kwa Excel kumapangitsa kuti mafomuwa azisinthidwa malinga ndi zosowa za aliyense wogwiritsa ntchito, kukwaniritsa mulingo wolondola komanso waluso pazotsatira zomwe zapezedwa.
Chofunika kwambiri, monganso mbali ina iliyonse ya Excel, kumvetsetsa bwino mfundo zoyambira zamasamba ndi ntchito za pulogalamuyo ndikofunikira. Chifukwa chake, tikupangira kuti ogwiritsa ntchito omwe ali ndi chidwi chofufuza kuthekera kwa kukweza mphamvu ku Excel amathera nthawi yowerengera ndikuyesa mwayi wosiyanasiyana womwe umapereka.
Ndi izi, azitha kugwiritsa ntchito bwino ntchitoyi ndikuigwiritsa ntchito ngati chida chodalirika chothetsera mavuto ovuta a masamu, kukonza bwino. kuntchito y onjezerani zokolola pakugwiritsa ntchito manambala. Mwachidule, ntchito yokweza mphamvu mu Excel ikuyimira chida chofunikira kwa ogwiritsa ntchito omwe amafunafuna njira yaukadaulo komanso yothandiza pantchito yawo yowerengera masamu.
Ndine Sebastián Vidal, mainjiniya apakompyuta omwe amakonda ukadaulo komanso DIY. Komanso, ine ndine mlengi wa tecnobits.com, komwe ndimagawana nawo maphunziro kuti ukadaulo ukhale wofikirika komanso womveka kwa aliyense.