Indlela yokuvelisa amanqaku angakhanjiswanga nge-Operation RAND ye-Excel

01 ngo 01

Ukuvelisa ixabiso elingenalutho phakathi kwama-0 no-1 kunye nomsebenzi we-RAND

Enye indlela yokuvelisa iinombolo ezingenangqangi kwi-Excel yinkqubo ye-RAND.

Ngokwalo, umsebenzi uvelisa uluhlu oluthile lweenombolo ezingahleliwe, kodwa ngokusebenzisa i-RAND kumafomula kunye neminye imisebenzi, uluhlu lwexabiso, njengoko kuboniswe kumfanekiso ongentla, lunokwandiswa lula ukuze:

• Ngokucacisa amaxabiso aphakamileyo aphantsi kwimiba , i-RAND ingenziwa ukubuyisela amanani angenangqangi phakathi kwecandelo elikhankanywe - njenge-1 ne-10 okanye i-1 kunye ne-100
• Isiphumo somsebenzi sinokuncitshiswa sibe yi-integers ngokudibanisa umsebenzi nomsebenzi we-TRUNC , othembisa okanye ususe zonke iindawo zokugqibela ukusuka kwinombolo.

Qaphela : Ngokutsho kwefayile yenkxaso ye-Excel, umsebenzi we-RAND ubuyisela inombolo ekhutshwe ngokulinganayo kunokuba ilingana no-0 nangaphantsi kwe-1 .

Kuthetha ukuthini ukuba ngelixa kuqhelekile ukuchaza uluhlu lwamaxabiso olwenziwe ngumsebenzi ovela ku-0 ukuya ku-1, inyaniso, kuchaneke ngakumbi ukuba uluhlu luphakathi kwe-0 kunye ne-0.99999999 ....

Ngomqondiso ofanayo, ifom ebuyisela inombolo engalindelekanga phakathi kwe-1 no-10 ibuyisela ixabiso phakathi kwe-0 no-9.999999 ....

I-syntax ye-RAND yomsebenzi

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .

I-syntax yomsebenzi we-RAND yile:

= RAND ()

Ngokungafani nomsebenzi we-RANDBETWEEN , ofuna iingxabano eziphakamileyo kunye eziphantsi ukuba zichazwe, umsebenzi we-RAND awwamkeli iimbambano.

UMSEBENZI Wemisebenzi

Ngezantsi zidweliswe amanyathelo afunekayo ukuvelisa imizekelo eboniswe kumfanekiso ongentla.

1. Umntu wokuqala ungena kumsebenzi we-RAND ngokwawo;
2. Umzekelo wesibini udala umhlathi ovelisa inombolo ehleliweyo phakathi kwe-1 no-10 okanye i-1 kunye ne-100;
3. Umzekelo wesithathu ukhiqiza inamba engahleliyo phakathi kwe-1 no-10 usebenzisa umsebenzi we-TRUNC;
4. Umzekelo wokugqibela usebenzisa umsebenzi we-ROUND ukunciphisa inani leendawo zokugqibela zeenombolo ezingenanto.

Umzekelo 1: Ukufaka umsebenzi weRAND

Ekubeni umsebenzi we-RAND awuthathi ngxabano, unokungenwa kalula kwiiselithi zefayile kuphela ngokuchofoza iseli kunye nokuthayipha:

= RAND ()

kwaye ucinezela ukhiye wokungena kwikhibhodi. Isiphumo siya kuba yinombolo engahleliyo phakathi kwe-0 no-1 kwiseli.

Umzekelo wesi-2: Ukuvelisa iinombolo zeRandom phakathi kwe-1 no-10 okanye i-1 kunye ne-100

Ifom ejwayelekile ye-equation esetyenziselwa ukuvelisa inombolo engalindelekanga kwinqanaba elikhankanyiweyo kukuba:

= I-RAND () * (Ephakamileyo - Ephantsi) + Ephantsi

apho iphakamileyo kunye nezantsi ibonisa imida engenasentla kunye nezantsi efunyenweyo yamanani.

Ukuvelisa inombolo ekhethiweyo phakathi kwe-1 no-10 faka ifom elandelayo kwiseli yomsebenzi:

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

Ukuvelisa inombolo ekhethiweyo phakathi kwe-1 no-100 faka ifom elandelayo kwiseli yomsebenzi:

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

Umzekelo wesi-3: Ukuvelisa ama-Random Integers phakathi kwe-1 no-10

Ukubuyisela i-integer - inombolo epheleleyo engenaso isahlulo esiphezulu - ifom ejwayelekile ye-equation yile:

= I-TRUNC (RAND () * (Ephakamileyo - Ephantsi) + Ephantsi)

Ukwenza i-integer ehleliweyo phakathi kwe-1 no-10 faka ifom elandelayo kwiseli yomsebenzi:

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

I-RAND ne-ROUND: Ukunciphisa iindawo eziMisiweyo

