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:

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:

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.