Ukufometha ama-Negative, Long, kanye nezinombolo ezikhethekile ku-Excel

01 ngo-04

Ukufometha Amanani ku-Excel Uhlolojikelele

Ulwazi oluthile kumafomethi wezinombolo ezithile lungatholakala emakhasini alandelayo:

Ikhasi 1: Izinombolo ezimbi (ngezansi);
Ikhasi 2: Bonisa izinombolo zamadoladi njengezingxenyana;
Ikhasi 3: Izinombolo ezikhethekile - amakhodi we-zip kanye nokufometha kwenombolo yocingo;
Ikhasi 4: Ukufometha izinombolo eziningana - njengezinombolo zamakhadi esikweletu - njengombhalo.

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, ukusebenzisa i-currency, iphesenti, noma ukufometha kwenombolo yedatha kubonakala kuphela esitokisini lapho inomboro ikhona khona. Ukuchofoza kuleyo seli kuzokhombisa inombolo ecacile, engafaniwe ebhafini yefomula ngaphezulu kwephepha lokusebenzela.

Okujwayelekile Okuzenzakalelayo

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.

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

Ukufometha KwamaNani Okungalungile

Ngokuzenzakalelayo, izinombolo ezimbi zikhonjiswe ngokusebenzisa uphawu olubi noma idashi (-) ngakwesokunxele kwenombolo. I-Excel inezinye izinketho eziningana zefomethi yokubonisa izinombolo ezimbi ezisebhokisini lengxoxo yefomathi yamafomethi . Lokhu kufaka:

• umbhalo obomvu
• amabakaki azungezile
• amabakaki azungezile kanye nombhalo obomvu

Ukubonisa izinombolo ezimbi ebomvu kungenza kube lula ukuzithola - ikakhulukazi uma ziyimiphumela yamafomula okungase kube nzima ukulandelela kwiphepha elikhulu lokusebenzela.

Amakhonksi avame ukusetshenziselwa ukwenza izinombolo ezimbi zilula ukuthola idatha ezoprintwa emnyama nasemhlophe.

Ukuguqula Ukufometha KwamaNani Okungalungile kwiBhokisi Lezingxoxo Zezingcingo

1. Qinisekisa idatha okufanele ifomathiwe
2. Chofoza kuthebhu yaseKhaya ye- ribbon
3. Chofoza kusiqalisi sebhokisi lezingxoxo - umcibisholo omncane owehlisa phansi ekhoneni elingezansi elingakwesokudla kweqembu lezinkinobho zezinombolo kulayini ukuze uvule ibhokisi lezingxoxo zefomathi yefomathi
4. Chofoza kuNombolo ngaphansi kwesigaba sesigaba sebhokisi lebhokisi
5. Khetha inketho yokubonisa izinombolo ezimbi - obomvu, amabakaki, noma obomvu nabakaki
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
7. Amanani angalungile kwimininingwane ekhethiwe kufanele manje ifomethiwe ngezinketho ezikhethiwe

02 ka 04

Ukufometha Izinombolo njengeziqephu ku-Excel

Bonisa Izinombolo Ezibukhali njengeziqephu

Sebenzisa ifomethi ye-Fraction ukuze ubonise izinombolo njengezingxenyana zangempela, kunokuba zihlasele. Njengoba kubhalwe ngaphansi kwekholomu yokuchaza esithombeni ngenhla, izinketho ezitholakalayo zezingxenyana zifaka:

• ukubonisa izinhlawulo njengezingxenye ezimbili, ezimbili, noma ezintathu zamadijithi engxenyeni yesigaba senombolo;
• ukubonisa izinhlawulo njengezicucu ezisetshenziswa kakhulu - njengengxenye eyodwa nengxenye eyodwa.

Fometha Okokuqala, Idatha Yesibili

Ngokuvamile, kungcono ukusebenzisa ifomethi yezingqimba kumaseli ngaphambi kokufaka idatha ukugwema imiphumela engalindelekile.

Isibonelo, uma izingxenyana ezinezinombolo eziphakathi kweyodwa no-12 - njenge-1/2 noma 12/64 - zingena emafeneni ngefomethi ejwayelekile, izinombolo zizoguqulwa zibe izinsuku ezifana nalezi:

• I-1/2 izobuyiselwa ngo-2-Jan
• 12/64 izobuyiselwa njengoJan-64 (ngoJanuwari, 1964)

Futhi, izingxenyana ezinamanani angaphezu kuka-12 zizoguqulwa zibe umbhalo, futhi zingabangela izinkinga uma zisetshenziselwa izibalo.

Ukufometha Izinombolo njengeziqeshana kwibhokisi le-Dialog Box Dialog

