¿Cómo hacer un generador de contraseñas en excel?

Mmelite ikpeazụ: 12/15/2023
Onye dere ya: Sebastian Vidal

Ọ bụrụ na ị na-achọ ụzọ dị mfe iji mepụta okwuntughe siri ike, ị bịarutela ebe kwesịrị ekwesị. N'isiokwu a, anyị ga-akụziri gị ka esi eme ka paswọọdụ generator na Excel iji ụfọdụ mfe ma dị irè ọrụ. Site na usoro ole na ole na ntakịrị ihe ọmụma dị mkpa nke Excel, ị nwere ike ịmepụta okwuntughe siri ike, omenala n'ime nkeji nkeji. Ịkwesighi ịbụ ọkachamara kọmputa iji soro usoro ndị a, yabụ echegbula onwe gị ma ọ bụrụ na ị nweghị ahụmịhe dị ukwuu na Excel. Gụkwuo wee chọpụta ka ọ dị mfe ịmepụta onye na-emepụta okwuntughe n'ime ngwa mgbasa ozi a na-ewu ewu!

- Nzọụkwụ site nzọụkwụ ➡️ Kedu ka esi eme onye na-emepụta okwuntughe na Excel?

  • Nzọụkwụ 1: Mepee Microsoft Excel na kọmputa gị.
  • Nzọụkwụ 2: Pịa taabụ "Developer" n'elu ihuenyo. Ọ bụrụ na ịhụghị taabụ a, gaa na "File"> "Nhọrọ"> "Hazie Ribbon" wee lelee igbe "Developer".
  • Nzọụkwụ 3: Ozugbo na "Developer" tab, pịa na "Visual Basic" button imeghe Visual Basic Editor.
  • Nzọụkwụ 4: Na Visual Basic Editor, pịa "Tinye" wee họrọ "Module." Nke a ga-emepụta modul ọhụrụ na ọrụ ahụ.
  • Nzọụkwụ 5: Ugbu a, detuo ma mado koodu a n'ime modul nke i mebere:
Ọdịnaya pụrụiche - Pịa ebe a  Otu esi enweta RFC site na CURP

