Daga cikin ayyukan ilmin lissafi da Microsoft Excel yake iya aiwatarwa, a zahiri, akwai yawa. Amma, rashin alheri, ba duk masu amfani zasu iya yin daidai da cikakkiyar amfani da wannan fasalin ba. Bari mu ga yadda ake aiwatar da hanyoyin ninka a Microsoft Excel.
Ciplesa'idojin Yin Nesa a Excel
Kamar kowane aikin ilimin lissafi a cikin Excel, ana yin ninka abubuwa ta amfani da dabaru na musamman. An yi rikodin ayyuka da yawa ta amfani da alamar "*".
Yawan lambobin talakawa
Kuna iya amfani da Microsoft Excel azaman kalkuleta, kuma sauƙaƙa ninka lambobi daban-daban a ciki.
Domin ninka lamba daya ta wani, muna rubutu a kowace sel a jikin takardar, ko a layin dabarun tsari, alamar ita ce (=). Na gaba, nuna asalin farko (lamba). To, sanya alamar don ninka (*). Sannan, rubuta abu na biyu (lamba). Don haka, tsarin maimaita adadin zai yi kama da haka: "= (lamba) * (lamba)".
Misali yana nuna yawan 564 zuwa 25. Ayyukan an rubuta su ta hanyar dabarar da ke tafe: "=564*25".
Don duba sakamakon lissafin, danna maɓallin Shiga.
Yayin yin lissafi, kuna buƙatar tuna cewa fifikon ilimin lissafi a cikin Excel daidai yake da na lissafi na yau da kullun. Amma, alamar alama dole ne a kara a kowane yanayi. Idan lokacin rubuta magana a kan takarda an ba shi izinin share alamar alamar yawa a gaban maƙalar, to, a cikin Excel, don ƙididdigar daidai, ana buƙata. Misali, bayanin 45 + 12 (2 + 4), a cikin Excel kuna buƙatar rubuta kamar haka: "=45+12*(2+4)".
Ka yawaita sel ta tantanin halitta
Hanyar ninkawa ta tantanin halitta ya rage duka zuwa irin na ka’ida kamar yadda ake yin amfani da adadin lamba zuwa lamba. Da farko dai, kuna buƙatar yanke shawara a cikin wane tantanin halitta za a nuna. Mun sanya alamar daidai (=) a ciki. Na gaba, a madadin danna kan sel waɗanda abubuwan da ke buƙata su ninka. Bayan an zaɓi kowace sel, sanya alamar ninka (*).
Harafi zuwa shafi ninka
Domin ninka lamba ta hanyar shafi, kai tsaye kana buƙatar ƙaraɗa samann sel na waɗannan ginshiƙai, kamar yadda aka nuna a misalin da ke sama. To, mun tsaya a kan ƙananan hagu na hagu na sel cike. Alamar cike take bayyana. Ja shi ƙasa yayin riƙe maɓallin linzamin kwamfuta na hagu. Saboda haka, hanyar kwafin halitta ana kwafa ta zuwa dukkanin sel a cikin shafin.
Bayan haka, ginshiƙan za su yawaita.
Hakanan, zaku iya ninka ginshiƙai uku ko fiye.
Aara lambar ta lamba
Don haɓaka sel ta lamba, kamar yadda a cikin misalan da aka bayyana a sama, da farko, sanya alama daidai (=) a cikin wannan tantanin halitta wanda kuke nufin nuna amsar ayyukan ilimin lissafi. Bayan haka, kuna buƙatar rubuta lambar lambobi, sanya alamar ninka (*), sannan danna kan wayar da kuke son ninkawa.
Domin nuna sakamakon allon, danna maballin Shiga.
Koyaya, zaku iya aiwatar da ayyuka daban-daban: nan da nan bayan alamar daidai, danna kan wayar don ku riɓaɓɓanya, sannan, bayan alamar sau ɗaya, rubuta lambar. Bayan haka, kamar yadda kuka sani, samfurin baya canzawa daga yanayin abubuwan.
Haka kuma, zaka iya, idan ya cancanta, haɓaka sel da dama da lambobi da yawa lokaci guda.
Aara lamba a lamba
Domin ninka lambar ta hanyar wata lamba, dole ne ka ninka sel nan da nan ta wannan lambar, kamar yadda aka bayyana a sama. Sannan, ta amfani da alamar cikawa, kwafa dabarar zuwa ƙananan sel, kuma muna samun sakamakon.
Yi lamba ɗaya ta sel
Idan akwai lamba a cikin takamaiman sel da ya kamata a ninka lamba, misali, akwai wadataccen abu, sannan hanyar da ke sama ba zata yi aiki ba. Wannan yana faruwa ne saboda gaskiyar cewa lokacin kwafa kewayon abubuwanda zasu canza, kuma muna buƙatar ɗayan abubuwan da zasu kasance koyaushe.
Da farko, muna ninka hanyar da ta saba kwayar farko ta sashin layi ta tantanin da ke dauke da mai aiki. Na gaba, a cikin dabara, mun sanya alamar dala a gaban daidaitawar shafi da hanyar haɗin layi zuwa tantanin halitta tare da mai aiki. Ta wannan hanyar, mun mai da hanyar haɗin dangi ta zama ta gaba ɗaya, ma'anar ayyukan da ba za su canza ba yayin kwafa.
Yanzu, ya kasance hanya ta yau da kullun, ta amfani da alamar cikewa, kwafa dabarar zuwa wasu ƙwayoyin. Kamar yadda kake gani, sakamakon gama ya bayyana nan da nan.
Darasi: Yadda ake yin cikakken haɗi
AIKIN SAUKI
Baya ga hanyar da aka saba amfani da ita, a cikin Excel akwai yuwuwar ga waɗannan dalilai don amfani da aiki na musamman FASAHA. Kuna iya kiransa duka ta hanya guda ɗaya kamar kowane ɗayan aikin.
- Ta amfani da Mayen Aiki, wanda za a iya farawa ta danna maballin "Saka aikin".
- Ta hanyar tab Tsarin tsari. Kasancewa a ciki, kana buƙatar danna maballin "Ilmin lissafi"wacce take akan kintinkiri a cikin akwatin kayan aiki Laburaren Ma’aikata. Sannan, a cikin jerin da ya bayyana, zaɓi "CIGABA".
- Rubuta sunan aiki FASAHA, da kuma muhawararsa, da hannu, bayan alamar daidai (=) a cikin tantanin da ake so, ko a cikin masarar dabara.
To, kuna buƙatar nemo aikin FASAHA, a cikin taga taga mai aiki, saika danna "Ok".
Samfurin aikin don shigarwar mai amfani kamar haka: "= CTIONirƙirari (lamba (ko zanen tantancewa); lamba (ko ƙirar sel); ...)". Wannan shine, idan alal misali muna bukatar mu ninka 77 zuwa 55, kuma mu ninka zuwa 23, to, zamu iya rubuta wannan dabarar: "= KYAUTATA (77; 55; 23)". Don nuna sakamakon, danna maɓallin Shiga.
Lokacin amfani da zaɓuɓɓuka biyun na farko don amfani da aiki (ta amfani da Wurin Aiki ko shafin Tsarin tsari), taga muhawara tana buɗewa, wanda kake buƙatar shigar da muhawara a cikin hanyar lambobi, ko adiresoshin sel. Ana iya yin wannan ta hanyar danna kawai cikin abubuwan da ake so. Bayan shigar da muhawara, danna maballin "Ok", don aiwatar da lissafi, da kuma nuna sakamako a allon.
Kamar yadda kake gani, a cikin Excel akwai zaɓuɓɓuka masu yawa don amfani da irin waɗannan ayyukan ilimin lissafi kamar ƙari. Babban abu shine sanin yanayin aiwatar da dabarun ninka abubuwa a kowane yanayi.
