ABC Manufacturing has 1630 employees. Each employee should have a distinct employee identification number. How would you suggest verifying this if all employee information, including identification number, are currently stored in a single spreadsheet?
Sort on the worker identification column. Once they are sorted, use IF, THEN statement to determine if any adjacent cells are the same. For example, =IF(B3=B2,1,0). Next, sum the column to find if and how many duplicates exist. Search in that sum column by using the ‘Find' command to identify those with duplicate i.d. numbers.
You might also like to view...
A painter did some work on a owners's house and was not paid. The owner also owned several other properties in the same neighborhood. The painter would most likely file a mechanic's lien against:
A. All the owner's real property. B. All the owner's personal property. C. The owner's property worked on by the painter. D. Both the owner's real and personal property.
Onstage contact points refer to contact points that are observable to the customer
Indicate whether the statement is true or false