"Vb
Ọrụ GeneratePassword(ogologo dị ka integer) Dị ka eriri
Ihe odide Const dị ka eriri = «ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!@#$%&»
Dim paswọọdụ dị ka eriri
Randomize
Mee Mgbe Len (paswọọdụ) < ogologo okwuntughe = paswọọdụ & etiti (chars, Int ((Len (chars) * Rnd) + 1), 1) Loop GeneratePassword = okwuntughe ngwụcha ọrụ ```

  • Nzọụkwụ 6: Chekwa ma mechie Visual Basic Editor.
  • Nzọụkwụ 7: Laghachi na mpempe akwụkwọ Excel gị wee họrọ cell nke ịchọrọ ka paswọọdụ emepụtara pụta.
  • Nzọụkwụ 8: En la barra de fórmulas, escribe = Mepụta okwuntughe(ogologo), ebe "ogologo" bụ ọnụọgụ mkpụrụedemede ịchọrọ ka paswọọdụ nwee.
  • Nzọụkwụ 9: Pịa "Tinye" ị ga-ahụ na a ga-emepụta paswọọdụ ọhụrụ na cell ị họọrọ.

Ajụjụ na Azịza

Ajụjụ ndị a na-ajụkarị: Otu esi eme Generator Password na Excel

1. Olee otú m nwere ike ịmepụta a paswọọdụ generator na Excel nzọụkwụ site nzọụkwụ?

1. Mepee Excel na kọmputa gị.
2. Pịa cell oghere.
3. Dee usoro =agwa( wee ọnụọgụ mkpụrụedemede ịchọrọ ka paswọọdụ bụrụ.
4. Mechie akara aka ma pịa Banye.

2. Kedu ka m ga-esi mepụta paswọọdụ na-enweghị usoro na Excel?

1. Mepee Excel n'ime otu gị.
2. Pịa cell efu.
3. Dee usoro = CONCATENATE(MMADỤ(RANDBETWEEN(65,90)),ỊMA (RANDBETWEEN(97,122))).
4. Presiona Banye.

Ọdịnaya pụrụiche - Pịa ebe a  Programas de CPU

3. Kedu otu m ga-esi chebe cell nwere paswọọdụ emepụtara na Excel?

1. Họrọ cell na paswọọdụ emepụtara.
2. Pịa na taabụ ahụ Nyochaa n'elu Excel.
3. Họrọ Proteger hoja.
4. Tọọ paswọọdụ iji chebe mpempe akwụkwọ.

4. Kedu ka m ga-esi tinye mgbochi na ọgbọ paswọọdụ na Excel?

1. Mepee Excel wee pịa cell efu.
2. Jiri ọrụ ahụ =agwa (RANDBETWEEN(65,90)) ka ịmepụta mkpụrụedemede ukwu na-enweghị usoro.
3. Jiri ọrụ ahụ =agwa (RANDBETWEEN(97,122)) ka imepụta obere mkpụrụedemede enweghị usoro.
4. Jiri ọrụ ahụ =agwa (RANDBETWEEN(48,57)) n'ihi na n'ịwa a random nọmba.
5. Jiri ọrụ ahụ =agwa (RANDBETWEEN(33,47)) iji mepụta agwa pụrụ iche na-enweghị usoro.

5. Kedu ka m ga-esi hazie usoro nke paswọọdụ emepụtara na Excel?

1. Mepee Excel na kọmputa gị.
2. Pịa cell efu.
3. Dee nchikota nke ọrụ =AKWỤKWỌ () na mkpụrụedemede ọ bụla ọzọ ịchọrọ.

6. Kedu ka m ga-esi mepụta ogbe okwuntughe na Excel?

1. Mepee Excel n'ime otu gị.
2. Dee usoro iji mepụta paswọọdụ n'ime cell.
3. Dọrọ ala aka nri akuku cell ala ka igbanye multiple okwuntughe.

Ọdịnaya pụrụiche - Pịa ebe a  Otu esi enweta draịvụ ike mpụga na Windows 11

7. Kedu otu m ga-esi gbochie ịmegharị okwuntughe emepụtara na Excel?

1. Mepee Excel na kọmputa gị.
2. Jiri ọrụ ahụ =Concatenate() na ọrụ RANDBETWEEN() iji mepụta paswọọdụ.
3. Jiri ọrụ ahụ ISNUMBER(STANDARDDEVIATION()) ka ịlele ma paswọọdụ pụrụ iche.

8. Kedu ka m ga-esi tinye ọrụ ngafe na okwuntughe emepụtara na Excel?

1. Mepee Excel n'ime otu gị.
2. Jiri ọrụ ahụ TAA() n'ime cell iji nweta ụbọchị dị ugbu a.
3. Wepụ ụbọchị ole ịchọrọ ka paswọọdụ kubie ume site na iji ọrụ ahụ ỤBỌCHỊ ().

9. Kedu ka m ga-esi mee ka onye na-emepụta okwuntughe na Excel dịkwuo nchebe?

1. Jiri nchikota random nke mkpụrụedemede ukwu, obere mkpụrụedemede, ọnụọgụ na mkpụrụedemede pụrụ iche n'ime onye na-emepụta okwuntughe.
2. Chekwaa akwụkwọ akụkọ ahụ na paswọọdụ iji gbochie ndị na-enweghị ikike ịnweta ozi ahụ.

10. Kedu ka m ga-esi mee ka onye na-emepụta paswọọdụ na Excel rụọ ọrụ nke ọma?

1. Jiri usoro Excel dị ka RANDBETWEEN() y agwa() iji mee ka ọgbọ paswọọdụ dị ngwa.
2. Jiri ngwaọrụ nhazi ọnọdụ iji gosipụta okwuntughe siri ike ma ọ bụ adịghị ike na mpempe akwụkwọ.