Mmene Mungowonjezere Ma Columns kapena Mizere ya Numeri ku Open Office Calc

01 a 02

Ntchito Yoyenera Yopangira Ntchito SUM

Kuwonjezera mzere kapena mizere yazithunzi ndi chimodzi mwa ntchito zomwe zimachitika m'mapulogalamu a spreadsheet monga OpenOffice Calc. Kuti zikhale zosavuta kukwaniritsa ntchitoyi, Calc imaphatikizapo zomangidwa mu ndondomeko yotchedwa ntchito SUM.

Njira ziwiri zolowera ntchitoyi ndizo:

1. Pogwiritsa ntchito batani lachidule la ntchito SUM - ndilo kalata yachigiriki ya Sigma (Σ) yomwe ili pafupi ndi mzere wolembera (monga bar bar in Excel).
2. Kuwonjezera ntchito ya SUM ku tsamba lolemba ntchito pogwiritsa ntchito bokosi la dialog box. Bokosi la funsolo likhoza kutsegulidwa mwa kuwonekera pa batani la Function Wizard yomwe ili pafupi ndi batani la Sigma pazotsatira.

Njira Zowonjezera ndi Bokosi la Dialog

Ubwino wogwiritsa ntchito batani la Sigma kulowa ntchito ndikuti ndiwophweka komanso kosavuta kugwiritsa ntchito. Ngati chiwerengerochi chifotokozedwe mwachidule chimagwirizanitsidwa palimodzi, ntchitoyi idzasankha mtundu wanu.

Ubwino wogwiritsira ntchito ntchito ya bokosi la SUM ndiloti deta iyenera kufotokozedwa ikufalikira pamaselo angapo osagwirizana. Kugwiritsira ntchito bokosilo muzochitikazi kumapangitsa kuti kukhale kosavuta kuwonjezera maselo payekha kuntchito.

Syntax ndi Ntchito Zokambirana za SUM

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya SUM ndi:

= SUM (nambala 1; nambala 2; ... nambala 30)

nambala 1; nambala 2; ... nambala 30 - deta yoti iwonetsedwe ndi ntchitoyi. Maganizo angakhale nawo:

• mndandanda wa ziwerengero zomwe ziyenera kufotokozedwa
• mndandanda wa mafotokozedwe a maselo omwe akusonyeza malo a deta mu tsamba la ntchito
• malingaliro osiyanasiyana a selo kumalo a deta

Dziwani : chiwerengero chapamwamba cha 30 chikhoza kuwonjezeredwa ndi ntchito.

Zomwe Ntchito YAMASI Ikusamalidwa

Ntchitoyo imanyalanyaza zopanda pake maselo ndi mauthenga olemba pamasewera omwe asankhidwa - kuphatikizapo manambala omwe afotokozedwa ngati malemba.

Mwachinsinsi, mauthenga a malemba ku Calc amasiyidwa mu selo - monga momwe akuwonetsera ndi nambala 160 mu selo A2 mu chithunzi pamwambapa - deta ya chiwerengero imagwirizana kumanja mwachisawawa.

Ngati deta yamtundu wotereyo ikasinthidwa kuti ikhale nambala ya chiwerengero kapena manambala akuwonjezeka ku maselo osalongosoka mumtunduwu, ntchito yonse ya SUM imangosintha kuti ikhale ndi deta yatsopano.

Kulowetsa Mwadongosolo Ntchito Yaka

Komabe njira ina yolowera ntchitoyi ndiyo kuyipaka mu selo lamasewera. Ngati mafotokozedwe a selo kuti awonetsedwe pamtunduwu adziwika, ntchitoyo ingatheke mosavuta. Kwa chitsanzo mu chithunzi pamwambapa, kulemba

= SUM (A1: A6)

kulowa mu selo A7 ndikukankhira muzipinda zolowera mu makiyi kuti akwaniritse zotsatira zomwezo monga ndondomeko ili m'munsiyi kuti mugwiritse ntchito batani la SUM njira.

Kusanthula Deta ndi Bulu la SUM

Kwa iwo amene amasankha mbewa ku kibokosi, bulu la SUM ndi njira yofulumira komanso yosavuta yolowera ntchito ya SUM.

Mukalowa mu fashoniyi, ntchitoyi imayesa kudziwa kuti maselo angaphatikizidwe ndi ma dera omwe akuzungulira ndipo amalowa mwachindunji monga kukangana kwa nambala .

Ntchitoyi imangosanthula deta ya chiwerengero yomwe ili pamndandanda pamwamba kapena m'mizere kumanzere kwa selo yogwira ntchito ndipo imanyalanyaza malemba ndi osalumikiza maselo.

