Txhawm rau ua haujlwm nrog cov ntxhuav hauv Windows operating system, Excel siv, uas yog ib feem ntawm Microsoft Office suite ntawm kev siv. Cov nqi hluav taws xob muaj cov haujlwm dav thiab tso cai rau koj los ua haujlwm tsis yog ntxiv cov haujlwm ntawm kev ntxiv thiab sau cov ntaub ntawv, tabsis tseem txheeb lawv los ntawm cov nqi.
Cov Lus Qhia
Kauj ruam 1
Txhawm rau xaiv tus nqi siab tshaj plaws nyob rau ntau kab lossis kab ntawv ntawm lub rooj, cov qauv tshwj xeeb "MAX" tau siv. Nws teeb hom ntau ntawm qhov muaj nuj nqis los ntawm tus xov tooj uas ntau tshaj tau xaiv thiab tso tawm kom pom txoj kab.
Kauj ruam 2
Qhib lub rooj koj xav tau hauv Excel los ntawm ob npaug nias ntawm nws cov ntawv nrog XLS txuas ntxiv. Koj tseem tuaj yeem tsim cov ntawv tshiab los ntawm kev ua haujlwm khiav ntawm "Pib" - "Txhua Qhov Kev Pab Cuam" - Microsoft Office - Microsoft Excel thiab xaiv "Tsim" los ntawm cov kev xaiv muaj. Nkag mus rau qhov tseem ceeb uas xav tau rau hauv lub rooj thiab tsim lub cell uas koj yuav ua kom pom tus nqi siab tshaj hauv kem tshwj xeeb.
Kauj ruam 3
Tso tus cursor rau hauv lub cell tsim. Tom qab ntawv, mus rau ntawm kab ntawv mis, uas yog nyob sab saum toj cov lus hauv lub qhov rais thov, thiab tso tus cim "=". Tom qab ntawd, nyem rau ntawm Fx icon, uas yog nyob rau sab laug ntawm kab no.
Kauj ruam 4
Hauv daim ntawv teev cov ncauj lus tawm tswv yim, nyem Static, thiab tom qab ntawd nrhiav thiab xaiv MAX kev xaiv. Lub qhov rai uas muaj lub npe "Cov lus sib cav" yuav qhib, qhov twg koj yuav tsum qhia meej txog pib thiab xaus rau qhov tseem ceeb.
Kauj ruam 5
Nyem rau ntawm "Number 1" teb thiab qhia meej lub hlwb nyob rau hauv uas koj yuav xav tau los xaiv tus naj npawb uas xav tau. Qhov no tuaj yeem ua los ntawm txhaj rau lub hauv paus pib thiab xaus rau tus nas nrog rau sab laug nas los yog los ntawm kev nkag mus rau cov npe ntawm cov hlwb no nws tus kheej. Yog tias tsim nyog, koj tuaj yeem teeb tsa cov kev txwv ntxiv. Tom qab ua cov chaw, nyem "OK".
Kauj Ruam 6
Yog hais tias cov ntawv suav sau tau xaiv thiab nkag mus kom raug, tus nqi siab tshaj plaws yuav tshwm sim hauv lub xov tooj ntawm qhov xav tau. Koj tuaj yeem txuas ntxiv ua haujlwm nrog lub rooj lossis txuag cov kev hloov pauv ntawm cov ntawv yauv kho.
