losh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a global company that manufactures medical equipment. He has created a worksheet summarizing the revenue and expenses for the first three quarters of the year. He asks for your help in determining what the Pennsylvania office needs to do to meet its targeted profit goals in the fourth quarter.Go to the Budget Summary worksheet. Cut the worksheet title from cell I$1$ and paste it in cell A$1$ to display the title in its expected location. B$2.$ In cell E$2,$ add the text Number of so that the complete text appears as "Number of salespeople:" and more clearly identifies the value in cell G$2\mathrm{.}3\mathrm{.}4.$Enter Quarter $2$ in cell C$4$ and Quarter $3$ in cell D$4.$In cell G$5,$ enter a formula without a function that subtracts the target revenue $($cell F$5)$ from the year to date revenue $($cell E$5)$ to determine how much revenue the field office needs to earn in Quarter $4$ to reach its target for the year$5.$ Josh wants to calculate the gross margin for Quarters $1-3$ and the year to date. Provide this information as follows: