Mmene Mungakhalire Nambala Zowonongeka Ndi Ntchito ya RAND ya Excel

01 ya 01

Pangani Phindu Labwino Pakati pa 0 ndi 1 ndi RAND Ntchito

Njira imodzi yopangira manambala osakanikirana mu Excel ali ndi RAND ntchito.

Pokhapokha, ntchitoyo imapanga mawerengero angapo osalongosoka, koma pogwiritsira ntchito RAND mu machitidwe ndi ntchito zina, zikhalidwe zambiri, monga momwe zasonyezedwera pa chithunzi pamwambapa, zikhoza kufalikira mosavuta kuti:

• Pogwiritsa ntchito mfundo zapamwamba komanso zochepa zazitali , RAND ikhoza kupangidwa kuti abwerere chiwerengero chosavuta mwachindunji - monga 1 ndi 10 kapena 1 ndi 100
• Zomwe zimagwira ntchito zimatha kuchepetsedwa kukhala ochepa mwa kuphatikiza ntchito ndi TRUNC ntchito , yomwe imadula kapena kuchotsa malo onse osungira kuchokera ku chiwerengero.

Zindikirani : Malingana ndi fayilo yothandizira ya Excel, ntchito ya RAND imabweretsanso chiwerengero chogawanika choposa kuposa kapena chofanana ndi 0 ndi zosachepera 1 .

Izi zikutanthawuza kuti ngakhale kuti ndi zachilendo kufotokozera zikhalidwe zomwe zimapangidwa ndi ntchito monga kuyambira 0 mpaka 1, zoona, zenizeni kunena kuti kusiyana kuli pakati pa 0 ndi 0.99999999 ....

Mwachiwonetsero chomwecho, njira yomwe imabweretsera nambala yosawerengeka pakati pa 1 ndi 10 imabweretsanso mtengo pakati pa 0 ndi 9.999999 ....

Syntax ya RAND Function

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito ya RAND ndi:

= RAND ()

Mosiyana ndi RANDBETWEEN ntchito , yomwe imakhala ndi mfundo zazikulu komanso zotsika zotsimikizirika, ntchito ya RAND sichimvetseratu zotsutsana.

ZOYENERA KUGWIRITSA NTCHITO ZOCHITA

M'munsimu muli zofunikira zofunikira kuti mubweretse zitsanzo zomwe zawonetsedwa pa chithunzi pamwambapa.

1. Woyamba akulowa mu RAND ntchito yokha;
2. Chitsanzo chachiwiri chimapanga ndondomeko yomwe imapanga chiwerengero chosasintha pakati pa 1 ndi 10 kapena 1 ndi 100;
3. Chitsanzo chachitatu chimapanga chiwerengero chokhazikika pakati pa 1 ndi 10 pogwiritsa ntchito ntchito TRUNC;
4. Chitsanzo chotsiriza chimagwiritsa ntchito ntchito ya ROUND kuchepetsa chiwerengero cha malo osungirako kwa nambala zosawerengeka.

Chitsanzo 1: Kulowa ntchito ya RAND

Popeza kuti ntchito ya RAND siimabweretsa zifukwa, zimatha kulowetsedwa mu selo iliyonse yamagetsi pokhapokha pang'onopang'ono pa selo ndi kuyimba:

= RAND ()

ndi kukanikiza fungulo lolowamo ku Enter. Chotsatiracho chidzakhala nambala yosawerengeka pakati pa 0 ndi 1 mu selo.

Chitsanzo chachiwiri: Kupanga Ma random Numeri pakati pa 1 ndi 10 kapena 1 ndi 100

Maonekedwe onse a equation omwe amagwiritsidwa ntchito popanga nambala yosadziwika mwachindunji ndiyi:

= RAND () * (High-Low) + Low

kumene Kumwamba ndi Kutsika kumatanthauza malire apamwamba ndi apansi a manambala omwe mukufuna.

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 10 kulowetsani ndondomeko zotsatirazi mu selo lamasamba:

= RAND () * (10 - 1) + 1

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 100 kulowa mndandanda wotsatirayi mu selo lamasamba:

= RAND () * (100 - 1) + 1

Chitsanzo chachitatu: Kupanga Ma Random Integers pakati pa 1 ndi 10

Kubwezera chiwerengero - chiwerengero chonse chopanda gawo - gawo lonse la equation ndi:

= TRUNC (RAND () * (High-Low) + Low)

Kupanga chiwerengero chokhazikika pakati pa 1 ndi 10 kulowetsani ndondomeko zotsatirazi mu selo lamasamba:

= TRUNC (RAND () * (10 - 1) + 1)

CHIKONDO NDI CHIKONDI: Pezani Malo Otsalira

M'malo mochotsa malo onse otsiriza ndi ntchito ya TRUNC, chitsanzo chomaliza pamwambapa chimagwiritsa ntchito ntchito yotsatirayi motsatira ndi RAND kuti kuchepetsa chiwerengero cha malo apamwamba mu nambala yosawerengeka mpaka ziwiri.

