from the communes you to w to stay in Protected Vier Erol Editing 1 Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical 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 1 and paste it in cell A1 to display the title in its expected location 2 In cell E2, add the text Number of so that the complete text appears as "Number at salespeople and more clearly identifies the value in cell 62. 3. Enter Quarter 2 in cell C4 and Quarter 3 in cell 04. 4. In cell G5, enter a formula without a function that subtracts the target revenue (cell F5) from the year to date revenue (cell ES) 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- ) and the year to date. Provide this information as follows: In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5). b. Fill the range C:E7 with the formula in call 67 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 E10, enter a formula that uses the SUM function to total the regional sales data for the Northeast region (the range B10:010) to calculate the year-to-date sales b. Use the Fill Handle to fill the range E11:13 with the formula in cell E10 to find the year-todate sales for the other three regions. PROTECTED VIEW els from the mess you need to do in Protected 1 Josh Bartells the senior director of the Pennsylvania field office for New Era Medical, 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 11 and paste it in cell Al to display the title in its expected location 2 In cell2, add the text Number of so that the complete text appears as "Number of salespeople and more clearly identifies the value in cell G2 3 Enter Quarter 2 in cell 04 and Quarter 3 in cell 04 4 In cell G5, enter a formula without a function that subtracts the target revenue (cell FS) from the year to date revenue (cell ES) to determine how much revenue the field office needs to 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: In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5), b. Fill the range C7:E7 with the formula in cell B7 to find the gross margin for Quarters 2 and 3 and for the year to date 6 Josh needs to sum the sales for each Pennsylvania region for the year to date. Provide this information as follows In cell E10, enter a formula that uses the SUM function to total the regional sales data for the Northeast region (the range B10:010) to calculate the year-to-date b. Use the filt Handle to fill the range E11:13 with the formula in cell E10 to find the Year-to-date sales for the other three regions. E 29 Party 7:07 AM from the communes you to w to stay in Protected Vier Erol Editing 1 Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical 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 1 and paste it in cell A1 to display the title in its expected location 2 In cell E2, add the text Number of so that the complete text appears as "Number at salespeople and more clearly identifies the value in cell 62. 3. Enter Quarter 2 in cell C4 and Quarter 3 in cell 04. 4. In cell G5, enter a formula without a function that subtracts the target revenue (cell F5) from the year to date revenue (cell ES) 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- ) and the year to date. Provide this information as follows: In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5). b. Fill the range C:E7 with the formula in call 67 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 E10, enter a formula that uses the SUM function to total the regional sales data for the Northeast region (the range B10:010) to calculate the year-to-date sales b. Use the Fill Handle to fill the range E11:13 with the formula in cell E10 to find the year-todate sales for the other three regions. PROTECTED VIEW els from the mess you need to do in Protected 1 Josh Bartells the senior director of the Pennsylvania field office for New Era Medical, 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 11 and paste it in cell Al to display the title in its expected location 2 In cell2, add the text Number of so that the complete text appears as "Number of salespeople and more clearly identifies the value in cell G2 3 Enter Quarter 2 in cell 04 and Quarter 3 in cell 04 4 In cell G5, enter a formula without a function that subtracts the target revenue (cell FS) from the year to date revenue (cell ES) to determine how much revenue the field office needs to 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: In cell B7, enter a formula without a function that divides the gross profit for Quarter 1 (cell B6) by the revenue in Quarter 1 (cell B5), b. Fill the range C7:E7 with the formula in cell B7 to find the gross margin for Quarters 2 and 3 and for the year to date 6 Josh needs to sum the sales for each Pennsylvania region for the year to date. Provide this information as follows In cell E10, enter a formula that uses the SUM function to total the regional sales data for the Northeast region (the range B10:010) to calculate the year-to-date b. Use the filt Handle to fill the range E11:13 with the formula in cell E10 to find the Year-to-date sales for the other three regions. E 29 Party 7:07 AM