Yayin aiki a Microsoft Excel, sau da yawa kuna buƙatar murƙushe jimlar a cikin ginshiƙai da layuka na allunan, kuma kawai ƙayyade jimlar adadin sel. Shirin yana samar da kayan aikin da yawa don magance wannan batun. Bari mu ga yadda ake tara sel a Excel.
AutoSum
Mafi shahararrun kayan aiki mai sauƙin amfani don ƙayyade adadin bayanai a sel a cikin Microsoft Excel shine avtosum.
Don yin lissafin adadin ta wannan hanyar, mun danna kan sashin ƙarshe na ƙarshe na shafi ko layi, kuma, kasancewa a cikin "Gidan" shafin, danna maɓallin "AutoSum".
Shirin yana nuna tsarin a cikin tantanin halitta.
Don ganin sakamakon, kuna buƙatar latsa maɓallin Shigar da ke kan maballin.
Ana iya yin shi kaɗan daban. Idan muna son kara sel ba duka na layin ko shafi ba, amma kawai wani takaddama, to sai ka zabi wannan zangon. Sannan mun danna maballin "Autosum" wanda muka saba da shi.
Sakamakon yana bayyana nan da nan akan allon.
Babban hasara na yin lissafi tare da taimakon tara kudi shi ne cewa yana ba ka damar lissafin jerin jerin bayanan data kasance a jere guda ko shafi. Amma tsararren bayanai dake cikin ginshikan da layuka da yawa ba za'a iya kirga ta wannan hanyar ba. Haka kuma, tare da taimakonsa bashi yiwuwa a kirga adadin adadin sel da yayi nesa da juna.
Misali, mun zabi kewayon sel, kuma danna maɓallin "AutoSum".
Amma ba jimlar duk waɗannan sel aka nuna akan allon ba, amma adadin kuɗi na kowane shafi ko layi daban.
Aikin SUM
Don duba jimlar komai, ko tarin bayanai, aikin "SUM" yana cikin Microsoft Excel.
Zaɓi tantanin da muke so adadin da za a nuna. Danna maɓallin "Saka aikin" da ke gefen hagu na masarar dabara.
Ana buɗe mai kunna Wurin Aiki. A cikin jerin ayyuka muna neman aikin "SUM". Zaɓi shi, kuma danna maɓallin "Ok".
A cikin bude taga abubuwan muhawara, shigar da daidaitawar sel, jimlar abin da za mu lissafta. Tabbas, shigar da hannu a cikin daidaitawar ba shi da matsala, don haka danna maballin da yake gefen dama na filin shigarwa.
Bayan haka, an rage girman aikin muhawara, kuma za mu iya zaban waɗancan sel ko jerin ƙwayoyin waɗanda adadin kuɗinmu da muke son lissafta. Bayan an zaɓi tsararru, kuma adireshin sa ya bayyana a filin musamman, danna maɓallin zuwa dama na wannan filin.
Mun sake komawa zuwa taga muhawara na aiki. Idan kana buƙatar ƙara wani tsararren bayanai zuwa jimlar, to muna maimaita waɗannan ayyukan da aka ambata a sama, amma a fagen tare da sigogi "Number 2". Idan ya cancanta, ta wannan hanyar zaka iya shigar da adreshin kwatancen marasa izini da yawa. Bayan an shigar da dukkan muhawara na aikin, danna maɓallin "Ok".
Bayan haka, a cikin tantanin da muka sanya sakamakon sakamakon, jimlar bayanan dukkan sel da aka nuna za a nuna su.
Yin amfani da dabara
Hakanan za'a iya kirga yawan adadin bayanan a sel a Microsoft Excel ta amfani da mafi sauki tsari. Don yin wannan, zaɓi tantanin da yakamata ya kamata ya kasance, sa'annan sanya alamar "=" a ciki. Bayan haka, mun danna kowane sel, ɗayan waɗanda kuke buƙatar lissafin jimlar abubuwan ƙididdigar. Bayan an shigar da adireshin tantanin a cikin masarar dabara, shigar da alamar "+" daga maballin, don haka bayan shigar da daidaitawar kowane tantanin halitta.
Lokacin da aka shigar da adreshin ƙwayoyin sel, danna maɓallin Shigar da maballin. Bayan haka, jimlar bayanan da aka shigar ana nuna su a cikin tantanin da aka nuna.
Babban hasara ta wannan hanyar ita ce cewa adireshin kowane tantanin halitta dole ne a shigar dashi daban, kuma ba zaku iya zavi dumbin sel ba kai tsaye.
Duba kuɗi a Microsoft Excel
Hakanan, a cikin Microsoft Excel, zaka iya duba jimlar sel da aka zaɓa ba tare da nuna wannan adadin ba a cikin wani sel daban. Iyakar abin da ake so shi ne cewa duk ƙwayoyin, jimlar abin da ya kamata a lissafta, dole ne su kasance kusa, cikin tsararru ɗaya.
Kawai zaɓi kewayon ƙwayoyin, jimlar bayanan abin da kuke buƙatar ganowa, kuma duba sakamakon a cikin matsayin matsayin Microsoft Excel.
Kamar yadda kake gani, akwai hanyoyi da yawa don takaita bayanai a Microsoft Excel. Kowane ɗayan waɗannan hanyoyin suna da matakan nasa da rikitarwa. A matsayinka na mai mulkin, mafi sauƙin zaɓi, mara sauƙin sassauƙa. Misali, lokacinda kake tantance adadin ta amfani da tamanin gwaji, zaka iya aiki ne akan bayanan da aka tsara a jere. Sabili da haka, a kowane yanayi takamaiman, mai amfani dole ne ya yanke shawara wacce hanya ce ta fi dacewa.
