Izinketho zeFomenti eziPhambili ze-Excel

Shintsha iNani leendawo eziDumiweyo eziboniswe nguDatha

I-Excel ikuvumela ukuba ulawule inani leendawo zokugqibela eziboniswe ngedatha.

Izinketho zokubonisa i-decimals ziquka

• Ukutshintsha idatha ekhoyo usebenzisa idibhoni
• ukubeka inani leendawo zokugqibela zeedatha ezikhoyo okanye iiseli ezingenanto usebenzisa ibhokisi yencoko yencoko yefomathi
• Ukutshintsha inani elingagqibekanga leendawo zokugqibela eziboniswe kuwo onke amaseli kwiphepha lokusebenzela

Umntu ngamnye okanye amaqela eeseli kunokuba itekisi isasazeke kwiiseli ezininzi kwiphepha lokusebenzela .

Ngeenombolo ezisele zifakwe kwiphepha lokusebenzela, unokwandisa okanye unciphise inani leendawo eziboniswa emva kwendawo yokugqibela ngokusebenzisa iibhobho zebarbar. Ungacacisa nenani leendawo ezisemgangathweni ofuna ukuyisebenzisa xa usebenzisa ifomati yenombolo eyakhelwe kwiseli okanye idatha. Ukuze ube ne-Excel faka amanqaku aphezulu, ungacacisa iphuzu elimisiweyo lokugqibela lamanani.

Khetha iseli okanye uluhlu lweeseli eziqulethe iinombolo ofuna ukutshintsha iindawo zokugqibela. iseli kunokuba isicatshulwa sisasazeke kwiiseli ezininzi kwiphepha lokusebenzela .

Ukwandisa okanye ukunciphisa iindawo zokugqibela kwiphepha lokusebenzela

Kwifayile yefomathi yokufometha, yenza enye yezi zinto zilandelayo:

1. Chofoza ukwandisa umfanekiso ogqithisiweyo we-Button ukubonisa amadijithi angaphezulu emva kwendawo yokugqibela
2. Chofoza ukunciphisa umfanekiso we-Button we-Decimal ukubonisa amanani ambalwa emva kwendawo yokugqibela
3. Kwi-cell E1 thayipha itekisi: Iindleko zenyanga kwaye ucinezela ukhiye wokungena kwikhibhodi.
4. Ngokungena kwedatha kwi-E1 ilebula kwiseli D1 kufuneka inqunywe ekupheleni kweseli D1. Kwakhona, itekisi e-E1 kufuneka ichithe kwi-cell ukuya kwesokudla.
5. Ukulungisa iingxaki ngala malebula, drag ukhetha iiseli D1 ne-E1 kwi-spreadsheet ukuze zigqitywe.
6. Cofa kwiTebhu yeKhaya .
7. Cofa kwiComputer Inkinobho kwi- Ribbon .
8. Iibhile eziseli D1 kunye ne-E1 zimele zibonwe ngokubini ngokubhaliweyo kwimbhalo ephule emigqeni emibini ngaphandle kokuhlawulela kwiiseli eziseduze.

Cacisa iindawo zokugqibela zefomati yenombolo eyakhelwe

1. Kwimenyu yefomathi, nqakraza iiseli, uze ucofe iqhosha leNombolo.
2. Chofoza ukunciphisa umfanekiso we-Button we-Decimal ukubonisa amanani ambalwa emva kwendawo yokugqibela
3. Kuluhlu lweCandelo, nqakraza iNombolo, iMali, i-Accounting, Ipesenteji, okanye iSayensi.
4. Kwibhokisi yeendawo ezigqibeleleyo, faka inani leendawo zokugqibela ozifunayo.
5. Ukulungisa iingxaki ngala malebhile, gcoba iiseli D1 ne-E1 kwi-spreadsheet ukuze zigqitywe.
6. Cofa kwiTebhu yeKhaya .
7. Cofa kwiComputer Inkinobho kwi- Ribbon .
8. Iibhile eziseli D1 kunye ne-E1 zimele zibonwe ngokubini ngokubhaliweyo kwimbhalo ephule emigqeni emibini ngaphandle kokuhlawulela kwiiseli eziseduze.

Cacisa indawo ehleliweyo yokugqibela yamanani

Kwifayile yefomathi yokufometha, yenza enye yezi zinto zilandelayo:

1. Kwimenyu yeThuluzi, cofa Khetha.
2. Kwi-Hlela ithebhu, khetha ibhokisi yokujonga engaguqukiyo.
3. Kwibhokisi yeendawo, faka inombolo efanelekileyo kwidijithi ukuya ngasekunene kwinqanaba lokugqibela okanye inombolo engafanelekanga kwidijithi ukuya kwesobunxele kwinqanaba lokugqibela
4. Kwibhokisi yeendawo ezigqibeleleyo, faka inani leendawo zokugqibela ozifunayo.
5. Ukulungisa iingxaki ngala malebula, drag ukhetha iiseli D1 ne-E1 kwi-spreadsheet ukuze zigqitywe.
6. Cofa kwiTebhu yeKhaya .
7. Cofa kwiComputer Inkinobho kwi- Ribbon .
8. Iibhile eziseli D1 kunye ne-E1 zimele zibonwe ngokubini ngokubhaliweyo kwimbhalo ephule emigqeni emibini ngaphandle kokuhlawulela kwiiseli eziseduze.

Umzekelo, ukuba ungena kwi-3 yebhokisi yeBhokisi uze uthayiphe 2834 kwiseli, ixabiso liya kuba 2.834. Ukuba ungena -3 kwiBhokisi yeendawo uze uthayiphe 283 kwiseli, ixabiso liya kuba ngu-283000. Chofoza OK. Isalathisi seFIX sibonakala kwibha yomgangatho. Kwiphepha lokusebenzela, cofa iseli, uze uthayiphe inombolo oyifunayo. Qaphela Idatha oyifakile ngaphambi kokuba ukhethe ibhokisi yokujonga engasetyenzisiweyo ekhethiweyo ayichaphazeli. Iingcebiso Ukwenza ngaphezulu kwexesha lokugqibela elikhethiweyo, khetha uhlobo lokugqibela xa uthayipha inamba. Ukususa amaphuzu ama-decimal ukusuka kumanani osuvele ungene ngawo kunye nee-decimals eziqingqiweyo: Kwi-Hlela ithebhu kwibhokisi yencoko yebhokisi, cima ibhokisi yokutshekisha yokugqibela. Kwiseli engenanto, thayipha inombolo efana ne-10, i-100, okanye i-1,000, kuxhomekeke kwinani leendawo zokugqibela ofuna ukususa. Ngokomzekelo, thayipha i-100 kwiseli ukuba iinombolo ziqulethe iindawo ezigqibeleleyo kwaye ufuna ukuziguqula zibe ngamanani apheleleyo. Chofoza ikopi ye-Button umfanekiso (okanye cinezela i-CTRL + C) ukukopisha iseli kwi-Clipboard, uze ukhethe iiseli eziqulethe iinombolo kunye neendawo zokugqibela.

Kwimenyu ye-Hlela, nqakraza Hlanganisa okuKhethekileyo, uze ukhethe ucofa.