Maitiro ekuwanda muExcel. Mirayiridzo yekuti ungaita sei kuwanda muExcel

The spreadsheet Excel ipurogiramu ine mabasa akawanda inokubvumira kuti uite nhamba huru yekuverenga kwakasiyana. Chirongwa ichi chinoita zvese zviri nyore masvomhu mashandiro uye zvakaomarara masvomhu kuverenga. Ichi chinyorwa chinotarisa nzira dzinoverengeka dzekushandisa kuwanda muspredishiti.

Kuita kuwanda muchirongwa

Tese tinonyatsoziva mashandisiro akaita arithmetic oparesheni sekuwedzera pabepa. Mune spreadsheet, nzira iyi zvakare iri nyore. Chinhu chikuru ndechokuziva algorithm yakarurama yezviito kuitira kuti usaita zvikanganiso mukuverenga paunenge uchishanda nehuwandu hwemashoko.

"*" - chiratidzo cheasterisk chinoita sekuwedzera muExcel, asi basa rinokosha rinogona kushandiswawo panzvimbo. Kuti unzwisise zviri nani nyaya, funga nezvekuita kuwanda uchishandisa mienzaniso chaiyo.

Muenzaniso 1: kuwedzera nhamba nenhamba

Chigadzirwa che2 kukosha ndeye yakajairwa uye yakajeka muenzaniso we arithmetic mashandiro muspredishiti. Mumuenzaniso uyu, chirongwa chinoshanda seyakajairwa Calculator. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoisa cursor pane chero yemahara sero uye sarudza iyo nekudzvanya bhatani rekuruboshwe.
2. Isa iyo "=" saina mairi, uye wobva wanyora nhamba yekutanga.
3. Tinoisa chiratidzo chechigadzirwa nenzira yeasterisk - "*".
4. Isa nhamba yechipiri.

5. Dzvanya kiyi ye "Enter" pane keyboard.
6. Ready! Muchikamu chawakaisa fomura yakapfava, mhedzisiro yekuwanza yakaratidzwa.

Zvinokosha! MuExcel spreadsheet, kana uchishanda nekuverenga, mitemo yakafanana yekutangira inoshanda seyakajairika masvomhu. Mune mamwe mazwi, kupatsanura kana chigadzirwa kunotanga kuitiswa, uyezve kubvisa kana kuwanza.

Patinonyora chirevo chine mabhuraketi pabepa, chiratidzo chekuwanza kazhinji hachinyorwi. MuExcel, chiratidzo chekuwedzera chinogara chichidikanwa. Semuenzaniso, tora kukosha: 32+28(5+7). Muchikamu chetafura processor, tinonyora chirevo ichi nenzira inotevera: =32+28*(5+7).

Nekudzvanya "Enter" kiyi pane keyboard, isu ticharatidza mhedzisiro muchitokisi.

Muenzaniso 2: wedzera sero nenhamba

Iyi nzira inoshanda maererano nemitemo yakafanana nemuenzaniso uri pamusoro apa. Musiyano mukuru hausi chigadzirwa chenhamba mbiri dzakajairika, asi kuwanda kwenhamba neukoshi huri mune imwe sero yespredishiti. Semuenzaniso, tine ndiro inoratidza mutengo weyuniti yechero chigadzirwa. Tinofanira kuverenga mutengo nehuwandu hwezvidimbu zvishanu. Iyo yekufamba inotaridzika seiyi:

1. Isu tinoisa iyo cursor muchikamu umo zvakakosha kuita kuwanda. Mumuenzaniso uyu, iri sero C2.
2. Tinoisa chiratidzo "=".
3. Isu tinotyaira mukero yesero umo nhamba yekutanga iripo. Mumuenzaniso uyu, iri sero B2. Pane nzira mbiri dzekutsanangura sero iri. Yekutanga ndeye yakazvimirira yekuisa uchishandisa kiibhodhi, uye yechipiri iri kudzvanya pane iyi sero uri mumutsara wekupinda mafomula.
4. Isa chiratidzo chekuwedzera muchimiro chenyeredzi - "*".
5. Isa nhamba 5.

