Microsoft Office Excel, Gnumeric thiab OpenOffice.org Calc software pob khoom tsis tsuas yog tso cai rau koj los tsim thiab kho cov ntawv nthuav qhia, tab sis tseem ua kev suav. Koj tuaj yeem, piv txwv li, nkag mus rau lub xyoo yug ntawm cov neeg muaj npe nyob rau hauv daim ntawv teev npe thiab cia li suav lawv hnub nyoog.
Cov Lus Qhia
Kauj ruam 1
Tseg ib tus lej tso rau hauv lub rooj rau tus lej xyoo tam sim no. Sau tus naj npawb tsim nyog nyob ntawd (yuav tsum muaj plaub-lej, tsis yog ob tug lej). Hauv tag nrho cov piv txwv hauv qab no, xyoo tam sim no yuav xav tias nkag rau hauv A1.
Kauj ruam 2
Koj tseem tuaj yeem ua rau lub xyoo tam sim no tau teeb tsa ncaj qha. Tom qab ntawv tus nqi ntawm lub xov tooj sib haum tsis tas yuav hloov kho ib xyoos ib zaug, tab sis kev suav tseeb yuav ua tau tsuas yog lub moos thiab lub hnub tau teev nyob rau hauv lub khoos phis tawj. Txhawm rau ua qhov no, siv cov qauv hauv qab no: = xyoo (hnub no () (hauv) (Lavxias) lossis = xyoo (hnub no ()) - hauv Lus Askiv. Hauv Gnumeric program, tiam no, siv tus tswj hwm hauv Askiv, txawm tias qhov cuam tshuam interface nws tus kheej yog Lav Xias.
Kauj ruam 3
Hauv lub xovtooj ntawm qhov chaw uas tus neeg lub hnub nyoog yuav tsum tau, sau cov lus hauv qab no: = A1-Xn, qhov twg Xn yog lub cell uas tus neeg lub xyoo yug nyob. Piv txwv, yog tias nws nyob hauv cell B4, ces cov lus qhia yuav zoo li: = A1-B4.
Kauj ruam 4
Cov qauv no tsis yooj yim nyob rau hauv uas cov hnub yug ntawm txhua tus neeg muaj npe hauv lub rooj coj mus rau Lub Ib Hlis 1, thiab lub hnub nyoog tau txiav txim siab tsis suav txog qhov tseeb tias hnub yug kuj tuaj yeem poob rau hauv nruab nrab lossis xaus ntawm lub xyoo. Los laij lub hnub nyoog kom raug dua, sau hnub tim tam sim no nyob rau ntawm tes A1 hauv hom ntawv uas cov chaw ua haujlwm suite koj tau siv tau raug teeb tsa (cov chaw no tuaj yeem hloov tau). Piv txwv li, yog hnub ntawv hom ntawv yog hnub / hli / xyoo thiab hnub no yog Plaub Hlis 6, 2012, sau rau 2012-04-06 hauv tus xov tooj no. Thov nco ntsoov tias qhov no koj yuav tsum tau hloov cov ncauj lus ntawm tus xov tooj no txhua hnub. Txhawm rau zam qhov no, ntaus cov kab lus hauv qab no rau hauv nws: = hnub no () lossis = hnub no (). Hauv qhov xwm txheej no, ib yam li yav dhau los, nco ntsoov tias lub moos thiab lub hnub tau teev nyob hauv lub khoos phis tawm kom raug.
Kauj ruam 5
Hloov chaw ntawm tus neeg lub xyoo yug, qhia hauv lub xov tooj ntawm tes tsim nyog nws hnub yug nyob rau hauv hom ntawv uas chaw ua haujlwm suite tau teeb tsa. Thiab hauv lub xov tooj ntawm tes uas suav hnub nyoog xam yuav tsum tau qhia, nkag mus rau cov lus qhia hauv qab no: = hnub qub (A1; Xn; "y") lossis = sau hnub tim (A1; Xn; "y"). Piv txwv li: = datedif (A1; B4; "y"). Tsab ntawv y yog Latin hauv ob kis no.
