Yadda ake yin janareta kalmar sirri a cikin Excel?

Sabuntawa na karshe: 15/12/2023
Author: Sebastian Vidal

Idan kana neman hanya mai sauƙi don ƙirƙirar kalmomin sirri masu ƙarfi, kun zo wurin da ya dace. A cikin wannan labarin, za mu koya muku yadda ake yin janareta na kalmar sirri a cikin Excel ta amfani da wasu ayyuka masu sauƙi amma masu tasiri. Tare da ƴan matakai da ƙananan ilimin asali na Excel, zaku iya samar da ƙarfi, kalmomin shiga na al'ada a cikin minti kaɗan. Ba buƙatar ku zama ƙwararrun kwamfuta don bin waɗannan matakan ba, don haka kada ku damu idan ba ku da ƙwarewa sosai da Excel. Ci gaba da karantawa kuma gano yadda yake da sauƙin ƙirƙirar janareta kalmar sirri a cikin wannan mashahurin kayan aikin maƙunsar bayanai!

– Mataki-mataki ➡️ Yadda ake yin janareta na kalmar sirri a cikin Excel?

  • Hanyar 1: Bude Microsoft Excel akan kwamfutarka.
  • Hanyar 2: Danna shafin "Developer" a saman allon. Idan baku ga wannan shafin ba, je zuwa "Fayil"> "Zaɓuɓɓuka"> "Customize Ribbon" kuma duba akwatin "Developer".
  • Hanyar 3: Da zarar a cikin "Developer" tab, danna kan "Visual Basic" button don bude Visual Basic Edita.
  • Hanyar 4: A cikin Visual Basic Editan, danna "Saka" kuma zaɓi "Module." Wannan zai haifar da sabon tsari a cikin aikin.
  • Hanyar 5: Yanzu, kwafi da liƙa wannan lambar a cikin tsarin da kuka ƙirƙira yanzu:
Keɓaɓɓen abun ciki - Danna nan  Haɗa Audio cikin Gabatarwar PowerPoint: Hanyar Fasaha

"vb
Aiki GeneratePassword(tsawo A Matsayin Integer) A matsayin String
Const haruffa As String = «ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!@#$%&»
Dim kalmar sirri As String
Bazuwar
Yi Yayin Len (kalmar sirri) <tsawon kalmar sirri = kalmar sirri & Tsakanin (chars, Int ((Len (chars) * Rnd) + 1), 1) Loop GeneratePassword = kalmar wucewa ta Ƙarshen Aiki ```

  • Hanyar 6: Ajiye ku rufe Editan Kayayyakin Kayayyakin gani.
  • Hanyar 7: Koma zuwa takardar Excel ɗin ku kuma zaɓi tantanin halitta wanda kuke son ƙirƙirar kalmar sirri ta bayyana.
  • Hanyar 8: A cikin mashaya dabara, rubuta = Ƙirƙirar Kalmar wucewa (tsawo), inda "tsawon" shine adadin haruffan da kuke son kalmar sirri ta kasance.
  • Hanyar 9: Danna "Enter" kuma za ku ga cewa za a samar da sabuwar kalmar sirri a cikin tantanin halitta da kuka zaba.

Tambaya&A

Tambayoyi akai-akai: Yadda ake Yin Generator Password a Excel

1. Ta yaya zan iya ƙirƙirar janareta kalmar sirri a cikin Excel mataki-mataki?

1. Bude Excel a kan kwamfutarka.
2. Danna wani tantanin halitta mara komai.
3. Rubuta dabarar = HALAYE( sannan kuma adadin haruffan da kake son kalmar sirri ta kasance.
4. Rufe bakan gizo kuma latsa Shigar.

2. Ta yaya zan iya samar da kalmar sirri bazuwar a cikin Excel?

1. Bude Excel akan kungiyar ku.
2. Danna komai a cell.
3. Rubuta dabarar = CIN GINDI(HALI (RANDBETWEEN(65,90)),SABIYYA (RANDBETWEEN(97,122)), HALI (RANDBETWEEN(48,57))).
4. Latsa Shigar.

Keɓaɓɓen abun ciki - Danna nan  Yadda ake sanin lambar lambar haraji na

3. Ta yaya zan iya kare tantanin halitta mai dauke da kalmar sirri da aka samar a cikin Excel?

1. Zaɓi tantanin halitta tare da kalmar sirri da aka samar.
2. Danna kan shafin Don dubawa a saman Excel.
3. Zaɓi Kare takardar.
4. Saita kalmar sirri don kare takardar.

4. Ta yaya zan iya ƙara ƙuntatawa ga ƙirƙirar kalmar sirri a cikin Excel?

1. Bude Excel kuma danna kan komai a ciki.
2. Yi amfani da aikin = HALI (RANDETWEEN(65,90)) don samar da babban harafi bazuwar.
3. Yi amfani da aikin = HALI (RANDETWEEN(97,122)) don samar da ƙaramin harafi bazuwar.
4. Yi amfani da aikin = HALI (RANDETWEEN(48,57)) don samar da lambar bazuwar.
5. Yi amfani da aikin = HALI (RANDETWEEN(33,47)) don haifar da bazuwar hali na musamman.

5. Ta yaya zan iya tsara tsarin kalmar sirri da aka samar a cikin Excel?

1. Bude Excel a kan kwamfutarka.
2. Danna komai a cell.
3. Rubuta haɗin ayyuka = HALIN () da duk wani ƙarin haruffa da kuke so.

6. Ta yaya zan iya samar da rukunin kalmomin shiga a cikin Excel?

1. Bude Excel akan kungiyar ku.
2. Rubuta dabara don samar da kalmar sirri a cikin tantanin halitta.
3. Jawo kusurwar dama ta ƙasa zuwa ƙasa don samar da kalmomin shiga da yawa.

Keɓaɓɓen abun ciki - Danna nan  Yadda za a mai da Deleted hotuna da Recuva a cikin sauki hanya?

7. Ta yaya zan iya hana ƙirƙirar kalmomin shiga daga maimaitawa a cikin Excel?

1. Bude Excel a kan kwamfutarka.
2. Yi amfani da aikin = CIN GINDI() tare da ayyuka RANDBETWEEN() don samar da kalmar sirri.
3. Yi amfani da aikin ISNUMBER(STANDARDDEVIATION()) don bincika idan kalmar sirri ta musamman.

8. Ta yaya zan iya ƙara aikin ƙarewa zuwa kalmomin sirri da aka samar a cikin Excel?

1. Bude Excel akan kungiyar ku.
2. Yi amfani da aikin YAU() a cikin tantanin halitta don samun kwanan wata na yanzu.
3. Rage adadin kwanakin da kuke son kalmar sirri ta ƙare ta amfani da aikin KWANAKI AIKI().

9. Ta yaya zan iya sanya janareta kalmar sirri a cikin Excel mafi aminci?

1. Yi amfani da bazuwar haɗakar manyan haruffa, ƙananan haruffa, lambobi da haruffa na musamman a cikin janareta na kalmar sirri.
2. Kare maƙunsar bayanai da kalmar sirri don hana mutanen da ba su da izini shiga bayanan.

10. Ta yaya zan iya sanya janareta kalmar sirri a Excel mafi inganci?

1. Yi amfani da dabarun Excel kamar RANDBETWEEN() y HALI () don hanzarta samar da kalmar sirri.
2. Yi amfani da kayan aikin tsara yanayi don haskaka kalmomin sirri masu ƙarfi ko rauni a cikin maƙunsar rubutu.