Excel Rolling Dice Tutorial

Phunziroli limapanga momwe angapangire pulogalamu yachitsulo mu Excel ndipo amagwiritsa ntchito njira zojambula kuti ziwonetsere nkhope imodzi ya awiriwa.

Dice iwonetsa nambala yosasinthika yopangidwa ndi RANDBETWEEN ntchito. Madontho pa nkhope zakufa amapangidwa pogwiritsira ntchito font Wingdings. Kuphatikiza kwa AND , IF, ndi OR kumayendetsa pamene madontho amawonekera mu selo iliyonse ya adondomeko. Malingana ndi manambala osasinthasintha opangidwa ndi RANDBETWEEN ntchito, madontho adzawoneka m'maselo oyenerera a tsambalo mu tsamba la ntchito . Madzi akhoza "kugubudulidwa" mobwerezabwereza powerenga kachiwiri

01 ya 09

Zolemba za Excel Dragler Tutorial Steps

Njira zowonjezera Excel Dice Roller ndi izi:

1. Kumanga Dice
2. Kuwonjezera Ntchito YOPHUNZITSIDWA
3. The Functions behind the Dots: Kupeza NDI NDI ngati IF Functions
4. The Functions behind the Dots: Kugwiritsa ntchito IF Function Alone
5. The Functions behind the Dots: Kupeza NDI NDI ngati IF Functions
6. The Functions behind the Dots: Kupeza ntchito OR ndi IF
7. Kupukuta Dice
8. Kubisa ntchito ZONSE

02 a 09

Kumanga Dice

Mapepala omwe ali m'munsiyi awonetsere njira zomwe zimagwiritsidwa ntchito pojambula bwino nkhope imodzi ya mapepala mu tsamba lanu kuti mupange maice awiri.

Njira zogwiritsa ntchito zimaphatikizapo kusintha kusinthana kwa selo, kusuntha kwa selo, ndi kusintha mtundu wa maonekedwe ndi kukula.

• Kokani osankha maselo D1 mpaka J3
• Ikani kutalika kwa mzere wa maselowa mpaka 25
• Ikani chigawo cha m'kati mwa maselowa kufika 5
• Ikani kusinthasintha kwa maselo osasunthika kuti muyambe
• Ikani mawonekedwe oyendetsa maselo pakati
• Ikani mtundu wazithunzi kwa Wingdings
• Ikani kukula kwazithunzi kufikira 30

Mtundu wa mandimu

1. Kokani osankha maselo D1 mpaka F3
2. Ikani mtundu wa chigawo cha selo ku buluu
3. Kokani osankhira maselo H1 ku J3
4. Ikani mtundu wa chigawo cha selo kuti ukhale wofiira

03 a 09

Kuwonjezera Ntchito YOPHUNZITSIDWA

Ntchito YAM'MBUYO YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI ILI MU KOPERANI MAPODIKASITI MITU YA NKHANI

Kwa First Die

1. Dinani pa selo E5.
2. Dinani pa Fomu tab ya menyu yowonjezera.
3. Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi.
4. Dinani PAMODZI mndandanda kuti mubweretse bokosi lazokambirana.
5. Dinani pa mzere wa "pansi" mu bokosi la dialog.
6. Lembani nambala 1 (imodzi) pamzerewu.
7. Dinani pa "Top" mzere mubox.
8. Lembani nambala 6 (zisanu ndi chimodzi) pamzerewu.
9. Dinani OK.
10. Nambala yosasintha pakati pa 1 ndi 6 iyenera kuoneka mu selo E5.

Kwachiwiri Kumwalira

1. Dinani pa selo I5.
2. Bwerezaninso masitepe 2 mpaka 9 pamwambapa.
3. Nambala yosasintha pakati pa 1 ndi 6 iyenera kuoneka mu selo I5.

04 a 09

The Functions behind the Dots (# 1)

Maselo D1 ndi F3 akuyimira ntchito zotsatirazi:

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

Ntchitoyi ikuyesera kuti awone ngati nambala yosawerengeka mu selo E5 ili pakati pa 2 ndi 6. Ngati ndi choncho, imayika "l" m'maselo D1 ndi F3. Ngati sichoncho, zimasiya maselo opanda kanthu ("").

Kuti mutenge zotsatira zomwezo zachiwiri kufa, maselo H1 ndi J3 ayambe ntchitoyi:

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

Kumbukirani: Kalata "l" (lowercase L) ndi dontho muzithunzi za Wingdings.

05 ya 09

The Functions behind the Dots (# 2)

Maselo D2 ndi F2 akuyimira ntchito zotsatirazi:

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

Ntchitoyi ikuyesera kuti muwone ngati nambala yosawerengeka mu selo E5 ili yofanana ndi 6. Ngati ndi choncho, imayika "l" m'maselo D2 ndi F23. Ngati sichoncho, zimachoka mu selo ("").

Kuti mutenge zotsatira zomwezo zachiwiri kufa, m'maselo H2 ndi J2 ayambe ntchitoyi:

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

Kumbukirani: Kalata "l" (lowercase L) ndi dontho muzithunzi za Wingdings.

06 ya 09

The Functions behind the Dots (# 3)

Maselo D3 ndi F1 akuyimira ntchito zotsatirazi:

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

Ntchitoyi ikuyesera kuti muwone ngati nambala yopanda malire mu selo E5 ili pakati pa 4 ndi 6. Ngati ndi choncho, imayika "l" m'maselo D1 ndi F3. Ngati sichoncho, zimasiya maselo opanda kanthu ("").

Kuti mutenge zotsatira zomwezo zachiwiri kufa, mu maselo H3 ndi J1 ayambe ntchitoyi:

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

Kumbukirani: Kalata "l" (lowercase L) ndi dontho muzithunzi za Wingdings.

07 cha 09

The Functions behind the Dots (# 4)

Mu selo E2 tchulani ntchito yotsatirayi:

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

Ntchitoyi ikuyesera kuti muwone ngati nambala yosawerengeka mu selo E2 ili yofanana ndi 1, 3, kapena 5. Ngati ndi choncho, imayika "l" mu selo E2. Ngati sichoncho, zimachoka mu selo ("").

Kuti mutenge zotsatira zomwezo zachiwiri, afa mu selo I2 akuyimira ntchitoyi:

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

Kumbukirani: Kalata "l" (lowercase L) ndi dontho muzithunzi za Wingdings.

08 ya 09

Kupukuta Dice

Kuti "mutenge" makinawo, yesani key 9 F pa makiyi.

Kuchita izi, kumayambitsa Excel kuti ayambitsenso ntchito zonse ndi mawonekedwe pa tsamba la ntchito . Izi zidzachititsa kuti RANDBETWEEN izigwira ntchito m'maselo E5 ndi I5 kuti apange nambala yodziwika pakati pa 1 ndi 6.

09 ya 09

Kubisa ntchito YAM'MBUYO

Dice likadzatha ndipo ntchito zonse zayesedwa kuti zitsimikizire kuti zikugwira ntchito bwino, ZINTHU zimagwiritsidwa ntchito m'maselo E5 ndi I5.

Kubisa ntchito ndichinthu chofunikira. Kuchita zimenezi kumaphatikizapo ku "chinsinsi" cha momwe disi ya roller imagwirira ntchito.

Kubisa Ntchito ZONSE

1. Kokani osankha maselo E5 kuti I5.
   
2. Sinthani mtundu wa maonekedwe a maselowa kuti mufanane ndi mtundu wa chiyambi. Pankhaniyi, yikani kuti "yoyera".