Ukufometha Izinombolo ku-Excel Ukusebenzisa Izinqamuleli Zezinqamuleli

Amafomethi kukhona izinguquko ezenziwe kuma-Worksheets ukuze kuthuthukiswe ukubukeka kwazo kanye / noma ukugxila emininingwaneni ethile kwiphepha lokusebenzela.

Ukufometha kushintshe ukubukeka kwedatha, kodwa akuguquli idatha yangempela esitokisini, okungabalulekile uma leyo datha isetshenziselwa ukubalwa. Isibonelo, izinombolo zokufometha ukubonisa izindawo ezimbili zedesimali azifinyezi noma amanani angaphakathi azungeze izindawo ezimbili ezingaphezulu.

Ukuze ushintshe empeleni izinombolo ngale ndlela, idatha izodinga ukujikelezwa isebenze eyodwa yemisebenzi yokuqoqa i-Excel.

01 ngo-04

Ukufometha Amanani ku-Excel

Ukufometha kwenombolo ku-Excel kusetshenziselwa ukushintsha ukubukeka kwenombolo noma inani esitokisini ekhasini lokusebenzela.

Ukufometha kwenombolo kufakwe esitokisini hhayi kokubaluleka esitokisini. Ngamanye amazwi, ukufometha kwenombolo akuguquli inombolo yangempela esitokisini, kodwa nje ngendlela ebonakala ngayo.

Isibonelo, khetha iseli elifomathiwe ngezinombolo ezingalungile, ezikhethekile, noma ezide nenamba ethafeni kunokuba inombolo efomethiwe iboniswe kubha yamatomu ngaphezulu kwephepha lokusebenzela.

Izindlela ezihlanganisiwe zokushintsha ukufometha kwenombolo zifaka:

• izinkinobho zokunqamulela ekhibhodi;
• ukufometha imifanekiso kwi- ribbon ;
• ibhokisi lengxoxo yefomathi yefomathi .

Ukufometha kwenombolo kungasetshenziswa kuseli elilodwa, amakholomu noma imigqa, ibanga elikhethiwe lamaseli, noma ishidi lokusebenzela.

Ifomethi ezenzakalelayo yamaseli aqukethe yonke idatha yisitayela esijwayelekile. Lesi sitayela asinayo ifomethi ethile futhi, ngokuzenzakalelayo, sibonisa izinombolo ngaphandle kwezimpawu zama dollar noma amakhomitha nezinombolo ezixubekile - izinombolo ezinezigaba ezingezansi - azikhawulelwe kwinani elithile lezindawo zedesimali.

02 ka 04

Ukusebenzisa ukufometha kwenombolo

Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa ukufometha kwenombolo yedatha yilezi:

Ctrl + Shift + ! (iphuzu lokumemeza)

Amafomu asetshenziselwa idatha yezinombolo ezikhethiwe besebenzisa izinkinobho zesinqamuleli yi:

• izindawo ezimbili zedesimali
• i-comma njenge-separator yezinkulungwane (,)

Ukufaka ukufometha kwenombolo yedatha usebenzisa izinkinobho zokunqamulela:

1. Qinisekisa amaseli aqukethe idatha ukuthi ifomathiwe
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi
3. Cindezela bese ukhulula ukhiye wephoyinti (!) - etholakala ngaphezu kwenombolo 1 - ekhibhodi ngaphandle kokukhulula izinkinobho ze- Ctrl ne- Shift
4. Khipha okhiye be-Ctrl ne-Shift
5. Lapho kufanelekile, izinombolo kumaseli akhethiwe zizofomathwa ukuze zibonise amafomethi akhulunywe ngenhla
6. Ukuchofoza kunoma yiliphi lamaseli ubonisa inombolo engafaniwe engafaniwe ebhakisini lefomula ngaphezulu kwephepha lokusebenzela

Qaphela: ngezinombolo ezinezindawo ezimbili ezingaphezulu kwedesimenti kuphela izindawo zokuqala zesidali eziboniswayo, ezinye azikhiphi futhi zizosetshenziselwa ukubalwa ezifaka lezi zimiso.

Faka isicelo sokufometha kwenombolo usebenzisa izinketho zeRibbon

Nakuba amafomethi ambalwa avamile asetshenziswayo atholakalayo njengezithombe ngabanye kuthebhu yaseKhaya yebhebhoni, njengoba kuboniswe esithombeni ngenhla, amafomethi amaningi amanani atholakala kuhlu lokuhlaselwa kwefomu leNombolo - olubonisa jikelele njengefomethi ezenzakalelayo yamaseli Ukusebenzisa okukhethwa kukho uhlu:

