Kupeza Mtengo Wopambana ndi Ntchito YOYENERA ya Excel

Gwiritsani ntchito NTCHITO YOPHUNZITSIRA kuti mupeze masamu omwe amatanthauza manambala a manambala

Masamu, pali njira zingapo zowunikira chizoloŵezi chachikulu kapena, monga momwe zimatchulira kawirikawiri, chiwerengero cha zikhalidwe. Njira izi zikuphatikizapo masamu amatanthawuza , wamkati , ndi machitidwe .

Kawirikawiri chiwerengero cha chizoloŵezi chapakati ndi mathemati amatanthawuza - kapena osawerengeka owerengeka - ndipo amawerengedwa powonjezera chiwerengero cha ziwerengero palimodzi ndikugawanika ndi chiŵerengero cha nambala imeneyo. Mwachitsanzo, pafupifupi 2, 3, 3, 5, 7, ndi 10 ali 30 ogawanika ndi 6, omwe ali asanu.

Kuti zikhale zosavuta kuyeza chizoloŵezi chapakati, Excel ili ndi ntchito zingapo zomwe zikhoza kuwerengera zomwe zimagwiritsidwa ntchito kwambiri. Izi zikuphatikizapo:

• Ntchito YOPHUNZITSIRA - imapeza chiwerengero cha masamu kumatanthauza mndandanda wa nambala
• Ntchito ya MEDIAN - imapeza mtengo wapakati kapena pakati pakati pa manambala
• Ntchito ya MODE - imapeza njira kapena zochitika zomwe zimachitika kawirikawiri pamndandanda wa manambala

Syntax ndi Maganizo Ogwira Ntchito

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Mawu omasulira a NTCHITO ntchito ndi:

= GAWO (Number1, Number2, ... Number255)

• Namba1 - (yofunika) deta yoti ikhale yofanana ndi ntchitoyo.
• Number2 to Number 255 - (zosankha) zina zowonjezera ma deta zikhale zofanana. Chiwerengero chazomwe chiloledwa chikuloledwa ndi 255.

Mtsutso uwu ukhoza kukhala:

• Mndandanda wa manambala omwe angakhalepo;
• Maumboni a magulu kumalo a deta mu worksheet;
• Mafotokozedwe osiyanasiyana a selo;
• Dzina lotchulidwa.

Kupeza NTCHITO YA Ntchito

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yamphumphu , monga = MAGAZINI (C1: C7) mu selo lamasewera;
2. Kulowa ntchito ndi ndemanga pogwiritsa ntchito bokosi lazokambirana ;
3. Kulowa ntchito ndi zifukwa pogwiritsa ntchito njira yachidule ya ntchito ya Excel.

YAM'MBUYO YOTSATIRA Ntchito

Excel ili ndi njira yowonjezera yolowera ntchito YAM'MBUYO - nthawi zina imatchedwa AutoAverage chifukwa choyanjana ndi chidziwitso chodziwika bwino cha AutoSum - chomwe chili pa Tsamba la Home la Riboni .

Chithunzi pa toolbar cha izi ndi ntchito zina zambiri zotchuka ndi kalata yachi Greek Sigma ( Σ ). Mwachinsinsi, ntchito ya AutoSum ikuwonetsedwa pafupi ndi chizindikiro.

Gawo lachidziwitso limatanthawuza kuti pamene atalowetsedwa pogwiritsa ntchito njirayi, ntchitoyi imasankha zomwe zimakhulupirira kuti maselo ambiri amatha kufotokozedwa ndi ntchitoyo.

Kupeza Average ndi AutoAverage

1. Dinani pa selo C8 - malo omwe zotsatira za ntchito zikuwonetsedwa;
2. Monga momwe tawonera pa chithunzi pamwambapa, kokha C7 khungu iyenera kusankhidwa ndi ntchito - chifukwa chakuti selo C6 liribe kanthu;
3. Sankhani zamtundu woyenera pa ntchito C1 mpaka C7 ;
4. Lembani fungulo lolowamo lolowera ku makina kuti mulandire ntchitoyo;
5. Yankho 13.4 liyenera kuoneka mu selo C8.

Excel KUGWIRITSIDWA NTCHITO CHITSANZO Chitsanzo

Masitepe omwe ali m'munsiwa akuthandizira momwe mungaloweretse ntchito YAM'MBUYO YOTSATIRA yomwe ikuwonetsedwa mu mzere wachinayi mu chitsanzo pa chithunzi pamwambapa pogwiritsa ntchito njira yopita ku NTCHITO imene tatchula pamwambapa.

Kulowa Ntchito YOTSATIRA

