Excel ProblemCreate a spreadsheet with the following columns:• Plaintext character• ASCII...

Excel Problem

Create a spreadsheet with the following columns:

• Plaintext character

• ASCII code (seven bits, binary number)

• First bit

• Second bit

• Third bit

• Fourth bit

• Fifth bit

• Sixth bit

• Seventh bit

• Number of bits with value = 1

• Parity bit for odd parity coding

• Parity bit for even parity coding

REQUIRED

a. Enter a-e, A-E, 0-9, ?, !,%, &, and ; in the plaintext column.

---

b. The ASCII column should convert the plaintext character to the binary code used by your computer. (Hint: Search Execl’s built-in functions).

---

c. The next seven columns should each display one bit of the ASCII code, beginning with the leftmost digit. (Hint: Excel provides text functions that can select individual characters from a string.)

---

d. The tenth column should sum the number of bits that have the value 1. (Hint: The text functions used to populate columns 3 to 9 return a text string that you will need to convert to a numeric value.)

---

e. Column 11 should display the number 1 if the value in column 10 is odd, and display the number 0 if the value in column 10 is even.

---

f. Column 12 should display the number 1 if the value in column 10 is even, and the number 0 if the value in column 10 is odd.

---