Kodi kuthetsa vuto kupambana «The kalata yoyamba ya mutu wakuti"

Ambiri amadabwa bwanji mu kupambana kuti kalata yoyamba capitalized? vuto Ilitu sizachilendo. Mwachitsanzo, owerenga lolembamo kulowa deta inaccurately, atagwira dzina ndi kalata yaing'ono, kulola malo owonjezera Zolakwika zachipembedzo, ndi zolakwika, imbaenda chakuti pachilichonse ndi zovuta kukwaniritsa mapeto.

nkhaniyi zoyenera zimene zikutanthauza kuti kupambana spreadsheet mkonzi wa "Microsoft" ndi amene amapereka mapulogalamu woyang'anira likulu ndi zilembo zazing'ono nokha.

Excel maluso

Mu kupambana, pali zotsatirazi ntchito predefined ntchito ndi zingwe:

• = Chapamwamba (malemba kapena bokosi lemba) - otembenuka onse lemba analowa (kapena malemba selo anasankha) kwa mutu zikutanthauza;
• = M'munsi (malemba kapena bokosi lemba) - otembenuka onse lemba analowa (kapena malemba selo anasankha) mzere mtundu;
• = YOYENERA (malemba kapena bokosi lemba) - Ntchito imeneyi ndi likulu kalata yoyamba liwu lililonse (ankasiyana mipata) lemba ndiponso makalata ena kuchita pang'ono.

Mugwire ntchito inayake mu kupambana «The kalata yoyamba ya dzina," pamene ife tikuwona, si palibe ntchito akufuna. Pakuti ichi tinena ntchito osakaniza ntchito okonzeka zopangidwa, koma yang'anani pa m'munsimu. Poyamba, tiona Aunika mmene angapangire ndi kupambana zazikulu ndi lowercase makalata pa maziko a ntchito pamwamba.

Kugwira ntchito ndi ntchito chapamwamba, m'munsi, ndi KOYENERA

Zinatsimikizira pomwepo chifukwa cha ntchito zonse zitatu m'chipinda A2 atchule kupambana fomu iri chingwe "apulo antonovka atsopano" (makamaka kulola owonjezera likulu kalata kukayendera chifukwa cha ntchito). Mu ndime pafupi, kulowa chilinganizo zotsatirazi fanizirani zotsatira:

Monga mukuonera, mbali zonse ntchito monga tafotokozera.

Gwirizanani, zingakhale yabwino kupambana mu kalata yoyamba ya dzina amakhala momwemonso, basi kusankha ntchito yofanana, koma, mwatsoka, zimenezi n'zosatheka. Tili kulenga tokha chilinganizo bwino ... allocated gawo iyi yoyenera.

Excel: kalata yoyamba ya dzina

Pofuna kuthetsa, tiyenera nawatsimikizira kutenga kuwasiyanitsa mu magawo osiyana. Pankhaniyi, ndi zotsatirazi:

1. Sankhani kalata yoyamba ya lemba. M'pofunika kuganizira kuti owerenga nthawi zambiri mipata owonjezera pamaso lembalo. Chotsani malo owonjezera chingatithandize ntchito kokha (mawu), ndi kusankha woyamba kalata - ntchito WAWUSIYA (malemba [chiwerengero manambala]) ndi Mtsutso wachiwiri kwa 1 (ndi osankhidwa ndi kusakhulupirika, kotero inu mukhoza kumasula).
2. Unikani kalata yoyamba ntchito zafotokozedwa mu gawo yapita chapamwamba ntchito kusamutsa udindo kuona.
3. Times tiyenera kuchita ntchito mu kupambana «The kalata yoyamba ya dzina," zikutanthauza kuti ena a m'lemba adzakhala capitalized. Mulimonse mmene zinakhalira, ife tsopano ayenera angagwirizanitse kwa kalata yoyamba ya lemba otsala. Kodi zidzatithandiza ntchito zolungama (malemba [chiwerengero manambala]) olekanitsidwa mapeto a lemba la nambala lamanja la manambala. Ndipo kodi kwenikweni, pomwe? Ziyenera kukhala momwe kutalika chingwe opanda khalidwe choyamba, kuti ndi -1. Atamaliza zimenezi, muyenera zotsatira mu mawonekedwe zazikulu.
4. Mpaka kugwirizana zotsatira za wachiwiri ndi wachitatu ndime ndi ampersand (&).

Izi ndondomeko yonse ya vuto tebulo, adzapanga chifukwa ndi losavuta kumva kwa mawu akuti "apulo Antonovka atsopano" ochepa mipata owonjezera.

Monga tikuonera, kuthetsa vuto kupambana «The kalata yoyamba ya dzina," izo sizinali choncho zovuta, Chofunika kwambiri, kupereka tsatanetsatane onse masitepe.