Qhov wikiHow qhia koj yuav ua li cas ntxiv hnub ntxiv rau hnub tim uas twb muaj lawm hauv Microsoft Excel. Cov mis ntxiv hnub rau hnub yog = hnub+hnub tim.
Cov kauj ruam
Kauj Ruam 1. Qhib Microsoft Excel
Nws yog hauv Txhua Apps cheeb tsam ntawm Start menu hauv Windows, lossis hauv Cov ntawv thov nplaub tshev hauv macOS.
Kauj Ruam 2. Qhib daim ntawv nthuav qhia uas muaj hnub tim
Txhawm rau qhib nws sai, nyem Ctrl+O, xaiv cov ntawv, thiab nyem Qhib.
Kauj Ruam 3. Nyem rau ntawm tes tsis muaj dab tsi hauv nws kab ntawv
Nov yog qhov uas koj yuav ntaus cov qauv uas ntxiv hnub rau hnub tim.
Kauj Ruam 4. Ntaus = rau hauv xovtooj
Qhov no qhia txog qhov pib ntawm cov mis.
Kauj Ruam 5. Nyem rau ntawm tes uas muaj hnub tim
Qhov no ntxiv cov xov tooj ntawm tes tom qab "=" hauv cov qauv.
- Piv txwv, yog tias hnub tim nyob hauv cell C5, nyem rau ntawm tes.
- Yog tias koj nyem C5, cov mis yuav nyeem = C5.
Kauj Ruam 6. Ntaus +naj npawb hnub
Hloov "naj npawb hnub" nrog cov hnub koj xav ntxiv rau hnub tim.
Piv txwv li, yog tias koj xav ntxiv 100 hnub rau hnub tim, lub xov tooj ntawm tes yuav tsum nyeem = C5+100
Kauj Ruam 7. Nias ↵ Enter los yog ⏎ Rov qab los.
Txawm hais tias hnub no tau ntxiv rau hnub tim, koj yuav zaum pom tus lej coj txawv txawv ntev hauv xov tooj. Tus lej no tsuas yog xav tau hloov pauv mus rau hnub tim.
Kauj Ruam 8. Nyem tsab ntawv saum toj kab ntawv uas muaj cov mis
Piv txwv li, yog tias koj ntaus tus lej rau hauv F2, nyem rau F kem
Kauj Ruam 9. Nyem rau kab xub me hauv "Numbers" tab
Nws nyob ze ntawm qhov nruab nrab ntawm kab bar nyob rau sab saum toj ntawm Excel. Cov ntawv qhia zaub mov yuav nthuav dav.
Kauj Ruam 10. Nyem Cov Sijhawm Luv
Nws nyob ze nruab nrab ntawm cov ntawv qhia zaub mov. Qhov no hloov tus lej rau hnub tim.