Question: I just need to know how to do the formulas 17.10 Excel Problem* Objective: Learn how to use text and array formulas to locate potential

I just need to know how to do the formulas

I just need to know how to do the formulas 17.10 Excel

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?" write 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?" write 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?" 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 em- ployee" or display nothing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!