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.

Business

You might also like to view...

In December 2012, U.S. President Barack Obama signed the Russia and Moldova Jackson-Vanik Repeal and Sergei Magnitsky Rule of Law Accountability Act. What does this law entail and how does it affect Russia-U.S. relations?

What will be an ideal response?

Business

In the context of employment law, which of the following are guaranteed rights to receive pension benefits?

A. Human rights B. Union rights C. Vesting rights D. Access rights

Business

Manufacturers' ________, also called manufacturers' representatives, represent a buyer or seller on an ongoing basis.

A. intermediaries B. agents C. retailers D. franchisers E. brokers

Business

Which of these résumé tips is most accurate?

A) Don't list awards and honors on a résumé; if you list them, you will appear to be bragging. B) Omit school and community activities from your résumé because they are unrelated to your work experience. C) Include your personal information (height, weight, and marital status) to give a potential employer a complete picture. D) Improve the visual impact of your résumé by placing your employment achievements and relevant job duties in an easy-to-read bulleted list.

Business