Yadda za a Haɓaka Ƙidaya a cikin Shafukan Lissafin Google

Hanyar mafi sauƙi don ninka lambobi biyu a cikin Shafukan Rubutun Google shine ƙirƙirar wata takarda a cikin sashin layi.

Mahimman mahimmanci su tuna game da Maƙunsar Bayani na Google:

• Kayan tsari sukan fara da alamar daidai ( = );
• Daidai daidai yana shiga cikin tantanin halitta inda kake son amsawa;
• mahaɗin ƙaddamarwa shine alama ( * );
• An kammala tsari ta latsa maɓallin Shigar da ke keyboard.

01 na 06

Amfani da Siffofin Siffar a cikin Formulas

Ko da yake shigar da lambobi a cikin wata hanya, kamar:

= 20 * 10

aiki - kamar yadda aka nuna a jere na biyu a cikin misalin - ba shine hanya mafi kyau don ƙirƙirar ƙira ba.

Hanyar mafi kyau - kamar yadda aka nuna a layuka biyar da shida - shine:

1. Shigar da lambobi zuwa ƙaddara zuwa ɗakunan Kayan aiki dabam;
2. Shigar da sanannun tantancewar kwayoyin halitta don waɗannan kwayoyin da ke dauke da bayanai a cikin wannan tsari.

Siffofin salula suna hade da harafin shafi na tsaye da lambar jeri na kwance tare da harafin shafi na farko da aka rubuta a farko - irin su A1, D65, ko Z987.

02 na 06

Abubuwan da ake amfani da salula na Cell

Ana amfani da alamun salula don gano inda ake amfani da bayanan da aka yi amfani dashi a cikin wani tsari. Shirin ya karanta bayanan salula sannan kuma matosai a bayanan da ke cikin wadannan kwayoyin cikin wuri mai dacewa a cikin tsari.

Ta amfani da bayanan salula fiye da ainihin bayanan a cikin wata hanya - daga baya, idan ya zama wajibi don canja bayanai , yana da sauƙi na maye gurbin bayanai a cikin kwayoyin maimakon sake rubutawa da wannan tsari.

Yawanci, sakamakon wannan tsari zai sabunta ta atomatik sau ɗaya bayanan canje-canjen.

03 na 06

Alamar ƙirar yawanci

Kamar yadda aka nuna a cikin hoton da ke sama, wannan misali ya haifar da wata ƙira a cikin cell C4 wanda zai ninka bayanai a cikin cell A4 ta wurin bayanai a A5.

Kayan da aka gama a cikin cell C4 zai kasance:

= A4 * A5

04 na 06

Shigar da Formula

1. Danna kan wayar C4 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon wannan tsari;
2. Rubuta alamar daidai ( = ) a cikin cell C4;
3. Danna maɓallin A4 tare da maɓallin linzamin kwamfuta don shigar da wannan tantanin halitta a cikin tsari;
4. Rubuta alamar alama ( * ) bayan A4;
5. Danna maɓallin A5 tare da maɓallin linzamin kwamfuta don shigar da wannan tantanin halitta;
6. Latsa maɓallin shigarwa a kan keyboard don kammala tsari;
7. Amsar 200 ya kasance a cikin cell C4;
8. Ko da yake an nuna amsar a cikin ƙwayar C4, danna kan tantanin halitta zai nuna ainihin matsala = A4 * A5 a cikin maɓallin tsari a sama da takardun aiki.

05 na 06

Canza Bayanan Bayanin Samun

Don gwada darajar amfani da bayanan salula a cikin wani tsari:

• Canja t da lambar a cell A4 daga 20 t o 5 kuma danna maɓallin Shigar da ke keyboard.

Amsar a cikin cell C4 ya kamata ta atomatik sabuntawa zuwa 50 don yin la'akari da canji cikin bayanai a cikin cell A4.

06 na 06

Canza Formula

Idan ya zama wajibi don gyara ko canza wani tsari, biyu daga cikin mafi kyau mafi kyau shine:

• Danna sau biyu a kan tsari a cikin takardun aiki don sanya Rubutun Shafukan Google cikin Yanayin Shirya sa'annan kuyi canje-canje a cikin tsari - aiki mafi kyau don canje-canje kaɗan.
• Danna sau ɗaya akan tantanin halitta dauke da maƙirarin kuma sake rubuta kowane tsari - mafi kyau ga manyan canje-canje.