1. Qinisekisa ukuthi amaseli wedatha azofomatha
2. Chofoza umcibisholo ophansi ngaphansi kwebhokisi lefomethi yenombolo ukuvula uhlu lokudonsa phansi
3. Chofoza kuNombolo yezinketho kuhlu ukuze usebenzise le nketho kumaseli akhethiwe yedatha

Izinombolo zifomathiwe ezindaweni ezimbili zesimanje ezifana nesinqamuleli sekhibhodi ngenhla, kepha ukwahlukana kombala akusetshenziswanga ngale ndlela.

Faka isicelo sokufometha kwenombolo kwibhokisi le-Dialog Box

Zonke izinketho zokufometha kwenombolo zitholakala ebhokisini lengxoxo yefomathi yefomathi .

Kunezinketho ezimbili zokuvula ibhokisi lengxoxo:

1. Chofoza kusiqalisi sebhokisi lengxoxo - umcibisholo omncane owehla phansi ekhoneni elingakwesokudla kwesigcawu sezinombolo ze-Ribbon ku-ribbon
2. Cindezela i- Ctrl + 1 kukhibhodi

Izinketho zokufometha kweselula ebhokisini lengxoxo zihlanganiswe ndawonye ohlwini lwamathebhu namafomethi ezinombolo ezitholakala ngaphansi kwethebhu lezinombolo.

Kule ithebhu, amafomethi atholakalayo ahlukaniswe ngezigaba ngakwesokunxele. Chofoza kunketho ewindini kanye nezimfanelo kanye nesampula yalolu khetho kuboniswa ngakwesokudla.

Ukuchofoza kuNombolo efasiteleni lesokunxele kubonisa izimfanelo ezingalungiswa

• inombolo yezindawo zedesimali ezibonisiwe
• ukusetshenziswa kwehlukanisa ama-comma ezinkulungwaneni
• ukubonisa izinketho ngezinombolo ezimbi

03 ka 04

Faka isicelo sokufometha kwemali

Ukusebenzisa Ukufometha Kwemali Ukusebenzisa Amathanga Ashothikhathi

Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa i-currency ukufometha kwedatha yile:

• I-Ctrl + Shift + $ (isibonakaliso se-dollar)

Amafomethi wezimali ezizenzakalelayo asetshenziselwa idatha ekhethiwe usebenzisa izinkinobho zokunqamulela yi:

• isibonakaliso se-dollar
• izindawo ezimbili zedesimali
• i-comma njenge-separator yezinkulungwane (,)

Izinyathelo Zokusebenzisa Ukufometha Kwemali Ukusebenzisa Amathanga Ashothikhathi

Ukusebenzisa imali yokufometha kwedatha usebenzisa izinkinobho zokunqamulela:

1. Qinisekisa amaseli aqukethe idatha ukuthi ifomathiwe
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi
3. Cindezela bese ukhulula ukhiye we-dollar ($) - ophezu kwenombolo 4 - ekhibhodi ngaphandle kokukhulula ukhiye we- Ctrl no- Shift
4. Khipha okhiye be-Ctrl ne-Shift
5. Amaseli akhethiwe azokwenziwa ngemali efomathiwe futhi, lapho kufanele khona, ubonise amafomethi ashiwo ngenhla
6. Ukuchofoza kunoma yiliphi lamaseli ubonisa inombolo engafaniwe engafaniwe ebhakisini lefomula ngaphezulu kwephepha lokusebenzela.

Faka isicelo sokufometha kwemali ngokusebenzisa ama-Ribbon

Ukufometha kwemali kungasetshenziswa kudatha ngokukhetha ukhetho lwemali kusuka kuhlu lokuhlaselwa kwefomethi yenombolo .

Isithonjana se-dollar ( $) esitholwe eqenjini leNombolo kuthebhu yasekhaya lebhande, akuyona ifomethi yeMali kodwa ifomethi ye- akhawunti njengoba kuboniswe esithombeni ngenhla.

Umehluko omkhulu phakathi kwalaba ababili ukuthi ifomethi yokubika iqondisa isibonakaliso se-dollar ngakwesobunxele beseli ngenkathi ihlanganisa idatha ngokwayo ngakwesokudla.

Faka isicelo sokufometha kweMali kwiBhokisi le-Dialog Box

Ifomethi yemali ebhokisini lengxoxo yefomathi yefometha lifana kakhulu nefomethi yenombolo, ngaphandle kokukhethwa kukho ukukhetha uphawu oluhlukile lwemali kusuka kusignali ye-dollar ezenzakalelayo.

Ibhokisi lengxoxo yefomathi yefomathi lingavulwa enye yezindlela ezimbili:

1. Chofoza kusiqalisi sebhokisi lengxoxo - umcibisholo omncane owehla phansi ekhoneni elingakwesokudla kwesigcawu sezinombolo ze-Ribbon ku-ribbon
2. Cindezela i- Ctrl + 1 kukhibhodi

