I-Excel Rolling Dice Teutorial

Lesi sifundo sihlanganisa indlela yokwakha uhlelo lwe-dice roller ku-Excel futhi isebenzisa amasu okufometha ukuveza ngokucacile ubuso obunye bendidi yedayisi.

Idayisi izobonisa inombolo engahleliwe eyenziwe ngu- RANDBETWEEN function. Amachashazi ebusweni bokufa adalwa ngokusebenzisa i-Wingdings font. Inhlanganisela ye- AND , i-IF, ne- OR isebenza ngokulawula uma amachashazi avela esitokisini ngasinye sedayisi. Kuye ngezinombolo ezihleliwe ezikhiqizwa yimisebenzi ye-RANDBETWEEN, amachashazi azovela kumaseli afanele edayisi ekhasini lokusebenzela . Ama-dice angakwazi "ukugoqa" ngokuphindaphindiwe ngokuphindaphinda ishidi lokusebenzela

01 ka 09

I-Excel Dice Roller Teutorial Steps

Izinyathelo zokwakha i-Excel Dice Roller zimi kanje:

1. Ukwakha i-Dice
2. Ukwengeza umsebenzi we-RANDBETWEEN
3. ImiSebenzi ngemuva kwamaDotshi: Ukuhlaziya imisebenzi ye-AND AND IF
4. Imisebenzi emva kwamaDots: Ukusebenzisa i-IF Function Alone
5. ImiSebenzi ngemuva kwamaDotshi: Ukuhlaziya imisebenzi ye-AND AND IF
6. Imisebenzi ngemuva kwamaDotshi: Ukuhlalisa imisebenzi ye-OR kanye ne-IF
7. Ukuhambisa i-Dice
8. Ukufihla imisebenzi ye-RANDBETWEEN

02 ka 09

Ukwakha i-Dice

Izinyathelo ezingezansi zimboze amasu okufometha asetshenziselwa ukubonisa ubuso obunye bendidi yedayisi ekhasini lakho lokusebenzela ukuze udale amadayisi amabili.

Izindlela zokufometha ezisetshenzisiwe zihlanganisa ukushintsha usayizi weseli, ukulungiswa kweseli, nokushintsha uhlobo lwefonti nosayizi.

• Hudula ukhethe amaseli D1 kuya ku-J3
• Setha ukuphakama komugqa wamaseli kuya ku-25
• Setha ububanzi bekholomu lala maseli ukuya ku-5
• Setha ukulungiswa kwamaseli okugxile kuya esikhungweni
• Setha ukulungiswa kweseli okuqondile kuya phakathi
• Setha uhlobo lwefonti kuma- Wingdings
• Setha usayizi wefonti ube ngu-30

Umbala wedayisi

1. Hudula ukhethe amaseli D1 kuya ku-F3
2. Setha umbala wesizinda sangasese ku-blue
3. Hudula ukhethe amaseli H1 kuya ku-J3
4. Setha umbala wesizinda sangemuva ube obomvu

03 ka 09

Ukwengeza umsebenzi we-RANDBETWEEN

Umsebenzi we- RANDBETWEEN usetshenziselwa ukukhiqiza izinombolo ezihleliwe eziboniswe kumadayisi amabili.

Ngokuba i-First Die

1. Chofoza kuseli E5.
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon .
3. Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza.
4. Chofoza ku- RANDBETWEEN ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi.
5. Chofoza kumugqa "ongaphansi" ebhokisini lengxoxo.
6. Thayipha inombolo 1 (eyodwa) kulolu gqa.
7. Chofoza kulayini "Ophezulu" ebhokisini lengxoxo.
8. Thayipha inombolo 6 (ayisithupha) kulolu gqa.
9. Chofoza OK.
10. Inombolo engahleliwe phakathi kuka-1 no-6 kufanele ivele kuseli E5.

Ukufa kwesibili

1. Chofoza kuseli I5.
2. Phinda izinyathelo ezimbili kuya ku-9 ngenhla.
3. Inombolo engahleliwe phakathi kuka-1 no-6 kufanele ibonakale esitokisini I5.

04 ka 09

