Microsoft Excel yog ib qho ntawm tes haujlwm tshaj plaws hauv Microsoft Office suite. Nws yog qhov yooj yim hauv qhov ntawd nws muaj ntau lub zog sib txawv thiab tso cai cov lus teb nyuaj. Qhov nrov tshaj plaws ntawm cov haujlwm no yog qhov tsim ntawm daim ntawv teev npe.
Cov Lus Qhia
Kauj ruam 1
Ua ntej koj yuav tsum sau tag nrho cov khoom ntawm kev txaus siab rau koj. Lawv yuav tsum tau npaj kom raws seem uas koj xav kom lawv tshwm tawm.
Kauj ruam 2
Tam sim no koj yuav tsum xaiv cov ntawv sau ua ke thiab muab nws lub npe. Nws yuav tsum nkag mus rau hauv txoj kab uas nyob rau sab laug sab laug, uas qhov chaw nyob ntawm tes feem ntau sau. Hauv peb qhov piv txwv, daim ntawv teev npe hu ua "Cov Cuab Yeej".
Kauj ruam 3
Tom ntej no, koj yuav tsum xaiv cov xov tooj ntawm tes uas koj xav tsim ib daim ntawv teev npe, piv txwv li, qhov no yog G4. Tom qab ntawd, hauv "Cov Ntaub Ntawv" tab, nias lub pob "Data Validation". Nyob rau hauv lub qhov rai uas qhib, nyob rau hauv "Cov ntaub ntawv hom" teb, xaiv "Sau".
Kauj ruam 4
Tom qab ntawd, txoj kab "Tau" yuav tsum tshwm nyob rau hauv lub qhov rai. Hauv nws koj yuav tsum qhia lub npe ntawm daim ntawv, tom qab "=" kos npe, thiab nyem "OK".
Kauj ruam 5
Tam sim no hauv daim kev cai hauv xov tooj ntawm tes koj tuaj yeem xaiv ib yam khoom los ntawm cov npe uas peb tau teev tseg. Yog tias koj xav tau ua tib daim ntawv nyob rau lwm qhov chaw, koj tuaj yeem luam theej tawm thiab tom qab ntawd muab nws lo rau qhov chaw koj xav tau, txawm ntawm lwm daim ntawv.
Kauj Ruam 6
Koj tuaj yeem saib tag nrho cov npe uas tau tsim hauv cov ntaub ntawv no los ntawm txhaj rau "Npe Tus Thawj Coj" khawm nyob rau hauv "Formulas" tab. Ntawm no koj tuaj yeem tsim, rho tawm thiab hloov koj cov npe, nrog rau saib lawv lub zog.
Kauj Ruam 7
Yog tias xav tau los tsim daim ntawv teev cia nyob hauv ib daim ntawv uas nyob sib ze, koj yuav tsum xaiv lub xov tooj ntawm tes, nyem "Cov Ntaub Ntawv", tom qab ntawd "Cov Ntaub Ntawv Pov Thawj". Hauv kab "Cov hom ntaub ntawv" koj yuav tsum xaiv "Sau", thiab hauv "Cov Ntawv" koj yuav tsum qhia cov npe ntawv thiab ntau yam. Lub npe ntawm daim ntawv yuav tsis ua haujlwm nyob rau hauv cov ntaub ntawv no. Hauv peb qhov piv txwv, cov npe khoom tau nyob hauv thaj tsam li J2 txog J8, yog li peb sau = Sheet1! $ J $ 2: $ J $ 8. Cov kab ntawv no tuaj yeem theej tawm ntawm Lub Npe Tus Thawj Coj, uas nyob rau ntawm Daim Ntawv Teev Npe.
Kauj ruam 8
Txoj hauv kev yooj yim los tsim cov lus teev cia hauv Excel yog los ntawm nias tus ntawv shortcut alt="Duab" + ↓. Hauv qhov no, nws yog qhov tsim nyog tias lub xov tooj ntawm ib sab uas nyob ib sab ntawm daim ntawv teev cov khoom yuav tsum tau hais. Cov. hauv qhov piv txwv saum toj no, qhov no tsuas yog ua haujlwm nrog cov hlwb J1 thiab J9. Yog lawm, kev ua haujlwm ntawm cov qauv no yog qhov tsawg heev, tab sis qee qhov nws yuav pab tau.