6. Dzvanya kiyi ye "Enter" pane keyboard uye uwane yekupedzisira mhedzisiro yekuverenga.

Muenzaniso 3: wedzera sero nesero

Fungidzira kuti isu tine tafura ine data inoratidza huwandu hwezvigadzirwa uye mutengo wavo. Tinofanira kuverenga mari yacho. Kutevedzana kwezviito zvekuverenga mari yacho hakuna kumbosiyana nenzira iri pamusoro. Musiyano mukuru ndewekuti isu hatipindi chero nhamba isu pachedu, uye pakuverenga tinoshandisa chete data kubva kumaseru etafura. Iyo yekufamba inotaridzika seiyi:

1. Isa chitubu muchikamu cheD2 uye sarudza nekudzvanya bhatani rekuruboshwe.
2. Isa chirevo chinotevera mubhari yeformula: =B2*С2.

3. Dzvanya kiyi ye "Enter" uye uwane yekupedzisira mhedzisiro yekuverenga.

Zvinokosha! Maitiro echigadzirwa anogona kusanganiswa neakasiyana arithmetic mashandiro. Formula inogona kuve nenhamba huru yekuverenga, maseru anoshandiswa, uye akasiyana manhamba manhamba. Hapana zvirambidzo. Chinhu chikuru ndechokunyatsonyora pasi maitiro emashoko akaoma, sezvo iwe unogona kuvhiringidzika uye kuita kuverenga kusina kururama.

Muenzaniso 4: kuwanza koramu nenhamba

Uyu muenzaniso ndeyekuenderera kwemuenzaniso wechipiri, unowanikwa pakutanga munyaya ino. Isu tatova nemhedzisiro yakaverengerwa yekuwedzera kukosha kwenhamba uye chikamu chesero C2. Zvino iwe unofanirwa kuverenga kukosha mumitsetse iri pazasi nekutambanudza fomula. Ngatitarisei izvi zvakadzama. Iyo yekufamba inotaridzika seiyi:

1. Fambisa chitubu chegonzo kukona yekurudyi yechikamu nemhedzisiro inoratidzwa. Muchiitiko ichi, iri sero C2.
2. Kana yasimudzwa, cursor yakashanduka kuita icon inoita sediki plus. Nyatsobata bhatani rekuruboshwe woridhonzera kumutsara wepasi petafura.
3. Sunungura bhatani rekuruboshwe kana wasvika pamutsetse wekupedzisira.

4. Ready! Isu takawana mhedzisiro yekuwanza kukosha kubva kukoromo B nenhamba 5.

Muenzaniso 5: wedzera mbiru nekoromo

Uyu muenzaniso kuenderera mberi kwemuenzaniso wechitatu wakurukurwa kwokutanga munyaya ino. Mumuenzaniso 3, nzira yekuwanza chikamu chimwe nechimwe chakatariswa. Iyo algorithm yezviito haina kumbosiyana neiyo yapfuura muenzaniso. Iyo yekufamba inotaridzika seiyi:

1. Fambisa chitubu chegonzo kukona yekurudyi yechikamu nemhedzisiro inoratidzwa. Muchiitiko ichi, sero D
2. Kana yasimudzwa, cursor yakashanduka kuita icon inoita sediki plus. Nyatsobata bhatani rekuruboshwe woridhonzera kumutsara wepasi petafura.
3. Sunungura bhatani rekuruboshwe kana wasvika pamutsetse wekupedzisira.

4. Ready! Isu takawana mhedzisiro yechigadzirwa chekoramu B nekoramu C.

Zvakakodzera kutarisisa kuti nzira yekutambanudza fomula, inotsanangurwa mumienzaniso miviri, inoshanda sei. Semuenzaniso, sero C1 ine formula =A1*V1. Paunenge uchikwevera fomu kuzasi sero C2, inotora fomu =A2*V2. Mune mamwe mazwi, maseru anoronga anoshanduka pamwe nenzvimbo yemhedzisiro inoratidzwa.

Muenzaniso 6: kuwanza koramu nesero

