Sida loo sameeyo tiro labajibbaaran oo ku jirta Excel

Isku-duubnida lambar ee xaashida xaashida waxay u ekaan kartaa caqabad, laakiin Microsoft Excel, hawshani waa mid fudud. Maqaalkan, waxaan ku dabooli doonaa sida saxda ah ee loo sameeyo. Haddi aad ka shaqaynayso dhib xisaabeed ama aad u baahan tahay inaad xisaabiso aagagga xog-ururinta, casharkan ayaa ku bari doona. Sida loo sameeyo tiro labajibbaaran oo ku jirta Excel si degdeg ah oo fudud. Waxaan ku tusi doonaa sida loo isticmaalo qaacidooyinka jira iyo sida loo abuuro kaaga si ay ugu habboonaato baahiyahaaga gaarka ah. Aynu si wada jir ah ugu socono safarkan waxbarasho ee Excel.

Talaabo Talaabo ➡️ Sida Loo Sameeyo Nambarka Excel,

• Ku fur xaashida shaqada ee ExcelTallaabada ugu horreysa ee lagu gaarayo Sida loo sameeyo tiro labajibbaaran oo ku jirta Excel waa inaad furto barnaamijka Excel oo dooro xaashida shaqada meesha aad rabto inaad xisaabiso.
• Dooro unugga meesha aad rabto inaad geliso lambarka labajibbaaran: Marka xaashida shaqadu furto, dooro unugga aad qorshaynayso inaad geliso lambarka aad doonayso inaad laba jibaaranto.
• Geli hawlwadeenka "="Kahor intaadan ku qorin qaacido kasta oo Excel ah, waa inaad had iyo jeer ku bilowdaa hawlwadeenka "="
• Qor lambarka aad rabto in aad laba jibaaranto: Isla markiiba ka bacdi "=" hawlwadeenka, ku qor nambarka aad rabto inaad labajibaarto. Tusaale ahaan, haddii aad rabto inaad labajibaarto lambarka 5, qaacidada ilaa hadda waxay noqonaysaa "=5."
• Isticmaal hawlwadeenka "^": Hawlwadeenkan ayaa looga baahan yahay Sida loo sameeyo tiro labajibbaaran oo ku jirta Excel. Waxay ku taal xagga sare ee kiiboodhkaaga, isla furaha lambarka 6. Si aad u labajibaarto nambar Excel, waa inaad ku darto hawlwadeenkan qaacidadaada ka dib lambarka.
• Ku dar nambarka 2 dhamaadka caanahaagaSi aad u dhamaystirto qaacidada oo aad u labajibaarto nambarka, waa inaad ku dartaa lambarka "2" ka dib hawl wadeenka "^". Ku sii socoshada tusaalihii hore, qaacidadu waxay noqonaysaa "= 5^2".
• Riix furaha GeliKa dib markaad dhamaystirto qaacidada, taabo furaha ku yaala kiiboodhkaaga. Tani waxay u oggolaan doontaa Excel inuu xisaabiyo natiijada oo uu ku muujiyo lambarka labajibbaaran ee unugga la doortay.

S&J

1. Sideen ugu soo koobayaa nambar Excel?

Si aad u cabbirto nambar gudaha Excel, waa inaad raacdaa tillaabooyinkan:

1. Dooro unugga aad rabto in natiijadu ka soo muuqato.
2. Qoraa =n^2, halka "n" uu yahay lambarka aad rabto inaad labajibbaarto.
3. Ku dhufo furaha Gelida

2. Sideen u barbardhigi karaa tirooyinka taxanaha ah ee Excel?

Haddii aad rabto in aad isku koobto tirooyin taxane ah oo Excel ah, waxaad samayn kartaa sida soo socota:

1. Dooro unugga meesha aad rabto in natiijada ugu horreysa ay ka soo baxdo.
2. Qoraa =A1^2, haddii "A1" uu yahay unugga uu ku yaal lambarka koowaad ee taxanaha.
3. Ku dhufo furaha Gelida
4. Hoos u jiid qaacidada si aad ugu dabaqdo tirooyinka intiisa kale.

