Using Exel, Create a translation table to convert each letter of the alphabet to

Question

Using Exel, Create a translation table to convert each letter of the alphabet to a numeric, then use a formula to apply the translation to each numeric value. Your table should have three columns. Suppose the translation factor is 3. Use a formula with the MOD function to create Col 3 of the table.

Col 1                           Col 2                                       Col 3

(Numerics)                  (Alphabet)                         (Translated Numeric)

      0                                  A                                             3

      1                                  B                                             4

      2                                  C                                             5

      3                                  D                                             6

      .                                   .                                               .

      .                                   .                                               .

25                              Z                                              2

Explanation / Answer

To convert each number in column A1 to alphabet

=CHAR(A1+65)

To convert each letter of the alphabet in B1 to a numeric

=MOD(CODE(B1),26)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.