Sezvo mu "Eksele" verenga pauwandu hweavo: pfungwa dzinokosha

Nhasi, vakawanda vanoshandisa kombiyuta kuziva mubvunzo sei kuti "Eksele" verenga pauwandu hweavo. Izvi ndezvechokwadi nokuti Spreadsheets kazhinji ane mashoko nemifananidzo. Kana totaura Excel, kazhinji anobata pamusoro kubva muzana uye musiyano muzana.

mubereko 101

Nepo Excel anogona kuita zvinhu zvakawanda, chirongwa haagoni kukudzidzisa masvomhu. Saka, vamwe ruzivo inokosha unofanira kupinda. Kuratidza nhamba muchimiro mubereko kuna Excel, unofanira akashandisa zvikurukuru akagadzirirwa urongwa ichi. Kurishandisa, sarudza masero kuti pasi formatting, uye ipapo baya 'Percentage "iri boka" nhamba "Tab" Home "(akaisa patepi). Kutaura kuti "Eksele" verenga mubereko, tinoona kuti nokukurumidza izvi zvinoitwa nokushandisa inopisa anokosha mubatanidzwa Ctrl + Shift +%.

In Excel, nechigadziko mutengo anogara inochengetwa grade chimiro. Saka, kunyange kana ukashandisa chinokosha Manyorerwo nokuti kuratidza chinhu muzana (10%), ndiko mufananidzo yokufananidzira zvitsigiro ukoshi. Nemamwe mashoko, Excel nguva dzose anoita Masvomhu mu grade ukoshi (0,1). To kaviri kutarisa kuti, sarudza muchitokisi, wokudhinda Ctrl + 1 uye kutarisa mimwe kusango "General mhando".

zvinhu pfungwa

Formatting munhu chikamu ingaita kunzwisisa zvishoma. Saka, kuti tinzwisise sei kuverenga pauwandu hweavo vari Excel, unofanira kufunga zvinotevera.

Pamanyorerwo aivapo tsika dziri kushanda kunoita chikamu ukoshi muchitokisi kare kuti ane data, Excel anowedzera pakuwanda 100 uye anowedzera kuti% chiratidzo apera. Izvi zvinotungamirira kuvhiringidzika, saka unofanira nokungwarira kunzwisisa zviri kuitika.

Toti kuti iwe kutaipa 10 muchitokisi A2, uye ipapo kushandisa pamanyorerwo%. Nekuti Excel anoratidza nhamba multiples ose 100 kuratidza rive chikamu (rangarira kuti 1% - ichi chikamu imwe zana), uchaona kuti 1000% unoratidzwa muchitokisi, pane 10%. Kushanda kumativi dambudziko iri, unogona exchange kukosha kwayo kuva chikamu pakutanga. Somuenzaniso, kana mapinda nzira = 10/100 A2, Excel achapa mugumisiro sezvo 0.1 muchitokisi. Kana unogona zvino Format ari grade data, nhamba chichange uratidzwe se 10% - sezvo here zvawaizotarisira. Unogona chete kupinda nhamba iri grade chimiro zvakananga kupinda muchitokisi, kureva, kupinda 0.1, uye ipapo kushandisa chikamu format. Izvi zvichabatsira kuna kana muchitsvaka mukana, sapamazuva "Excel" wedzera mubereko kana kutora mamwe zviito navo.

Empty Sero nemanyorerwo: Excel achiita zvakasiyana kana iwe Format munhu pre-chiro masero, uye ipapo kupinda nhamba. Numbers akaenzana uye kupfuura 1, ari kuchinjwa kuti default mubereko; nhamba asingasviki 1 dzisiri kunaka, vawanda ne 100 kutendeutsa navo pauwandu hweavo. Somuenzaniso, kana iwe kutaipa 10 kana 0.1 iri reformatted muchitokisi, unogona kuona kukosha 10% kukaonekwa. Zvino, kana imi kutaipa 0.1, uchaona kuti vakaratidza ukoshi kuchinja. Rinogonawo kukuratidza sei kuti "Eksele" bvisa mubereko.

Format sezvo imi kutaipa: Kana mapinda 10% zvakananga kupinda muchitokisi, Excel vachangoerekana kushandisa chikamu format. Izvi zvinobatsira kana uchida kupinda chimwe chete muzana pamusoro jira Somuenzaniso, uwandu mutero kana basa.

mubereko statement

Sei uye pamunopinda chero zvokuimba kupinda Excel, unofanira kutanga kunyora kukosha, kutaipa chiratidzo yakaenzana (=) muchitokisi dzakasarudzwa. The inokosha yokuita kuti "Eksele" verenga mubereko tarirai seizvi: = B2 / C2.

Mumwe muenzaniso zvingava zvakaoma zvikuru kukarukureta. Saka, kana uchida kuderedza imwe mari kuti 25% kana iwe edza kushandisa dhisikaundi, inonyatsoita wako Muchawana zvinotevera chimiro: = B2 * (1-C2). Kuwedzera 25%, inofanira chikatsiviwa kubvisa chiratidzo nzira iri ndinoiitawo.