Pub muab kwv yees mus Excel - nws yog ib qho yooj yim!

Nyob rau hauv no tsab xov xwm peb yuav saib ntawm ib qho ntawm cov chaw ua hauj lwm daim ntaub ntawv MS Office Excel.

MS Office Excel - ib txoj kev pab uas yog muaj nyob rau hauv Microsoft Office Complex. Siv rau ntau yam ntawm zauv, charting, tsim ntxhuav, etc.

kev pab cuam ntawv no yog ib tug sau thiab khij tau. Cov phau ntawv muaj ib tug xov tooj unlimited kev los xij los ntawm tus neeg siv.

Txhua daim ntawv kev pab cuam yog ib lub rooj, muaj raws ntawm 256 kab thiab 65.536 kab. Txhua ntawm tes rau hauv ib lub rooj no yog hu ua ib tug cell.

Excel cell nws muaj nws tus kheej ib tug neeg qhov chaw nyob uas muaj cov kab xov tooj thiab Latin ntawv kem (e.g., 1A, 2B, 5C).

Main nta

Cov nuj nqi "Tawm" (lub sum nyob rau hauv Excel)

Lub summation ntawm cov nuj nqis thiab xov tooj nyob rau hauv Excel yuav ua tau nyob rau hauv peb txoj hau kev.

1. Siv ib tug qauv ntxiv kos npe rau - plus ( "+"). Nyob rau hauv feem ntau tus neeg mob, xws li ib tug txoj kev yog siv nyob rau hauv qhov sib ntxiv ntawm ib tug me me muaj pes tsawg tus ntawm tug lej tom qab los yog tus xov tooj, thiab nyob rau hauv tas li ntawd qauv rau caag ntawm lwm yam kev khiav dej num.
2. Siv cov tswv yim muaj nuj nqi "Nyiaj" thiab xaiv cov lus. Tso cai rau ntxiv tus xov tooj teem nyob rau hauv ib tug ib array (ntawm sab, kab), uas tsis yog-contiguous hlwb, ib tug seem array, lub array ntawm nyob ib sab hlwb thiab uas tsis yog-contiguous qhov chaw. Nyiaj nyob rau hauv Excel siv no muaj nuj nqi yuav tsum xam muaj.
3. Siv AutoSum cim «Σ», thiab xaiv ib tug ntau yam ntawm cov nqe lus. Nws yog siv los mus xam tus nqi nyob rau hauv xws li mob, raws li tau zoo raws li lub "sum".

Cov mis "HLOOV"

Cov tshwm sim ntawm tej xam, raws li zoo raws li tus nqi nyob rau hauv Excel, tej zaum yuav raug rau pub muab kwv yees. Pub muab kwv yees nyob rau hauv Excel tseem ceeb tsis yog yuav tsum tsis meej pem nrog cov zaub nqi.
Yuav kom ua tau ib tug txiav txim "pub muab kwv yees nyob rau hauv Excel," koj yuav tsum xaiv lub cell muaj lub xam tshwm sim, ua ntej tus xov tooj nrog ib tug sib npaug zos kos npe rau ( '='), xaiv cov "HLOOV" muaj nuj nqi thiab muab lub yam naj npawb ntawm cov khoom.

Hais txog cov cim zaub yuav tsum tau muab sau tseg tias cell qhia txog cov khoom uas yog muab tso rau hauv nws rau cov neeg siv visibility. Tab sis nyob rau hauv cov ntaub ntawv no, pub muab kwv yees raws li xws li tsis tshwm sim. Thaum hloov cov cell loj, tus xov tooj ntawm cov khoom kuj txawv raws li ib tug loj, los ntawm nce lub cell, thiab nyob rau hauv lub me me, thaum nws yog zuj zus lawm, cov kev taw qhia.

Raws li koj tau pom, lub rounding nyob rau hauv Excel yog tsis xws li ib tug yooj yim ua hauj lwm.

"PUB", "Len" - text zog uas tso cai rau los mus hloov lub kab ntev register los yog kev siv, thiab muab los yog phua kab.

"BDSCHET", "DSUM" - muaj nuj nqi rau databases. Cia kom suav tus xov tooj ntawm database ntaub ntawv, lub sum ntawm qhov tseem ceeb. Qhov no muaj nuj nqi yog zoo li tus nqi nyob rau hauv Excel zoo li "Tawm".

"Hlwb" - Qhov no muaj nuj nqi muaj rau tus neeg siv cov ntaub ntawv hais txog lub zog ntawm cov cell.

Math Tso - Excel ntsiav. Suav kev siv lawv - lub hom phiaj tseem ceeb ntawm cov kev pab cuam. Nyob rau hauv Excel, ib tug loj loj set ntawm zauv zog xws li sine, cosine, arc cosine, arc sine, tangent, cotangent. Thaum cov nta yog feem ntau tau multi-ntsis nqi. Yog li ntawd xaiv "pub muab kwv yees nyob rau hauv Excel" nyob rau hauv no tsab xov xwm no pab tau nyob rau hauv cov ntaub ntawv no.

"MMULT", "MDETERM", "ASI" rau kev ua hauj lwm nyob rau hauv numeric arrays, matrices.

"UNIT", "nruab nrab" rau intermediate thiab zaum kawg qhov tseem ceeb.

Logarithms, linear logarithms, logarithms.

Txheeb cais. "BETAINV" - ua ib tug rov qab mus rau lub rov qab muaj nuj nqi ntawm lub ib nuj nqi beta probability ceev. "WEIBULL" - Rov cov Weibull tis.

MS Office Excel kuj muaj ib cov nyiaj txiag muaj nuj nqi, muaj nuj nqi ua tim khawv thiab arrays, hnub tim thiab lub sij hawm zog, xyuas cov ntawv ua thiab zog.

Yog li, qhov kev pab cuam yog ib tug indispensable cuab tam rau cov neeg ntawm tag nrho cov hauj lwm uas yog sov ua licas kev cob cog rua nrog cov nuj nqis thiab xov tooj.