Imisebenzi ngemuva kwamaDotshi (# 1)

Kumaseli D1 no-F3 thayipha umsebenzi olandelayo:

= IF (NOMA (E5> = 2, E5 <= 6), "l", "")

Lo msebenzi uvivinya ukubona ukuthi inombolo ehleliwe esitokisini se-E5 iphakathi kuka-2 no-6. Uma kunjalo, ifaka i- "l" kumaseli D1 no-F3. Uma kungenjalo, kushiya amangqamuzana angenalutho ("").

Ukuze uthole umphumela ofanayo wesibili ufe, kumaseli H1 noJ3 thayipha umsebenzi:

= IF (no (I5> = 2, I5 <= 6), "l", "")

Khumbula: Incwadi "l" (i-lowercase L) ichashaza kwifolda ye-Wingdings.

05 ka 09

Imisebenzi ngemuva kwamaDotshi (# 2)

Kumaseli D2 no-F2 thayipha umsebenzi olandelayo:

= IF (E5 = 6, "l", "")

Lo msebenzi uhlola ukuhlola ukuthi inombolo ehleliwe engqamuzaneni e-E5 ilingana no 6. Uma kunjalo, ifaka i- "l" kumaseli D2 no-F23. Uma kungenjalo, kushiya iseli lingenalutho ("").

Ukuze uthole umphumela ofanayo wesibili ufe, kuma-H2 no-J2 thayipha umsebenzi:

= IF (I5 = 6, "l", "")

Khumbula: Incwadi "l" (i-lowercase L) ichashaza kwifolda ye-Wingdings.

06 ka 09

Imisebenzi ngemuva kwamaDotshi (# 3)

Kumaseli D3 no-F1 thayipha umsebenzi olandelayo:

= IF (NOMA (E5> = 4, E5 <= 6), "l", "")

Lo msebenzi uhlola ukuhlola ukuthi inombolo ehleliwe e-cell E5 iphakathi kuka-4 no-6. Uma kunjalo, ifaka i- "l" kumaseli D1 no-F3. Uma kungenjalo, kushiya amangqamuzana angenalutho ("").

Ukuze uthole umphumela ofanayo wesibili ufe, kumaseli H3 no-J1 thayipha umsebenzi:

= IF (NOMA (I5> = 4, I5 <= 6), "l", "")

Khumbula: Incwadi "l" (i-lowercase L) ichashaza kwifolda ye-Wingdings.

07 ka 09

Imisebenzi ngemuva kwamaDotshi (# 4)

E-cell E2 thayipha umsebenzi olandelayo:

= IF (OR (E5 = 1, E5 = 3, E5 = 5), "l", "")

Lo msebenzi uhlola ukuhlola ukuthi inombolo ehleliwe e-cell E2 ilingana no-1, 3, noma 5. Uma kunjalo, ifaka i- "l" kuseli E2. Uma kungenjalo, kushiya iseli lingenalutho ("").

Ukuze uthole umphumela ofanayo wesibili ufe, kuseli cell I2 uthayiphe umsebenzi:

= IF (OR (I5 = 1, I5 = 3, I5 = 5), "l", "")

Khumbula: Incwadi "l" (i-lowercase L) ichashaza kwifolda ye-Wingdings.

08 ka 09

Ukuhambisa i-Dice

Ukuze "uqhube" idayisi, cindezela ikhi F 9 ekhibhodi.

Ukwenza lokhu, kubangela i-Excel ukuthi ibuyele kabusha yonke imisebenzi kanye namafomula kwiphepha lokusebenzela . Lokhu kuzobangela imisebenzi ye- RANDBETWEEN kuma-cell E5 no-I5 ukukhiqiza enye inombolo engahleliwe phakathi kuka-1 no-6.

09 ka 09

Ukufihla umsebenzi we-RANDBETWEEN

Uma idayisi iqedile futhi yonke imisebenzi ihlolwe ukuqinisekisa ukuthi isebenzayo kahle, imisebenzi ye- RANDBETWEEN kuma-cell E5 no-I5 ingafihlwa.

Ukufihla imisebenzi kuyisinyathelo sokuzikhethela. Ukwenza kanjalo kufakazela "imfihlakalo" yokuthi i-roller ye-dice isebenza kanjani.

Ukufihla imisebenzi ye-RANDBETWEEN

1. Hudula ukhethe amaseli E5 kuya ku-I5.
   
2. Shintsha umbala wefonti wale maseli ukufanisa umbala wangemuva. Kulesi simo, sishintshe ukuthi "mhlophe".