send it as an excel fail.
This quiz asks you to create three extra columns based on the information provided in the table. Column G has the heading "Branch recoded". For this column, "Westside" should be recoded as 1, "Central" recoded as 2, and "North County" recoded as 3. Enter an appropriate VLOOKUP formula in cell G12 after you create an appropriate lookup table, copy and paste it to the rest of the column. Column H has the heading "OpenedBy recoded". For this column "New Accts" should be recoded as 1 and "Teller" as 0 . To recode the Opened By in column H, you must use the IF function. Enter an appropriate formula in cell H12, copy and paste it to the rest of the column. For column I, labeled as "Amount recoded", Amount $0 to $1,999 should be recoded as "Low", from $2,000 to $5,999 recoded as "Medium", and $6,000 and above recoded as "High". For recoding the Amount in this column, again you must use the VLOOKUP command by creating and using another appropriate lookup table. Enter an appropriate formula in cell 112, copy and paste it to the rest of the column. Pointing your mouse to the heading of any of these three columns provides comments, which also tells the recoding schemes. \begin{tabular}{|r|r|r|r|r|} \hline 20 & \multicolumn{2}{|l|}{ North County } & New Accts & $13,636 \\ \hline 21 & Central & New Accts & $16,000 \\ \hline 22 & Central & New Accts & $5,879 \\ \hline 23 & Central & New Accts & $4,000 \\ \hline 24 & North County & Teller & $10,000 \\ \hline 26 & \multicolumn{2}{|l|}{ North County } & New Accts & $7,427 \\ \hline 27 & Corth County & New Accts & $4,500 \\ \hline 28 & Central & Teller & $12,962 \\ \hline 29 & Central & Teller & $500 \\ \hline 30 & North County & Teller & $5,364 \\ \hline 31 & North County & Teller & $45,000 \\ \hline 32 & Central & Teller & $14,867 \\ \hline 33 & Central & Teller & $13,061 \\ \hline 34 & Central & New Accts & $4,995 \\ \hline 35 & Central & New Accts & $10,096 \\ \hline 36 & Central & New Accts & $14,861 \\ \hline 37 & Central & Teller & $500 \\ \hline 38 & Central & New Accts & $5,524 \\ \hline 39 & North County & Teller & $5,862 \\ \hline 40 & Central & Teller & $12,592 \\ \hline 41 & Westside & Teller & $7,188 \\ \hline 42 & North County & Teller & $9,159 \\ \hline 43 & Central & Teller & $9,208 \\ \hline 44 & North County & Teller & $5,756 \\ \hline 45 & Central & Teller & $14,480 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline ID & Branch & OpenedBy & Amount & Branchrecoded & OpenedByrecoded & Amountrecoded \\ \hline 1 & Central & New Accts & $5,000 & & & \\ \hline 2 & Central & Teller & $14,571 & & & \\ \hline 3 & Central & New Accts? & $500 & & & \\ \hline 4 & Central & New Accts & $15,000 & & & \\ \hline 5 & North County & New Accts & $4,623 & & & \\ \hline 6 & Westside & New Accts & $8,721 & & & \\ \hline 7 & North County & New Accts & $15,276 & & & \\ \hline 8 & Westside & New Accts & $5,000 & & & \\ \hline 9 & Westside & Teller & $15,759 & & & \\ \hline 10 & Westside & New Accts & $12,000 & & & \\ \hline 11 & North County & Teller & $7,177 & & & \\ \hline 12 & Westside & New Accts & $6,837 & & & \\ \hline 13 & Westside & New Accts & $3,171 & & & \\ \hline 14 & Central & New Accts & $50,000 & & & \\ \hline 15 & North County & New Accts & $4,690 & & & \\ \hline 16 & Central & New Accts & $12,438 & & & \\ \hline 17 & North County & New Accts & $5,000 & & & \\ \hline 18 & North County & New Accts & $7,000 & & & \\ \hline 19 & Central & New Accts & $11,957 & & & \\ \hline 20 & North County & New Accts & $13,636 & & & \\ \hline 21 & Central & New Accts & $16,000 & & & \\ \hline 22 & Central & New Accts & $5,879 & & & \\ \hline 23 & Central & New Accts & $4,000 & & & \\ \hline \end{tabular}