¿Cómo cambiar mayúsculas a minúsculas en Excel?

¿Cómo cambiar mayúsculas a minúsculas en Excel? Uma uke wahlangana nedokhumenti ye-Excel lapho zonke izinhlamvu zingosonhlamvukazi futhi udinga ukuzishintsha zibe ngofeleba abancane, usufike endaweni efanele. Ngenhlanhla, i-Excel inikeza indlela esheshayo nelula yokufeza lo msebenzi, ngaphandle kwesidingo sokuphinda uthayiphe iseli ngalinye ngesandla. Kulesi sihloko sizokukhombisa indlela ephumelela kakhulu yokuguqula izinhlamvu zakho ezingosonhlamvukazi zibe izinhlamvu ezincane ku-Excel, ukonga isikhathi nomzamo enqubweni. Ngokulandela nje izinyathelo ezimbalwa ezilula, ungaguqula umbhalo wakho ngemizuzu nje embalwa. Ngakho-ke funda ukuze ufunde ukuthi ungasibamba kanjani lesi sici esiwusizo se-Excel.

- Guqula umbhalo ube ngofeleba abancane ku-Excel usebenzisa umsebenzi we-LOWERCASE

• Vula ispredishithi sakho se-Excel.
• Khetha iseli noma ububanzi bamaseli aqukethe umbhalo ofuna ukuwuguqula ube ngofeleba abancane.
• Yiya kubha yefomula phezulu esikrinini.
• Faka ifomula LOWERCASE() elandelwa abakaki abavulayo «(«.
• Khetha iseli eliqukethe umbhalo ofuna ukuwuguqula noma uthayiphe mathupha ireferensi yeseli, bese uvala abakaki.
• Pulsa la tecla «Enter» en tu teclado.
• Ilungile! Manje, umbhalo kumaseli akhethiwe uguqulelwe kuzinhlamvu ezincane.

¿Cómo cambiar mayúsculas a minúsculas en Excel?

Imibuzo Nezimpendulo

1. Ungashintsha kanjani osonhlamvukazi baye kwabancane ku-Excel?

1. Bhala ifomula kuseli elingenalutho: =MINUSC(cell)
2. Faka esikhundleni "iseli" ngereferensi yeseli eliqukethe umbhalo omkhulu
3. Cindezela u-Enter ukuze usebenzise ifomula futhi uguqule umbhalo ube ngofeleba abancane

2. Ngingakwazi ukushintsha umbhalo ube ngofeleba abancane ngaphandle kokusebenzisa amafomula?

1. Khetha iseli elinombhalo ngosonhlamvukazi
2. Chofoza ithebhu "Ekhaya" kubha yamathuluzi ye-Excel
3. Chofoza inkinobho ethi "Shintsha icala" eqenjini elithi "Ifonti".
4. Khetha inketho "yezinhlamvu ezincane" ukuze uguqule umbhalo

3. Ingabe kukhona umsebenzi othile wokushintsha ukufometha kombhalo?

1. Sebenzisa umsebenzi we-"MINUSC" ukuze uguqule umbhalo ube ngofeleba abancane
2. Thayipha okuthi "MINUSC(cell)" kuseli elingenalutho, esikhundleni sika-"cell" ngereferensi yeseli ngombhalo ngosonhlamvukazi
3. Cindezela u-Enter ukuze usebenzise uhlelo nokuguqula umbhalo

4. Ngingakwazi ukushintsha umbhalo ube ngofeleba abancane ebangeni lamaseli?

1. Khetha ububanzi bamaseli aqukethe umbhalo ngosonhlamvukazi
2. Chofoza ithebhu "Ekhaya" kubha yamathuluzi ye-Excel
3. Chofoza inkinobho ethi "Shintsha icala" eqenjini elithi "Ifonti".
4. Khetha inketho "yezinhlamvu ezincane" ukuze uguqule ukufometha kombhalo kulo lonke ububanzi

5. Ngingakwenza kanjani ngokuzenzakalelayo ukushintsha osonhlamvukazi baye kwabancane ku-Excel?

1. Sebenzisa umsebenzi we-"MINUSC" kukholamu eseduze nale equkethe umbhalo omkhulu
2. Thayipha ifomula =MINUSC(iseli) bese uhudulela phansi ukuze ulisebenzise kuwo wonke amaseli ebangeni

6. Ingabe zikhona izinqamuleli zekhibhodi zokushintsha osonhlamvukazi baye kwabancane?

1. Khetha iseli elinombhalo ngosonhlamvukazi
2. Cindezela okhiye be-“Ctrl + Shift + F3” ukuze usebenzise ukufometha kwezinhlamvu ezincane

7. Ingabe ifomethi yombhalo ingashintshwa kusetshenziswa ibha yefomula?

1. Chofoza ibha yefomula phezulu esikrinini
2. Bhala ifomula =MINUSC(cell) bese ucindezela u-Enter ukuze ulisebenzise

8. Ngingakushintsha kanjani ukufometha kombhalo efayeleni elikhulu le-Excel?

1. Sebenzisa amafomula noma imisebenzi ukuze uguqule ukufometha kumaseli amaningi ngesikhathi esisodwa
2. Khetha amaseli aseduze noma ububanzi ukuze usebenzise ifomula kumaseli amaningi

9. Uyini umehluko phakathi komsebenzi we-“MINUSC” kanye “MINUSC.EXT”?

1. I-"MINUSC" iwumsebenzi we-Excel ojwayelekile ongashintshwa ube ngofeleba abancane
2. I-"MINUSC.EXT" iwumsebenzi wokwengeza ongadingeka ezinguqulweni ezithile ze-Excel

10. Ngingakwazi yini ukubuyela kofeleba abancane ku-Excel?

1. Uma uguqule umbhalo waba ngofeleba abancane, khetha ububanzi beseli
2. Chofoza ithebhu "Ekhaya" bese ukhetha "Shintsha icala".
3. Khetha inketho ethi "upper case" ukuze ubuyele kosonhlamvukazi