= ROUND () * (* * * (100-1) +2,2)

Ntchito ya RAND ndi Kusakhazikika

Ntchito ya RAND ndi imodzi mwa ntchito za Excel zosasinthasintha . Izi zikutanthauza kuti:

• Ntchitoyi imagwirizanitsa - imapanga chiwerengero chatsopano - nthawi iliyonse tsamba lamasinthidwe, ndipo izi zikuphatikizapo zochita monga kuwonjezera deta yatsopano.
• Njira iliyonse yomwe imadalira - kaya mwachindunji kapena mwachindunji - mu selo yomwe ili ndi ntchito yosasinthasintha idzakhalanso kubwereza nthawi iliyonse kusintha kwa tsambali likuchitika.
• M'mapukutu kapena mabuku ogwira ntchito omwe ali ndi deta yambiri, ntchito zowonongeka ziyenera kukhala zogwiritsa ntchito mosamala pamene zingachepetse nthawi yowonjezera pulojekiti chifukwa cha kuwerengedwa kwafupipafupi.

Yambani ndi Imani Zotsatira Zambiri za Nambala ndi F9

Kukakamiza ntchito ya RAND kupanga maulendo atsopano osasintha popanda kupanga zina kusintha pa tsambali zingathekanso kukwaniritsira f9 Fungulo pa keyboard. Izi zimapangitsa kuti pepala lonselo likhazikitsenso - kuphatikizapo maselo aliwonse omwe ali ndi RAND ntchito.

Mfungulo F9 ukhozanso kugwiritsidwa ntchito popewera nambala yosasintha yosintha nthawi iliyonse kusintha kumapangidwira pa tsamba, pogwiritsa ntchito njira zotsatirazi:

1. Dinani pa selo lamasewera, komwe nambala yosawerengeka iyenera kukhala
2. Lembani ntchito = RAND () mu barra yachitsulo pamwamba pa tsamba
3. Dinani fungulo F9 kuti musinthe ntchito ya RAND mu nambala yosawerengeka
4. Lembani fungulo lolowamo lolowera ku kiyibokosi kuti mulowe nambala yosasintha mu selo losankhidwa
5. Kulimbikitsanso F9 sikudzakhalanso ndi zotsatira pa nambala yosasintha

Bokosi la Ntchito la RAND

Pafupifupi zonse zomwe zili mu Excel zingalowetsedwe pogwiritsa ntchito bokosi la malumikizowo m'malo mowalowa mwadongosolo. Kuti tichite zimenezi, ntchito ya RAND ikhale njira zotsatirazi:

1. Dinani pa selo patsiku la zolemba kumene zotsatira za ntchito ziyenera kuwonetsedwa;
2. Dinani pa Fomu tab ya riboni ;
3. Sankhani Math & Trig kuchokera paboni kuti mutsegule ntchito yolemba pansi;
4. Dinani pa RAND mu mndandanda;
5. Funso la bokosi la ntchito liri ndi mfundo zomwe ntchitoyo sizitenga zotsutsana;
6. Dinani OK kuti mutseke bokosi la bokosi ndikubweranso ku tsamba la ntchito;
7. Nambala yosawerengeka pakati pa 0 ndi 1 iyenera kuonekera mu selo yamakono;
8. Kuti mupange winayo, yesani key F9 pa keyboard;
9. Mukasindikiza pa selo E1, ntchito yonse = RAND () ikuwoneka mu barra yazenera pamwamba pa tsamba.

Ntchito ya RAND mu Microsoft Word ndi PowerPoint

Ntchito ya RAND ikhoza kugwiritsidwanso ntchito pazinthu zina za Microsoft Office, monga Mawu ndi PowerPoint, kuwonjezera ndime zosasintha za deta kapena chiwonetsero. Ntchito imodzi yogwiritsira ntchito imeneyi ndi yodzaza zinthu zamakono.

Kuti mugwiritse ntchito izi, lowetsani ntchitoyo mofanana mu mapulogalamu ena monga Excel:

1. Dinani ndi mbewa pamalo pomwe ndimeyo iyenera kuwonjezeredwa;
2. Mtundu = RAND ();
3. Dinani ku key lolowamo pa khibhodi.

Chiwerengero cha ndime za malemba osasintha chimasiyana malinga ndi momwe ntchitoyo imagwiritsidwira ntchito. Mwachitsanzo, Mawu 2013 amapanga ndime zisanu zalemba mosasintha, pamene Mawu 2010 amapanga atatu okha.

Kuti muwone kuchuluka kwa malemba, lowetsani nambala ya ndime zofunidwa ngati mkangano pakati pa mabakita opanda kanthu.

Mwachitsanzo,

= NJIRA (7)

adzapereka ndime zisanu ndi ziŵiri zalemba pamalo omwe asankhidwa.