Daga cikin ayyuka da yawa da aka yi amfani da shi na Microsoft Excel na iya yin, ba shakka, akwai kuma ƙaddamarwa. Amma, da rashin alheri, ba duk masu amfani ba zasu iya amfani da wannan dama ba daidai ba. Bari mu kwatanta yadda za a aiwatar da hanyar ƙaddamarwa a cikin Microsoft Excel.
Ka'idojin ƙaddamarwa a Excel
Kamar kowane aikin ilimin lissafi a Excel, ana yin amfani da ƙayyadaddun tsari ta musamman. An rubuta ayyuka masu yawa tare da alamar - "*".
Ƙara yawan lambobin waya
Ana iya amfani da Microsoft Excel a matsayin maƙirata kuma kawai ninka lambobi daban-daban a ciki.
Don ninka lambar ɗaya ta wani, mun shiga cikin kowane tantanin halitta a kan takardar, ko a cikin layin layi, alamar ita ce (=). Kusa, saka asalin farko (lamba). Sa'an nan kuma, mun sanya alamar ta ninka (*). Sa'an nan, rubuta na biyu factor (lambar). Ta haka ne, tsari mai yawa zai kasance kamar wannan: "= (lambar) * (lambar)".
Misali ya nuna yawancin 564 da 25. An rubuta aikin ne ta hanyar dabara ta biyowa: "=564*25".
Don duba sakamakon lissafi, kana buƙatar danna maballin Shigar.
A lokacin lissafi, kana buƙatar ka tuna cewa fifiko na aiki na asali a cikin Excel, daidai yake da ilimin lissafi. Amma, alamar ƙaddamarwa tana buƙatar ƙarawa a kowace harka. Idan, a lokacin rubuta rubutu a kan takarda, an yarda da shi ya cire alamar ƙaddamarwa a gaban iyaye, sa'an nan kuma a Excel, don ƙididdiga daidai, an buƙata. Alal misali, bayanin 45 + 12 (2 + 4), a Excel, kana buƙatar rubuta kamar haka: "=45+12*(2+4)".
Ƙara yawan salula ta hanyar salula
Hanyar ƙara yawan tantanin halitta ta hanyar salula yana rage duk abin da yake daidai da hanya na ninka lambar ta lamba. Da farko, kuna buƙatar yanke shawara game da tantanin sakamakon tantanin halitta za a nuna. A cikinta mun sanya alamar daidai (=). Next, alternately click a kan sel wanda abun ciki bukatar a ninka. Bayan zabar kowane tantanin halitta, sanya alamar ƙaddamarwa (*).
Rage shafi ta shafi
Domin yada mahallin shafi ta hanyar shafi, dole ne ka buƙaci ninka yawan ƙananan ginshiƙan waɗannan ginshiƙai, kamar yadda aka nuna a misalin da ke sama. Bayan haka, zamu kasance a saman kusurwar hagu na tantanin halitta. Alamar cika alama ta bayyana. Jawo shi tare da maballin linzamin kwamfuta na hagu danna. Saboda haka, ana yin kwafin takaddama akan dukkanin sel a cikin wani shafi.
Bayan haka, za a ninka ginshiƙan.
Hakazalika, zaku iya ninka ginshiƙai uku ko fiye.
Ƙara yawan salula ta lamba
Don ƙara ninka tantanin halitta ta hanyar lamba, kamar yadda a cikin misalan da aka bayyana a sama, da farko, sanya daidai alamar (=) a cikin tantanin salula inda kake son fitowa da amsar lissafi. Na gaba, kana buƙatar rubuta rubutun maɓalli na lamba, sanya alamar ƙaddamarwa (*), kuma danna kan tantanin da kake so ka ninka.
Domin nuna sakamakon akan allon, danna maballin. Shigar.
Duk da haka, zaka iya yin aiki cikin tsari daban-daban: nan da nan bayan alammar daidai, danna kan tantanin halitta da ake buƙata a ninka, sannan, bayan alamar ƙaddamarwa, rubuta lambar. Lalle ne, kamar yadda aka sani, samfurin ba ya canzawa daga sake gyara abubuwan.
Haka kuma, yana yiwuwa, idan ya cancanta, don ninka yawancin kwayoyin da lambobi da yawa yanzu.
Haɓaka wani shafi ta lamba
Don ƙara ninka shafi ta wani lamba, dole ne ka ninka tantanin halitta ta wannan lamba, kamar yadda aka bayyana a sama. Sa'an nan, ta yin amfani da alamar cika, kwafin dabarar zuwa ƙananan Kwayoyin, sa'annan ka sami sakamakon.
Rage shafi ta hanyar tantanin halitta
Idan akwai lambobi a cikin wani tantanin halitta wanda za'a buƙaɗa shafi, alal misali, akwai tasiri a can, to, hanyar da aka sama ba zata yi aiki ba. Wannan shi ne saboda gaskiyar cewa idan aka kwafi, zangon waɗannan abubuwa zai matsa, kuma muna buƙatar ɗaya daga cikin dalilai don kasancewa akai.
Na farko, ninka a cikin hanyar da ta saba da tantanin halitta na farko na shafi ta tantanin halitta wanda ke dauke da mahaɗin. Bugu da ari, a cikin wannan tsari mun sanya alamar dollar a gaban daidaitawar shafi da jere na tantancewar tantanin halitta tare da haɗin kai. Ta wannan hanyar, mun juya bayanin dangi zuwa cikakkiyar ma'ana, ƙayyadaddun abin da ba zai canza ba lokacin yin kwafi.
Yanzu, yana zama a cikin hanyar da ta saba, ta yin amfani da alamar cika, don kwafin dabarun zuwa wasu kwayoyin. Kamar yadda kake gani, sakamakon ƙarshe ya bayyana.
Darasi: Yadda za a yi cikakken mahada
PRODUCTION aiki
Bugu da ƙari da sababbin hanyoyin haɓaka, a cikin Excel akwai yiwuwar waɗannan dalilai don amfani da aikin musamman PRODUCTION. Zaka iya kiran shi a cikin hanya ɗaya kamar kowane aikin.
- Amfani da Wizard na Gini, wanda za'a iya kaddamar ta danna kan maballin "Saka aiki".
- Ta hanyar shafin "Formulas". Duk da yake a ciki, kana buƙatar danna maballin. "Ilmin lissafi"wanda aka samo a kan tef a cikin asalin kayan aiki "Gidan Kayan aiki". Bayan haka, cikin lissafin da ya bayyana, zaɓa GASKIYA.
- Rubuta sunan aiki PRODUCTION, da jayayya, da hannu, bayan alamar ta daidaita da (=) a cikin tantanin da ake so, ko a cikin tsari.
Bayan haka, kana buƙatar samun aikin PRODUCTION, a cikin taga mai bude aiki, sa'annan danna "Ok".
Aikin samfurin don shigarwar manhaja kamar haka: "= PRODUCTION (lamba (ko tantanin halitta); lambar (ko tantanin halitta); ...)". Wato, idan misali muna buƙatar ninka 77 ta hanyar 55, sa'annan mu ninka ta 23, to, sai mu rubuta irin wannan tsari: "= PRODUCTION (77, 55; 23)". Don nuna sakamakon, danna kan maballin. Shigar.
Lokacin yin amfani da zaɓuɓɓuka biyu na farko don amfani da aikin (ta amfani da Wizard Wurin aiki ko shafin "Formulas"), window na muhawara ya buɗe, inda kake buƙatar shigar da muhawara a cikin lambobi, ko adiresoshin salula. Ana iya yin wannan ta hanyar danna kan sel da ake so. Bayan shigar da muhawara, danna maballin "Ok", yin lissafi, kuma nuna sakamakon akan allon.
Kamar yadda ka gani, a cikin Excel akwai babban adadin zaɓuɓɓukan don yin amfani da irin wannan aikin lissafi kamar ƙaddamarwa. Babban abu shi ne mu san nuances na yin amfani da takaddun tsari a kowane hali.
