Midterm Makeup Excel Problem:

Scientists have discovered a giant asteroid made entirely up of liquid mercury.  This asteroid is exactly your OU ID# cubic kilometers in volume.  No one is sure where this asteroid is heading, but to be on the safe side, NASA has decided that all space colonies and space probes should be equipped with stilts so that if the asteroid lands on a planet, the colony or probe will be above the liquid mercury (atomic symbol Hg), once it has been evenly distributed all over the planet.  Your assignment is to calculate how deep the mercury will be on each of the 9 planets in the Solar System (Mercury (the planet, not the liquid) through Pluto).  For the purposes of this exercise, assume all of the planets are perfectly spherical and have solid surfaces so that the mercury will form an even ocean of a certain depth all over the planet.

• In cell A1 put your name
• In cell C1 put your OU ID#
• In cells A3 through E3 put the headers: URL, Planet, Radius (km), Volume (km^3), Depth Hg (km)
• In cells B4 through B12 put the names of the 9 planets (include Earth)
• Find the radii of the planets using the internet.  Put the URL of your source for each planet's radii info (or half the diameter) in cells A4 through A12.
• Type in the appropriate values for each planet's radii
• Type in the appropriate formula for calculating each planet's volume so that Excel displays the values
• Type in the appropriate formula for the depth of the liquid mercury above the planet's standard radius so that Excel displays the appropriate values.  Remember, when you cut and paste formulae in Excel, Excel automatically increments cell numbers and/or letters in the formula as it moves down each cell.  To fix a cell in a formula so that it never changes no matter where the formula is pasted to, put dollar signs before the letter and before the number. E.g. "=D4+$C$1" is a formula where cell C1 will be referenced no matter where the formula is pasted, but cell D4 will automatically change to D5 in the copy of the formula that is pasted into the row below.
• Create a bar chart where the planets are along the X-Axis and the depth of Hg is displayed by the height of the Bar.  Paste the chart so it starts around row 16.  Make sure the chart is titled "Height of Hg in km."
• In cell A14 type in "The work on this assignment is my own, and was done in accordance with the guidelines described in the assignment."

Note that some of the planets may have bars so small that they do not show up on the chart, that's ok.  You can mouse over the base of the bar to see the value.