Aiki tare da tsari a fice

Ofaya daga cikin manyan kayan aikin Microsoft Excel shine ikon yin aiki tare da dabaru. Wannan yana rage sauƙaƙe da haɓaka hanya don kirga sakamakon gama gari da nuna bayanan da ake buƙata. Bari mu gano yadda ake ƙirƙirar tsari da yadda ake aiki tare da su a cikin shirin.

Ingirƙiri Tsarin Tsara Are Excel

Mafi sauki dabara a cikin excele sune maganganun aikin lissafi tsakanin bayanai data cikin sel. Don ƙirƙirar tsari mai kama da wannan, da farko muna rubuta alamar daidaito a wannan tantanin, wanda aka yi niyya don cire sakamakon sakamakon ilimin lissafi. Ko zaka iya haskaka tantanin halitta, amma saka alamar daidaito a cikin kirjin dabara. Wadannan magudi suna da daidai kuma suna kwafi ta atomatik.

Sannan zaɓi takamaiman kwayar halitta tare da bayanai, kuma sanya alamar ilimin lissafi da ake so ("" - "-", "/", ", da sauransu). Irin waɗannan alamun ana kiransu masu aiki. Yanzu zaɓi Zaɓi mai zuwa kuma maimaita ayyukan a madadin har sai duk sel da ake buƙata suna da hannu. Bayan wannan furci ya shiga, latsa Shigar a kan keyboard don nuna lissafin.

Tallafin Excel

A ce muna da tebur wanda aka nuna adadin kayan da aka nuna, kuma farashin raka'o'insa. Muna buƙatar gano jimlar adadin darajar kowane samfurin. Ana iya yin wannan ta ninka yawan adadin akan farashin kaya.

1. Mun zabi tantanin halitta inda za'a nuna adadin, kuma a sa a can =. Bayan haka, muna haskaka tantanin halitta tare da adadin kayayyaki - hanyar haɗi zuwa gare ta nan da nan ta bayyana bayan alamar daidaici. Bayan daidaitawar tantanin halitta kuna buƙatar saka alamar lissafi. A cikin lamarinmu, zai zama alamar da yawa - *. Yanzu danna kan sel, inda aka sanya bayanai tare da farashin ɓangaren kaya. Tsarin lissafi ya shirya.



2. Don duba sakamakon sa, latsa Shigar.



3. Domin kada shigar da wannan dabara a duk lokacin da za su ƙididdige jimlar kowane sunan samfurin, ɗaukar siginar siginar tantanin halitta wanda sunan na Ubangiji kaya suna.



4. An lasafta tsarin da kuma jimlar kudin ta atomatik don kowane nau'in samfurin, gwargwadon bayanai akan adadinta da farashinsa.

Hakanan, zaku iya lissafin tsari a cikin ayyuka da yawa kuma tare da alamun lissafi daban-daban. A zahiri, dabarun fifaffi an tattara bisa ga ka'idodi guda ɗaya kan abin da ake yin misalan misalan ilimin lissafi na al'ada. Yana amfani da kusan daidaitaccen tsarin rubutu.

Kammala aikin, rarraba adadin kayayyaki a cikin tebur cikin bangarori biyu. Yanzu, don gano jimlar kuɗin, ya kamata ku fara ninka yawan ɓangarorin biyu na samfurin kuma sakamakon ya yawaita ta farashin. A ilmin lissafi, irin wannan lissafin ana yin ta amfani da baka, in ba haka ba farkon matakin za a ninka, wanda zai haifar da kirga lissafta. Muna amfani da su kuma mu warware aikin da ke Fiye.

1. Don haka, muna rubutu = a cikin tantanin farko na shafi "Adadin". Sannan mun bude bangar hannu, danna kwayar farko ta farko a cikin "1 Party" shafi na farko "pice +, danna kan kwalin farko a cikin" 2 tsari ". Bayan haka, muna rufe sashin ƙarfe kuma a saita *. Danna kan kwayar farko a cikin "farashin" - Don haka mun sami dabara.



2. Latsa Shigar don gano sakamakon.



3. Kamar dai lokacin ƙarshe, ta amfani da hanyar jan kwanon kwafa wannan tsari da sauran layuka na tebur.



4. Ya kamata a lura cewa ba lallai ba lallai ba ne duk waɗannan dabarun ya kamata a cikin sel maƙwabta ko a cikin iyakokin tebur ɗaya. Suna iya kasancewa cikin wani tebur ko ma a kan wani takardar daftarin takarda. Shirin har yanzu yana lissafta.

Amfani da Excel a matsayin mai kalkuleta

Kodayake babban aikin shirin shine yin lissafi a allunan, ana iya amfani dashi azaman kalkuleta mai sauƙi. Mun shiga alamar daidai kuma shigar da lambobin da ake so da kuma masu aiki a cikin kowane sel na takardar ko a cikin kirtani.

Don samun sakamakon, latsa Shigar.

Ma'aikatan asali na asali

Babban aikin lissafin da ake amfani da su a Microsoft Excel ya hada da masu zuwa:

• = ("Alamar daidaito") - daidai;
• + ("Da"): Bugu da kari;
• - ("debe") - ragewa;
• * ("Star") - ci gaba;
• / ("" Karkatar da halin ") - rarrabuwa;
• ^ ("Waka") - motsa jiki.

Microsoft Excel yana samar da cikakken kayan aikin mai amfani don yin aikin Arithmetic daban-daban. Ana iya yin su duka a cikin shirye-shiryen tebur da dabam don yin lissafin sakamakon wasu ayyukan Ariya.