Although the metric system (also called SI) is used throughout the world, the U.S. still widely depends

on the English system of measurements.

a) Create a new workbook.

b) Enter the data and apply formatting as shown below:

Screen shot 2009-11-08 at 9.25.11 PM

c) Save the workbook naming it Metric Conversions.

d) Use the information below to add the appropriate formulas that use cell references into cells C4 through C14:

  • cubic meters = 0.0283*cubic feet
  • cubic meters = 0.7646*cubic yards
  • meters = 0.3048*feet
  • meters = 0.9144*yards
  • liters = 3.7853*gallons
  • centimeters = 2.54*inches
  • kilometers = 1.6093*miles
  • kilograms = 0.3732*pounds
  • square meters = 0.0929*square feet
  • square kilometers = 2.59*square miles
  • square meters = 0.8361*square yards

e) Check your spreadsheet by entering 5 in cell A4. Cell C4 should display 0.1415 because it automatically calculates the metric equivalent of 5 cubic feet.

f) Enter the following measurements into cells A4 through A14. Your worksheet should look similar to:

Screen shot 2009-11-08 at 9.27.39 PM

g) Create a header that right aligns your name and a footer that center aligns the current date.

h) Save the modified Metric Conversions.

i) I will check the formulas when I grade them in class.

Leave a Reply

Your email address will not be published.