MA321 Lab 6

The Convert Function in Excel.

• By tying in =convert(x,"from_unit_y","to_unit_z"), you will be converting the quantity x given in unit y to unit z.

  For example, typing =convert(600,"w","kw") will give you the equivalent of 600 watts in 0.6 kilowatts.

  A complete listing of measurement units that the convert function supports is available from Microsoft Office Support at https://support.office.com/en-us/article/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2

Multiply Numbers In A Cell

To do this task, use the ***** (asterisk) arithmetic operator.

For example, if you type =5*10 in a cell, the cell displays the result, 50.

In the above example, if 5 is in cell A1 and 10 is in cell B1, you may also calculate the produce by =A1*B1.

Divide Numbers In A Cell

To do this task, use the / (forward slash) arithmetic operator.

For example, if you type =10/5 in a cell, the cell displays 2.

In the above example, if 5 is in cell A1 and 10 is in cell B1, you may also calculate the produce by =B1/A1.

Lab Assignment 6

1. Convert 7 feet into inches
2. How many seconds are there in one year?
3. Convert 68 degrees Fahrenheit to Celsius
4. Convert 100 square feet into square meters
5. According to the U.S. Bureau of Labor Statistics, sanitation workers had an average yearly wage of $47,600. Assume that sanitation workers generally work 40 hours a week, and there are 52 weeks in the year. Calculate the average hourly wage for sanitation workers.
6. Assume regular unleaded fuel costs $4.00 per gallon. A Mercedes that uses unleaded fuel gets about 25 miles per gallon. How much money will the driver of the Mercedes spend on gas in one year if he drives 12,000 miles