Please answer asap

es from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing C D E F G H O Q R This quiz asks you to create three extra columns based on the information provided in th 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 n appropriately to write appropriate VLOOKUP formula in cell G12 after you create an appropriate lookup table, 2 and 112. Copy and paste to get 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 OpenedBy in column H, you must use the IF Branch OpenedBy Amount function. Enter an appropriate formula in cell H12, copy and paste it to the rest of the ID Branch OpenedBy Amount recoded recoded recoded column. Central New Accts $5,000 For column I, labeled as "Amount recoded", Amount $0 to $1,999 should be recoded as Central Teller $14,571 "Low", from $2,000 to $5,999 Jrecoded as "Medium", and $6,000 and above recoded as W Central New Accts $500 "High". For recoding the Amount in this column, again you must use the VLOOKUP Central New Accts $15,000 command by creating and using another appropriate lookup table. Enter an appropriate North County New Accts $4,623 formula in cell 112, copy and paste it to the rest of the column. Westside New Accts $8,721 North County New Accts $15,276 Pointing your mouse to the heading of any of these three columns provides comments, Co Westside New Accts $5,000 which also tells the recoding schemes. 9 Westside Teller $15,759 10 Westside New Accts $12,000 11 North County Teller $7,177 12 Westside New Accts $6,837 13 Westside New Accts $3,171 14 Central New Accts $50,000 15 North County New Accts $4,690 16 Central New Accts $12,438 17 North County New Accts $5,000 18 North County New Accts $7,000 19 Central New Accts $11,957 Search ~ OR ENG