Ɗaya daga cikin hanyoyin da ake amfani da shi a cikin aikin injiniya da sauran lissafi shi ne gina wani lamba zuwa na biyu, wanda ake kira wani wuri guda ɗaya. Alal misali, wannan hanya tana ƙayyade wurin wani abu ko adadi. Abin baƙin cikin shine, Excel ba shi da kayan aiki dabam wanda zai sanya lambar da aka bayar. Duk da haka, wannan aiki za a iya yi ta amfani da kayan aikin da aka yi amfani dashi don gina kowane digiri. Bari mu gano yadda za a yi amfani dashi don lissafin ma'auni na lambar da aka bayar.
Squaring hanya
Kamar yadda ka sani, ana lissafa ma'auni na lamba ta hanyar ninka shi ta hanyar kanta. Wadannan ka'idodin, ba shakka, suna ƙaddamar da lissafin wannan alama a Excel. A cikin wannan shirin, zaka iya gina lamba a cikin wani square a hanyoyi biyu: yin amfani da alamar ƙayyadadden tsari don ƙirar "^" da kuma yin amfani da aikin DEGREE. Ka yi la'akari da algorithm don yin amfani da waɗannan zaɓuɓɓuka cikin aikin don tantance wanda ya fi kyau.
Hanyar 1: erection ta yin amfani da tsari
Da farko, bari muyi la'akari da hanyar da aka yi amfani da shi a mafi sauƙi kuma mafi yawancin lokaci a Excel, wanda ya haɗa da yin amfani da wani tsari tare da alama "^". A wannan yanayin, a matsayin abin da za a kasance mai sigina, zaka iya amfani da lamba ko ƙaddamar da tantanin halitta inda aka samo darajar lambar.
Babban nau'i na takaddamar ƙaddamarwa kamar haka:
= n ^ 2
A cikinta maimakon "n" kana buƙatar canza wani lambar da ya kamata ya zama squared.
Bari mu ga yadda wannan yake aiki tare da misalai na musamman. Da farko, muna ƙaddamar da lambar da za ta zama ɓangare na dabara.
- Zaɓi tantanin halitta akan takardar da za'a yi lissafi. Mun sanya a cikin alamarta "=". Sa'an nan kuma mun rubuta adadi mai mahimmanci da muke so mu gina a cikin ikon sarauta. Bari ya kasance lamba 5. Gaba, sanya alamar digiri. Alamar alama ce "^" ba tare da fadi ba. Sa'an nan kuma ya kamata mu nuna wacce mataki ya kamata a yi gyaran kafa. Tun da square shine digiri na biyu, mun sanya lambar "2" ba tare da fadi ba. A sakamakon haka, a cikin yanayinmu, mun sami wannan tsari:
=5^2 - Don nuna sakamakon lissafin akan allon, danna maballin. Shigar a kan keyboard. Kamar yadda ka gani, shirin ya ƙidaya cewa lambar 5 squared zai zama daidai da 25.
Yanzu bari mu ga yadda za a iya amfani da darajar da aka samo a cikin wani tantanin halitta.
- Saita alamar daidai (=) a cikin tantanin halitta wanda za'a iya nuna yawan adadi. Kusa, danna kan kashi na takardar, inda ne lambar da kake so ka zama squared. Bayan haka daga keyboard muna rubuta bayanin "^2". A cikin yanayinmu, mun sami wannan tsari:
= A2 ^ 2 - Don lissafta sakamakon, kamar lokaci na ƙarshe, danna maballin. Shigar. Aikace-aikacen yana ƙididdige kuma yana nuna jimlar a cikin takardar shaidar da aka zaɓa.
Hanyar 2: ta amfani da aikin POWER
Hakanan zaka iya amfani da aikin ginawa na Excel don ƙaddamar da lambar. DEGREE. Wannan afaretan ɗin ya shiga cikin rukuni na ayyuka na ilmin lissafi da kuma aikinsa shine tada wani adadi na lamba zuwa ikon da aka ƙayyade. Haɗin aikin shine kamar haka:
= GARATARWA (lambar digiri)
Magana "Lambar" zai iya zama takamaiman lamba ko hanyar haɗi zuwa takardar takarda inda aka samo shi.
Magana "Degree" ya nuna matakin da za a tashe lambar. Tunda mun fuskanci tambaya game da wasanni, a cikinmu akwai wannan hujja za ta daidaita 2.
Yanzu bari mu dubi wani misali na yadda ake yin sigina ta amfani da mai aiki DEGREE.
- Zaɓi tantanin halitta inda za a nuna sakamakon lissafi. Bayan wannan danna kan gunkin "Saka aiki". Ana tsaye a gefen hagu na tsari.
- Wurin ya fara. Ma'aikata masu aiki. Muna yin sauyawa a ciki a cikin rukunin "Ilmin lissafi". A cikin jerin da ya buɗe, zaɓi darajar "ƘARARWA". Sa'an nan kuma danna maballin. "Ok".
- An kaddamar da taga na mai gudanarwa. Kamar yadda kake gani, ya ƙunshi wurare guda biyu daidai da yawan ƙididdigar wannan aikin lissafi.
A cikin filin "Lambar" saka adadin lambobi don zama squared.
A cikin filin "Degree" saka lambar "2", tun da muna bukatar mu yi ginin daidai a filin.
Bayan haka, danna maballin. "Ok" a kasan taga.
- Kamar yadda zaku iya gani, nan da nan bayan wannan, sakamakon siginar yana nunawa a cikin takaddun da aka zaɓa na takardar.
Har ila yau, don magance matsalar, maimakon nau'in, a cikin hanyar jayayya, zaka iya amfani da ma'anar tantanin salula wanda yake samuwa.
- Don yin wannan, kira ma'anar hujjar aikin da ke sama a daidai yadda muka yi shi a sama. A cikin farawa taga a filin "Lambar" saka mahaɗin zuwa tantanin tantanin halitta inda aka samo darajar lambobi, wanda ya kamata ya zama squared. Ana iya yin hakan ta hanyar sanya siginan kwamfuta a filin kuma danna maɓallin linzamin hagu akan nauyin daidai akan takardar. Ana adana adireshin nan a cikin taga.
A cikin filin "Degree"Kamar lokaci na ƙarshe, sanya lambar "2"sannan danna maballin "Ok".
- Mai tafiyar da aikin yana aiwatar da bayanai da aka shigar kuma ya nuna sakamakon sakamakon lissafi akan allon. Kamar yadda kake gani, a wannan yanayin, sakamakon yana daidai da 36.
Duba kuma: Yadda ake tada digiri a Excel
Kamar yadda kake gani, a cikin Excel akwai hanyoyi guda biyu na yin tseren lamba: ta amfani da alamar "^" da kuma yin amfani da aikin ginawa. Duk waɗannan zaɓuɓɓuka za a iya amfani da su don gina lambar zuwa wani digiri, amma don lissafa ma'auni a cikin waɗannan lokuta, kana buƙatar ƙaddamar da digiri "2". Duk waɗannan hanyoyin zasu iya yin lissafi, ko dai kai tsaye daga ƙimar da aka ƙayyade, don haka ta hanyar yin amfani da wannan maƙasudin dangane da tantanin halitta da aka samo shi. Da yawa, waɗannan zaɓuɓɓuka suna kusan daidai a cikin aiki, saboda haka yana da wuya a faɗi wanda ya fi kyau. A nan, ƙananan abu ne na halaye da kuma muhimmancin kowane mai amfani, amma ma'anar da alamar ta fi yawan amfani dashi. "^".