Ebhokisini lebhokisi, chofoza kwiMali emkhakheni wesigaba ngakwesokunxele ukuze ubuke noma ushintshe izilungiselelo zamanje.

04 ka 04

Faka ukufometha kwama-Percent

Qiniseka ukuthi idatha iboniswa kwifomethi yephesenti ifakwe efomini yedesimali - njenge-0.33 - okuyiyo, uma ifomethiwe ngamaphesenti, izobonisa kahle njenge-33%.

Ngaphandle kwenombolo 1, izinamba eziphelele - ezingenayo ingxenye yedesimali - azijwayele ukufometha ngamaphesenti njengoba amanani abonisiwe akhuliswa isici se-100.

Isibonelo, uma ifomathiwe ngamaphesenti:

• inombolo 1 izoboniswa njenge-100%;
• inombolo 33 izoboniswa njenge-3300%.

Faka Ukufometha Kwemaphesenti Ukusebenzisa Amathanga Ashothikhathi

Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa ukufometha kwenombolo yedatha yilezi:

I-Ctrl + Shift + % (uphawu lwamaphesenti)

Amafomu asetshenziselwa idatha yezinombolo ezikhethiwe besebenzisa izinkinobho zesinqamuleli yi:

• Izindawo ezingu-0 zesimanje
• uphawu lwephesenti lengeziwe

Izinyathelo Zokusebenzisa Ukufometha Kwemaphesenti Ukusebenzisa Izinqamuleli Zezinqamuleli

Ukufaka isicelo samaphesenti ukufometha kwedatha usebenzisa izinkinobho zokunqamulela:

1. Qinisekisa amaseli aqukethe idatha ukuthi ifomathiwe
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi
3. Cindezela bese ukhulula ukhiye wamaphesenti wamaphesenti (%) - akhiwe ngaphezu kwenombolo 5 - ekhibhodi ngaphandle kokukhulula ukhiye we- Ctrl no- Shift
4. Khipha okhiye be-Ctrl ne-Shift
5. Izinombolo kumaseli akhethiwe azofomathwa ukuze abonise uphawu lwephesenti
6. Ukuchofoza kunoma yiliphi lamaseli afomathiwe ubonisa inamba yangempela engafaniwe ebhasini lefomula ngaphezulu kwephepha lokusebenzela

Faka Ukufometha Kwemaphesenti Ukusebenzisa Izinketho zeRibbon

Ifomethi yamaphesenti ingasetshenziswa kudatha besebenzisa isithonjana sephesenti esiseqenjini leNombolo kuthebhu yaseKhaya yebhande, njengoba kuboniswe esithombeni esingenhla, noma ngokukhetha inketho yePhesenti ukusuka kuhlu lokuhlaselwa kwefomu leNombolo .

Umehluko nje phakathi kokubili ukuthi i-icon ye-ribbon, njenge-shortcut yekhibhodi engenhla, ibonisa izindawo zedesimali ngenkathi uhlu lokudonsa phansi lubonisa izindawo ezimbili ezidumile. Isibonelo, njengoba kuboniswe esithombeni ngenhla, inombolo 0.3256 iboniswa njenge:

• 33% uma ifomathiwe usebenzisa isithonjana sedabhoni
• 32.56% uma ifomathiwe usebenzisa ukhetho lokuhlula phansi

Izinombolo zifomathiwe ezindaweni ezimbili zesimanje ezifana nesinqamuleli sekhibhodi ngenhla, kepha ukwahlukana kombala akusetshenziswanga ngale ndlela.

Faka isicelo samaphesenti usebenzisa i- Cells Box Cell Dialog Box

Uma ucabangela inani lezinyathelo ezidingekayo ukuze ufinyelele ukhetho lwendlela yephesenti ebhokisini lezingxoxo zefomathi, kukhona izikhathi ezimbalwa lapho lokhu kukhetha kudinga ukusetshenziselwa esikhundleni sezinye zezindlela ezibalwe ngenhla.

Isizathu esisodwa sokukhetha ukusebenzisa lolu khetho kungaba ukushintsha inombolo yezindawo zedesimali ezikhonjiswe ngezinombolo ezifakwe amaphesenti - ebhokisini lengxoxo inombolo yezindawo zedesimali ezikhonjisiwe ingahle isethwe kusuka ku-zero kuya ku-30.

Ibhokisi lengxoxo yefomathi yefomathi lingavulwa enye yezindlela ezimbili:

1. Chofoza kusiqalisi sebhokisi lengxoxo - umcibisholo omncane owehla phansi ekhoneni elingakwesokudla kwesigcawu sezinombolo ze-Ribbon ku-ribbon
2. Cindezela i- Ctrl + 1 kukhibhodi