Kuwerengeredwa kwa kupatuka kwapadera mu Microsoft Excel

Chimodzi mwazida zazikulu zowerengera anthu ndikuwerengera kupatuka kwazomwe zikuchitika. Chizindikiro ichi chimakupatsani mwayi kuti muyerekeze kupatuka kwachitsanzo kapena kwa anthu onse. Tiyeni tiphunzire momwe mungagwiritsire ntchito kakhalidwe kakang'ono ka kupatuka kwa Excel.

Kudziwitsa kupatuka kwakanthawi

Tidzazindikira nthawi yomweyo kupatuka komanso momwe mawonekedwe ake amawonekera. Mtengo uwu ndi muzu wokulirapo wa masamu kutanthauza za mabwalo amasiyana azikhalidwe zonse za mndandanda ndi tanthauzo lawo la masamu. Pali dzina lofanana ndi chizindikiro ichi - kupatuka kwofananira. Mayina onsewa ndi ofanana kwathunthu.

Koma, mwachilengedwe, ku Excel, wogwiritsa ntchito sayenera kuwerengera izi, popeza pulogalamuyo imamuchitira zonse. Tiyeni tiwone momwe angawerengere kupatuka kwapadera ku Excel.

Kuwerengera ku Excel

Mutha kuwerengera mtengo womwe mwatchulidwa mu Excel pogwiritsa ntchito ntchito zapadera ziwiri. STANDOTLON.V (mwa zitsanzo) ndi STANDOTLON.G (mwa anthu onse). Mfundo pazomwe akuchita ndi chimodzimodzi, koma mutha kuwaimbira njira zitatu, zomwe tikambirana pansipa.

Njira 1: Wizard wa Ntchito

1. Sankhani khungu pa pepala momwe zotsatira zomalizidwa ziwonetsedwa. Dinani batani "Ikani ntchito"ili kumanzere kwa mzere wa ntchito.



2. Pa mndandanda womwe umatsegulira, yang'anani kulowamo STANDOTLON.V kapena STANDOTLON.G. Palinso ntchito mndandanda STD, koma idatsalira pamitundu yapa Excel pazolinga zofananira. Nyimbozo zikasankhidwa, dinani batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imatsegulidwa. Mugawo lirilonse, lowetsani kuchuluka kwa anthu. Ngati manambala ali m'maselo a pepalalo, ndiye kuti mutha kutchula mgwirizanowu wa maselo kapena kungodina. Ma adilesi adzawonetsedwa nthawi yomweyo m'magawo omwe akugwirizana. Pambuyo manambala onse a anthu atalowa, dinani batani "Zabwino".



4. Zotsatira zowerengera zikuwonetsedwa mu foni yomwe idawonetsedwa koyambirira kwa ndondomeko yopezera kupatuka kwodziyimira.

Njira 2: Tab

Mutha kuwerengetsanso mtengo wokhotakhota kudzera pa tabu Mawonekedwe.

1. Sankhani khungu kuti muwonetse zotsatira ndikupita pa tabu Mawonekedwe.



2. Mu bokosi la zida Laibulale ya Feature dinani batani "Ntchito zina". Kuchokera pamndandanda womwe umawonekera, sankhani "Zowerengera". Pazosankha zotsatirazi, timasankha pakati pazofunikira STANDOTLON.V kapena STANDOTLON.G kutengera mtundu kapena kuchuluka kwa anthu amatenga nawo mbali powerengera.



3. Pambuyo pake, zenera zotsutsana zimayamba. Zochita zina zonse ziyenera kuchitidwa monga momwe zimakhalira poyamba.

Njira 3: ikani pamanja formula

Palinso njira yomwe simukuyenera kuyitanitsa iwowo pazenera. Kuti muchite izi, ikani mawonekedwe pamanja.

1. Sankhani foni kuti muwonetse zotsatira ndikulembamo kapena mu kakhwalidwe kazomwe mwatsatanetsatane motengera:

   = STANDOTLON.G (nambala1 (cell_address1); nambala2 (cell_address2); ...)
   kapena
   = STDB.V (nambala1 (cell_address1); nambala2 (cell_address2); ...).

   Pazonse, mpaka 255 malingaliro akhoza kulembedwa ngati pakufunika.



2. Kujambulako kukamaliza, dinani batani Lowani pa kiyibodi.

Phunziro: Kugwira ntchito ndi mafomu ku Excel

Monga mukuwonera, makina a kuwerengera kupatuka kwapadera mu Excel ndikosavuta kwambiri. Wogwiritsa amangofunika kulowetsa manambala kuchokera ku kuchuluka kwa anthu kapena kulumikizana ndi maselo omwe ali nazo. Kuwerengera konse kumachitika ndi pulogalamu yomweyi. Ndizovuta kwambiri kuzindikira kuti chawerengedwa ndi chiyani ndikuwunika momwe angawerengere. Koma kumvetsetsa izi kumakhudzana kale ndi gawo la ziwerengero kuposa kuphunzitsa mu mapulogalamu.