Maitiro ekubvisa nhamba kubva pakati peExapale

Chirongwa cheEkunyanyisa uchishandisa chishandiso chakadai, se formula, chinobvumira kune dzakasiyana siyana Arititmetic zviito pakati pe data mumasero. Izvi zviito zvinosanganisira kubvisa. Ngationgororei zvakadzama kuti ndedzipi nzira dzinogona kuburitsa kuwanda uku mukubatana.

Kushandisa kwekunyura

Kugodziisa kuti ubudise kunogona kushandiswazve kune nhamba dzakatarwa uye kero dzemasero umo iyo data iri. Ichi chiitiko chinoitwa nekuda kwezvinhu zvakakosha mafomula. Sezvazviri mune mamwe arithmetic kuverenga muchirongwa ichi, pamberi pekutanga formula, iwe unofanirwa kutanga chiratidzo chakaenzana (=). Ipapo yakaderedzwa (muchimiro chenhamba kana kero yechitokisi), iyo minus () chiratidzo, yekutanga sign (muchimiro chenhamba kana kero), uye mune zvimwe zviitiko zvakatsiga zvakabviswa.

Ngationgororei pane chaiwo mienzaniso kuti iyi arithmetic chiito inoitwa sei muExcel.

Nzira 1: Bvisa nhamba

Muenzaniso uri nyore ndiko kugoverwa kwehuwandu. Mune ino kesi, zviito zvese zvinoitwa pakati penhamba dzakatarwa seyakajairwa Calculator, uye kwete pakati pemasero.

1. Sarudza chero sero kana kuseta iyo inotuka mufomula tambo. Takaisa chiratidzo "chakaenzana." Isu tinodhinda arithmetic mhedzisiro nekubvisa, sezvatinoita papa pepa. Semuenzaniso, nyora pasi nzira inotevera:

   = 895-45-69



2. Kuti uburitse maitiro ekuverenga, tinya bhatani rePeturu pane kiyi.

Mushure mekunge matanho aya agadzirwa, mhedzisiro inoratidzwa muchitokisi chakasarudzwa. Pane yedu nyaya, iyi ndiyo nhamba 781. Kana iwe ukashandisa imwe data yekuverenga, ipapo, maererano, mhedzisiro yako ichave yakasiyana.

Nzira yechipiri: Kugovana kwehuwandu kubva kumasero

Asi, sezvaunoziva, Excel ndeyekutanga pane zvese, chirongwa chekushanda nematafura. Naizvozvo, mashandiro ane masero anotorerwa zvakanyanya. Kunyanya, ivo vanogona kushandiswa nekubvisa.

1. Isu tinosimbisa sero umo iyo yekubvisa iyo formula ichave iri. Isu tinoisa chiratidzo "=". Dzvanya pane sero rine data. Sezvauri kuona, mushure mekuita uku, kero yayo yakapinda mune formula tambo uye yakawedzera mushure me "yakaenzana" chiratidzo. Isu tinodhinda nhamba yaunoda kuti ubvise.



2. Sezvazviri kare, kuwana mhedzisiro yekuverenga, tinya kiyi yekupinda.

Nzira 3: Sarudzo imwechete yekuchenesa

Iwe unogona kuitisa zvidimbu zvekungoita uye kazhinji pasina nhamba, kubata chete foni kero nedata. Iyo nheyo yekuita yakafanana.

1. Sarudza iyo sero kuratidza mhedzisiro yekuverenga uye kuisa iyo "yakaenzana" chiratidzo mairi. Dzvanya pane imwe sero ine yakaderedzwa imwe. Takaisa chiratidzo "-". Dzvanya pane imwe sero ine zvinotariswa. Kana zvikaita kuti kuvhiyiwa kuchizofanira kuitwa pamwe nekuverengera kwakasiyana, ipapo kunoisa zvakare "minus" chiratidzo uye ita zviito pane chimwe chiitiko.



2. Mushure mekunge data rese rapindwa, kune iyo yakabuda yemhedzisiro, tinya pane iyo Enter bhatani.

Chidzidzo: Shanda neFordelas muExcel

Nzira 4: Masasi Kugadzirisa Kunze Kwekunze

Kazhinji kazhinji, kana uchishanda nechirongwa cheEkutanga, zvinoitika kuti zvinodikanwa kuti uverenge kuderedzwa kwekamuri yese yemasero pane imwe column. Ehe, zvinokwanisika kuti chimwe nechimwe chiito chekunyora fomu rakaparadzana, asi zvinotora nguva yakawanda. Neraki, kushanda kweiyo application kunokwanisa kuwedzera otomatiki kuverenga kwakadaro, nekutenda kuAutofile Basa.

