Steps to Complete This Project

On your computer, open a new MS Excel worksheet and answer each of the following. Enter your responses in the spaces provided.

$(1)($ Feet to Inches $)$

Using a single Excel worksheet expression, construct a formula that will convert $0\mathrm{.}45$ feet to inches.

Note: one U$.$S$.$ foot is equivalent to $12$ inches.

Solution: Click cell A$1$ and type the words Feet to Inches. Size the width of column A to fit correctly fit these words. Then click cell B$1$ and enter the formula below in the cell.

$=0\mathrm{.}45*12$

Observe the result in cell B$1.$

$(2)($ Ounces to Gallons $)$

Using a single Excel worksheet expression, construct a formula that will convert $65$ ounces to gallons.

Note: one U$.$S$.$ gallon is equivalent to $128$ ounces.

Solution: Click cell A$2$ and type the words Ounces to Gallons. Size the width of column A to fit correctly fit these words. Then click cell B$2$ and enter the formula below in the cell.

$=65/128$

Observe the result in cell B$2.$

$(3)($ Pounds to Ounces $)$

Using a single worksheet expression, write a formula that converts $3\mathrm{.}5$ pounds to ounces.

Note: one U$.$S$.$ pound $($ dry measure $)$ is equivalent to $16$ ounces.

Solution: Click cell A$3$ and type the words Pounds to Ounces. If necessary, size the width of column A to fit correctly fit these words. Then click cell B$3$ and enter the formula below in the cell.

$=3\mathrm{.}5*16$

Observe the result in cell B$3.$

$(4)($ Square Inches to Square Feet $)$

With a single worksheet expression, construct a formula that will convert $96$ square inches to square feet.

Note: one square inch is equivalent to $(1/144)$ square feet.

Solution: Click cell A$4$ and type the words in$^2$ to ft$^2.$ Then click cell B$4$ and enter the formula below in the cell.

$=96/144$

Observe the result in cell B$4.$

PROJECT Measurements

$(5)($ Miles to Kilometers $)$

Using a single Excel worksheet expression, construct a formula that will convert $40$ miles to kilometers.

Note: One kilometer is equivalent to $1,000$ meters or $0\mathrm{.}621$ U$.$S$.$ miles.

Solution: Click cell A$5$ and type the words Miles to Kilometers. Then click cell B$5$ and enter the formula below in the cell.

$=40/0\mathrm{.}621$

Observe the result in cell B$5.$

$(6)($ Gallons to Liters $)$

Click cell A$6$ and type the words Gallons to Liters. Then click cell B$6$ and enter a formula in that cell to convert $12$ gallons to liters.

Hint: $1$ U$.$S$.$ gallon is approximately $3\mathrm{.}785$ liters.

$(7)($ Grams to Micrograms $)$

Click cell A$7$ and type the words Grams to Micrograms. Then click cell B$7$ and enter a formula in that cell to convert $0\mathrm{.}735$ grams to micrograms.

Hint: $1$ gram $($ metric system $)$ is equivalent to $1,000,000$ micrograms.

$(8)($ Feet per Second to Miles per Hour $)$

Click cell A$8$ and type the words Time Units. Then click cell B$8$ and enter a formula in that cell to convert $220$ feet per second to miles per hour.

Hint: There are $3,600$ seconds in one hour, and $5,280$ feet to one mile.

$(9)($ Seconds to Hours $)$

Click cell A$9$ and type the words Seconds to Hours. Then click cell B$9$ and enter a formula in that cell to convert $25,700$ seconds to hours.

$(10)($ Cubits to Feet $)$

Click cell A$10$ and type the words Cubits to Feet. Then click cell B$10$ and enter a formula in that cell to convert $1,600$ cubits to feet. Note: there are $18$ inches in $1$ cubit.

$(11)($ Fahrenheit to Centigrade $)$

Click cell A$11$ and type the words Fahrenheit to Centigrade. Then click cell B$11$ and enter a formula in that cell to change $125\backslash$deg Fahrenheit to Centigrade.

Use C $=(5/9)($ F $32).$

$(12)($ Centigrade to Fahrenheit $)$

Click cell A$12$ and type the words Centigrade to Fahrenheit. Then click cell B$12$ and enter a formula in that cell to change $10\backslash$deg Celsius to Fahrenheit.

$(13)($ Apothecary $)$

Click cell A$13$ and type the words Apothecary. Then click cell B$13$ and enter a formula in that cell to find the number of drams in $20$ grains, where $1$ grain is $3/82$ of a dram.

$(14)($ Apothecary $)$

Click cell A$14$ and type the words Apothecary. Then click cell B$14$ and enter a formula in that cell to find the number of grains in $210$ drams, where $1$ dram is $27\mathrm{.}34$ grains.

$(15)($ Calories $)$

Click cell A$15$ and type the words Calories. Stephanie burns $150$ calories each hour when she swims. How many calories does she use if she swims $1\mathrm{.}25$ hours per day for $3$ days? Click cell B$15$ and enter a formula in that cell to solve this problem.