# An associate created a worksheet to help people plan retirement based on a set of annual…

An associate created a worksheet to help people plan retirement based on a set of annual contributions to a retirement account. A user indicates the age to start contributions, projected retirement age, the number of years in retirement, and the rate of return expected to earn on the money when the user retires. The worksheet determines the total amount the user will have contributed, the amount the user will have accumulated, and the value of the monthly retirement amount. However, the worksheet contains errors. You will use the auditing tools to identify and correct errors. Then you will specify validation rules to ensure users enter valid data. This exercise follows the same set of skills as used in Hands-On Exercise 3 in this chapter. Refer to Figure 34 as you complete this exercise.

a. Open e08p2retire, and then save it as e08p2retire_LastnameFirstname.

b. Click cell B14, click the Formulas tab, and then click Trace Precedents in the Formula Auditing group.

c. Click the Error Checking arrow in the Formula Auditing group, and then select Error Checking.

d. Click Show Calculation Steps in the Error Checking dialog box. The Evaluate Formula dialog box opens, showing the formula and stating that the next evaluation will result in an error. Click Evaluate to see the error replace the argument in the function: #DIV/0!. Click Step In to see the value, and then click Step Out to return to the evaluation. Repeat the Step In and Step Out process, and then click Close. Click Next in the Error Checking dialog box, and then click OK in the message box. Find the 0 in cell B9, and then change it to 12.

e. Click Remove Arrows in the Formula Auditing group to remove the precedents arrow.

f. Click Watch Window in the Formula Auditing group, and then click Add Watch. Move the dialog boxes so that you can see the data, select the range B12:B14, and then click Add.

g. Create a data validation rule to ensure the retirement age is greater than 59.5 by doing the following:

• Click cell B5, click the Data tab, and then click Data Validation in the Data Tools group.

• Click the Settings tab, click the Allow arrow, and then select Decimal.

• Click the Data arrow, and then select greater than or equal to.

• Type 59.5 in the Minimum box.

• Click the Input Message tab, and then type Retirement Age in the Title box.

• Type Federal law does not permit payout prior to 59.5. in the Input message box.

• Click the Error Alert tab, click the Style arrow, and then select Warning.

• Type Invalid Data in the Title box, type Age must be greater than 59.5. in the Error message box, and then click OK.

h. Adapt step g to create a validation rule for cell B6 to ensure the rate of return will not exceed 8%. Include appropriate titles and messages.

i. Adapt step g to create a validation rule for cell B8 to ensure the rate of return during retirement will not exceed 7%. Include appropriate titles and messages.

j. Type 50 in cell B5. Click No when the error message displays, change the value to 60, and then press Enter.

k. Type 8.5% in cell B6. Click No when the error message displays, change the value to 8%, and then press Enter.

l. Type 7.5% in cell B8. Click No when the error message displays, change the value to 7%, and then press Enter. Close the watch window.

m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

n. Save and close the workbook, and submit based on your instructor’s directions.

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Are You Looking For Assignment Help? We Can Certainly Assist You