I have been stuck on this problem for the past two days. It is asking to make a

Question

I have been stuck on this problem for the past two days. It is asking to make a spreadsheet with 3 different cases. Which the first test case is 11 cm, then 22 ft, and 33 mm. What I am not getting is what equation to put into excel which does the converting of units automatically. If anyone can help I would really appreciate it, thank you!

Create an Excel worksheet that will allow the user to type i the radius of a sphere and select from a drop-down menu the standard abbreviation for the units use Standard Unit Abbreviations meter centimeter millimeter yard foot inch Unit Abbreviation The volume of the sphere should then be calculated and expressed by the following units cubic meters, cubic centimeters, cubic millimeters, liters, gallons, cubic yards, cubic feet, and Your should appear similar to the sample shown below, although you will probably need additional information in the worksheet not shown here Volume mm' liters gallons yda Enter Enter Radius Radius Value Here Unlts Here B. Most resistors are so small that the actual value would be difficult to read if printed on the resistor. Instead, colored bands denote the value of resistance in ohms. Anyone involved in constructing electronic circuits must become familiar with the color code, and with practice, means For the novice, however,

Explanation / Answer

In Excel there is one formula which you can just write in the required column and get the answer and the for maula is :

CONVERT (number ,"units needs to be converted", " units which you want as answer")

for eg:- you want to convert 100 ft into meters then you should write

CONVERT(100,"ft","m") and you will get the answer as 30.480 automatically

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.