Cov ntawv sau Excel los ntawm cov chaw khiav dej num ntawm Microsoft Office kev siv ntau dua li lwm cov kev pab cuam rau ntau cov kev daws teeb meem nrog cov lej. Yog lawm, kev nthuav tawm kev ua haujlwm muaj nyob rau hauv cov program no, thiab nws txoj kev siv tsis tsim ib qho kev nyuaj thaum ua haujlwm nrog cov ntawv xaib.
Tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Muab tus cursor tso rau ntawm lub xovtooj ntawm qhov sib kis uas koj xav kom tshwm sim ntawm qhov tshwm sim ntawm kev nthuav tawm. Mus rau "Formulas" tab ntawm tus khoos phis tawm thiab nyem rau ntawm nruab nrab khawm ntawm sab xis sab xis ntawm cov cim hauv "Function Library" cov lus txib - thaum koj hover tus nas pointer hla nws, "Mathematical" tooltip pops. up.
Kauj ruam 2
Lub khawm no qhib lub npe ntev ntev ntawm built-in Excel cov haujlwm ntsig txog kev ua haujlwm kev ua lej - xaiv Cov Qib Kawm los ntawm lawv. Tom qab ntawd, cov nuj nqi tsim wizard daim ntawv yuav tshwm nyob rau ntawm qhov screen. Daim foos no tuaj yeem hu ua lwm txoj hauv kev, yog tias koj siv lub pob fₓ - "Ntxig ua haujlwm" - nyob rau sab laug sab ntawm lub thawv noj mis. Nws qhib lub qhov rai uas koj yuav tsum tau tsim tus nqi "Lej" hauv "Qeb" hauv daim teb, thiab tom qab ntawd xaiv tib qho haujlwm "Degree" hauv tib daim ntawv ntev. Txoj kev no, txawm hais tias ib kauj ruam ntev dua, tuaj yeem siv tau los ntawm txhua qhov tab ntawm daim ntawv Excel.
Kauj ruam 3
Hauv "Tus lej" daim foos ntawm daim foos tau qhib hauv kauj ruam dhau los, sau tus nqi pib uas koj xav tsa rau lub zog. Yog tias nws yuav tsum tsis yog tus nqi tas li, tab sis cov ntsiab lus ntawm lub cell hauv lub rooj, qhia nws qhov chaw nyob. Qhov no tuaj yeem ua tiav manually lossis los ntawm txhaj rau ntawm cov xov tooj uas xav tau nrog tus nas pointer. Koj tuaj yeem tso tus qauv nyob ntawm no, piv txwv li, suav qhov ntau ntawm cov hlwb lossis xam lawv qhov txiaj ntsig nruab nrab. Yog lawm, koj yuav tsum ntaus cov haujlwm uas siv hauv tus qauv koj tus kheej, yam tsis muaj kev koom tes ntawm tus qauv ntsuas.
Kauj ruam 4
Mus rau daim npov txuas ntxiv ntawm daim foos thiab sau exponent. Raws li hauv qib dhau los, koj tuaj yeem tso tus nqi tsis tu ncua, siv tau ntawm tes, lossis cov qauv ntawm no.
Kauj ruam 5
Nyem OK thiab Excel qhia cov tshwm sim piav qhia.
Kauj Ruam 6
Ntxiv nrog rau qhov "Ua Haujlwm" kev ua haujlwm, tus khoos phis tawm ntawv kuj tseem nkag siab txog kev ua haujlwm sau ntawv uas siv cov cim sau cia, uas tus lej naj npawb thiab cov rho tawm tau cais los ntawm "cap" - ^. Piv txwv li, koj tuaj yeem ntaus ntawv = 2 ^ 3 hauv qhov khoob ntawm tes, nias Enter thiab Excel yuav tso tawm qhov tshwm sim ntawm qhov cub ntawm ob. Daim ntawv sau cia no yooj yim, piv txwv li, thaum lub sijhawm ua haujlwm yog ib feem ntawm ntau txoj haujlwm.
