Daya daga cikin mafi yawan ayyukan lissafi da aka yi amfani da shi a Injiniya da sauran lissafin shine ƙayyadaddun lamba na lamba na biyu, wanda ya bambanta a cikin wani yanki. Misali, wannan hanyar tana lissafa yanki na abu ko adadi. Abin takaici, babu kayan aiki daban a cikin ingantaccen shirin da zai gina takamaiman lambar a cikin murabba'in. Ko ta yaya, ana iya yin wannan aikin ta amfani da kayan aikin guda ɗaya waɗanda ake amfani da su don gina kowane mataki. Bari mu gano yadda ake amfani da su don ƙididdige filin daga lambar da aka ƙayyade.
Tsarin gini na gini
Kamar yadda kuka sani, ana kiransa lambar lamba ta hanyar yawaita akan kanta. Waɗannan ƙa'idodin a zahiri sun mamaye lissafin da aka ƙayyade kuma a cikin Excel. A cikin wannan shirin, za mu iya gina lamba a cikin square ta hanyoyi biyu: amfani da alamar motsa jiki zuwa mataki don tsari "^" da kuma amfani da matakin digiri. Yi la'akari da algorithm don amfani da waɗannan zaɓuɓɓuka a aikace don nuna godiya ga wanda ya fi kyau.Hanyar 1: erection tare da taimakon forarila
Da farko dai, la'akari da mafi sauƙin da mafi sauki kuma mafi yawan yau da kullun don gina digiri na biyu cikin fice, wanda ya shafi amfani da tsari tare da alamar "^". A lokaci guda, a matsayin abu, wanda za a ɗaukaka zuwa ga murabba'i, zaku iya amfani da lamba ko hanyar haɗi zuwa sel, inda wannan ƙimar wannan lambar take.
Janar na gaba na dabara don gina filin shine kamar haka:
= N ^ 2
A ciki, maimakon "N", ya zama dole don canza takamaiman lambar da yakamata a tashe ta zuwa murabba'i.
Bari mu ga yadda yake aiki akan takamaiman misalai. Da farko, ya gina lamba a cikin wani square wanda zai kasance wani ɓangare na dabara.
- Muna nuna tantanin halitta a kan takardar wanda aka sanya lissafin. Mun sanya alamar "=". Sannan muna rubuta ƙimar lamba da muke son gina digiri na biyu. Bari ya kasance lamba 5. Na gaba, sanya alamar digiri. Alama ce "^" ba tare da kwatancen ba. Sannan ya kamata mu ayyana abu ya kamata a gina abu. Tunda murabba'i shine digiri na biyu, to, mun saita lamba "2" ba tare da kwatancen ba. A sakamakon haka, a cikin lamarinmu, dabarar ta juya:
= 5 ^ 2
- Don nuna sakamakon lissafin akan allon, danna maɓallin Shigar a kan keyboard. Kamar yadda kake gani, shirin daidai ya lissafa cewa lambar 5 a cikin filin zai zama daidai da 25.
Yanzu bari mu ga yadda ake gina ƙimar a cikin wani square wanda yake a cikin wani sel.
- Sanya alamar "daidai" (=) a cikin tantanin halitta wanda ya fito daga lissafin za a nuna. Na gaba, danna kan takardar, inda lambar da kake son gina murabba'i. Bayan haka, daga keyboard, muna daukar furcin "^ 2". A cikin lamarinmu, wannan tsari ya juya:
= A2 ^ 2
- Don kirga sakamakon, a matsayin lokacin ƙarshe, danna maɓallin Shigar. Ana lissafta aikace-aikacen kuma yana nuna sakamako a cikin takardar da aka zaɓa.
Hanyar 2: Yin Amfani da Aiki
Hakanan, don gina lamba a cikin wani murabba'in, zaku iya amfani da aikin da aka saka tare da ExpedDed Standard. Wannan ma'aikaci ya shiga rukuni na ayyukan lissafi da aikinsa shine gina wasu ƙimar lambobi zuwa takamaiman digiri. Syntax na aikin kamar haka:
= Digiri (lamba; digiri)
Muhawara "lamba na iya zama takamaiman lamba ko magana game da sifar takarda, inda aka samo shi.
Hujja "digiri" yana nuna digiri wanda adadin ya kamata a gina adadin. Tunda muna fuskantar tambaya game da gina wani square, to, a cikin yanayinmu wannan hujja zai zama daidai da 2.
Yanzu bari mu kalli takamaiman misali, yadda ake yin square ta amfani da mai aikin digiri.
- Selectel a cikin abin da sakamakon lissafin za a nuna shi. Bayan haka, danna aikin "saka aiki" gunkin "icon" icon. Yana kan hagu na hanyar da aka samu.
- Window ɗin Window taga yana farawa. Mun fitar da canji a cikin rukunin "lissafi". A cikin jerin da aka katse jerin, zaɓi darajar "digiri". Sannan danna maballin "Ok".
- Tufafin muhawara ta aka tsara an ƙaddamar. Kamar yadda muke gani, akwai filaye biyu a ciki, daidai da yawan muhawara a cikin wannan aikin lissafi.
A filin "Number", saka ƙimar lambobin da yakamata a tashe ta zuwa cikin square.
A filin "digiri", mun tantance lambar "2", tunda muna buƙatar aiwatar da daidai murabba'in.
Bayan haka, danna maɓallin "Ok" a cikin ƙasa na taga.
- Kamar yadda kake gani, kai tsaye bayan wannan, sakamakon gina square aka bayyana a cikin wani sashi na ƙaddara takardar.
Hakanan, don warware aikin, maimakon lamba lamba da yawa, zaku iya amfani da hanyar haɗi zuwa tantanin halitta wanda yake.
- Don yin wannan, kira taga muhawara ta aikin da ke sama daidai wannan hanyar da muka yi hakan. A cikin taga taga a cikin filin "lamba", saka hanyar haɗi zuwa tantanin halitta, inda darajar lambobi take zuwa square. Za'a iya yin wannan ta hanyar shigar da siginan kwamfuta a cikin filin kuma danna maɓallin linzamin kwamfuta na hagu a kan ƙayyadaddun a kan takardar. Adireshin zai bayyana nan da nan a cikin taga.
A filin "digiri", kamar na ƙarshe, mun sanya lambar "2", sannan danna maɓallin "Ok".
- Mai aiki Yana aiwatar da bayanan da aka shigar kuma yana nuna lissafin sakamako akan allon. Kamar yadda muke gani, a wannan yanayin, sakamakon sakamako daidai yake da 36.
Duba kuma: Yadda za a gina Digiri a Fim
Kamar yadda kake gani, akwai hanyoyi guda biyu na tsallaka lambar a cikin wani square: amfani da alama "^" alama da amfani da aikin ginanniyar aiki. Hakanan za'a iya amfani da waɗannan zaɓuɓɓuka don gina lamba zuwa kowane mataki, amma don ƙididdige murabba'in a cikin duka halayen da kuke buƙata don tantance digiri "2". Kowane ɗayan hanyoyin da aka ƙayyade na iya yin lissafin, kamar kai tsaye daga ƙayyadaddun ƙididdigar lambobi, don haka amfani da hanyar haɗi zuwa tantanin halitta wanda yake a cikin waɗannan dalilai. Da girma, waɗannan zaɓuɓɓuka suna daidai gwargwado kan ayyuka, don haka yana da wuya a faɗi wanda ya fi kyau. Yana da matukar muhimmanci ga al'adun kowane mai amfani, amma ana iya amfani da tsari da alama "^" har yanzu ana amfani da shi sosai.