Vicky Luo, analytics manager for Thompson Industries, wishes to clean the data in Figure G.2 (p. 816)

prior to analyzing it. She wants to check the following four items:

1. Any blank entries need to be identified and filled.

2. The percentages in columns G and H must be between 0% and 100%.

3. The value in column E for a supplier cannot exceed the value in column D for that supplier.

4. The value in column F for a supplier should not be 5 if the value in column H exceeds 10%.