Ungabala kanjani iphesenti lokumaka ku-Excel

Ku-Microsoft Office Excel, kungenzeka ukubala iphesenti lemakhaphu yomkhiqizo othile ngesikhathi esifushane kakhulu ngokusebenzisa ifomula ekhethekile. Imininingwane yokubala izovezwa kulesi sihloko.

Yini i-markup

Ukuze ubale le parameter, kufanele uqale uqonde ukuthi iyini. I-Markup umehluko phakathi kwezindleko ze-wholesale nezokudayisa zezimpahla, okuholela ekwenyukeni kwentengo yemikhiqizo yomthengi wokugcina. Ubukhulu bemajini buncike ezintweni eziningi, futhi kufanele buhlanganise nezindleko.

Nakani! Imajini kanye nemakhaphu imiqondo emibili ehlukene futhi akufanele kudidaniswe. I-margin iyinzuzo yonke ekuthengisweni kwempahla, etholakala ngemva kokudonsa izindleko ezidingekayo.

Ungabala Kanjani Amaphesenti EMarkup ku-Excel

Asikho isidingo sokubala ngesandla. Lokhu akufanelekile, ngoba. I-Excel ikuvumela ukuthi wenze ngokuzenzakalelayo noma yisiphi isenzo sezibalo, wonge isikhathi somsebenzisi. Ukuze ubale ngokushesha iphesenti lokumaka kule software, udinga ukwenza lezi zinyathelo ezilandelayo:

1. Hlanganisa ithebula ledatha langempela. Kulula kakhulu ukusebenza ngamakholomu asevele eqanjwe igama. Isibonelo, ikholomu lapho umphumela wefomula uzovezwa khona ingabizwa ngokuthi “Markup,%”. Nokho, isihloko sekholomu asiwuthinti umphumela wokugcina ngakho-ke singaba yinoma yini.
2. Faka uphawu oluthi “Equals” olusuka kukhibhodi uye kuseli elidingekayo, elingenalutho lohlu lwetafula bese ufaka ifomula eshiwo esigabeni sangaphambilini. Isibonelo, faka "(C2-A2) / A2 * 100". Isithombe esingezansi sibonisa ifomula ebhaliwe. Kubakaki kunamagama amaseli lapho kubhalwa khona amanani ahambisanayo enzuzo nezindleko zezimpahla. Eqinisweni, amaseli angase ahluke.

3. Cindezela okuthi “Enter” kukhibhodi yekhompyutha ukuze uqedele ifomula.
4. Hlola umphumela. Ngemva kokwenza lokhu kukhohlisa okungenhla, engxenyeni yethebula lapho ifomula ifakwe khona, inombolo ethile kufanele iboniswe ebonisa inkomba yokumaka yomkhiqizo njengephesenti.

Kubalulekile! Imakhaphu ingabalwa mathupha ukuze kubhekwe ukuthi inani eliwumphumela lilungile yini. Uma konke kulungile, ifomula enqunyiwe kufanele yelulwe emigqeni esele yohlu lwetafula ukuze igcwaliswe ngokuzenzakalelayo.

Imajini ibalwa kanjani ku-MS Excel

Ukuze uthole ukuqonda okuphelele kwesihloko, kuyadingeka ukucabangela umthetho wokubala we-margin ku-Microsoft Office Excel. Nalapha futhi, akufanele kube nezinkinga nakubasebenzisi abangenalwazi bohlelo. Ukuze uthole umphumela ophumelelayo, ungasebenzisa i-algorithm yesinyathelo ngesinyathelo:

1. Dala ispredishithi ukuze ubale imajini. Kuhlu lokuqala lwethebula, ungabeka amapharamitha ambalwa wokubala, kuhlanganise nemajini.
2. Beka ikhesa yegundane kuseli elihambisanayo lepuleti, faka uphawu oluthi “Equal” bese ubhala ifomula ekhonjiswe ngenhla. Ngokwesibonelo, ake sibhale inkulumo elandelayo: “(A2-C2) / C2 * 100”.

3. Cindezela okuthi “Enter” kusukela kukhibhodi ukuze uqinisekise.
4. Hlola umphumela. Umsebenzisi kufanele aqinisekise ukuthi iseli elikhethwe ngaphambilini linenani elibonisa inkomba yemajini. Ukuze kuqinisekiswe, ungakwazi ukubala kabusha ivelu mathupha ngezinkomba ezishiwo. Uma izimpendulo zihlangana, ifomula enqunyiwe inganwetshwa kumaseli asele ochungechunge lwetafula. Kulokhu, umsebenzisi uzozisindisa ekugcwaliseni kabusha into ngayinye edingekayo etafuleni, onge isikhathi sakhe.

Ulwazi Olwengeziwe! Uma ngemuva kokubhala ifomula, isoftware ye-Microsoft Office Excel idala iphutha, umsebenzisi uzodinga ukuthi ahlole ngokucophelela ukunemba kwezinhlamvu ezifakwe kunkulumo.

Ngemva kokubala izinkomba zemakhaphu nemajini, ungahlela lawa manani etafuleni lokuqala ukuze ubone ngeso lengqondo umehluko phakathi kokuncika okubili.

Ungabala kanjani inani lephesenti ku-Excel

Uma umsebenzisi edinga ukuqonda ukuthi iyiphi inombolo yenkomba ephelele iphesenti elibaliwe elihambisana nayo, kufanele enze lokhu kukhohlisa okulandelayo:

1. Kunoma iyiphi iseli yamahhala yekhasi lokusebenzela le-Excel, bhala ifomula “= inani lephesenti * inani eliphelele.” Imininingwane eyengeziwe esithombeni esingezansi.

2. Cindezela okuthi “Enter” kusukela kukhibhodi ye-PC ukuze uqedele ifomula.
3. Hlola umphumela. Esikhundleni sefomula, inombolo ethile izovela kuseli, okuzoba umphumela wokuguqulwa.

4. Ungakwazi ukunweba ifomula emigqeni esele yethebula uma inani eliphelele okubalwa ngalo iphesenti lifana naso sonke isimo.

Nakani! Ukuhlola inani elibaliwe kwenziwa kalula ngesandla kusetshenziswa umshini wokubala ovamile.

Ungabala kanjani iphesenti lenombolo ku-Excel

Lena inqubo ehlehlayo okukhulunywe ngayo ngenhla. Isibonelo, udinga ukubala ukuthi mangaki amaphesenti inombolo engu-9 esuka kunombolo 17. Ukuze ubhekane nomsebenzi, kufanele wenze kanje:

1. Beka ikhesa yegundane kuseli elingenalutho ekhasini lokusebenza le-Excel.
2. Bhala ifomula ethi “=9/17*100%”.

3. Cindezela okuthi “Enter” kusukela kukhibhodi ukuze uqedele ifomula futhi ubone umphumela wokugcina kuseli efanayo. Umphumela kufanele ube ngu-52,94%. Uma kunesidingo, inani lamadijithi ngemva kwephuzu ledesimali lingandiswa.

Isiphetho

Ngakho, inkomba yemajini yomkhiqizo othile ku-Microsoft Office Excel ibalwa kusetshenziswa ifomula evamile. Into esemqoka ukubhala inkulumo ngendlela efanele, ekhombisa amaseli afanele lapho kubhalwa khona amanani afiswayo. Ukuze uqonde lesi sihloko kahle, udinga ukufunda ngokucophelela ulwazi olungenhla.