Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

14 Use the Format Painter to apply the formatting from the cell A3 to the range A28:B28. N 15 Use Advanced Filtering to restrict the

image text in transcribed
image text in transcribed
14 Use the Format Painter to apply the formatting from the cell A3 to the range A28:B28. N 15 Use Advanced Filtering to restrict the data to only display FT employees based on the criteria W in the range K10:K11. Place the results in cell A29. 16 Enter a database function in cell K18 to determine the total number of FT employees. To N complete the function use the range A5:H25 as the database argument, cell E5 for the field, and the range K10:K11 for the criteria. 17 Enter a database function in cell K19 to determine the total value of FT employee salaries. To N complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 18 Enter a database function in cell K20 to determine the average FT employee salary. To 3 complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 19 Enter a database function in cell K21 to determine the highest FT salary. To complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria. 20 Format the range K19:K21 with Currency Number Format. N 21 Ensure that the New_Construction worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6 to the optimal value of $8000. Complete this task by changing the Loan amount in cell E6. 22 Create the following three scenarios using Scenario Manager. The scenarios should change 7.4 the cells B7, B8, and E6. Good B7 = .0312 B8 = 5 Most Likely B7 = .0575 B8 = 5 Bad B7 = .0625 B8 = 3 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately and reorder the worksheets so the Scenario Summary worksheet appears as the last worksheet in the workbook. 23 Ensure that the New_Construction worksheet is active. Enter a reference in cell B12 to the 4 beginning loan balance and enter a reference in cell C12 to the payment amount. 24 Use the IPMT function in cell D12 to calculate the interest paid for the first payment of the 4 loan. Use the information in the loan details section (E6:E9) of the worksheet to locate the required inputs for the function. Be sure to use the appropriate absolute, relative, or mixed cell references. All results should be formatted as positive numbers. 25 Enter a formula in cell E12 based on the payment and loan details that calculates the amount 4 of principal paid on the first payment. The principal is the payment - interest. Be sure to use the appropriate absolute, relative, or mixed cell references

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

New Products Management

Authors: C Merle Crawford

12th Edition

1260512010, 9781260512014

More Books

Students also viewed these Economics questions

Question

8. What values do you want others to associate you with?

Answered: 1 week ago