Daya daga cikin siffofin Microsoft Excel shine ikon yin aiki tare da tsari. Wannan yana sauƙaƙe da saukaka hanya don ƙididdige adadin, kuma nuna bayanan da ake so. Wannan kayan aiki shi ne nau'i na musamman na aikace-aikacen. Bari mu kwatanta yadda za mu ƙirƙira da takaddun a cikin Microsoft Excel, da yadda za mu yi aiki tare da su.
Samar da hanyar da ta fi sauƙi
Mafi mahimman tsari a cikin Microsoft Excel shine maganganu don aiki na lissafi tsakanin bayanai dake cikin sel. Don ƙirƙirar irin wannan tsari, da farko, mun sanya alamar daidai a cikin tantanin halitta wanda ya kamata ya samar da sakamakon da aka samo daga aikin lissafi. Ko kuma za ku iya tsaya a tantanin tantanin halitta, kuma ku saka alamar daidai a cikin tsari. Wadannan ayyuka suna daidai kuma suna duplicated ta atomatik.
Sa'an nan kuma zaɓi wani sel wanda ya cika da bayanai, sa'annan ya sanya alamar lissafin da ake so ("+", "-", "*", "/", da dai sauransu). Wadannan alamun suna kiran masu aiki. Zaɓi cell ta gaba. Don haka muna maimaita har sai dukkanin kwayoyin da muke buƙata ba za su shiga ba. Bayan an gama cikakkiyar magana, don duba sakamakon sakamakon, latsa maɓallin shigarwa akan keyboard.
Misalan Kira
Yi la'akari da cewa muna da tebur wanda aka nuna yawan kayan kayayyaki, da farashin ɗayanta. Muna buƙatar sanin yawan kuɗin da kowanne abu yake. Ana iya yin wannan ta hanyar ninka yawan ta hanyar farashin kaya. Mu zama siginan kwamfuta a cikin tantanin halitta inda za'a nuna adadin, kuma sanya daidai alamar (=) a can. Sa gaba, zaɓi tantanin halitta tare da yawan kayan kaya. Kamar yadda kake gani, haɗin zuwa nan da nan ya bayyana bayan alamar daidai. Bayan haka, bayan bayanan tantanin tantanin halitta, kana buƙatar saka alamar lissafi. A wannan yanayin, zai zama alamar ƙaddamarwa (*). Kusa, danna kan tantanin halitta inda aka sanya bayanai tare da farashi a cikin ɗaya. Dabarar lissafi ya shirya.
Don duba sakamako, kawai danna maɓallin Shigar da ke keyboard.
Don kada a shigar da wannan tsari a kowane lokaci don lissafin farashin kuɗi na kowane abu, kawai kaɗa siginan kwamfuta a saman kusurwar dama na tantanin halitta tare da sakamakon, kuma ja shi a cikin dukan yankunan da aka kunshi sunan abu.
Kamar yadda kake gani, ana kwashe ma'anar, kuma an kiyasta kudin da aka ƙayyade akai-akai ga kowane nau'in samfurin, bisa ga bayanai akan yawanta da farashi.
Haka kuma, yana yiwuwa a lissafta samfurori a ayyuka da dama, kuma tare da alamomin alamomi daban-daban. A gaskiya ma, an tsara lissafin Excel bisa ga ka'idoji guda kamar misalai na lissafi na lissafi. A lokaci guda, kusan ana amfani dashi guda ɗaya.
Bari mu gwada aikin ta rarraba adadin kaya a cikin tebur a cikin guda biyu. Yanzu, don gano farashin kuɗi, muna buƙatar farko mu ƙara yawan kayan sufuri biyu, sannan mu ninka sakamakon ta farashin. A rubuce-rubuce, irin waɗannan ayyuka za a yi ta amfani da iyayengiji, in ba haka ba aikin farko zai kasance ƙaddamarwa, wanda zai haifar da ƙidayar ƙidayar. Muna amfani da shafuka, da kuma magance matsalar a Excel.
Saboda haka, mun sanya alamar daidai (=) a cikin tantanin farko na "Kudi" shafi. Sa'an nan kuma bude sashin takalmin, danna kan tantanin halitta na farko a cikin "1 tsari", sanya alamar alama (+), danna kan tantanin farko a cikin "2 tsari". Kusa, rufe shinge, kuma saita alamar ninki (*). Danna maɓallin farko a shafi "Farashin". Don haka mun sami wannan maƙala.
Danna maɓallin Shigar don gano sakamakon.
Hakazalika a ƙarshe, ta yin amfani da hanya mai jawo, za mu kwafa wannan ma'anar don sauran layuka na tebur.
Ya kamata a lura da cewa ba duk waɗannan ƙididdiga ba dole ne a kasance a cikin sel masu kusa, ko a cikin wannan tebur. Suna iya zama a wata tebur, ko ma a kan wani takarda na takardun. Shirin zai sake lissafta sakamakon.
Calculator
Kodayake, babban aikin Microsoft Excel shine lissafi a cikin tebur, amma ana iya amfani da aikace-aikace, kuma a matsayin mai sauƙi mai sauƙi. Kawai, mun sanya alamar daidai, kuma mun shigar da ayyuka masu dacewa a kowace tantanin halitta, ko za mu iya rubuta ayyukan a cikin tsari.
Don samun sakamako, danna kan Shigar da button.
Bayanan maɓallin Excel
Ma'aikatan lissafi masu mahimmanci waɗanda aka yi amfani da su cikin Microsoft Excel sun haɗa da waɗannan masu biyowa:
- = ("daidai daidai") - daidai;
- + ("da") - Bugu da ƙari;
- - ("minus") - raguwa;
- ("alama") - ninka;
- / ("slash") - rabuwa;
- ^ ("circumflex") - bayyanawa.
Kamar yadda kake gani, Microsoft Excel tana samar da kayan aiki na cikakke don mai amfani don yin ayyukan aiki da yawa. Wadannan ayyuka za a iya yin duka a cikin shirye-shirye na tebur kuma dabam don lissafta sakamakon wasu ayyukan lissafi.
