How kuverenga module muna Excel

Kushanda mu "Eksele", unogona kuita mabasa akawanda akasiyana, kusanganisira akarongeka. A-siyana-software maturusi unokubvumira kubudisa yaidiwa zviito regai zvinoda okuwedzera software. Chimwe chinhu ndehwevakadai chikwata - muna Excel, rinoshandiswa zvishoma kakawanda, asi ane chinangwa chinokosha.

Chii chinonzi module

By tsanangudzo, kuti module - ndiwo kwemasvomhu oparesheni kuti anodzoka zvachose kukosha nhamba, kureva nhamba pacharo pasina chiratidzo chacho. Pasinei dzakananga kushandiswa module kunogona kuonekwa kwete chete kugadzirisa matambudziko akarongeka, asiwo zvoupfumi yokutevedzera, wefizikisi sayenzi nezvimwe zvakawanda.

How kuverenga module "Eksele"?

Kuti vazive module muna Excel, unogona kushandisa nenzira dzakawanda, nyore iyo ndiyo ABS ishande. It anodzoka mhedziso kukosha nhamba vakasarudzwa kana kwemasvomhu mashoko.

The nemarongerwo mashandiro module iri nyore chaizvo - mu "Eksele" rakakwana zvakanyatsonanga mune nzira bhaa "= ABS", uye ipapo muzvikomberedzo inoratidza nharo, zvinogona kuva nhamba, foni reference, uyewo basa kuti anodzoka munhu Numeric ukoshi. Uyewo oparesheni ichi chinogona kuitwa ne nekudzvanya kuti "Insert Rinoshanda", iro sarudza yakakodzera chisarudzo, kana nokutsvaka nokupinda shoko "module" kana "ABS".

Pakuverenga uwandu modules

Chimwe ndicho akavhiyiwa kuti Excel - Verengai modulo. Kunoitawo kuti kuwedzera zvinokosheswa masero pasina chokuita chiratidzo chavo. Kubereka izvi haisi kunodiwa kuverenga kutanga nhamba mumwe module, uye ipapo kushandisa mashandiro Verengai.

Kana achiita kuvhiyiwa chokuita multiple tsika mu Excel module anogona kushanda panguva imwe chete yakatarwa kana chikuva nemasero. Saka, kuverenga Verengai modulo zvakakwana kushandisa zvinotevera mubvunzo mamiriro:

= Verengai (ABS (A1: A4))

Kuno mbiru A mana mitsetse okutanga ane tsika yawakashandira kuda kubereka modulo.

mienzaniso

Kusimbisa kunzwisisa module rondedzero iri Excel uye sei akunoita, zvakakodzera kufunga vaviri mienzaniso nyore anoratidza mashandiro.

Nokuti kukarukureta chikwata akafanorongerwa nhamba kana kwemasvomhu muenzaniso Somuenzaniso, musiyano 2, uye 5, shandisa anotevera kupinda:

= ABS (2-5)

Mugumisiro mubvunzo iyi nhamba "3".

Kana kunodiwa kuverenga kuwanda modules ose chizvaro zvinhu vane tsika yakanyorwa tafura, pamwe kuwanda A1: C3, kuti uchitsanya nzira kuwana mhinduro iri design:

= Verengai (ABS (A1: C3))