1. Dinani pa selo D4 - malo omwe zotsatira zake zidzasonyezedwe;
2. Dinani pa tabu la Home la riboni
3. Dinani pamsana wotsika pambali pa batani la AutoSum pa riboni kuti mutsegule mndandanda wa ntchito
4. Dinani pa mawu Average pakati pa mndandanda kuti alowe mu CHIYAMBI ntchito mu selo D4
5. Dinani pazithunzi za Ntchito pa toolbar pamwamba pa kutsegula mndandanda wa ntchito;
6. Sankhani Avereji kuchokera pa mndandanda kuti muikepo kopanda kanthu kopanda kanthu mu selo D4;
7. Mwachinsinsi, ntchitoyo imasankha nambala mu selo D4;
8. Sinthani izi powonetsera maselo A4 mpaka C4 kuti mulowetse maumboniwa ngati zifukwa za ntchitoyi ndi kukanikiza fungulo lolowamo ku kibokosi;
9. Nambala 10 iyenera kuoneka mu selo D4. Ichi ndi chiwerengero cha nambala zitatu - 4, 20, ndi 6;
10. Mukasindikiza pa selo A8 ntchito yonse = AVERAGE (A4: C4) ikuwonekera pa bar barolomu pamwamba pa tsamba.

Kumbukirani mfundo izi:

• Maselo aumwini, m'malo mokhalapo mosalekeza akhoza kuwonjezeredwa ngati zotsutsana koma selo lililonse liyenera kukhala losiyana ndi chida.

• Mauthenga ndi mauthenga omwe ali ndi ma Boolean (TRUE kapena FALSE) ndi maselo omwe alibe kanthu amanyalanyazidwa ndi ntchito monga ikusonyezedwa m'mizere 6, 8 ndi 9 pamwambapa.

• Pambuyo polowera ntchitoyo, ngati kusintha kumapangidwira ku deta mu maselo osankhidwa, ntchitoyo, mwachisawawa, imangobwerezanso kuti iwonetse kusintha.

Momwe Okhazikitsa Okha Amasankhira Njira Yotsutsana

• Mtundu wosasinthika umaphatikizapo maselo omwe ali ndi manambala, mawerengedwe osankhidwa amasokonezedwa ndi selo liri ndi mawu kapena selo lopanda kanthu.
• Ntchito YAPAVERAGE yapangidwa kuti ikhale pansi pamtundu wa deta kapena kumapeto kwa deta. Zikuwoneka choyamba kuti chiwerengero cha nambala pamwamba ndiyeno kumanzere.
• Popeza kuti NTCHITO yowonjezera ili, kwenikweni, kulingalira pazomwe zimasankhidwa ndi ndemanga ya Nambala, kusankhidwa kumeneku kuyenera kuyang'aniridwa kuti mukhale wolondola musanatsegule fungulo lolowani mukhiyi kuti mukwaniritse ntchitoyo.

Maselo osajambulidwa ndi Zero

Pokhudzana ndi kupeza mtengo wambiri mu Excel, pali kusiyana pakati pa zopanda kanthu kapena maselo opanda kanthu ndi omwe ali ndi chiwerengero cha zero.

Maselo osajambulidwa amanyalanyazidwa ndi NTCHITO YOPHUNZITSIRA, yomwe ingakhale yopindulitsa kwambiri chifukwa imapeza kuti maselo osagwirizana a deta ndi ovuta kwambiri monga momwe akuwonedwera mzere 6 pamwambapa.

Maselo okhala ndi chiwerengero cha zero, komabe, akuphatikizidwa pafupipafupi monga momwe tawonedwera mzere 7.

Kuwonetsa Zosos

Mwachinsinsi, Excel imawonetsa zero m'maselo okhala ndi chiwerengero cha zero - monga zotsatira za mawerengedwe, koma ngati njirayi itsekedwa, maselo oterewa amasiyidwa opanda kanthu, komabe akuphatikizidwa mu mawerengedwe apakati.

Kuti musankhe njirayi:

1. Dinani pa Fayilo ya tabu ya riboni kuti muwonetse mafayilo a menyu;
2. Dinani Zosankha mu mndandanda kuti mutsegule Zokambirana za Excel Zokambirana .
3. Dinani pa Zomwe Zadasankhidwa kumanja lamanzere la bokosi kuti muwone njira zomwe zilipo.
4. Muzanja lamanja, muzithunzi Zosonyeza gawoli la gawo lothandizira pezani bokosi la Kuwonetsera zero mu maselo omwe ali ndi zero mtengo checkbox.
5. Kuwonetsera zero (0) mu maselo kuonetsetsa kuti Onetsani zero m'maselo omwe ali ndi zero mtengo checkbox amasankhidwa.