3. Sida loo isticmaalo shaqada AWOODDA in la isku koobo nambar Excel?

Si aad u isticmaasho shaqada POWER gudaha Excel, waa inaad raacdaa talaabooyinkan:

1. Dooro unugga aad rabto in natiijadu ka soo muuqato.
2. Qoraa =Awood(n;2) halka "n" uu yahay lambarka aad rabto inaad labajibaarto.
3. Ugu dambeyntii, taabo furaha Enter si aad natiijada u hesho.

4. Ma jiraa qaacido loogu talagalay tirooyinka labajibbaaran ee Excel?

Haa, waxaa jira qaacido loogu talagalay tirooyinka labajibbaaran ee Excel. Way fududahay sida wax ku qorista "= n^2", halkaas oo "n" ay tahay tirada la laba jibaaranayo iyo "^" oo ka dhigan hawl-galka xisaabeed ee labajibbaaran.

5. Sideen ugu dhejin karaa lambar labajibbaaran isla unugga Excel?

Waxaad ku dhejin kartaa lambar labajibbaaran isla unugga sida soo socota:

1. Guji unugga lambarka aad rabto inaad laba jibaaranto.
2. Qoraa =RC[0]^2 ku jira qaacidada.
3. Riix furaha Gelida

6. Sideen tirooyinka labajibaaran karaa anigoon isticmaalin shaqada AWOODDA ee Excel?

Waxaad ku labajibaari kartaa tirooyinka Excel la'aanteed shaqada AWOODDA. Kaliya raac talaabooyinkan:

1. Dooro unugga meesha aad rabto in natiijada ku taal.
2. Qoraa =n^2 gudaha bar qaacidada, halkaas oo "n" uu yahay lambarka aad rabto in aad laba jibaarto.
3. Ugu dambeyntii, taabo furaha Enter.

7. Sideen isku geyn karaa unugyo kala duwan oo Excel ah?

Si aad isugu geyso unugyo kala duwan oo Excel ah, raac tillaabooyinkan:

1. Dooro unugga meesha aad rabto in natiijada ugu horreysa ay ka soo baxdo.
2. Qoraa =A1^2 (halka "A1" uu yahay unugga ugu horreeya ee kala duwan).
3. Ku dhufo furaha Gelida
4. Hoos u jiid caanaha si aad ugu dabaqdo unugyada intiisa kale ee xadka.

8. Ma isticmaali karaa Excel si aan u xisaabiyo xididka labajibbaaran ee tirada?

Haa, si loo xisaabiyo xididka laba jibaaran ee nambarka Excel, waa inaad raacdaa tillaabooyinkan:

1. Dooro unugga meesha aad rabto inaad jawaabta ka hesho.
2. Qoraa =SQRT(n), halka "n" uu yahay lambarka aad rabto inaad xididka ka hesho.
3. Riix furaha Geli.

9. Sideen ku heli karaa labajibbaaran lambar oo aan ugu soo bandhigaa unug kale oo Excel ah?

Si aad u hesho labajibbaaran lambar oo aad natiijada ugu muujiso unug kale, raac tillaabooyinkan:

1. Dooro unugga aad rabto in natiijadu ka soo muuqato.
2. Qoraa =n^2 (halka "n" uu yahay unugga ka kooban lambarka aad rabto inaad laba jibaarto).
3. Riix Gelida

10. Sideen ugu dhejin karaa lambarka unugga Excel anigoo isticmaalaya makro?

Si aad u jeexdid nambar gudaha unugga Excel adigoo isticmaalaya makro, raac tillaabooyinkan:

1. Riix Alt + F11 si aad u furto tafatiraha VBA.
2. Guji Gelida> Module.
3. Ku qor makro-ga lambar ee unugga. Tusaale ahaan: Range("A1").Qiimaha = Range("A1").Qiimaha ^ 2.
4. Riix F5 si aad u socodsiiso makro.