NeMhedziso kubatana kuna Excel - description, mienzaniso.

In zvose, kunyange zvinhu pasuru "Microsoft Office" inopa simba spreadsheet mupepeti Excel ( "Excel"). The mazita inowanika mashandiro zviri zvechokwadi hunoshamisa kubva mukana kufambira uye mupise Data akaguma zvingangoita kuvaka kwavo maererano pfupiso charts. Uye zvinenge zvisingaiti kuti chero zvakachengetwa umboo munguva mupepeti pasina computed ne Masvomhu pemitsara neshongwe.

Zvokuimba mu "Excel"

Chero nzira - timu dzine chiratidzo zvii kubereka pamwe siyana sero. Uye kana User anotarisana kudikanwa kutevedzera "tatamuka" bumbiro remitemo mutsara yose kana mbiru, ipapo anoziva kuti mune zvimwe zviitiko chikamu nzira kana kuti nzira inofanira kuramba zvachose kuchinja. Saka mushandisi vachaziva kuti pane ari Excel kwakakwana uye hama Links. Funga izvi pfungwa zvizere.

batanidzo hama

Yeuka kuti hama kubatana kuna Excel, nyore pane kare. Izvi Link mhando anosarudzwa nevanhu default ochinja ukoshi hwayo kana kudhonza (kungatonziwo) pamusoro nzira kuti pedyo masero pasinei kungatonziwo pamwe mbiru kana pemitsara.

Funga muenzaniso nyore. Gadzira chiduku akagadzirwa data, iine mbiru mbiri: "Employee" uye "muhoro":

Munyaya parameters kuti "vamwe" Kumbirai A1 manyorerwo arimo - Vachitaura yakadaro imwe uye nzwisisa vakawanda vanoshandisa. Pano, A, B, C - Mbiru mazita uye mutsetse nhamba. Saka, sero Data "Zakirova E. M." kero - A4. Izvi kutsaudzira duku vachada kana tauya kubata magwaro Masvomhu.

Zvino fungidzira kuti tinoda kuverenga pahwaro pamusoro muhoro nerimwe mushandi Payroll mashoko. We ndipe muchitokisi C2 inofananidza kuzozivisa mutoo (inobva ruzivo kuti muhoro ndiyo 40% kuti muhoro): = B2 * 100/40. Pano B2 - yokutanga mushandi muhoro iri tafura. Uye wokudhinda Pinda Kutamira negonzo kunzvimbo dzakaderera kurudyi kumucheto muchitokisi C2, vakamirira kusvikira Pointer kuchinja kuti mutete muchinjikwa dema. Batisisa pasi kuruboshwe mbeva bhatani, anodhonzera nzira pasi pamugumo tafura, ndiko, kusvikira sero C7 (unogona kutsiva chakaitwa kaviri-nekudzvanya negonzo musi rezasi rworudyi kumucheto muchitokisi). Mbiru iri kwaita pakazara pamwe date:

Formula Sero Data ndeinotevera:

Sezvaunogona kuona, kana isu akaiyera payakavakirwa pasi hunyambiri mbiru zita Zvisaririra kuchinja (B), asi mutsara nhamba ane anosiyaniswa achinja. Saizvozvowo, nokukopa ari yemaitiro yakatambarara, tinowana kugara tambo ukoshi ane kuchinja kamuri mbiru. Saka, kubatana anonzi "hama" - kopi yokutanga akapinda payakavakirwa ichachinja kubatana hama kuti panzvimbo yacho kuwanda shizha masero.

Sezvatinoona, kubata chokuti wakadaro hama kubatana kuna Excel, hazvina kuoma.

Ngatikurukurei zvinotevera marudzi Links.

Mhedziso batanidzo

NeMhedziso kubatana kuna Excel - inotevera vanhuwo mhando Links. Muchiitiko chino, apo nokukopa iri nzira yakatarwa mutsara uye mbiru, uko anotaurwa kutaura.

Zvechokwadi, pachako nemhedziso bhuku haina kushandiswa oga, nekuti kopi hazvina zvikuru pfungwa. Naizvozvo, kwakadai kupararira yakasanganiswa Masvomhu, apo vamwe vavo - nemhedziso reference, vamwe hama.

Isu tanga Somuenzaniso, tipiwe date - aipiwa kuti muhoro, zvakafanana vashandi vose:

Saka, zvinokosha kuti kuchinja uye masero C2 pamwe kukarukureta kuti muhoro, zvino zvichava zvine mutoo:

Kana tinoenderera Nyora, tinoona kuti mari recalculated zvakarurama muchitokisi. Asi kana isu achatambanudza kuti bumbiro remitemo vashandi vose, ivo kuti mari hautorwi, nokushandisa kubatana hama vakaedza kutora tsika G4..G8, apo zvachose. Kuti tidzivise mamiriro ezvinhu akadaro, zvakakodzera kushandisa nemhedziso panotaurwa muna Excel. Kukiya mbiru kana musara, iyo anochinja kana iwe kutevedzera nzira yemaitiro havafaniri kuva zvakafanira kuisa azvaitwa pedyo zita mbiru kana mutsara nhamba dhora chiratidzo ($).

Tinochinja fomura redu zvinotevera:

Zvino isu kutevedzera izvozvo, vose mari dzevashandi recalculated:

Next kuti pfungwa "bhuku kwakakwana" muna Excel anogara pfungwa yakavhenganiswa arimo.

batanidzo hwakakanyiwa

Funga izvi mhando kutaura. Mixed Link - kubatana kuti zvachinja kana iwe kukopa nhamba mbiru pane kugara mutsetse nhamba, kana vakutarisire. Saka Dhora chiratidzo inomira pamberi mutsara nhamba azvaitwa (A $ 1) kana pamberi mbiru nhamba ($ A1) - iri, pamberi ichocho kuchaita kuti haachinji.

Link hwakakanyiwa kushandiswa zvikuru kupfuura wechokwadi Mhedziso bhuku. Somuenzaniso, kunyange iri nyore zvapfuura muenzaniso, tinogona kwazvo kutsiva nzira = (B2 + $ G $ 3) * 100/40 kuti = (B2 + G $ 3) * 100/40 uye kuwana chete mugumisiro, nekuti tiri kutevedzera mafungiro okuda fomura vertically uye mbiru nhamba chero zvazvingava angadai kumbochinja. Uye izvozvo tisingatauri ezvinhu kana uchinyatsoda kukiya chete musara nhamba yacho kana mbiru, uye kusiya vamwe iripo kuti vachinje.

dzinonakidza chokwadi

Zvichava zvinofadza kuziva chii Mhedziso panotaurwa muna Excel rinogona kuisa kwete chete yakazvimirira chinoratidza dhora chiratidzo pamberi mumutsetse uye / kana mbiru. "Excel" achibvumira nokutsikirira pasi F4 kiyi pashure chaiyo kero sero kusarudza mhando Links - kokutanga link rikazvisundira pamwe hama Kuchinja paMhedziso, apo rechipiri - neveMamwe wakaiswa-mutsetse nhamba, ari wechitatu - neveMamwe wakaiswa mbiru nhamba, zvakanaka, nguva inotevera nekudzvanya zvakare anova hama. Kushandura chimiro tsamba Excel saka zviri nyore chaizvo, nokuti hazvina zvakakodzera kushandisa kuchinja kiibhodhi marongerwo.