M'munsimu muli ndondomeko zomwe zimagwiritsidwa ntchito kulowa ntchito SUM mu selo A7 monga momwe taonera pa chithunzi pamwambapa.

1. Dinani pa selo A7 kuti mupange selo yogwira ntchito - malo omwe zotsatira za ntchitoyi zidzawonetsedwa
2. Pewani batani la SUM pafupi ndi mzere wolembera - monga momwe chikuwonetsedwera pamwambapa
3. Ntchito ya SUM iyenera kulowa mu selo yogwira ntchito - ntchitoyi iyenera kulowa mu selo loyang'ana A6 ngati nthano ya chiwerengero
4. Kusintha mafotokozedwe a selo ogwiritsidwa ntchito pa nambala ya nambala , gwiritsani ntchito ndondomeko ya ndondomeko kuti muwonetse mndandanda wa A1 mpaka A6
5. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo
6. Yankho 417 liyenera kuwonetsedwa mu selo A7
7. Mukasindikiza pa selo A7, ntchito yonse = SUM (A1: A6) ikuwoneka mu mzere wolembera pamwamba pa tsamba

02 a 02

Onjezerani Numeri Pogwiritsa Ntchito SUM ya Ntchito Yopangira Bokosi

Deta Yophatikizira ndi Bokosi la Kugwiritsa Ntchito SUM

Monga tanenera, njira ina yolowera mu ntchito ya SUM ndiyo kugwiritsa ntchito bokosi la zokambirana, limene lingatsegulidwe mwina ndi:

• ndikudalira pakani ya Function Wizard pamzere wolowera pamwamba pa tsamba.
• kukanikiza makiyi a Ctrl + F2 pa kibokosilo

Bokosi la Zokambirana

Ubwino wogwiritsa ntchito bokosilo ndi awa:

1. Bukhuli limasamalira mawu ogwira ntchito - kuti zikhale zosavuta kuti alowe mmaganizo a ntchito imodzi pokha popanda kulowetsa chizindikiro chofanana, mabakita, kapena ma simicolons omwe amachititsa kukhala olekanitsa pakati pa zotsutsana.
2. Pamene deta ikulumikiziridwa sichipezeka m'magulu osiyana siyana, mafotokozedwe a selo, A1, A3, ndi B2: B3 akhoza kutsekedwa mosavuta ngati zifukwa zosiyana siyana mu bokosilo pogwiritsa ntchito kuwonetsera - zomwe zikuphatikizapo kudalira maselo osankhidwa ndi mimba mmalo mozilemba izo. Sikuti kungowonongeka kosavuta, kumathandizanso kuchepetsa zolakwika m'mafomu omwe amachitidwa ndi maumboni olakwika a selo.

Chitsanzo cha Ntchito YOMWE

M'munsimu muli ndondomeko zomwe zimagwiritsidwa ntchito kulowa ntchito SUM mu selo A7 monga momwe taonera pa chithunzi pamwambapa. Malangizowa amagwiritsa ntchito bokosi la ntchito la SUM kuti adziwe mfundo zomwe zili mu maselo A1, A3, A6, B2, ndi B3 monga zifukwa za chiwerengero cha ntchitoyo.

1. Dinani pa selo A7 kuti mupange selo yogwira ntchito - malo omwe zotsatira za ntchitoyi zidzawonetsedwa
2. Dinani pazithunzi za Function Wizard pafupi ndi mzere wolowera (monga bar bar in Excel) kuti mubweretse bokosi la bokosi la Ntchito
3. Dinani ku List list low-list ndipo sankhani Mathematical kuona mndandanda wa masamu ntchito
4. Sankhani SUM kuchokera mndandanda wa ntchito
5. Dinani Zotsatira
6. Dinani pa nambala 1 mu bokosi la bokosi ngati kuli kofunikira
7. Dinani pa selo A1 patsiku la ntchito kuti mulowetse selololo mu bokosi la dialog
8. Dinani pa nambala 2 mu bokosi la bokosi
9. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse selolo
10. Dinani pa nambala 3 mu bokosi la bokosi
11. Dinani pa selo A6 mu tsamba lothandizira kuti mulowetse selolo
12. Dinani pa nambala 4 mu bokosi la bokosi
13. Onetsetsani maselo B2: B3 mu tsamba lothandizira kuti mulowe muyeso ili
14. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito
15. Chiwerengero cha 695 chiyenera kuoneka mu selo A7 - chifukwa ichi ndi chiwerengero cha manambala omwe ali m'maselo A1 mpaka B3
16. Mukasindikiza pa selo A7 ntchito yonse = SUM (A1; A3; A6; B2: B3) ikuwoneka pamzere wolembera pamwamba pa tsamba