Answer this question:1. Type in a CONCAT() function that could be typed in cell E2 then copied down to combine the text in cells B2, C2 and D2 and "@company.ca" to re-create the email address. Hint: You will need to manually enter the last part of the e-mail address using double quotations " ", not single quotations ' '

A B C D E Email First Last # Concatenate 2 pdangelo1@company.ca p dangelo 1 pdangelo1@company.ca 3 dgoggin2@company.ca d goggin 2 dgoggin2@company.ca 4 bluu2@company.ca b luu 2 bluu2@company.ca 5 cprow8@company.ca C prow 8 cprow8@company.ca 6 ddecato2@company.ca d decato 2 ddecato2@company.ca 7 ssilguero9@company.ca S silguero 9 ssilguero9@company.ca 8 sjacobi1@company.ca S jacobi 1 sjacobi1@company.ca 9 tpalmatier5@company.ca t palmatier 5 tpalmatier5@company.ca 10 efoust6@company.ca e foust 6 efoust6@company.ca 11 ulomonaco7 @company.ca U lomonaco 7 ulomonaco7 @company.ca