17.10 Excel Problem* Objective: Learn how to use text and array formulas to locate potential payroll problems. REQUIRED a. Download the spreadsheet for this problem from the course website. b. In column I, under the label "Ghost Employee?" use a function that compares the employee# in the time cards column to the employee# in the payroll master data column and displays the message: "Time card employee# does not exist in 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 em-ployee# in the time cards worksheet does exist in the payroll master file worksheet or if that row in the time card column is blank. (Hint: Use the ISNA and MATCH functions.) c. In column L, titled "Invalid SSN?" use a function to identify invalid Social Secu-rity 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. (Hint: There are text functions that examine specific portions of a string, such as the left three characters, and there are also functions that convert text to nu-meric values.) d. In column P, titled "Missing Paycheck?" use 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 em-ployee" or display nothin.

				Payroll Master Data
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
89224476	Julie West	42		89224476	Julie West	135-79-0246
12886345	Susie East	40		12886345	Susie East	246-80-1357
44339987	George Diaz	40		44339987	George Diaz	357-91-2468
12288765	Jose Gonzales	45		12288765	Jose Gonzales	468-02-3579
23300654	Fred Smith	40		23300654	Fred Smith	579-13-4680
72993356	Frida Engles	40		72993356	Frida Engles	680-24-5791
63349987	Bjorn Johns	40		63349987	Bjorn Johns	791-35-6802
38872987	Betty Smith	35		38872987	Betty Smith	802-46-7913
49923456	Paul Jones	36		49923456	Paul Jones	345-88-9877
18832098	John Adams	40		18832098	John Adams	913-57-8024
82230872	Mary Alcott	40		82230872	Mary Alcott	024-56-8976
45002345	Wendy Jones	40		24987622	Pete Jackson	333-66-9834
24987622	Pete Jackson	40		13579086	Willa DeVille	665-77-9753
13579086	Willa DeVille	39		24680975	Amy Jacks	399-00-2345
24680975	Amy Jacks	40		35790864	Linda Brown	834-62-9753
35790864	Linda Brown	44		46809753	Mary Smith	268-13-4456
46809753	Mary Smith	40		57912468	Jenny Rogers	223-99-0234
57912468	Jenny Rogers	43		68023579	Karen Kills	334-98-2234
80245791	Larry Lugs	40		79134680	Paul Reston	111-33-5555
91356802	Rafael Ruiz	40		80245791	Larry Lugs	298-63-0864
				91356802	Rafael Ruiz	773-66-2453

please help with question all info is there.