Kawm tau li cas rau "Eksele" xam tus nqi ntawm cov

Yuav ua li cas yuav cov neeg tsis xa mus rau cov kev hloov uas muaj feem rau chaw ua hauj lwm cov kev pab cuam, qhov tseeb tseem hais tias lawv tau, thiab yuav tsum tau, thiab yog li ntawd yuav tau hloov mus rau lawv es changeable tsos. Raws li koj paub, peb yuav sib tham txog qhov tseeb versions ntawm MS Office, uas yog heev txawv los ntawm lawv cov predecessors. Cia peb saib seb tsuas tsos yog tas rau cov developers lub sij hawm no.

Lavxias teb sab lus lawm thaum kawg ua ib tug ntawm cov sawv cev rau hauv daim ntawv, yog li ntawd kev txhawj txog qhov complexities ntawm lub hloov lwm lub tsev yog tsis tsim nyog. Nyob rau hauv tas li ntawd, cov rau ib zaug khaws cia nws lo lus cog tseg thiab kuav los tiag tawm rau pej xeem rau ib tug tag nrho x 64 version. Txawm li cas los, lawv ua siab ncaj ceeb toom hais tias nyob rau hauv lub qhaj ntawv ntawm qhov yuav tsum tau mus ua hauj lwm nrog Excel ntaub ntawv ntau thiab tsawg 2GB thiab ntau ntshaw kom siv cov obsolete 32-ntsis version.

Cia peb tawm ib sab qhov lyrics. Niaj hnub no peb yuav kawm tau li cas rau "Eksele" Xam cov nyiaj. Yog, rau cov neeg siv no yog tsis muaj big deal, tab sis tseem feem ntau ntawm cov neeg tuaj tshiab no tau yeej tsis tau raug.

Lub xam txheej txheem

Nyob rau hauv kev ncaj ncees nws yuav tsum tau muab sau tseg tias muab xam los ntawm tag nrho cov nqi - ib qho ntawm qhov nyuaj ua hauj lwm nrog cov qauv uas tsuas muaj no spreadsheet editor. Cia peb kawm cov feem ntau elementary piv txwv.

Cia peb xav hais tias cov ua hauj lwm yog nqa tawm nyob rau hauv ib kem nyob rau hauv lub chav A4 A9. Ua ntej yuav mus nyob rau hauv, "Eksele" xam lub sum ntawm cov qhov tseem ceeb yuav tsuas tau mus xaiv rau txhua lub hlwb thiab ib tug dawb paug rau lawv (ie, lub ntau yam ntawm cov A4 rau lub A10), ces nyem rau ntawm lub sum khawm. Qhov kev pab cuam txiav yuav suav uas tus raug thiab muab tso rau nws nyob rau hauv cell A10.

Muaj ib txoj kev. Xav hais tias cov kev kawm tseem ceeb muaj nyob rau hauv tib lub hlwb. Tab sis tej zaum koj yuav xav tau mus rau lub yam tshwm sim yog nyob rau hauv lwm tes ntawm cov ntau yam (B7, piv txwv li). Yuav ua li cas ua tau qhov no?

Ua ntej, highlight lub cell B7 laug nas khawm, ces nias rau ntawm tus lej khawm. Tom qab ntawd, rau sab laug nas khawm qhia kom meej rau hauv lub chav uas muaj cov ntaub ntawv koj xav tau. Qhov kawg ntawm tes ntawm yam nqi zoo nkaus li. Yog hais tias tsim nyog, lub ntau yam uas tau faib rau lub hlwb yuav raug hloov.

Ib tug ntau sophisticated version

Txhua yam uas peb tau kawm saum toj no, yog cov qeb ntawm cov banal lus, uas muab cov menyuam kawm ntawv nyob rau hauv thawj ob peb zaj lus qhia Informatics. Tab sis li cas txog nyob rau hauv lub rooj plaub thaum lub yam nqi yog yuav tsum tau txais raws li nyob rau hauv cov ntaub ntawv, uas yog nyob rau hauv ib tug txawv kiag li bands?

