Xav paub yuav ua li cas los daws qhov ua zauv sib npaug nrawm dua? Qee leej ntseeg tias kev txiav txim siab yog txoj hauv kev zoo mus, tab sis yuav ua li cas yog tias koj muaj cov lej sib npaug uas tsis yog qhov tseeb? Tseeb, koj ib txwm tuaj yeem siv cov lej sib npaug tab sis nws yooj yim dua rau siv Lub Hom Phiaj Nrhiav hauv Microsoft Excel. Nov yog qhov kev qhia tseem ceeb rau kev ua lej thiab engineering cov tub ntxhais kawm uas yuav pab daws qhov loj dua (thiab tsis yog plaub npaug) sib npaug!
Cov kauj ruam
Ntu 1 ntawm 5: Tshaj Tawm Txoj Haujlwm thiab Tau Txais Qhov Sib Txawv
Kauj Ruam 1. Tua tawm Microsoft Excel 2010 program
Cov txheej txheem no tuaj yeem siv rau Microsoft Excel 2013 lossis ua ntej ntawm Microsoft Excel ntev li ntev tau nws muaj Lub Hom Phiaj Nrhiav
Kauj Ruam 2. Nrhiav qhov kev ua zauv uas koj npaj yuav daws thiab rov teeb tsa qhov sib npaug kom xoom
Rau qhov ua piv txwv no, peb yuav siv qhov ua zauv sib npaug ntawm daim ntawv ax^2+bx+c = 0. Txhawm rau ua qhov no, peb yuav tsum tau rov teeb tsa qhov sib npaug kom sab tes xis sib npaug rau xoom
Kauj Ruam 3. Txheeb tawm qhov koj xav tau ntawm cov hauv paus hniav (kev daws teeb meem)
Txog plaub npaug nrog kev txiav txim ntawm 2, qhov kev cia siab muaj peev xwm yog ob lub hauv paus lossis tsis muaj cag
Ntu 2 ntawm 5: Kho Cov Ntawv Cuam Tshuam
Kauj Ruam 1. Xaiv cov cell los ua haujlwm nrog
Koj tuaj yeem ua qhov no los ntawm kev xaiv cov cell uas koj xav siv. Txog qhov piv txwv no, peb yuav siv plaub lub cell tag nrho. Peb tau txiav txim siab xaiv qhov thaiv ntawm A1 thiab B2
Kauj Ruam 2. Sau ib lub xovtooj "X-value" thiab ib lub xovtooj uas nyob ib sab hauv tib kab "Equ = 0"
"X-Tus Nqi" yuav yog kev kwv yees rau lub hauv paus, lossis kev daws teeb meem, rau qhov sib npaug. "Equ = 0" yuav yog koj qhov kev ua kom sib npaug sib npaug rau xoom
Kauj Ruam 3. Hauv kab hauv qab no "X-Tus Nqi" hauv tib kab lus, muab tus lej twv rau x
Muab qhov kwv yees rau qhov kev daws teeb meem sib npaug. Nco ntsoov, peb tsis paub kev daws teeb meem yog li peb yuav tsum kwv yees! Txij li thaum peb tab tom nrhiav rau qhov siab dua (lossis ntau lub hauv paus zoo), nws yog qhov zoo tshaj los kwv yees ob tus lej tus lej zoo. Peb yuav xaiv qhov zoo 10 raws li kev kwv yees. Nyem Sau
Kauj Ruam 4. Hauv kab hauv qab no “Equ = 0” hauv tib kab ntawv, muab tso rau hauv koj qhov kev npaj rov ua dua tshiab siv X-tus nqi kwv yees hauv qib 3 raws li koj qhov sib txawv
Sau los ntawm kev muab "=" thiab tso qhov sib npaug los ntawm xaiv X-tus nqi (A2 Cell) twv raws li qhov sib txawv. Nias Sau
Ntu 3 ntawm 5: daws rau hauv paus hauv paus
Kauj Ruam 1. Nrhiav thiab nyem rau "Cov Ntaub Ntawv" tab nyob rau sab saud ntawm daim ntawv Excel
Kauj Ruam 2. Nyem “What-if Analysis” and select “Goal Seek” from the drop down tab
Kauj Ruam 3. Nyem rau ntawm tes uas siv los tawm tswv yim koj qhov sib npaug hauv Tshooj 2, Kauj Ruam 4 hauv qab "Teeb Tus Nqi" teb
Kauj Ruam 4. Ntaus hauv xoom hauv qab "To value" field (saib daim duab saum toj no)
Nov yog lub hom phiaj ntawm kev rov teeb tsa peb cov kev ua kom sib npaug rau xoom
Kauj Ruam 5. Nyem rau ntawm tes siv los tawm tswv yim koj qhov kev kwv yees x-tus nqi hauv qab "Los ntawm kev hloov xov tooj ntawm tes" (saib daim duab saum toj no)
Excel yuav suav qhov kev daws teeb meem los ntawm kev hloov pauv qhov kev kwv yees no kom txog thaum cov lej nkag tau sib npaug rau xoom
Kauj Ruam 6. Nyem “Ok” los daws
Qhov "Lub Hom Phiaj Nrhiav Tus Kheej" qhov rai yuav tshwm. Raws li koj tuaj yeem pom, Equ = 0 hloov pauv mus rau tus nqi me me uas ze rau xoom, thaum cov kev daws teeb meem tuaj yeem pom nyob hauv qab "X-Tus Nqi" header li 3
Ntu 4 ntawm 5: daws rau hauv paus qis
Kauj Ruam 1. Nrhiav lub hauv paus qis los ntawm kev nkag mus rau lwm qhov kev kwv yees rau X-Tus Nqi
Lub sijhawm no, peb yuav xaiv qhov tsis zoo 10 txhawm rau txhawm rau qis qis hauv Excel txoj kev daws teeb meem
