• DeShawn Washington runs the Florida office of Maxwell Training, a corporate training firm in Tampa. He is using an Excel workbook to analyze the company's financials and asks for your help in correcting errors and solving problems with the data.
  
  Go to the Blended Training worksheet. DeShawn asks you to correct the errors in the worksheet. Correct the first error as follows:
  • Use the Trace Precedents arrows to find the source of the #VALUE! error in cell F7.
  • Use the Trace Dependents arrows to determine whether the formula in cell F7 causes other errors in the worksheet.
  • Correct the formula in cell F7, which should multiply the Mandatory training fee per person (cell F3) by the minimum number of trainees (cell F5), and then add the online access fee (cell F6) to that result.
• Correct the Name error in cell B21 as follows:
  • Use any error-checking method to determine the source of the error in cell B21, which should calculate the average income per session.

d.Remove the trace arrows.

b.Correct the error by editing the formula in cell B21.