ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Data Task

Please read the instructions below before you begin.

The data on the "Existing Data Set" sheet details some dummy employee data that has been previously sent by a client and represents what has been uploaded to the our system for to maintain records. This template, as well as the data, is completely accurate and contains no errors.

The data on the "New Data Set" sheet details the same dummy employee data that the client has sent us 1 month after having sent the previous file.

You'll notice that in the "New Data Set" sheet there are a number of problems with the data that will prevent the data being loaded to our system. One of the biggest issues is that the unique employee identifier that has been provided is now different. The client has confirmed that we need to use the employee identifier from the "Existing Data Set" file before we load the data. Show how would you obtain the employee identifier from the "Existing Data Set" and insert it into the "New Data Set" sheet.

There are also 12 data errors in the new file. You may also see there are some changes to the data, but note there are only 12 errors. Please identify and highlight these errors using your preferred method.
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100