Hauv excel spreadsheet - ib tug uas pab rau tus tsom xam ntawm cov ntaub ntawv

Lub tabular daim ntawv siv los sawv cev rau cov lus qhia nyob rau hauv ib tug generalized daim ntawv no, feem ntau yog rau tom ntej cov ntaub ntawv tsom xam. Excel spreadsheets yuav automate txheej txheem ntawm xam thiab cov ntaub ntawv los xyuas dua, graphically sawv cev rau cov ntaub ntawv tsom xam.

Thaum cov kev pab cuam sau tas phau tso tawm kom pom ntawm qhov screen, uas yog ib tug txheej ntawm peb cov nplooj ntawv (lub neej ntawd), nyob rau txhua tus uas muaj ib lub rooj yog tam sim no. Rooj kab muaj numbered los 1, thiab cov kab xaiv nyob rau hauv Latin cov tsiaj ntawv, pib nrog A. Nyob rau hauv tag nrho daim ntawv 65 muab tso rau txhiab tus kab thiab tshaj 250 txhua. Hauv Excel rooj muaj xws li cov hlwb xaiv los ntawm A1 hom, qhov twg A - kem los, 1 - kab los. Koj yuav tau xaiv ib ntu ntawm lub hlwb. Piv txwv li, A1: C4 los sawv cev rau ib pawg ntawm cov hlwb teej tug mus rau ib lub cheeb tsam, uas ces kaum steel cell A1 thiab C4.

cim formatting nyob rau hauv lub hlwb yog heev uas zoo sib xws mus rau ib tug lo lus processor, tsuas nyob rau hauv Excel tsawg tsis hais tias yuav tau hloov. Tag nrho manipulation ntawm lub hlwb yuav tsum tau siv cov dialog "Format hlwb."

Raws li ib tug txoj cai, tom qab cov ntaub ntawv ua nws yog tsim nyog los qhia cov kev tshwm sim nyob rau hauv graphical daim ntawv. Muaj xam lub caij rau cov no nyob rau hauv Excel. Bar graphs, charts, taw tes thiab ncuav qab zib kab kos. Txhua yam ntawm lawv yog siv nyob rau hauv tej yam mob. Yog hais tias koj xav mus graphically qhia cov kev sib raug zoo ntawm ob cov ntaub ntawv poob lawm, koj yuav siv tau ib lub teeb los yog ib tug nphoo daim ntawv. Yog hais tias koj xav qhia qhov chaw ntawm ib tug tag nrho, peb muaj peev xwm tsim ib lub ncuav los yog donut daim ntawv. Nyob rau hauv lub caij nyoog kawg no cov ntaub ntawv, kom yooj yim to taub txog daim duab nws yog ntshaw kom muab lub xov tooj ntawm qhov tseem ceeb nyob rau hauv ntau 5-6.

Lub hlwb yuav tsum tau nyob hauv cov ntaub ntawv li ntawv, xov tooj (zauv, fractions, feem pua, thiab lwm yam), raws li zoo raws li cov qauv. Mis pib nrog cov kos npe rau "=" thiab muaj lub cim rooj hlwb, tej yam tshwm sim ntawm xam hauj lwm thiab txheem kev khiav dej num. Microsoft Excel kev pab cuam muaj 10 pawg ntawm kev khiav dej num: nyiaj txiag, hnub tim thiab lub sij hawm, zauv, statistical thiab lwm tus neeg. Qhov no yog ua li cas rau lub yooj yim ntawm lawv daim ntawv teev, nyob rau hauv uas tag nrho cov kev khiav dej num cov txheej txheem ntawm nyob rau hauv alphabetical thiaj (thawj nyob rau hauv lus Askiv thiab ces nyob rau hauv Lavxias teb sab).

Excel spreadsheets kuj muaj lub peev xwm ntawm sorting thiab filtering cov ntaub ntawv. Yog hais tias koj coj mus rau lub rooj ib tug ntev daim ntawv teev, ces nws yuav ua tau heev yooj yim mus ua hauj lwm nrog, yog tias npaj kab nyob rau hauv ascending los yog nqis kev txiav txim. Ntxiv mus, lub sorting yuav tsum tau ua los ntawm tej yam kab los yog ntau txawm tias. Lub lim tso cai rau xaiv tej yam kab ntawm lub hauv paus (mob). Piv txwv li, nws muaj peev xwm tso saib ntawm qhov screen, tsuas yog cov tseem ceeb uas yog ntau tshaj li zero.

Thaum ib tug tso zis rau lub Excel spreadsheets printing yuav yooj yim kho rau kev loj daim ntawv, ua los yog zuj zus lawm scale. Yog lub neej ntawd, lub rooj ciam teb rau lwm yog tsis pom thaum koj sau, yog li ntawd yog koj xav tau, koj muaj peev xwm tso saib daim phiaj los ntawm kev sib tham "Format hlwb" (tus "Ciam teb").

Microsoft Excel 2010 kev pab cuam nyob rau hauv MicrosoftOffice 2010 pob uas muaj xws li lwm teb ntawm lwm yam tseem ceeb daim ntawv sau npe. Tag nrho cov kev pab cuam muaj ib tug zoo li interface uas simplifies txoj kev loj hlob ntawm tus neeg siv.