Tso cai nyob rau hauv Excel: dab tsi yog lawv siv?

Nws yuav tsum tau muab sau tseg hais tias zoo-paub Excel kev pab cuam muaj zoo functionality, txawm ib tug me me ib feem ntawm uas feem ntau nyob twj ywm "qab lub scenes". Qhov no yog tshwj xeeb tshaj yog muaj tseeb ntawm txhua txhua hnub chav ua hauj lwm, muaj ntau tus ua hauj lwm uas yuav tsum caw kaw lus. Nyob rau hauv cov kev siv cov ib puag ncig yog tsis tshua muaj nrov nta Excel, uas koj muaj peev xwm txawm tsim koj tus kheej mis. Txawm li cas los, yog dab tsi tag nrho hais txog?

Qhov tseeb hais tias cov yam ntxwv nyob rau hauv daim ntawv thov no yog hu ua yooj yim ntawv nyeem commands uas txhais los ntawm ib lub computer, uas txawm lub feem ntau complex zauv. Yuav kom pab tau koj to taub, muab ib tug tiag tiag li piv txwv. Koj puas xav hais tias qhia qhov muaj nuj nqi nyob rau hauv Excel zoo li no: "= NRUAB NRAB (A1: A5)"? Yog hais tias koj decipher cov tsiaj ntawv nyob rau hauv thaum pib, nyob rau hauv Lavxias teb sab txhais lus ntawm qhov no yog "qhov nruab nrab nqi ntawm cov ntau yam ntawm hlwb A1 rau A5 inclusive." Qhov kos npe rau ":" yog tsis xaiv faib thiab ntau yam.

Kuv yuav tsum hais tias mus manually nkag mus rau qhov chaw nyob xov tooj tsis ua kev zoo siab, vim lawv qee ntawm tus nas nws tus kheej hloov kev rau sab laug tseem ceeb rau lawv noj mis nyuj tov tswv yim box. Cov tau ua li suav nyob rau hauv Excel lub cuab tam haib mus nqa tawm complex zauv hauj lwm los ntawm lawv txuas ntxhuav rau hauv ib tug sib tham sib system.

Yuav ua li cas nkag mus rau nws?

Raws li kev khiav dej num ntawm mis yuav tsum pib nrog ib tug "=" kos npe rau hauv lub tswv yim kab. Qhov no yog ua raws li los ntawm cov tsiaj ntawv ntawm cov kev qhia, tom qab uas lub nkhaus yog teem (raws li nyob rau hauv cov piv txwv saum toj no). Hauv muaj lus sib cav yog ib tug graphical zaub ntawm lub qhov tseem ceeb siv nyob rau hauv cov lus teb. Raws li xws li, kev khiav dej num nyob rau hauv Excel yuav siv tsis tau tsuas yog ib tug neeg hlwb, tab sis kuj mus rau ib tug tib tus nqi, raws li zoo raws li ib tug tag nrho series ntawm cell ua tim khawv. Yog li, cov kev qhia "= sum (12; 24)" yuav muab rau koj cov "36", thaum ib tug zoo xws li cov system "= sum (A12: A24)" yuav muab lub sum ntawm cov zauv uas yog nyob rau hauv lub teev ntau.

nested zog

Raws li peb twb hais tias, qhov cuab tam yog haib li ntawd, hais tias nws tso cai rau kom daws tau txawm heev kab zauv. No Excel (tus nqi zog uas yuav ua tau txawv heev) siv nyob rau hauv txoj systems lwm kab zauv. Kom nws dlaim phaj, peb yuav muab ib cov tswv yim piv txwv: "= sum (A5: A10; NRUAB NRAB (B7: C10))." Nco ntsoov tias qhov txhawb sevenfold zes. Ntawm cov hoob kawm, koj yuav tau sau thiab xav paub ntau sib cav, tab sis nws yog ntseeg hais tias kev qhia yuav ploj mus.

Txawm li cas los, lub Microsoft tshwj xeeb yog lossi ua hauj lwm los txhim kho lawv cov khoom, yog li ntawd muaj yog ib lub caij nyoog uas qhov kev pab cuam yuav sai sai no to taub thiab ntau cov kab zauv.

"Master"

Rau novice neeg siv yog muab "muaj nuj nqi Wizard", uas zoo heev tswj lawv lub tsev lag luam. Koj muaj peev xwm siv nws nyob rau hauv ob txoj kev:

• Nrhiav cov tab "Ntxig" thiab xaiv muaj qhov khoom "muaj nuj nqi";
• koj yuav txo tau lub sij hawm mus nrhiav tau rau lub toolbar khawm "Insert muaj nuj nqi".

Raws li peb twb hais tias, yuav siv spreadsheet editor ntawm Microsoft kuj yuav me nyuam kawm ntawv, raws li nws tso cai rau koj mus xam thiab ntau "ceev" piv txwv. Yog li, lub teeb nyob rau hauv Excel zog yuav muab yooj yim thiab intuitive graphical daws mus rau teeb meem ntawm lub hom «y = f (x), ib ya [ib tug, b]. Kauj ruam h = 0,1 ». Qhov no yuav zoo heev pab txhawb txoj kev kawm.