Cov ntaub ntawv tshaj tawm Microsoft Office Excel tso cai rau koj yooj yim ua cov kev suav nrog cov ntaub ntawv me me. Daim ntawv thov no nws muaj nws cov txheej txheem ntawm kev nyuaj, thiab kev ua haujlwm xws li ntxiv cov feem pua tuaj yeem ua tau yam tsis muaj cuam tshuam nrog lawv.
Nws yog qhov tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Cia hais tias koj xav tau ntxiv qhov feem pua ruaj ruaj rau thawj tus lej tso rau hauv cell A1 thiab tso saib qhov tshwm sim hauv cell A2. Tom qab ntawd cov qauv yuav tsum tau muab tso rau hauv A2, uas ua rau kom qhov txiaj ntsig ntawm A1 los ntawm qee yam cuam tshuam. Pib los ntawm kev txiav txim siab qhov ntau ntawm qhov sib ntxiv - ntxiv ib puas ntawm ib feem pua ruaj rau ib. Piv txwv, yog tias koj xav tau ntxiv 25% rau tus lej ntawm xov tooj ntawm A1, ces tus lej yuav yog 1 + (25/100) = 1.25. Nyem rau ntawm tes A2 thiab ntaus tus qauv uas yuav tsum muaj: nkag rau hauv kos npe sib npaug, nyem cell A1, nyem lub cim (kev ua haujlwm kos npe sib npaug) thiab luam tawm khoo. Tag nrho cov ntaub ntawv rau qhov ua piv txwv saum toj no yuav tsum zoo li no: = A1 * 1, 25. Nias Sau thiab Excel yuav laij thiab saib qhov tshwm sim.
Kauj ruam 2
Yog tias koj yuav tsum suav cov nqi sib npaug ntawm txhua qhov ntawm ib kem ntawm qee kab thiab ntxiv cov txiaj ntsig tawm mus rau tib lub hlwb, tom qab ntawd muab cov lej sib ntxiv tso rau hauv ib kem. Cia hais tias koj yuav tsum ntxiv 15%, thiab cov khoom tseem ceeb yog los ntawm tus thawj txog rau kab thib nees nkaum hauv kab ntawv A. Tom qab ntawd muab qhov nqi 1, 15 (1 + 15/100) tso rau hauv lub cell dawb thiab theej nws (Ctrl) + C). Tom qab ntawd xaiv qhov ntau los ntawm A1 rau A20 thiab nias qhov tseem ceeb ua ke Ctrl + alt="Duab" + V. Lub "Paste Tshwj Xeeb" tham yuav tshwm rau ntawm qhov screen. Hauv seem "Kev Ua Haujlwm", khij lub npov nyob ib sab ntawm lo lus "multiply" thiab nyem rau ntawm OK. Tom qab ntawd, txhua tus xaiv ntawm lub hlwb yuav hloov los ntawm qhov feem pua teev tus nqi, thiab lub koom haum pabcuam uas muaj cov lej sib ntxiv yuav raug tshem tawm.
Kauj ruam 3
Yog tias koj yuav tsum muaj peev xwm hloov qhov feem pua ntxiv, nws yog qhov zoo dua muab tso rau hauv ib kem cais, thiab tsis txhob kho nws txhua zaus hauv cov qauv. Piv txwv li, tso tus nqi qub hauv thawj kab ntawm thawj kab (A1), thiab feem pua uas yuav muab ntxiv rau hauv kab ntawv thib ob ntawm tib kab (B1). Txhawm rau tso qhov tshwm sim hauv cell C1, nkag mus rau cov kab hauv qab no: = A1 * (1 + B1 / 100). Tom qab koj nias tus yuam sij Enter, tus nqi xav tau yuav tshwm sim hauv kem yog tias A1 thiab B1 twb muaj tus nqi tsim nyog.
