ACCOUNTING INFORMATION SYSTEMS The messages below were encrypted using the techn

Question

ACCOUNTING INFORMATION SYSTEMS

The messages below were encrypted using the
technique illustrated in Figure 2-10 (using displacement keys other than 5). Using trial and
error, decode them. Hint: This task becomes
easy if you use an Excel spreadsheet and
VLookUp formulas that reference a table of letters and their numeric equivalencies.

Message 1 OZ OY TUZ CNGZ CK JUTZ
QTUC ZNGZ NAXZY AY OZ OY
CNGZ CK JU QTUC ZNGZ PAYZ
GOTZ YU
Message 2 QBZAPJL KLSHFLK PZ QBZAPJL KLUPLK
Message 3 FAA YMZK OAAWE EBAUX FTQ
NDAFT

Simkin, Mark G.; Norman, Carolyn S.; Rose, Jacob M. (2014-11-26).

Core Concepts of Accounting Information Systems,

13th Edition (Page 62). Wiley. Kindle Edition.

chapter 2

Explanation / Answer

Hi, you can create a lookup table like this:

After creating this table, you can call =VLOOKUP("C",$A$1:$B$26,2)

So, your message 1 will be decrypted as:

A U B V C W D X E Y F Z G A H B I C J D K E L F M G N H O I P J Q K R L S M T N U O V P W Q X R Y S Z T

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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