Esikhundleni sokususa zonke iindawo zokugqibela kunye nomsebenzi we-TRUNC, umzekelo wokugqibela ongasentla usasebenzisa umsebenzi olandelayo weROUND ngokubambisana ne-RAND ukunciphisa inani leendawo zokugqibela kwi-random number ukuya kubini.

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

Umsebenzi weRAND kunye noVuqu

Umsebenzi we-RAND ungomnye wemisebenzi engaxhamliyo ye-Excel. Oko kuthetha ukuthini:

• Umsebenzi uqalisa kwakhona - uvelisa inani elitsha elingenanto - rhoqo xa iphepha lokusebenzela litshintshwa, kwaye oku kubandakanye nezenzo ezifana nokungongeza idatha entsha.
• Nayiphi na ifom exhomekeke kuyo - ngokuthe ngqo okanye ngokungathanga ngqo - kwiseli equkethe umsebenzi ongeyantlupheko iya kuphinda iphinde iphinde iguquke rhoqo xa utshintsho kwiphepha lokusebenzela lwenzeka.
• Kwiphepha lokusebenzela okanye iincwadi zokusebenzela ezinamanani amaninzi edatha, imisebenzi enokuzenzekelayo kufuneka isebenziswe ngokuqapha njengoko inganciphisa ixesha lokuphendula leprogram ngenxa yobunzima bokuphindaphinda.

Qala kunye neNqama yeNombolo yesiHlomelo ngeF9

Ukuphoqelela umsebenzi we-RAND ukuvelisa amanani amanani angakhanjwanga ngaphandle kokwenza ezinye utshintsho kwiphepha lokusebenzela lungenziwa ngokucinezela iqhosha le- F9 kwibhodibhodi. Oku kwenza ukuba lonke iphepha lokusebenzela liphinde lenzeke kwakhona - kubandakanywa nayiphi na iseli equkethe umsebenzi we-RAND.

Incoko yeF9 ingasetyenziselwa ukunqanda inombolo engalindelekanga ekutshintsheni rhoqo ngexesha utshintsho lwenziwa kwiphepha lokusebenzela, usebenzisa amanyathelo alandelayo:

1. Cofa kwiseli yomsebenzi, apho inombolo ehleliyo ihlala khona
2. Thayipha umsebenzi = RAND () kwibha yefomula ngaphezu kwephepha lokusebenzela
3. Cinezela iqhosha le- F9 ukutshintsha umsebenzi we-RAND kwinombolo ye-randatic random
4. Cinezela ukhiye wokungena kwibhodibhodi ukufaka inombolo engalindelekanga kwiseli ekhethiweyo
5. Ukuxhaswa kwakhona kweF9 kwakhona akusayi kuba nempembelelo kwinani elingenanto

Ibhokisi yeNtsebenzo ye-RAND

Phantse yonke imisebenzi kwi-Excel ingangeniswa usebenzisa ibhokisi yencoko kunokuba ungene ngesandla. Ukwenza njalo ukuze umsebenzi we-RAND usebenzise amanyathelo alandelayo:

1. Cofa kwiseli kwiphepha lokusebenzela apho iziphumo zomsebenzi ziza kuboniswa khona;
2. Cofa kwiThebhu yefomula yerbhoni ;
3. Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwi- RAND kwoluhlu;
5. Ibhokisi yencoko yencoko yomsebenzi iqulethe ulwazi lokuba umsebenzi awuthathi nxaxheba.
6. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela;
7. Inombolo engahleliweyo phakathi kwe-0 no-1 kufuneka ibonakale kwiseli langoku;
8. Ukwenza omnye, cofa iqhosha le- F9 kwibhodibhodi;
9. Xa ucofa kwi-cell E1, umsebenzi opheleleyo = I-RAND () ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

Umsebenzi we-RAND kwi-Microsoft Word kunye nePowerPoint

Umsebenzi we-RAND ungasetyenziselwa kwezinye iinkqubo ze-Microsoft Office, ezifana neLizwi kunye nePowerPoint, ukufaka imihlathi engapheliyo kwidokethi okanye ukunikezelwa. Enye into enokusetyenziswa ngayo le mpawu injengomxholo wokugcwalisa kwiimodeli.

Ukusebenzisa le mpawu, faka umsebenzi ngendlela efanayo kuleminye iiprogram njenge-Excel:

1. Cofa kunye nemouse endaweni apho isicatshulwa siya kudibaniswa khona;
2. Uhlobo = RAND ();
3. Cinezela ukhiye wokungena kwikhibhodi.

Inani lemihlathi yesicatshulwa esingenanto ihluka ngoxhomekeke kwenguqu yeprogram esetyenzisiweyo. Ngokomzekelo, iZwi lika-2013 livelisa imihlathi emihlanu yesicatshulwa ngokungagqibekanga, ngelixa iLizwi lika-2010 lenza ezintathu kuphela.

Ukulawula inani leetekisi ezifakiwe, faka inani leimfuno ezifunwayo njengengxabano phakathi kweebhanki ezingenanto.

Umzekelo,

= I-RAND (7)

iya kuvelisa imihlathi ekhomba yesicatshulwa kwindawo ekhethiweyo.