Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ms_excel 1-3 You will be constructing a pret that will calculate your current weight if you were standing and still alive!) on each of the
ms_excel 1-3 You will be constructing a pret that will calculate your current weight if you were standing and still alive!) on each of the planets (including Photo 2. Open a New Worksheet in Microsoft Weight in Space Excel Calculate 3. Type the spreadsheet shown to the night My Weights 4. In the column titlod, New Weight (lbs) Planet Gravity Factor Mew Welshiba insert a formula that multiplies the gravity Micul 0.29 factor by the weight entered in the cell Venus 091 entitled, My Weight (lbs). MAKE SURE Earth 100 TO USE ABSOLUTE REFERENCING!!! 0.38 Pupee 5-After you have entered your forms and Satum 1.10 calculated your weights for each Uranus 090 planet Highlight the entire table of planets, Neptune 1.20 gravity factors and now weight, and sort the Pluto 008 Data by Gravity Factor in Ascending order 7. Test your weight calculator by typing in different welchts in the cell next to the My Weight (lbs) = You should notice that the New Weight columnastically. If not check through your formulas 8. Type your full name in row 1. 9. Save the workbook in your excel folder Chapter 11 as Review_2_yourname Doww O
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started