Delete a defined name. Updote the defined name for a cel. $2.$ In cel B$8,$ calculate the ban amount by entering a formula without using a function that subtracts the Down$\_.$ Payment trom the Price. X Create a formula. In the toan Calculator waksheet, the formula in cell $88$ should contain the named range 'Price"$\mathrm{.}1.$ Lam Richardson is the business manager tor the Smith $\backslash$& Lyngate insurance agencies in the state of Maryland. Liam is interested in increasing the number of agents in Baltimore and plans to buy an ollice building for the new operation. He has asked for your help in creating a loan analysis that wummarizes information about the loans to cover the cost. of the builing. Go to the Loan Calculator workseet. The cels in the range $86$:$88$ have defined names, but one is incomplete and