Ua ntej yuav mus nyob rau hauv, "Eksele" Xam cov nyiaj nyob rau hauv tej yam, yuav tau ua ib tug me ntsis ntau. Ua ntej, muab cov cursor ntawm lub cell qhov twg tag nrho cov nyiaj yuav tau. Muab muaj kos npe rau "=", ces sab laug nas khawm xaiv lub cell uas nws muaj nuj nqis yuav tsum tau ntxiv ua ke nrog rau lwm cov nuj nqis.

Tom qab lub "sib npaug" kos npe rau zoo nkaus li nws tus nqi (A6, piv txwv li). Muab A6 tom qab lub "+", ces peb yuav noj peb caug koj xav ntau yam. Thaum tiav lawm, tsuas nias lub «Sau»: tus yam nqi zoo nkaus li nyob rau hauv cov yam qhov chaw.

"Ceev sum"

Thiab raws li nyob rau hauv "Eksele" Xam cov nyiaj hais tias koj tsuas xav tau ceev nrooj saib tag nrho cov nqi ntawm ob peb lub hlwb, tsis sau rau qhov no complex kab zauv? Zoo, tus creators ntawm qhov kev pab cuam (hu nws nqi hluav taws xob tsis tig cov lus), thiab muab ib tug xws li scenario.

Tom qab ntawm cov tsab ntawv khom nqi rau lo lus kab yog "ua li cas." Nyem rau nws txoj cai nas khawm, thiab nyob rau hauv lub popup ntsiab lus teb ntawv qhia zaub mov xaiv qhov khoom "Nyiaj". Tom qab uas koj xav tau mus rau ntsiab lub cell ntau sab laug nas khawm thaum tuav cia lub Ctrl qhov tseem ceeb rau lub keyboard.

Qhov twg mus nrhiav ib lo lus teb?

Xaiv lub cell thiab tso tus yuam sij rau lub keyboard, peb ua kom lwm tus sab sab ces kaum ntawm lub lag luam screen qhov twg yuav muaj kab "Tawm =", uas qhia lub resulting tus nqi.

Raws li koj tau saib, siv ib tug tswvyim rau intermediate suav tsis tas yuav, vim hais tias Excel yooj yim neeg ntaus nws nyob rau tag nrho cov suav. Yog, vim hais tias nyob rau hauv Excel los xam tus nqi yog tsis muab rau txhua leej txhua tus, suav nyiaj nrog kev feem ntau siv no xyov cov txheej txheem.

lwm txoj kev

Yog hais tias koj ua tib zoo nyeem peb cov tsab xov xwm no, tej zaum koj pom tus xov tooj ntawm cov qauv siv nyob rau hauv cov lus teb. Yog, koj hais yog lawm: yog hais tias manually nkag mus rau lawv nyob rau hauv lub tsim nyog teb, nws yog tau tsis txhob kov nas. Cia peb kawm saib yuav ua li cas no ua hauj lwm nyob rau hauv xyaum.

Yuav kom tau nkag mus rau cov mis nyob rau hauv lub "Excel", koj yuav tsum xub kawm (tus nqi nyob rau hauv cov lus yuav tsis ua hauj lwm tsis muaj nws) nyob rau qhov twg nkag mus rau nws nyob rau tag nrho cov. Tam sim ntawd hauv qab no lub toolbar (los yog nyob rau hauv lub siv nyob rau hauv newer versions) muaj ib tug ntev daim teb. Thaum nws pib muaj Fx icon, yog li ntawd koj yuav tsis mus tsis ncaj ncees lawm.

Ntawm no nws cia li nkag mus hauv yuav tsum tau kev tso cai. Piv txwv hais tias koj yuav tau mus nrhiav lub sum ntawm ib tug xov tooj ntawm hlwb uas uniformly faib thoob plaws hauv lub rooj. Ua ntej, xaiv lub teb, uas yuav tsum tau xam zauv. Tom qab ntawd, peb sau nyob rau hauv lub teb "=" qauv, thiab ces muab cov hlwb uas muaj cov kev kawm ntaub ntawv, sib cais los ntawm ib tug "+".

Piv txwv li: = A1 + B2 + C3. Thaum tiav lawm, nyem rau ntawm qhov ubiquitous sau. Nyob rau hauv koj xaiv teb tus yuav tsum tau tshwm. Txij li thaum "Eksele" xam tus nqi ntawm nws yog feem ntau yuav tsum tau nyob rau hauv no txoj kev, nyob rau nws koj yuav tsum nco ntsoov.