1. Qinisekisa ukuthi amaseli azofomathwa njengezingxenyana
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Chofoza kusiqalisi sebhokisi lezingxoxo - umcibisholo omncane owehlisa phansi ekhoneni elingezansi elingakwesokudla kweqembu lezinkinobho zezinombolo kulayini ukuze uvule ibhokisi lezingxoxo zefomathi yefomathi
4. Chofoza ku- Fraction ngaphansi kwesigaba sesigaba sebhokisi lengxoxo ukuze ubonise uhlu lwamafomethi wezingxenyana ezitholakalayo ngakwesokudla ngakwesokudla ibhokisi lengxoxo
5. Khetha ifomethi yokubonisa izinombolo zamadesimali njengezingxenyana ezivela kuhlu
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
7. Izinombolo ezidumile ezifakwe ebangeni elifomethiwe kufanele ziboniswe njengezingxenyana

03 ka 04

Ukufometha Izinombolo Ezikhethekile ku-Excel

Okujwayelekile nokulinganiselwa kwefomethi yezinombolo

Uma usebenzisa i-Excel ukugcina izinombolo zokuhlonza - ezifana namakhodi we-zip noma izinombolo zocingo - ungathola inombolo ishintshiwe noma iboniswe ngemiphumela engalindelekile.

Ngokuzenzakalelayo, wonke amaseli kuphepha lokusebenzela lase-Excel basebenzisa i- General format, futhi izici zalokhu kufomethi zifaka:

• ukuhola ama-zero ngezinombolo zisusiwe,
• Izinombolo ezinamadijithi angaphezulu kwangu-11 ziguqulwa kwesaziso sesayensi (noma ukuboniswa).

Ngokufanayo, ifomethi yenombolo ilinganiselwe ukubonisa izinombolo zamadijithi angu-15 ubude. Noma yimaphi amadijithi angaphezu kwalolu mkhawulo ahlelwe phansi ku-zero

Ukuze ugweme izinkinga ngezinombolo ezikhethekile, izinketho ezimbili zingasetshenziswa kuye ngokuthi yiluphi uhlobo lokugcinwa kwiphepha lokusebenzela:

• isigaba esikhethekile sefomethi ebhokisini lengxoxo yefomathi yefomathi (bheka ngezansi);
• izinombolo zokufometha njengombhalo (ikhasi elilandelayo).

Ukuqinisekisa ukuthi izinombolo ezikhethekile ziboniswa kahle uma zingenwe, fometha iseli noma amaseli usebenzisa enye yamafomu amabili ngezansi ngaphambi kokufaka inombolo.

Isigaba Sokwakheka Okukhethekile

Isigaba esikhethekile ebhokisini lengxoxo yefomathi yefometha sisebenza ngokuzenzakalela ngokufometha okukhethekile kulezi zinamba ezifana:

• izinombolo zocingo - zihlanganisa izinombolo ezintathu zokuqala zenombolo eyidijithi eyi-10 kubazali bama-parentes futhi ihlukanisa izinombolo eziyisikhombisa ezisele zibe ngamaqembu amabili ahlukaniswe yi-hyphen. Isibonelo: (800) 555-1212
• Izinombolo Zokuvikeleka Komphakathi - ihlukanisa izinombolo eziyizinombolo eziyisishiyagalolunye zibe ngamaqembu amathathu, amabili, futhi amane ahlukaniswe ama-hyphens. Isibonelo: 555-00-9999

• amakhodi we-zip - agcina ama-zeros ahamba phambili ngezinombolo - ezikhishwa ngamafomethi wezinombolo ezivamile. Isibonelo: 00987

• i-zip code + 4 : ihlukanisa izinombolo zamadijithi eziyisishiyagalolunye ngamaqembu amadijithi amahlanu futhi amane ahlukaniswe i-hyphen. Futhi igcina noma yikuphi i-zeros ehamba phambili. Isibonelo: 00987-5555

Indawo ezwelayo

Uhlu lokudonsa ngaphansi kwe- Locale lunikeza izinketho ukufometha izinombolo ezikhethekile ezifanele emazweni athile. Isibonelo, uma i-Locale ishintshwa esiNgisi (Canada) izinketho ezitholakalayo yiNombolo Yefoni kanye nenombolo yomshuwalense womphakathi - okuvame ukusetshenziswa izinombolo ezikhethekile zelo lizwe.

Ukusebenzisa Ukufometha Okukhethekile Kwezinombolo kuBhokisi Lokudlulisa Amaseli Wefomathi

1. Qinisekisa ukuthi amaseli azofomathwa njengezingxenyana
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Chofoza kusiqalisi sebhokisi lezingxoxo - umcibisholo omncane owehlisa phansi ekhoneni elingezansi elingakwesokudla kweqembu lezinkinobho zezinombolo kulayini ukuze uvule ibhokisi lezingxoxo zefomathi yefomathi
4. Chofoza ku- Okukhethekile ngaphansi kwesigaba sesigaba sebhokisi lengxoxo ukuze ubonise uhlu lwefomethi ezikhethekile ezikhona ngakwesokudla ngakwesokunxele kwebhokisi lengxoxo
5. Uma kunesidingo, chofoza inketho ye- Locale ukushintsha izindawo
6. Khetha okukhethwa kukho kwendlela yokwenza izinombolo ezikhethekile ohlwini
7. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
8. Izinombolo ezifanele zangena ebangeni elifomethiwe kufanele ziboniswe njengefomethi ekhethekile ekhethiwe

