To figure your weight and the weight of your favorite animal on each of the nine planets complete the following steps. Sign in to your Google account. Retrieve your Sheets 1 document. File New to open a new blank sheets document. Copy your planet list as you will be needing it soon.
2. Leave that data page open as you will be using it soon.
3. Add the following data (to the new document) after saving it as Sheets2 your name:
Cell A1 Planets
Cells A2 – A10 Planets in orbital order
Cell B1 Gravity on each planet
Cell C1 My Weight
Cell D1 My Weight On Each Planet
4. Fill in your weight(if you would rather others not know your weight plese use something close by 30 or more pounds i.e, 100 covers 70 – 130 pounds) Using a formula identify your weight on each planet
5. Cells A12 – A14 answer the following questions expand the cells in A12 – A14 ONLY not the entire column! (hint: type your answer then Merge and Center!)
A12 which planets are you old enough to drive on, and how much would you weigh on those planets?
A13 On which planet would you weigh nearly 2.5 times as much as you do on earth?
A14 which planet would you possibly be able to leap a tall building in a single bound?
6. Copy cells A1 – D10.
7. Paste in Cell F1 then Save again
8. Get on the internet and look up your favorite animal get the average weight of that animal.
9. Replace the words My Weight with “animal’s average weight” with the word animal being the name of your animal (i.e., dolphin’s average weight).
10. Replace the words in the next column heading as well, as indicated.
11. In cell F12 paste your data once more. Then on the internet locate the average weight of something else commonly referred to in pounds (in a car curb weight, baseball ounces etc.)
12 Indicate the item (not person) in Cells H12 and I12
Adjust the weight as needed in your data, and then use the Fill Handle to modify the data for the last time.
13. In Cell A15 use a formula to convert your actual weight to ounces.
14. In cell A16 look up the current worth of an ounce of gold using a formula show me your worth in gold (i.e, your weight in ounces [operation sign] the cost of an ounce of gold).