Pamutemo, isu tinoverenga purofiti yebhizinesi munzvimbo dzakasiyana, kuziva mari yese uye mutengo wekugadzira. Nekuti izvi zvinofanira kuziviswa.

1. Isu tinogovera sero repamusoro kuti riveridze purofiti. Isu tinoisa chiratidzo "=". Dzvanya pane imwe sero ine mari yemari mumutsara mumwechete. Takaisa chiratidzo "-". Isu tinosimbisa sero nemutengo.



2. Kuti ubudise purofiti pane iyi mutsara pachiratidziro, tinya pane bhatani rePeturu.



3. Zvino isu tinofanirwa kutevedzera iyi formula mune yakaderera rondedzero kuti iite iyo yekuverenga yaunoda ipapo. Kuti tiite izvi, tinoisa iyo inotuka pamupendero wezasi rechitokisi rine formula. Mazano anozadza anoonekwa. Isu tinodzvanya bhatani rekuruboshwe rombo uye mumamiriro ekurongedza nekudhonza kutuka kusvika kumagumo etafura.



4. Sezvauri kuona, mushure meizvi zviito, iyo formula yakateedzerwa kune ese chikamu pazasi. Panguva imwecheteyo, nekuda kwechinhu ichi, seboka remakero, kopi iyi yakaitika nekukasirwa, iyo yakaita kuti igone kuburitsa kuverenga kwakakodzera kwekunyora uye mumasero aipota.

Chidzidzo: Maitiro ekuita autocomplete muExcel

Nzira 5: Misa Kubvisa kweDhipatimendi reSero rimwe kubva kune renji

Asi dzimwe nguva iwe unofanirwa kungoita zvakapesana, kureva kuti kero yacho haina kuchinja kana ichiramba ichitevedzera, asi yakaramba ichisingaperi, ichireva chirevo chimwe chete. Maitiro ekuzviita sei?

1. Isu tinova muchitokisi chekutanga kuburitsa mhedzisiro yekuverenga huwandu. Takaisa chiratidzo "chakaenzana." Dzvanya pane imwe sero mune iyo yakaderera. Isa iyo "minus" chiratidzo. Isu tinoita tinya pane sero racho rinobviswa, kero yeiyo haifanirwe kushandurwa.



2. Uye ikozvino takatendeukira kumisiyano yakakosha yeiyi nzira kubva pane yapfuura. Ndiro rinotevera rinokutendera kuti ushandise chinongedzo kubva kuhukama muMhedziso. Isu tinoisa dhora rechiratidzo pamberi penzvimbo yeiyo yakatwasuka uye yakatwasuka yeiyo cell ine kero haifanire kuchinja.



3. Dzvanya pane yekhibhodi pane iyo Enter Key kiyi, iyo inokutendera kuti ubudise iyo yekuverenga iyo mutsara kune iyo skrini.



4. Kuti uverenge kuverenga uye pane mamwe mitsara, nenzira imwecheteyo semuenzaniso wapfuura, tinodaidza iyo yekuzadza mucherechedzo ndokuidhonza pasi.



5. Sezvatinoona, maitiro ekubvisa akagadzirwa chaizvo sezvatinoda. Ndokunge, kana uchitungamira pasi kero yeiyo yakaderedzwa data yakachinja, asi iyo yakakundwa yakaramba isina kuchinjika.

Muenzaniso uri pamusoro unongova chinhu chakakosha chete. Nenzira imwecheteyo, inogona kuitwa pane zvinopesana, kuti iyo yakaderedzwa inoramba ichirara, uye yakatsiga yaive hama uye yakachinja.

Chidzidzo: Mhedziso uye hukama hwehukama kuti ubude

Sezvauri kuona, mukuvandudzwa kweiyo nzira yekubvisa muitiro yekukurira mune chirongwa cheEkutanga hapana chakaoma. Izvo zvinoitwa zvinoenderana nemitemo yakafanana neye mamwe arithmetic kuverenga mune iyi application. Kuziva zvimwe zvezvinyorwa zvinonakidza zvichabvumira mushandisi kuti aite nenzira kwayo kuita kwemasvomhu kweakaitwa ne data hombe, iyo ichaponesa zvakanyanya nguva.