Yawancin masu amfani masu kyau ba sa ganin bambanci tsakanin koyarwar "tsarin tantanin halitta" da nau'in bayanai ". A zahiri, wannan ya yi nisa da ra'ayi na musamman, kodayake, ba shakka, tuntuɓar. Bari mu gano abin da nau'in bayanai na nau'ikan, waɗanda Kungiyoyin da aka rarrabu, da yadda za su yi aiki tare da su.
Rarrabuwa na nau'ikan bayanai
Nau'in bayanan shine halayyar bayanan da aka adana a kan takardar. Dangane da wannan halayyar, shirin yana yanke shawarar yadda ake kulawa da wannan ko wannan darajar.Nau'in bayanan sun rarrabu zuwa manyan kungiyoyi biyu: kayan kwalliya da tsari. Bambanci tsakanin su shine cewa ana nuna dabarun a cikin sel, wanda na iya bambanta dangane da yadda muhawara ke cikin sauran sel zasu canza. Zaɓuɓɓuka ne na yau da kullun waɗanda ba sa canzawa.
Bisa biyun, ana raba su zuwa ƙungiyoyi biyar:
- Rubutu;
- Lambobin bayanai;
- Kwanan wata da lokaci;
- Bayanan latocin;
- Erroneous dabi'u.
Mun gano abin da kowane nau'in bayanan suna wakiltar ƙarin.
Darasi: Yadda ake canza tsarin tantanin halitta a Excel
Rubutun rubutu
Nau'in rubutu yana dauke da bayanan alama kuma ba a dauke su fifita abu a matsayin wani abu na lissafin lissafi ba. Wannan bayanin shine da farko don mai amfani, kuma ba don shirin ba. Rubutu na iya zama kowane haruffa, gami da lambobi idan an tsara su daidai. A cikin yaren dax, wannan nau'in bayanan yana nufin ƙananan ƙimar shari'ar. Matsakaicin rubutu mai matsakaiciyar 268435456 haruffa ne a cikin sel guda.
Don shigar da yanayin magana, kana buƙatar haskaka tantanin rubutu ko tsarin da aka raba a cikin wanda za'a adana shi, da kuma rubutu rubutu daga maballin. Idan tsawon magana magana magana ta wuce iyakokin gani na tantanin halitta, ana ci gaba da ci gaba da kasancewa a cikin sel na asali.
Lambobin bayanai
Ana amfani da lambobin lambobi don kwamfuta kai tsaye. Yana tare da fice-figure suna gudanar da ayyukan lissafi daban-daban (ƙari, ragewa, yawansu, rarrabuwa, gina tushen, da sauransu). Wannan nau'in bayanan da aka yi niyya ne kawai don yin rikodin lambobi, amma har ma yana da wasu haruffa masu taimakawa (%, $ et al.). Dangane da shi, zaka iya amfani da nau'ikan tsari da yawa:
- A zahiri lambobin;
- Kashi;
- Kuɗaɗe;
- Kudi;
- Rarrabuwa;
- Bala'i.
Bugu da ƙari, Excel yana da damar raba lambobi don fitarwa, kuma ƙayyade yawan lambobi bayan wakafi (cikin lambobi masu yawa).
Ana shigar da bayanan lambobin lambobi a cikin hanyar kamar yadda ƙimar rubutu da muka yi magana game da sama.
Kwanan wata da lokaci
Wani nau'in bayanai shine tsarin lokaci da kwanan wata. Wannan shine ainihin batun lokacin da nau'in bayanai da tsarin tsari ya zo daidai. An halita shi da gaskiyar cewa, yana yiwuwa a nuna a kan takarda da kuma gudanar da lissafin tare da kwanakin da lokaci. Abin lura ne cewa lokacin da aka lissafta wannan nau'in bayanan yana ɗaukar rana a kowane ɓangare. Haka kuma, wannan ya shafi ranakun, amma kuma lokaci. Misali, 12:30 ana la'akari da shirin, azaman kwanaki 0.52083, kuma an riga an nuna shi a cikin tantanin halitta a cikin tsarin da aka saba.
Akwai nau'ikan tsarawa da yawa don lokaci:
- H: MM: SS;
- H: MM;
- H: MM: SS AM / PM;
- H: MM AM / PM, da sauransu.
Yanayin daidai yake da kwanakin:
- Dd.mm.mm.yyy;
- Dd.mmm
- Mmmg.g da sauransu.
Akwai kuma hade kwanakin da tsari na lokaci, kamar DD: MM: Gygg H: MM.
Hakanan dole ne su yi la'akari da cewa shirin yana nuna yayin da kwanakin da ke dabi'u ne daga 01/01/1900.
Darasi: Yadda ake fassara agogo a cikin minti masu kyau
Bayanai na lafazi
Abin sha'awa shine irin bayanan ma'ana. Tana aiki da dabi'u guda biyu kawai: "Gaskiya" da "karya". Idan ka mika, wannan na nufin "taron yazo" kuma "ba a kasa bikin ba." Ayyuka, sarrafa abubuwan da ke cikin sel da suka ƙunshi bayanai, samar da wasu lissafi.
Erroneous dabi'u
Rarraba nau'in bayanai sune ƙimar kuskure. A mafi yawan lokuta, sun bayyana lokacin da aka yi aiki ba daidai ba. Misali, irin wannan ayyukan da ba daidai ba suna nufin sifili ko gabatarwar aiki ba tare da bin syntax ba. Daga cikin ƙimar erroneous sune masu zuwa:
- # Ma'ana! - Amfani da nau'in hujja da ba daidai ba don aiki;
- # Kasuwanci! - Dididdigar ta 0;
- #Number! - Ba daidai ba bayanan bayanai;
- # N / d - ma'ana mai fada;
- #NAME? - sunan kuskure a cikin dabara;
- # Fanko! - Ba daidai ba gabatarwar adiresoshin da aka samu;
- #Link! - Hakan yana faruwa lokacin da aka cire sel, wanda a baya ake magana da dabara.
Irin tsari
Wani rukuni na nau'ikan nau'ikan bayanai sune dabaru. Ba kamar suna da kyau ba, su, galibi, ba a gani a sel, amma sun sami sakamakon da zai iya bambanta, gwargwadon canjin muhawara. Musamman, ana amfani da tsari ga lissafin lissafi daban-daban. Ana iya ganin tsari a cikin kirtani na dabara, nuna alama tantanin halitta wanda yake ƙunshe.
Yanayin m ga shirin don fahimtar bayyanar, a matsayin tsari, shine kasancewar alamar daidai da (=).
Tsarin dabaru na iya ƙunsar nassoshi ga wasu sel, amma wannan ba abin da ake bukata bane.
Wani nau'in tsari daban-daban suna aiki. Waɗannan subroutines ne na musamman waɗanda ke ɗauke da saiti na mahimmin muhawara da kuma sarrafa su gwargwadon takamaiman algorithm. Ana iya gudanar da ayyuka da hannu cikin sel, sanya alamar pre-"=", kuma ana iya amfani dashi don waɗannan nau'ikan harsasai na musamman da ake samu a cikin shirin, wanda ya kasu kashi.
Yin amfani da Wizards Maɗaukaki, zaku iya yin canji zuwa taga hujja na takamaiman afareto. Filayensa ana gabatar da filayensa ko haɗi zuwa sel wanda wannan bayanan ke kunshe. Bayan danna maɓallin "Ok", an kashe wani aiki.
Darasi: Aiki tare da tsari a fice
Darasi: Ayyukan Wizard a Excel
Kamar yadda kake gani, akwai nau'ikan nau'ikan bayanai guda biyu a Excel: Cinta da Tsarin Kayayyaki. Su, bi da bi, sun kasu kashi da yawa wasu nau'in. Kowane nau'in bayanai yana da kaddarorinta, yin la'akari da shirin aiwatar da su. Mastering da ikon gane da kuma yadda kyau aiki tare da nau'ikan bayanai shine fifiko na kowane mai amfani da yake so ya koyi yadda ya fi so.