Basa module muExcel

Iyo module ndiyo yakakwana kukosha kweiyo chero nhamba. Kunyangwe pane imwe nhamba isina kunaka, module ichagara ichiripo. Ngatitsvage nzira yekuverenga sei hukuru hwema module muMicrosoft Excel.

BAST

Kuti uverenge hukuru hwema module muExcel, pane chinhu chakakosha chinonzi "abs". Iyo syntax yeiri basa iri nyore kwazvo: ABS (nhamba). Either the formula inogona kutora iyi mhando: ABS (Kero_chi_chilren_s_ch). Kuti uverenge, semuenzaniso, module kubva kuhuwandu -8, iwe unofanirwa kutyaira mune tambo yetambo kana kune chero sero pane runyorwa runotevera formula: "= Abs (-8)".

Kuita kuverenga, pinda paPinda - chirongwa chinoti chinoratidzira kukosha kwakanaka mukupindura.

Pane imwe nzira yekuverenga iyo module. Izvo zvakakodzera kune avo vashandisi vasina kujaira kuchengetedza mafomu akasiyana mumusoro.

1. Dzvanya pane iyo sero ratiri kuda kuramba ichiripo. Dzvanya pane iyo "Insert basa" bhatani, yakaiswa kuruboshwe rwetambo ye formula.



2. Iyo "Wizard mabasa" hwindo rinotanga. Mune rondedzero, iyo iri mazviri, tsvaga iyo BAST shuwa uye isarudze. Ini ndinosimbisa pane zvakanaka.



3. Nhaurwa dzebasa dzinovhura. Abs ane chete nharo imwe chete - nhamba, saka tinozvizivisa. Kana iwe uchida kutora nhamba kubva ku data iyo inochengeterwa muchitokisi chero yegwaro, tinya bhatani rakaiswa kurudyi rwechimiro chekuisa.



4. Iwindo rinouya, uye iwe unofanirwa kudzvanya pachiteshi, uko imwe ine nhamba kubva kwaunoda kuverenga module. Mushure mekuwedzera zvakare, tinya pane bhatani kurudyi kwemunda wekupinza.



5. Asess uhwindo nehasha dzebasa, uko "nhamba" munda uchatozadzwa neiyo kukosha. Dzvanya OK.



6. Kutevera izvi, kukosha kweiyo module yeiyo nhamba yawakasarudza inoratidzwa muchitokisi chawakasarudza.



7. Kana kukosha kuri patafura, iyo module formula inogona kutevedzera mamwe masero. Kuti uite izvi, iwe unofanirwa kuunza kutuka kwekona yepazasi kuruboshwe kwechitokisi, mune iyo iripo formula, clamp iyo bhatani bhatani uye uzvidzorere kusvika kumagumo etafura. Nekudaro, mumasero eiyi ikholamu pachave nekukosha kweiyo module yeiyo sosi data.

Izvo zvakakosha kuti uzive kuti vamwe vashandisi vanoedza kunyora module, sezvinoita tsika mumasvomhu, kureva | (nhamba) | , Semuyenzaniso | -48 | . Asi mumamiriro ezvinhu akadaro, chete chikanganiso chichaonekwa panzvimbo pemhinduro, sezvo Budiki haanzwisisi kudaro syntax.

Mukuverenga kweiyo module kubva kuhuwandu kuburikidza neyeMicrosoft Excel, hapana chinhu chakaoma, sezvo chiitiko ichi chinoitwa uchishandisa basa rakareruka. Iyo chete mamiriro ndeyekuti ichi chimiro chaunongoda kuziva.