a. Open e09h3FortWayne , click OK when prompted to fix a circular error, and then save it as e09h3FortWayne_LastFirst .

b. Click cell B3 , click the FORMULAS tab , and then click Trace Dependents in the Formula Auditing group. Excel displays a tracer arrow from cell B3 to cells E3 and B11, indicating that cell B3’s value is used in formulas in cells E3 and B11.

c. Click cell E11 and click Trace Precedents in the Formula Auditing group. Excel displays a tracer error showing that the values in the range B11:D11 are used within the current cell’s formula.

d. Click Remove Arrows in the Formula Auditing group. Save the workbook

a. Open e09h3FortWayne , click OK when prompted to fix a circular error, and then save it as e09h3FortWayne_LastFirst .

b. Click cell B3 , click the FORMULAS tab , and then click Trace Dependents in the Formula Auditing group. Excel displays a tracer arrow from cell B3 to cells E3 and B11, indicating that cell B3’s value is used in formulas in cells E3 and B11.

c. Click cell E11 and click Trace Precedents in the Formula Auditing group. Excel displays a tracer error showing that the values in the range B11:D11 are used within the current cell’s formula.

d. Click Remove Arrows in the Formula Auditing group. Save the workbook

a. Open e09h3FortWayne , click OK when prompted to fix a circular error, and then save it as e09h3FortWayne_LastFirst .

b. Click cell B3 , click the FORMULAS tab , and then click Trace Dependents in the Formula Auditing group. Excel displays a tracer arrow from cell B3 to cells E3 and B11, indicating that cell B3’s value is used in formulas in cells E3 and B11.

c. Click cell E11 and click Trace Precedents in the Formula Auditing group. Excel displays a tracer error showing that the values in the range B11:D11 are used within the current cell’s formula.

d. Click Remove Arrows in the Formula Auditing group. Save the workbook

d. Click Remove Arrows in the Formula Auditing group. Save the workbook

d. Click Remove Arrows in the Formula Auditing group. Save the workbook

d. Click Remove Arrows in the Formula Auditing group. Save the workbook