Excel Problem The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders.

It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest member, Jacques Noveau (1368). Members rent the flying machines by the hour, and all must be returned on the same day. The following six records were among those entered for the flights taken on September 1, 2017:

MEMBER #

FLIGHT DATE MM/DD/YY PLANE USED*

TAKEOFF TIME LANDING TIME 1234 09/10/17 G 6:25 8:46 4111 09/01/17 C 8:49 10:23 1210 09/01/17 P 3:42 5:42 0023 09/01/17 X 1:59 12:43 012A 09/01/17 P 12:29 15:32 0999 09/01/17 L 15:31 13:45

*C 5 Cessna, G 5 Glider, L 5 Lear Jet, P 5 Piper Cub REQUIRED

a. Identify and describe any errors in the data.

b. For each of the five data fields, suggest one or more input edit controls that could be used to detect input errors.

c. Enter the data in a spreadsheet, and create appropriate controls to prevent or at least detect the input errors.

d. Suggest other controls to minimize the risk of input errors.

(SMAC adapted)