04 ka 04

Ukufometha Amanani njengombhalo ku-Excel

Okujwayelekile nokulinganiselwa kwefomethi yezinombolo

Ukuqinisekisa ukuthi izinombolo ezinde - njengezinombolo ezingu-16 zekhadi lesikweletu kanye nezinombolo zekhadi lasebhange - zikhonjiswa ngendlela efanele uma zingenisiwe, ifometha iseli noma amaseli esebenzisa ifomu Yombhalo - mhlawumbe ngaphambi kokufaka idatha.

Ngokuzenzakalelayo, wonke amaseli ephepha lokusebenzela lase-Excel basebenzisa i- General format, futhi enye yezici zale fomathi ukuthi izinombolo ezinamadijithi angaphezulu kuka-11 ziguqulwa kwesaziso sesayensi (noma ukuboniswa) - njengoba kuboniswe esitokisini A2 esithombeni ngenhla.

Ngokufanayo, ifomethi yenombolo ilinganiselwe ukubonisa izinombolo zamadijithi angu-15 ubude. Noma yimaphi amadijithi angaphezu kwalolu mkhawulo ahlelwe phansi ku-zero.

Ku-cell A3 ngenhla, inombolo 1234567891234567 ishintshiwe ibe yi-123456789123450 lapho iseli isethelwe ukufometha kwenombolo.

Ukusebenzisa idatha yedatha kumafomula nemisebenzi

Ngakolunye uhlangothi, uma ukufometha kombhalo kusetshenziselwa - iseli A4 ngenhla - inombolo efanayo ekhombisa kahle, futhi, njengoba umkhawulo wobuningi ngeseli yefomethi yombhalo ingu-1,024, mhlawumbe izinombolo ezingenangqondo kuphela njengoPi (Π) noPhi (Φ) lokho angeke kuboniswe ngokugcwele.

Ngaphezu kokugcina inombolo efana nendlela eyafakwa ngayo, izinombolo ezifomathiwe njengombhalo zingasetshenziswa emafomula zisebenzisa imisebenzi eyisisekelo yezibalo - njengokungeza nokukhipha njengoba kuboniswe esitokisini A8 ngenhla.

Kodwa-ke, abakwazi ukukusebenzisa ekubaleni ngeminye imisebenzi ye-Excel - njenge-SUM no- AVERAGE , njengoba amaseli aqukethe idatha aphathwa njengenalutho futhi abuya:

• umphumela wezinga le-SUM - cell A9
• inani lephutha # DIV / 0! I-AVERAGE - iseli A10

Izinyathelo Zokufometha Umakhalekhukhwini Ngombhalo

Njengamanye amafomethi, kubalulekile ukufometha iseli yedatha yombhalo ngaphambi kokufaka inombolo - kungenjalo, kuzothinteka ukufometha kwamaseli wamanje.

1. Chofoza kuseli noma ukhethe ububanzi bamaseli ofuna ukuguqula ekufomeni yombhalo
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Chofoza umcibisholo ongaphansi kwesibalo sefomathi yenombolo - ubonisa jikelele ngokuzenzakalelayo - ukuvula imenyu yehla yezinketho zefomethi
4. Skrolela phansi kwimenyu bese uchofoze ku-Okukhethwa kukho Umbhalo - azikho izinketho ezengeziwe zokufometha kombhalo

Umbhalo kuya kwesobunxele, izinombolo ngakwesokudla

Insizakalo ebonakalayo yokusiza ukunquma ifomethi yeseli ukubuka ukulungiswa kwedatha.

Ngokuzenzakalelayo ku-Excel, idatha yombhalo ihambelana ngakwesobunxele kumininingwane yeselula kanye nenombolo ngakwesokudla. Uma ukulungiswa okuzenzakalelayo kwefomethi efomathiwe njengombhalo kungashintshwa, izinombolo ezingena kulolo hlu kumele ziboniswe ngakwesokunxele kwamaseli njengoba kuboniswa kuseli C5 esithombeni ngenhla.

Ngaphezu kwalokho, njengoba kuboniswe kumaseli A4 kuya ku-A7, izinombolo ezifomathiwe njengombhalo zizobonisa futhi unxantathu onohlaza oluhlaza okwesibhakabhaka ekhoneni elingaphezulu kwesobunxele beseli okubonisa ukuthi idatha ingafomathwa ngokungalungile.