Microsoft Office Tutorials and References

In Depth Information

EX 248

Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets

Cases and Places
continued

These formulas have been supplied:

Formula A: Amount Remaining = Original Amount

0.5(Number of Years Stored / Half-Life)

Formula B: Containment Costs = Containment Cost Per Kilogram

Total Amount Remaining

Formula C: Estimated Appropriations = Appropriations

(1 + Estimated Yearly Increase)

(Number of Years Stored / Half-Life)

Formula D: Percentage Spent on Containment = Containment Costs / Estimated Appropriations

The director has asked your group to include a function that prints “Acceptable” below the percentage

spent on containment whenever the percentage is less than 1%, otherwise print “Not Acceptable.”

Have each member of your team submit a sketch of the proposed worksheet and then implement

the best one. Use the concepts and techniques presented in this project to create and format the worksheet.

Submit the sketches and workbook as requested by your instructor.

Table 3–21 Cost of Storing Radioactive Isotopes

Number of Years Stored

.................................................

Number of Years Stored

1

2

3

10

Amount of Isotope X

Remaining (in kg)

Formula A

Amount of Isotope Y

Remaining (in kg)

Formula A

.................................................

Total Remaining (in kg)

—

—

—

—

Containment Costs

Formula B

Estimated Appropriations

Formula C

Percentage Spent on

Containment

Formula D

Message

Assumptions

Original Amount of Isotope X Remaining (in kg)

650

Half-Life of Isotope X (in years)

1

Containment Cost per Kilogram

1000

Estimated Yearly Increase

10.00%

Original Amount of Isotope Y Remaining (in kg)

3000

Half-Life of Isotope Y (in years)

0.45

Appropriations

6000000