IMPORTANT NOTE: To receive full credit in Problem 2, you MUST use string manipul
ID: 666035 • Letter: I
Question
IMPORTANT NOTE: To receive full credit in Problem 2, you MUST use string manipulation functions and variables to fulfill the requirements. You are NOT allowed to use formulas or to assign strings to cells in the spreadsheet to manipulate them.
In computer networking, it is essential to be able to uniquely identify every piece of equipment attached to a network. Therefore, each piece of equipment is assigned a Media Access Control (MAC) address. A MAC address is typically displayed as six pairs of hexadecimal numbers separated by colons (e.g., 88:17:E8:90:E2:0A). The first three pairs of hexadecimal numbers in a MAC address (e.g., 88:17:E8) identify the manufacturer of the hardware network adapter, whereas the last three pairs of hexadecimal numbers (e.g., 90:E2:0A) denote the serial number of the hardware network adapter.
For the purposes of this problem, you can assume the following:
· The user always provides a valid MAC address (i.e., six pairs of hexadecimal numbers separated by colons).
· The first pair and the last pair of hexadecimal numbers always start with a letter (i.e., A, B, C, D, E or F).
1. Write a sub procedure named MACAddress that takes a user-provided MAC address from cell C7 and does the following: - a) Displays the portion of the MAC address that identifies the manufacturer of the hardware network adapter, with colons, and centered in cell C10.- b) Displays the portion of the MAC address that identifies the manufacturer of the hardware network adapter, without colons, and centered in cell Cll. c) Displays the portion of the MAC address that identifies the serial number of the hardware network adapter, with colons, and centered in cell D10.- d) Displays the portion of the MAC address that identifies the serial number of the hardware network adapter, without colons, and centered in cell D11. e) Cells B7, B10, B11, C9, and D9 should display the labels shown in Figure 1. These labels need to be displayed in BOLD type.* f) Your sub procedure should end by selecting cell C7. g) Assign the sub procedure MAC Address to a rectangular shape button labeled "MAC Address Information" 2. Write a sub procedure namedleaMAC Datathat willv a) Clear the contents of cell C7 and range C10:D1l.- b) Assign the sub procedure named clear,ACData to a rectangular shaped button labeled "Clear MAC Address Data"Explanation / Answer
=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)