Steps i have completed:

Open e06r1NCCTS and save it as e06r1NCCTS_LastFirst.

Ensure the Disaster Recovery Forecast sheet is active. Create range names based on the values in the range B15:B16.

Edit the name range Disaster_Recovery to the more appropriate name Disaster_Recovery_Rate.

Use the formula Disaster_Recovery_Rate*Hours_Billed to calculate the Amount Billed in cell B17.

Create a series of substitution values in the range D4:D12 based on hours billed. The substitution values should range from five to nine hours in half-hour increments.

Steps i need help on:

Enter a reference to the Amount Billed in the appropriate location for the first data table. Complete the data table using the appropriate input cells. Apply a custom number format to the reference to the formula cell.

Apply Comma Style format to the range E4:E12.

Copy the substitution values used in the first data table to the range G4:G12.

Create a series of substitution values in the range H3:N3 based on hourly rate. The substitution values should range from $65 to $95 in increments of $5.00. Apply Accounting Number Format to the substitution values.

Enter a reference to the Amount Billed in the appropriate location for the second data table. Complete the data table using the appropria