Yuav Ua Li Cas Hloov Cov Hom Ntawv Ntawm Tes

Cov txheej txheem:

Yuav Ua Li Cas Hloov Cov Hom Ntawv Ntawm Tes
Yuav Ua Li Cas Hloov Cov Hom Ntawv Ntawm Tes

Video: Yuav Ua Li Cas Hloov Cov Hom Ntawv Ntawm Tes

Video: Yuav Ua Li Cas Hloov Cov Hom Ntawv Ntawm Tes
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Tej zaum
Anonim

Kev ua tiav ntawm cov txheej txheem rau kev hloov pauv hom ntawv ntawm tes ntawm chaw ua haujlwm ntawm lub chaw ua haujlwm daim ntawv thov Excel muaj nyob hauv Microsoft Office pob yog hais txog kev ua haujlwm ntawm cov txheej txheem thiab tuaj yeem ua los ntawm cov kev niaj zaus uas tsis muaj feem cuam nrog software ntxiv.

Yuav ua li cas hloov cov hom ntawv ntawm tes
Yuav ua li cas hloov cov hom ntawv ntawm tes

Tsim nyog

Microsoft Excel

Cov Lus Qhia

Kauj ruam 1

Pib lub chaw ua haujlwm daim ntawv thov Excel, muaj nyob hauv pob Microsoft Office, thiab qhib "Format cells" menu ntawm cov cuab yeej saum toj kawg nkaus ntawm qhov program ua kom tau ua haujlwm ntawm kev hloov pauv hom ntawv ntawm cov xovtooj xaiv.

Kauj ruam 2

Nkag mus rau qhov "Number" tab ntawm lub npov (box) uas qhib thiab sau cov hom ntawv xav tau hauv daim ntawv teev nqis ntawm ntu "Cov naj npawb" hauv daim ntawv (los ntawm lub neej ntawd, "General" hom ntawv siv).

Kauj ruam 3

Qhia kom meej ntawm tes yuav tsum tau teeb tsa thiab mus rau "Cov Ntawv Uas Tsis Raws Cai" ntawm cov khoom "Cov Ntawv" hauv cov txheej txheem sab saud ntawm daim ntawv thov lub qhov rai.

Kauj ruam 4

Siv Qhov Kev Xaiv Tus nqi los ua cov xov tooj ntawm koj xav tau raws li nws cov ncauj lus thiab qhia cov kev ua haujlwm sib piv.

Kauj ruam 5

Ntaus tus nqi xav tau lossis cov qauv mis (siv "=" cim) ua ntej rau hauv) lossis nkag rau "Tus Qauv" tus nqi los siv cov qauv xaiv cov qauv.

Kauj Ruam 6

Nkag tus nqi ntawm lub mis nrog cov lus txhais ntawm lub ntsiab lus "TSEEM" lossis "FALSE" thiab rov qab mus rau "Ntawv qhia" cov zaub mov nyob rau sab saum toj toolbar ntawm lub application window.

Kauj Ruam 7

Qhia kom meej xaiv hom xov tooj ntawm tes thiab nyem "Ntxiv" khawm los siv cov kev hloov pauv.

Kauj ruam 8

Xaiv lub xov tooj ntawm tes los theej tawm hauv cov xwm txheej, thiab nyem rau "Format by Sample" khawm ntawm lub cuab tam sab saum toj ntawm Excel thov lub qhov rais los theej hom kab ntawm lub xovtooj xaiv.

Kauj Ruam 9

Qhia kom meej cov hlwb yuav tsum tau ua hom thiab nias lub khawm "Thov" los siv rau cov lus txib.

Kauj ruam 10

Siv hom ntawv hais kom ua los hloov txhua hom qauv uas koj xav hloov, lossis nyem Clear hauv Format Cells dialog ntxiv txhawm rau txheeb xyuas cov qauv xaiv.

Kauj ruam 11

Nyem lub pob "Tsiav" thiab qhia cov hom tsim nyog.

Kauj ruam 12

Siv lo lus "Rho tawm" los tshem tawm cov kev xaiv kab ntawv uas raug xaiv thiab siv lub thawv kos rau ntawm thaj chaw ntawm cov qauv uas yuav raug rho tawm.

Pom zoo: