Use the following tables from Brice’s PT Cruisers’ expenditure system to address the situations below:

(a) Assume Brice’s PT Cruisers Inc. is concerned that its new temporary Purchase Department Manager, Sly Hawkeye, is allowing payments to be made to unauthorized vendors. Develop an Excel formula to identify any payments made to unauthorized vendors. (6 points):

(b) Assume Brice’s PT Cruisers Inc. wants to separate the employee first name into a separate column in the Current Employee table. Develop an Excel Formula to place first name in Column E. (6 points)

 

Transcribed Image Text:

A B C D Current employees 2 EmpNo 1. Name EmpID Term date bburns ggarcia 3 1 Brice Burns 4 2 Grace Garcia Lou Larson 5 3 llarson Cyndie Cortez Jordan Jones 6 4 ccortez ijones 7/6/2020 Heath Hook hhook 3/30/2020 56 78 A B C D Current employees 2 EmpNo 1. Name EmpID Term date bburns ggarcia 3 1 Brice Burns 4 2 Grace Garcia Lou Larson 5 3 llarson Cyndie Cortez Jordan Jones 6 4 ccortez ijones 7/6/2020 Heath Hook hhook 3/30/2020 56 78

Answer rating: 100% (QA)

P6a First we have to create new column in payment transactions table at right side end naming may be ... View the full answer