Darius has defined a name for cell B$23,$ but wants to change it to one more similar to the text in cell A$23.$

Edit the defined name for cell B$23$ to use Profit$\_$Margin as the name. $[$Mac Hint: Delete the old defined name and create a new defined name.$]$

Go to the Orlando worksheet. In the range E$6$:E$14,$ Darius needs to enter a formula to calculate the expiration dates for the service agreements, which expire after one year. He wants to use a defined name in the formula as he did on the Tampa worksheet.

Calculate the expiration dates as follows:

Examine the formula in cell G$6,$ which uses a defined name to calculate the sale price. Assign the same defined name $($Contract$\_$Orlando$)$ to the range C$6$:C$14,$ which resolves the errors in column G$.$ In cell E$6,$ enter a formula without using a function to determine the expiration date by adding $365$ to the defined name @Contract$\_$Orlando. $[$Hint: To avoid an #SPILL error, enable implicit intersection by placing the This Row specifier $($@ character$)$ in front of the defined name.$]$ Fill the range E$7$:E$14$ with the formula in cell E$6.$

The workbook contains a defined name Darius no longer needs.

Delete the defined name invoice$\_$number $($but not the data$)$ from the workbook.