(A) under the label "Ghost Employee?" Write a function that compares the employee# in the time cards column to the employee# in payroll master data column and displays the message: "Time card employee# does not exist in the master data" for any employee in the time cards column who is not listed in the payroll master data column. The function should leave the cell blank if the employee# in the time cards worksheet does not exist in the payroll master file worksheet or if that row in the time cards column is blank.(C) In column L, titled "invalid SSN" write a function to identify invalid social security numbers. Assume that social security numbers that begin with the digit 0 or that have the digits 99 for the middle two numbers are invalid. Your function should display a message that flags either of these two conditions or that displays nothing otherwise.(D) in column P titled "missing paycheck?" Write a function to check whether a time card exists for each employee in the master payroll data section of the worksheet. The formula should either return the message "No paycheck created for this employee" or display nothing

D E F G H J K L MNO P Q Payroll Master Data N Employee# Name Hours Employee# Name SSN Ghost Employee? Invalid SSN? Missing Paycheck? 22445724 Joe Smith 40 22445724 Joe Smith 133-50-3345 32188457 Bill Simple 40 32188457 Bill Simple 345-88-9876 6 89224476 Julie West 42 89224476 Julie West 135-79-0246 12886345 Susie East 40 12886345 Susie East 246-80-1357 Co 44339987 George Diaz 40 44339987 George Diaz 357-91-2468 12288765 Jose Gonzales 45 12288765 Jose Gonzales 468-02-3579 10 23300654 Fred Smith 40 23300654 Fred Smith 579-13-4680 11 72993356 Frida Engles 40 72993356 Frida Engles 680-24-5791 12 63349987 Bjorn Johns 40 63349987 Bjorn Johns 791-35-6802 13 38872987 Betty Smith 35 38872987 Betty Smith 802-46-7913 14 49923456 Paul Jones 36 49923456 Paul Jones 345-88-9877 15 18832098 John Adams 40 18832098 John Adams 913-57-8024 16 82230872 Mary Alcott 40 82230872 Mary Alcott 024-56-8976 17 45002345 Wendy Jones 40 24987622 Pete Jackson 333-66-9834 18 24987622 Pete Jackson 40 13579086 Willa De Ville 665-77-9753 19 13579086 Willa DeVille 39 24680975 Amy Jacks 399-00-2345 20 24680975 Amy Jacks 40 35790864 Linda Brown 834-62-9753 21 35790864 Linda Brown 44 46809753 Mary Smith 268-13-4456 22 46809753 Mary Smith 40 57912468 Jenny Rogers 223-99-0234 23 57912468 Jenny Rogers 43 68023579 Karen Kills 334-98-2234 24 80245791 Larry Lugs 40 79134680 Paul Reston 111-33-5555 25 91356802 Rafael Ruiz 40 80245791 Larry Lugs 298-63-0864 26 91356802 Rafael Ruiz 773-66-2453 27 28 29