Ngationgororei nzira yekuwanza koramu nesero. Semuenzaniso, zvinodikanwa kuverenga kuderedzwa kweiyo runyorwa rwezvigadzirwa zviri mukoramu B. Muchikamu E2, pane chiratidzo chekudzikisa. Iyo yekufamba inotaridzika seiyi:

1. Pakutanga, mumutsara weC2, tinonyora fomula yechigadzirwa chechikamu B2 neE2. Iyo formula inoita seizvi: =B2*E2.

2. Haufanire kudzvanya bhatani rekuti "Enter" nekukurumidza, sezvo panguva iyo mareferensi ehukama anoshandiswa mufomula, ndiko kuti, panguva yekukopa kune mamwe matunhu, iyo yakambokurukurwa yekuronga shanduko ichaitika (chikamu B3 chichawedzerwa neE3. ) Sero E2 ine kukosha kwekuderedzwa, izvo zvinoreva kuti kero iyi inofanirwa kugadziriswa uchishandisa absolute reference. Kuti uite nzira iyi, unofanirwa kudzvanya "F4" kiyi.
3. Isu takagadzira chirevo chakakwana nekuti iko zvino chiratidzo che "$" chabuda mufomula.

4. Mushure mekugadzira mhedziso zvinongedzo, tinya "Enter" kiyi.
5. Zvino, semumienzaniso iri pamusoro, tinotambanudza fomula kumaseru epasi tichishandisa mubato wekuzadza.

6. Ready! Iwe unogona kutarisa iko kurongeka kwekuverenga nekutarisa fomula muchitokisi C9. Pano, sezvazvaive zvakafanira, kuwanda kunoitwa nechikamu E2.

Operator PRODUCT

Mune spreadsheet Excel, chigadzirwa chezviratidzo chinogona kushandiswa kwete chete nekunyora mafomula. Pane basa rinokosha mupepeti rinonzi PRODUCT, iyo inoshandisa kuwanda kwemaitiro. Iyo yekufamba inotaridzika seiyi:

1. Isu tinodzvanya pachikamu chatinoda kuita masvomhu uye tinya pane "Insert basa" chinhu chiri padhuze nemutsara wekupinda mafomula.

2. Iwindo re "Function Wizard" richaonekwa pachiratidziro. Wedzera rondedzero padivi pechinyorwa "Chikamu:" uye sarudza chinhu "Mathematical". Muchivharo "Sarudza basa:" tinowana murairo PRODUCT, sarudza wobva wadzvanya pakanzi OK.

3. Hwindo renharo rinovhurwa. Pano iwe unogona kutsanangura nhamba dzakajairwa, hama uye mhedziso mareferensi, pamwe neakasanganiswa nharo. Iwe unogona kuisa data iwe pachako uchishandisa manyorerwo ekuisa kana nekutsanangura zvinongedzo kumaseru nekudzvanya paari nebhatani rekuruboshwe rembeva papepa rebasa.

4. Zadza nharo dzese uye tinya OK. Somugumisiro, takawana chigadzirwa chemasero.

Zvinokosha! Iyo "Function Wizard" inogona kusiiwa kana mushandisi weExcel spreadsheet achiziva kuisa fomula yekuverengera kutaura nemaoko.

Vhidhiyo pamusoro pekuwandisa mashandiro muExcel

Kana mirairo iri pamusoro nemienzaniso isina kukubatsira kuita kuwanda muspredishiti, ipapo kuona vhidhiyo inotevera inogona kukubatsira:

Vhidhiyo iyi, ichishandisa mienzaniso chaiyo, inotsanangura nzira dzinoverengeka dzekuwanza muchirongwa, saka zvakakosha kuti utarise kuti unyatsoona kuti maitiro aya anoitwa sei.

mhedziso

Zvinogoneka kuita kuwanda muExcel spreadsheet munzira dzakawanda. Iwe unogona kuwedzera kukosha kwemaseru, kuwedzera nhamba nechikamu, shandisa hukama uye absolute mareferensi, uye kushandisa basa remasvomhu. CHEMA. Nekuda kwesarudzo yakakura kudaro, mushandisi wega wega anogona kuzvisarudzira nzira yakakunakira uye nekuishandisa kana achishanda nedata muspredishiti.