Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions