Amfani da Kasuwancin CONVERT a cikin takardun Excel
Ana amfani da aikin CONVERT don sauya ma'aunai daga ɗayan raka'a zuwa ɗayan a Excel.
Alal misali, ana iya amfani da aikin CONVERT don sauyawa digiri Celsius zuwa digiri Fahrenheit, hours zuwa minti, ko mita zuwa ƙafa.
KARANNAN KASHIN KASAWA
Wannan shi ne haɗin kan aikin CONVERT:
= KASHI ( Lamba , Daga_Unit , To_Unit )- = KASHEWA : Wannan shine aikin, don haka kada a canza lokacin canza dabi'u.
- Lambar: Darajar da za'a canza. Za a iya kasancewa lamba da aka gudanar a cikin tantanin halitta kamar yadda aka saba ko wanda aka rubuta a cikin wani tantanin halitta.
- Daga_Unit : A takaitaccen ma'auni na Ƙidayar Yanayi, a cikin kwance.
- To_Unit : A takaice na ma'aunin ƙimar da Lambar za a juya zuwa, a cikin zance.
A lokacin da zaɓin raka'a don fasalin, shi ne gajerun hanyoyi da aka shigar kamar su na Daga_Unit da To_Unit don aikin. Alal misali, ana amfani da "in" don inci, "m" don mita, "sec" don na biyu, da dai sauransu. Akwai misalai da dama a kasa na wannan shafin.
KASA KASA KASA KYAU
Lura: Wadannan umarnin ba su haɗa da matakan tsarawa don takarda aiki kamar yadda kuke gani ba a siffarmu na misali. Duk da yake wannan ba zai tsangwama ba tare da kammala tutorial, toftarin aikinka zai yi banbanci da misali da aka nuna a nan, amma aikin CONVERT zai ba ka sakamakon wannan.
A cikin wannan misali, zamu dubi yadda za a sake canza ma'aunin mita 3.4 zuwa daidai daidai a ƙafa.
- Shigar da bayanan a cikin sassan C1 zuwa D4 na takardar aiki na Excel kamar yadda aka gani a hoton da ke sama.
- Zaɓi cell E4. Wannan shine inda za'a nuna sakamakon aikin.
- Je zuwa menu na Formulas kuma zaɓi Ƙari Ayyuka> Gin aikin injiniya , sannan ka zaɓa CONVERT daga wannan menu mai saukewa.
- A cikin maganganu , zaɓi akwatin rubutu kusa da "Layin", sa'an nan kuma danna maɓallin E3 a cikin takardar aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu.
- Koma zuwa akwatin maganganu kuma zaɓi akwatin "From_unit", sa'an nan kuma zaɓi tantanin halitta D3 a cikin takardun aiki don shigar da wannan tantanin salula.
- Koma a cikin akwatin maganganu, gano wuri kuma zaɓi akwatin rubutu kusa da "To_unit" sa'an nan kuma zaɓi cell D4 a cikin takardun aiki don shigar da wannan tantancewar salula.
- Danna Ya yi .
- Amsar 11.15485564 ya kamata ya bayyana a cikin cell E4.
- Lokacin da ka danna kan wayar E4, cikakken aikin = CONVERT (E3, D3, D4) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
- Don canza wasu nisa daga mita zuwa ƙafa, canza darajar a cikin cell E3. Don canza dabi'u ta amfani da raka'a daban, shigar da gajeren raga na raka'a a cikin sel D3 da D4 da darajar da za a canza cikin tantanin halitta E3.
Don yin sauƙi don karanta amsar, ana iya rage yawan wurare maras kyau a cikin tantanin halitta E4 ta amfani da Zaɓin Dec Decal wanda aka samo a cikin Gidan gidan> Sakamako menu.
Wani zaɓi don dogon lambobi kamar wannan shine don amfani da aikin ROUNDUP .
Jerin Jerin Ƙungiyar Sakamakon Sakamakon Ƙaƙwalwar Hanya da Excel ta Excel
An shigar da waɗannan gajerun hanyoyi a matsayin maɓallin Daga_unit ko To_unit don aikin.
Za a iya buga rubutun gajerun kai tsaye a cikin layin da aka dace a cikin akwatin maganganu , ko kuma tantance tantanin halitta zuwa wuri na gajeren rubutu a cikin takarda aiki za a iya amfani.
Lokaci
Shekara - "Yr" Ranar - "ranar" Sa'a - "hr" Minti - "mn" Na biyu - "sec"Temperatuwan
Degree (Celsius) - "C" ko "Cel" Degree (Fahrenheit) - "F" ko "fah" Degree (Kelvin) - "K" ko "kel"Distance
Mile - "m" Mile - "mi" Mile (nautical) - "Nmi" Mile (Mundin dokar bincike na Amurka) - "survey_mi" Inch - "a" Foot - "ft" Yard - "yd" Shekaru-shekara - "ly" Parsec - "pc" ko "parsec" Angstrom - "ang" Pica - "pica"Ruwan Liquid
Liter - "l" ko "Lt" Teaspoon - "tsp" Tebur - "tbs" Gilashin ruwa - "oz" Cup - "kofin" Pint (US) - "pt" ko "us_pt" Pint (Birtaniya) - "uk_pt" Quart - "qt" Gallon - "gal"Weight da Mass
Gram - "g" Rundin launi ('yandupois) - "lbm" Ounce mass (asdupois) - "ozm" nau'in kilogram (US) - "cwt" ko "shweight" nauyin fadin ("imperial") - "uk_cwt" ko "lcwt" U (atomic ƙungiyar masauki) - "u" Ton (mulkin) - "uk_ton" ko "LTON" Slug - "sg"Ƙarfin
Pascal - "Pa" ko "p" Atmosphere - "atm" ko "a" mm na Mercury - "mmHg"Ƙarfin
Newton - "N" Dyne - "Dyn" ko "Dy" Fara karfi - "lbf"Ikon
Horsepower - "h" ko "HP" Pferdestärke - "PS" watt - "w" ko "W"Makamashi
Jaule - "J" Erg - "e" Calorie (thermodynamic) - "c" Calorie (IT) - "cal" Kwamfutar lantarki - "ev" ko "eV" Hudu-hour - "hh" ko "HPh" Watt-hour - "wh" ko "Wh" Plain - "flb" BTU - "btu" ko "BTU"Magnetism
Tesla - "T" Gauss - "ga"Lura: Ba duk zaɓin da aka jera a nan ba. Idan naúrar ba ta buƙata a rage shi ba, ba'a nuna shi a wannan shafin ba.
Ƙididdigar Ƙananan Ƙwararren Ƙira
Don ƙananan na'urori, canji kawai zuwa sunan mahaɗin yayin da yake ragewa ko ƙãra girman shi ne prefix da aka yi amfani da shi a gaban sunan, kamar mita centi na 0.1 mita ko kilo mita don mita 1,000.
An ba da wannan, a ƙasa ƙasa ce jerin takardun haruffa guda ɗaya waɗanda za a iya sanya su a gaban kowane ƙananan matakan ma'auni wanda aka lissafa a sama don canja canje-canjen da aka yi amfani da su a cikin ƙwararrun Daga_unit ko To_unit .
Misalai:
- Don nisa, don juyawa mil zuwa kilomita maimakon mita, amfani km maimakon m
- Don nauyin nauyi, don juyar da jigilar zuwa milligrams maimakon grams, amfani da MG maimakon g
Wasu daga cikin prefixes dole ne a shiga cikin babba:
Na'urar - Kalmomin dashi - "E" peta - "K" - "T" giga - "G" mega - "M" kilo - "ƴan -" h "-" e " "c" milli - "m" micro - "u" nano - "n" pico - "p" femto - "f" - "a"