Question: PROJECT STEPS 1 . Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to
PROJECT STEPS Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to cities and other organizations, In an Excel workbook, Darius is tracking the service contracts he manages in Tampa and Orlando. He asks for your help in analyzing the contract data and correcting errors. Go to the Tampa worksheet. Correct the errors in the worksheet as follows: a In cell G trace the errors in the formula to identify the cause of the error message. Correct the formula so that the IF function tests whether the contract date the range named ContractTampa is less than the date in cell B If it is multiply the standard price cell F by the sale price rate cell G and return the result. If it is not, return the standard price cell F in cell G b Copy the formula in cell G into the range G: to fix the errors in that range. c In cell G use Error Checking to find the formula error, and then correct the formula. d Correct the formula error in cell F
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
