Microsoft Excel yana aiki tare da bayanan lambobi. Yayin yin rabawa ko aiki tare da lambobin haɓaka, shirin yana zagaye. Wannan shi ne mahimmanci saboda gaskiyar cewa lambobi masu yawa suna da wuya, amma ba dacewa ba don aiki tare da ƙananan magana tare da wurare masu yawa. Bugu da ƙari, akwai lambobin da ba a daidaita su sosai ba. Amma, a lokaci guda, rashin daidaito daidai zai iya haifar da manyan kurakurai a cikin yanayi inda ake buƙata ainihin. Abin farin, a cikin Microsoft Excel, masu amfani kansu za su iya saita yadda za a ƙidayar lambobin.
Ajiye lambobi a cikin ƙwaƙwalwa na Excel
Duk lambobin da ayyukan Microsoft Excel suke rarraba zuwa ainihin kuma kimanin. Ana adana lambobi zuwa lambobi 15 zuwa ƙwaƙwalwar ajiya, kuma an nuna har zuwa lambar da mai amfani da kansa ya nuna. Amma, a lokaci guda, duk lissafi ana aikata bisa ga bayanai da aka adana cikin ƙwaƙwalwar ajiyar, kuma ba a nuna su a kan saka idanu ba.
Ta yin amfani da aikin zagaye, Microsoft Excel ya watsar da wasu adadin wurare mara kyau. A cikin Excel, ana amfani da hanya na zagaye na al'ada, lokacin da lambar da ba ta kasa da 5 an ɗauka ba, kuma mafi girma ko kuma daidai da 5 - sama.
Tsayawa tare da maballin kan rubutun
Hanya mafi sauki don sauya zagaye na lamba shine don zaɓin tantanin halitta ko rukuni na sel, kuma yayin da ke cikin shafin shafin, danna kan rubutun kan rubutun "Ƙara Masarrafi" ko "Ƙara Girma". Dukansu maballin suna samuwa a cikin akwatin kayan "Number". A wannan yanayin, kawai lambar da aka nuna za a yi zagaye, amma don ƙididdiga, idan ya cancanta, har zuwa lambobi 15 na lambobi zasu shiga.
Lokacin da ka danna kan maballin "Ƙara fadin nisa", yawan adadin haruffa bayan ƙwaƙwalwar ƙira ta ƙaru ɗaya.
Lokacin da ka latsa maɓallin "Rage zurfin zurfin" yawan adadin bayan ƙaddamar da ƙaddamarwa ya rage ta daya.
Tsayawa ta hanyar tsarin salula
Hakanan zaka iya saita zagaye ta amfani da saitunan tsarin salula. Don wannan, kana buƙatar zaɓar kewayon kwayoyin a kan takardar, danna maɓallin linzamin linzamin dama, kuma a cikin jerin da aka bayyana zaɓin "Tsarin Kwayoyin" abu.
A cikin saitin bude tsarin salula, je zuwa shafin "Lambar". Idan matakan data ba numfashi ba ne, to kana buƙatar zaɓin tsarin tsarawa, in ba haka ba ba za ku iya daidaita daidaito ba. A tsakiyar ɓangaren taga kusa da rubutun "Adadin wurare masu kyau" muna nuna kawai adadin adadin haruffan da muke son gani a lokacin da ake zagaye. Bayan haka, danna maballin "OK".
Saita daidaitattun lissafta
Idan a cikin lokuta da suka gabata, abubuwan da aka saita kawai sun shafi bayanan bayanan waje, kuma ana amfani da alamun ƙididdiga masu kyau (har zuwa haruffa 15) a lissafin, yanzu za mu gaya muku yadda za a canza daidaitattun lissafin.
Don yin wannan, je zuwa shafin "File". Kusa, koma zuwa sashen "Sigar".
Zaɓin zaɓi na Excel ya buɗe. A cikin wannan taga, je zuwa sashe na "Babba". Muna neman wani ɓangaren saitunan da ake kira "A lokacin da kake karatun wannan littafi." Ba'a amfani da saitunan da ke gefe ba ga kowane ɗigon, amma ga dukan littafi a matsayin cikakke, wato, ga dukan fayil ɗin. Mun sanya kaska a gaban siginar "Saita daidaito a kan allon." Danna kan maballin "OK" a cikin kusurwar hagu na taga.
Yanzu, lokacin da aka lissafa bayanan, za'a nuna lissafin da aka nuna a kan allon, kuma ba wanda aka adana cikin ƙwaƙwalwar Excel ba. Za a iya daidaita daidaitattun lambar da aka nuna a cikin hanyoyi biyu, wanda muka tattauna a sama.
Aiwatar da ayyuka
Idan kana so ka canza darajar zagaye yayin da aka kirkira game da ɗaya ko sau da yawa kwayoyin, amma ba ka so ka rage daidaitattun lissafi don takardun a matsayin cikakke, sa'an nan kuma a cikin wannan yanayin, zai fi dacewa don amfani da damar da ROUND yayi da kuma bambancinta, da kuma wasu siffofin.
Daga cikin manyan ayyukan da ke tsara zagaye, ana biyowa wadannan:
- ROUND - zagaye zuwa ƙayyadadden wurare na wurare marasa kyau, bisa ga ka'idodi da aka ƙayyade akai-akai;
- ROUND-UP - zagaye har zuwa lambar da ta fi kusa da wannan ƙananan;
- ROUNDOWN - zagaye zuwa lambar da ke kusa kusa da ƙwaƙwalwar;
- RING - zagaye lambar tare da daidaitattun aka ba;
- OKRVVERH - yana zagaye lambar tare da daidaitattun da aka ba da ɗayan ɗin;
- OKRVNIZ - yana zagaye da lambar saukar da ɗayan tare da daidaitattun aka ba;
- OTBR - zagaye bayanai zuwa lamba;
- CHETN - yana zagaye bayanan zuwa lambar mafi kusa;
- Adadin bayanai zuwa lambobi mafi kusa.
Don ayyukan ROUND, ROUNDUP da ROUNDDOWN, wannan tsarin shigarwa shine: "Sunan aiki (lambar, lambobi) Wannan shine, idan kuna, misali, kuna so a zagaye lambar 2.56896 zuwa lambobi uku, to kuyi amfani da ROUND (2.56896; 3). Da fitarwa shi ne lambar 2.569.
Ana amfani da wannan mahimman tsari don ayyukan ROUNDCASE, OKRVVER da OKRVNIZ: "Sunan aikin (lambar, daidaito)". Alal misali, don zagaye lamba 11 zuwa nau'in mafi kusa na 2, shigar da aikin ROUND (11; 2). Sakamako shine lamba 12.
Ayyuka OTBR, SANTA DA KASA OF amfani da wannan tsarin: "Sunan aikin (lambar)". Domin yada lambar 17 zuwa mafi kusa, amfani da aikin CHETN (17). Mun sami lamba 18.
Za'a iya shigar da aikin a cikin tantanin salula da kuma a cikin aikin, bayan zaɓin tantanin halitta wanda za'a samo shi. Kowane aikin dole ne a rigakace ta hanyar "=".
Akwai hanyoyi daban-daban don gabatar da ayyuka na zagaye. Yana da mahimmanci idan akwai teburin tare da dabi'un da ake buƙatar tuba cikin lambobi masu mahimmanci a cikin wani shafi.
Don yin wannan, je shafin "Formulas". Danna kan maɓallin "Lissafi". Na gaba, a lissafin da ya buɗe, zaɓi aikin da ake so, misali ROUND.
Bayan haka, aikin gwagwarmayar aikin ya buɗe. A cikin "Lambar", za ku iya shigar da lambar da hannu, amma idan muna so mu yi nazarin bayanai na dukan teburin, sa'annan danna maballin zuwa hannun dama na shigarwar bayanai.
An rage girman gwargwadon aikin aiki. Yanzu kuna buƙatar danna kan tantanin halitta mafi girma na shafi, bayanan da za mu kashe. Bayan an shigar da darajar cikin taga, danna kan maballin zuwa dama na wannan darajar.
Gidan gwajin aikin yana buɗewa. A cikin "Number of Figures" filin da muka rubuta zurfin zurfin da muke bukatar mu rage yawan ɓangarori. Bayan haka, danna maballin "OK".
Kamar yadda ka gani, lambar ta cika. Domin yada dukkanin bayanan da ake so a cikin wannan hanya, muna motsa siginan kwamfuta a kusurwar dama na tantanin halitta tare da mahimmanci, danna kan maɓallin linzamin hagu, kuma ja shi zuwa ƙarshen tebur.
Bayan haka, duk martabobin a cikin shafi da ake buƙata za a yi zagaye.
Kamar yadda kake gani, akwai hanyoyi guda biyu don zagaye nuni na bayyane: amfani da maballin kan tef, da kuma canza sigogi na tsarin tantanin halitta. Bugu da ƙari, za ka iya canja zagaye na ainihin lissafin bayanai. Hakanan za'a iya yin hakan a hanyoyi biyu: ta hanyar canza saitunan littafin gaba ɗaya, ko ta amfani da ayyuka na musamman. Zaɓin hanyar da ta dace ta dogara ne akan ko za ku yi amfani da wannan nau'i na dukan bayanai a cikin fayil ɗin, ko kuma don wani kewayon kwayoyin halitta kawai.
