Zotsatira Zomwe Zimalongosola Zosiyanasiyana

Sinthani Chiwerengero cha Malo Otsika Owonetsedwa ndi Data

Excel imakulolani kuti muyambe kulemba chiwerengero cha malo osungidwa omwe akuwonetsedwa ndi deta.

Zosankha zoyenera kuziwonetsera zimaphatikizapo

• kusinthasintha deta yomwe ilipo pogwiritsa ntchito mphini
• Ikani chiwerengero cha malo osungirako za deta yomwe ilipo kapena maselo opanda kanthu pogwiritsa ntchito ma bokosi a dialogs
• Kusintha chiwerengero chosasintha cha malo apamwamba omwe amasonyezedwa m'maselo onse mu tsamba

Aliyense kapena magulu a maselo mmalo mokhala ndi mauthenga omwe amafalitsidwa pamaselo angapo pa tsamba .

Kwa manambala omwe alowe kale pa tsamba, mukhoza kuonjezera kapena kuchepetsa chiwerengero cha malo omwe amawonetsedwa pambuyo pa mfundo ya decimal pogwiritsa ntchito mabatani. Mukhozanso kutanthauzira chiwerengero cha malo omwe mukufuna kugwiritsa ntchito pamene mukugwiritsa ntchito chiwerengero cha chiwerengero chojambulidwa ku maselo kapena deta. Kuti mukhale ndi Excel alowetsani mfundo zamadzulo kwa inu, mungathe kufotokozera malo osankhidwa omwe amasankhidwa.

Sankhani selo kapena maselo osiyanasiyana omwe ali ndi manambala omwe mukufuna kusintha malo a decimal. selo mmalo mokhala ndi malemba akufalikira pa maselo angapo pa tsamba la ntchito .

Zonjezerani kapena kuchepetsa malo a decimal pa tsamba

Pa Formatting toolbar, chitani chimodzi mwa zotsatirazi:

1. Dinani kuonjezera chiwonetsero cha Decimal Button kuti muwonetsenso ma chiwerengero china pambuyo pa mfundo ya decimal
2. Dinani Kuthandizani Chithunzi cha Decimal Button kuti muwonetse mawerengere ochepa pambuyo pa malo a decimal
3. Mu selo E1 lembani mawuwa: Zowonongeka mwezi ndi mwezi ndikusindikizira fungulo lolowamo pa makiyi.
4. Mwa kulowetsa deta mu E1 chizindikiro chake mu selo D1 chiyenera kudulidwa kumapeto kwa selo D1. Komanso, malemba mu E1 ayenera kutaya mu selo kupita kumanja.
5. Kuti athetse mavutowa ndi malemba awa, kukoka maselo D1 ndi E1 pa spreadsheet kuti awoneke.
6. Dinani pa tsamba la Pakiti.
7. Dinani pa batani lolemba Wembali pa kaboni .
8. Malembo m'maselo D1 ndi E1 ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri popanda kutsanulira m'maselo apafupi.

Tchulani malo a decimal omwe ali omangidwa mu chiwerengero cha chiwerengero

1. Pa Mawonekedwe a Masitimu, dinani Maselo, ndiyeno dinani Tsambali la Nambala.
2. Dinani Kuthandizani Chithunzi cha Decimal Button kuti muwonetse mawerengere ochepa pambuyo pa malo a decimal
3. Mu List list, dinani Number, Currency, Accounting, Peresenti, kapena Scientific.
4. Mu bokosi la malo otsika, lowetsani chiwerengero cha malo omwe mukufuna kuwonetsera.
5. Kuti athetse mavutowa ndi malemba awa, kukoka maselo D1 ndi E1 pa spreadsheet kuti awoneke.
6. Dinani pa tsamba la Pakiti.
7. Dinani pa batani lolemba Wembali pa kaboni .
8. Malembo m'maselo D1 ndi E1 ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri popanda kutsanulira m'maselo apafupi.

Tchulani malo osankhidwa omwe amasankhidwa a manambala

Pa Formatting toolbar, chitani chimodzi mwa zotsatirazi:

1. Pa Zida zamkati, dinani Zosankha.
2. Pa tsamba la Kusintha, sankhani bokosi lachindunji lotsegula.
3. Mu Places box, lowetsani chiwerengero chabwino cha majerengero ndi ufulu wa decimal decimal kapena nambala yolakwika kwa majomba kapena kumanzere kwa decimal decimal
4. Mu bokosi la malo otsika, lowetsani chiwerengero cha malo omwe mukufuna kuwonetsera.
5. Kuti athetse mavutowa ndi malemba awa, kukoka maselo D1 ndi E1 pa spreadsheet kuti awoneke.
6. Dinani pa tsamba la Pakiti.
7. Dinani pa batani lolemba Wembali pa kaboni .
8. Malembo m'maselo D1 ndi E1 ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri popanda kutsanulira m'maselo apafupi.

Mwachitsanzo, ngati mutalowa 3 mu Places box ndikulemba 2834 mu selo, mtengo udzakhala 2.834. Ngati mutalowa -3 mu Places box ndiyeno pangani 283 mu selo, mtengo udzakhala 283000. Dinani OK. Chizindikiro cha FIX chikuwonekera mu barreti yoyenera. Patsamba lamagetsi, dinani selo, ndiyeno tekani nambala imene mukufuna. Dziwani Deta yomwe mwayimira musanasankhe bokosi labwino lachinsinsi la bokosi silinakhudzidwe. Zokuthandizani Kuti muchepetse kanthawi chosankhidwa chadongosolo, yesani chiwerengero cha decimal pamene mukulemba chiwerengerocho. Kuchotsa mfundo za decimal kumasamba omwe mwalowa kale ndi ziwonetsero zosasinthika: Pa tsamba la Kusintha la bokosi la Options, tsambulani bokosi lachinsinsi loyang'ana decimal. Mu selo yopanda kanthu, lembani nambala monga 10, 100, kapena 1,000, malinga ndi chiwerengero cha malo omwe mukufuna kuchotsa. Mwachitsanzo, firimu 100 mu selo ngati nambalayi ili ndi malo awiri omwe mukufuna kuti mutembenuzire ku nambala zonse. Dinani Chikhomo Chophimba Chojambula (kapena pezani CTRL + C) kuti mupange seloyo ku Clipboard, ndiyeno sankhani maselo omwe muli nambala ndi malo osungira.

Pa Masinthidwe, dinani Sakani Zapadera, ndipo dinani Pitirizani.