AE$1-1.$ Spreadsheet image. The spreadsheet in Microsoft Excel file Ch$01$Ex$01\_$U$10$e$.$xlsx contains records

of employee activity on special projects. Open this workbook and examine the data that you find in the

three spreadsheets it contains. Assess the accuracy, relevancy, and sufficiency of this data to the

following people and problems.

A$.$ You manage the Denver plant, and you want to know how much time your employees are

spending on special projects.

B$.$ You manage the Reno plant, and you want to know how much time your employees are

spending on special projects.

C$.$ You manage the Quota Computation project in Chicago, and you want to know how much time

vour employees have spent on that project.

D$.$ You manage the Quota Computation project for all three plants, and you want to know the total

time employees have spent on your project.

E$.$ You manage the Quota Computation project for all three plants, and you want to know the total

labor cost for all employees on your project.

F$.$ You manage the Quota Computation project for all three plants, and you want to know how the

labor$-$hour total for your project compares to the labor$-$hour totals for the other special projects.

G$.$ What conclusions can you make from this exercise?

AE$1-2.$ Image The database in the Microsoft Access file Ch$01$Ex$02\_$U$10$e$.$accdb contains the same records

of employee activity on special projects as in AE$1-1.$ Before proceeding, open that database and view the

records in the Employee Hours table.

A$.$ Eight queries have been created that process this data in different ways. Using the criteria of

accuracy, relevancy, and sufficiency, select the single query that is most appropriate for the

information requirements in AE$1-1,$ parts a f$.$ If no query meets the need, explain why.

B$.$ What conclusions can you make from this exercise?