In cell G$5,$ enter a formula without a function that subtracts the target revenue from the year$-$to$-$date revenue to determine how much revenue the field office must earn in Quarter $4$ to reach its target for the year.

Josh wants to calculate the gross margin for Quarters $1-3$ and the year to date. Provide this information as follows:

a$.$ In cell B$7,$ enter a formula without a function that divides the gross profit for Quarter $1$ by the revenue in Quarter $1.$

b$.$ Fill the Gross margin cell range with the formula in cell B $7$ to find the gross margin for Quarters $2$ and $3$ and for the year to date.

Josh needs to sum the sales for each Pennsylvania region for the year to date. Provide this information as follows:

a$.$ In cell E$10,$ enter a formula that uses the proper function to total the three quarters of regional sales data for the Northeast region to calculate the year$-$todate sales.

b$.$ Use the Fill Handle to fill the remaining three regions with the formula in cell E$10$ to find the year$-$to$-$date sales for the other three regions.