Daya daga cikin mahimman abubuwan Microsoft Excel shine ikon yin aiki tare da tsari. Wannan yana sauƙaƙa sauƙaƙewa da haɓaka hanya don ƙididdige yawan sakamakon, da kuma nuna bayanan da ake so. Wannan kayan aiki nau'in sifa ne na aikace-aikacen. Bari mu ga yadda ake kirkirar tsari a Microsoft Excel, da kuma yadda za mu iya aiki tare da su.
Simpleirƙiri dabaru masu sauƙi
Hanyar mafi sauki a cikin Microsoft Excel sune maganganun ayyukan sarrafawa tsakanin bayanan da ke cikin sel. Don ƙirƙirar tsari mai kama, da farko, sanya alamar daidai a cikin tantanin halitta wanda yakamata ya nuna sakamakon ilmin lissafi. Ko zaka iya tsayawa akan tantanin kuma sanya alamar daidai a layin dabara. Waɗannan ayyuka daidai suke, ana daidaita su ta atomatik.
Sannan muna zaɓar wani tantanin halitta da aka cika tare da bayanai kuma mun sanya alamar ilimin da ake so ("+", "-", "*", "/", da sauransu). Wadannan alamun ana kiransu masu aiki dabaran. Zaɓi sel na gaba. Don haka maimaita har sai dukkanin ƙwayoyin da muke buƙata suna da hannu. Bayan an shigar da magana ta haka ne gaba ɗaya, don duba sakamakon lissafin, latsa maɓallin Shigar da maballin.
Misalai na lissafi
Da ace muna da tebur wanda aka nuna yawan kayan, da farashin sashi. Ya kamata mu san jimlar farashin kowane kaya na kaya. Ana iya yin wannan ta hanyar ninka yawan da farashin kaya. Mun zama siginan kwamfuta a cikin tantanin da yakamata a nuna jimlar, kuma sanya alamar daidai (=) a ciki. Bayan haka, zaɓi tantanin tare da adadin kayan. Kamar yadda kake gani, hanyar haɗi zuwa gareta tana bayyana nan da nan bayan alamar daidai. Bayan haka, bayan haɗin gwiwar tantanin halitta, kuna buƙatar saka alamar arithmetic. A wannan yanayin, zai zama alama ce mai ninka (*). Bayan haka, mun danna kan tantanin da aka sanya bayanai tare da farashin naúrar. Tsarin ilmin lissafi ya shirya.
Don duba sakamakonsa, danna maɓallin Shigar da maballin.
Domin kada ku shiga cikin wannan dabara kowane lokaci don lissafin jimlar kowane abu, kawai matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na kwayar tare da sakamakon, kuma ja shi zuwa duk yankin layin da sunan samfurin ke ciki.
Kamar yadda kake gani, an kwafa fom din, sannan aka kirkiri jimlar kudin ta atomatik ga kowane nau'in samfurin, gwargwadon yawan sa da farashin sa.
Haka kuma, mutum na iya yin lissafin dabaru a matakai da yawa, kuma tare da alamun ilmin lissafi daban-daban. A zahiri, ana yin amfani da dabarun Excel bisa ga ka'idoji iri ɗaya waɗanda ta hanyar misalai ilmin lissafi ake aikatawa a cikin lissafi. A wannan yanayin, ana amfani da kusan kalma ɗaya.
Mun wahalar da aikin ta hanyar rarraba adadin kayan da ke cikin teburin zuwa kashi biyu. Yanzu, don gano jimlar darajar, da farko muna buƙatar ƙara adadin abubuwan biyu, sannan mu ninka sakamakon ta farashin. A ilmin lissafi, ana yin irin waɗannan ayyuka ta amfani da baka, in ba haka ba za a yi ninka abubuwa azaman matakin farko, wanda zai kai ga ƙididdigar da ba daidai ba. Muna amfani da baka, kuma don magance wannan matsala a Excel.
Don haka, sanya alamar daidai (=) a cikin sel na farko na shafi "Sum". Daga nan sai muka bude satin, danna maballin farko a cikin rukunin "batari" 1, sanya alamar da (+), danna kan wayar ta farko a layin "2." Na gaba, rufe satin, kuma sanya alamar don ninka (*). Danna kan tantanin farko a cikin shafin "Farashin". Don haka mun sami tsari.
Latsa maɓallin Shigar don gano sakamakon.
Haka kuma lokacin ƙarshe, ta amfani da hanyar jawo da sauke, kwafa wannan dabarar don sauran layuka na tebur.
Ya kamata a lura cewa ba duk waɗannan dabbobin ba dole ne su kasance a cikin sel na kusa, ko a cikin tebur iri ɗaya. Zasu iya kasancewa cikin wani tebur, ko ma akan wani takaddar. Shirin har yanzu zaiyi lissafin sakamakon.
Kalkuleta
Kodayake, babban aikin Microsoft Excel shine yin lissafi a cikin alluna, amma za'a iya amfani da aikace-aikacen azaman mai sauƙin lissafi. Kawai sanya alamar daidai kuma shigar da ayyukan da ake so a cikin kowane tantanin halitta, ko kuma ana iya rubutu ayyukan a cikin masarar dabara.
Don samun sakamakon, danna maɓallin Shigar.
Bayani na Karshen Excel
Babban manajan lissafin da ake amfani da shi a Microsoft Excel sun haɗa da masu zuwa:
- = ("alamar daidai") - daidai yake da;
- + ("ƙari") - ƙari;
- - ("minus") - ragewa;
- ("alama") - ninka;
- / ("slash") - rarrabuwa;
- ("cirifon") - ƙararrawa.
Kamar yadda kake gani, Microsoft Excel yana ba da cikakken kayan aikin kayan aiki don mai amfani don yin ayyukan da yawa na ilmin lissafi. Ana iya aiwatar da waɗannan ayyuka duka lokacin da ake tattara teburin, kuma daban don ƙididdige sakamakon wasu ayyukan ilmin lissafi.
