Yadda ake saita daidai kamar akan allo a Excel. Yadda ake saitawa da daidaita daidaito a cikin Excel

Lokacin yin wasu ƙididdiga a cikin Excel waɗanda ke da alaƙa kai tsaye da ƙimar juzu'i, masu amfani za su iya fuskantar yanayi inda cikakkiyar lamba ta bayyana a cikin tantanin halitta tare da fitar da sakamakon. Wannan ya faru ne saboda fasahar fasaha na wannan shirin. Ta hanyar tsoho, Excel yana ɗaukar ƙimar juzu'i don ƙididdigewa tare da lambobi 15 bayan maki goma, yayin da tantanin halitta zai nuna har zuwa lambobi 3. Domin kar a ci gaba da karɓar sakamakon lissafin da ba a zata ba, ya zama dole a riga an saita daidaiton zagaye daidai da wanda aka nuna akan allo a gaban mai amfani.

Yadda tsarin zagaye ke aiki a Excel

Kafin ka fara saita zagaye na ƙimar juzu'i, ana ba da shawarar ƙarin koyo game da yadda wannan tsarin ke aiki, wanda canza sigoginsa zai shafa.

Ba a ba da shawarar canza saituna a cikin yanayin da ake yin lissafin da ya ƙunshi ɓangarorin ba sau da yawa. Wannan na iya komawa kan abin da kuke so.

Ɗaya daga cikin yanayin da aka ba da shawarar yin ƙarin gyare-gyare ga lissafin daidaito shine ƙara lambobi da yawa ta amfani da wuri ɗaya kawai. Don fahimtar abin da ke faruwa sau da yawa ba tare da ƙarin tsari ba, kuna buƙatar la'akari da misali mai amfani. Mai amfani yana buƙatar ƙara lambobi biyu - 4.64 da 3.21, yayin ɗaukar lambobi ɗaya kawai bayan ƙima a matsayin tushe. Tsari:

1. Da farko, kuna buƙatar zaɓar sel masu lambobi da aka shigar dasu tare da linzamin kwamfuta ko madannai.
2. Danna RMB, zaɓi aikin "Format Cells" daga menu na mahallin.

3. Bayan haka, wani taga tare da saituna zai bayyana, a cikin abin da kuke buƙatar zuwa shafin "Lambar".
4. Daga cikin lissafin kuna buƙatar zaɓar tsarin "Lambobi".
5. A cikin filin kyauta "Lambar wurare goma" saita ƙimar da ake buƙata.
6. Ya rage don ajiye saitunan ta danna maɓallin "Ok".

Koyaya, sakamakon ba zai zama 7.8 ba, amma 7.9. Saboda wannan, mai amfani zai iya tunanin cewa an yi kuskure. An samo wannan ƙimar juzu'i saboda gaskiyar cewa ta tsohuwar Excel ta taƙaita cikakkun lambobi, tare da duk wuraren ƙima. Amma bisa ga ƙarin sharadi, mai amfani ya ƙayyade lamba tare da lambobi ɗaya kawai bayan maki goma don nunawa akan allon. Saboda haka, an tattara sakamakon da aka samu na 7.85, inda 7.9 ya fito.

Muhimmin! Don gano ƙimar da shirin zai ɗauka a matsayin tushe yayin ƙididdigewa, kuna buƙatar danna kan tantanin halitta tare da adadin LMB, kula da layin inda aka ƙaddamar da dabara daga tantanin halitta. A cikinsa ne za a nuna ƙimar da za a ɗauka a matsayin tushen ƙididdiga ba tare da ƙarin saitunan ba.

Saita madaidaicin zagaye

Hanyar da za a saita zagaye na ƙimar juzu'i don Excel (2019) - hanyar:

1. Je zuwa babban menu "Fayil".

2. Je zuwa shafin "Parameters". Kuna iya samun shi a kasan shafin a gefen hagu.
3. Zaɓi saitunan ci gaba.
4. A gefen dama na taga da ya bayyana, nemo toshe "Lokacin da ake sake kirga wannan littafin", nemo aikin "Ka saita ƙayyadaddun daidaito" a ciki. Anan kuna buƙatar duba akwatin.
5. Bayan waɗannan matakan, ƙaramin taga gargadi ya kamata ya bayyana akan allon. Zai nuna cewa ta hanyar yin wannan aikin, daidaiton ƙididdiga a cikin tebur na iya raguwa. Don ajiye saitunan, dole ne ku yarda da canje-canje ta danna "Ok". Danna "Ok" sake don fita saitunan.

Lokacin da kuke buƙatar kashe ainihin aikin zagaye ko canza shi, kuna buƙatar zuwa saitunan iri ɗaya, cire alamar akwatin ko shigar da adadin haruffa daban bayan ma'aunin ƙima, waɗanda za a yi la'akari da su yayin lissafin.

Yadda ake daidaita daidaito a cikin sigogin baya

Ana sabunta Excel akai-akai. Yana ƙara sabbin abubuwa, amma yawancin manyan kayan aikin suna aiki kuma ana daidaita su ta hanya iri ɗaya. Lokacin saita daidaitattun ƙima a cikin sigar farko na shirin, akwai ƙananan bambance-bambance daga sigar zamani. Don Excel 2010:

1. Je zuwa shafin "File" akan babban kayan aiki.
2. Je zuwa zaɓuɓɓuka.
3. Wani sabon taga zai bayyana wanda kake buƙatar nemo kuma danna "Advanced".
4. Ya rage don nemo abin "Lokacin da ake sake lissafin wannan littafin", sanya giciye kusa da layin "Saita daidaito kamar kan allo." Tabbatar da canje-canje, ajiye saituna.

Hanyar don Excel 2007:

1. A saman panel tare da buɗe kayan aikin maƙunsar bayanai, nemo gunkin “Microsoft Office”, danna kan shi.
2. Ya kamata lissafin ya bayyana akan allon, daga abin da kuke buƙatar zaɓi abu "Zaɓuɓɓukan Excel".
3. Bayan buɗe sabon taga, je zuwa shafin "Advanced" tab.
4. A hannun dama, je zuwa rukunin zaɓuɓɓukan "Lokacin da ake sake lissafin wannan littafin". Nemo layin "Saita daidaito kamar akan allo", saita giciye a gabansa. Ajiye canje-canje tare da maɓallin "Ok".

Hanyar don Excel 2003:

1. Nemo shafin "Service" a saman babban kayan aiki, shiga ciki.
2. Daga lissafin da ya bayyana, je zuwa sashin "Settings".
3. Bayan haka, taga tare da saitunan ya kamata ya bayyana, daga abin da kuke buƙatar zaɓar "Lissafi".
4. Ya rage don duba akwatin kusa da ma'aunin "Daidai kamar kan allo".

Kammalawa

Idan kun koyi yadda ake saita daidaiton zagaye a cikin Excel, wannan saitin zai taimaka muku yin lissafin da ake buƙata lokacin da, bisa ga sharuɗɗan, kawai waɗannan ƙimar lambobi uXNUMXbuXNUMXb waɗanda ke yin la'akari da lambobi ɗaya bayan madaidaicin ƙima za a iya la'akari da su. Duk da haka, kada mu manta don kashe shi don daidaitattun yanayi, lokacin da lissafin ya kamata ya zama daidai kamar yadda zai yiwu, la'akari da duk lambobi.