Topic_2_DQ_1 finish
.xlsx
keyboard_arrow_up
School
Brigham Young University, Idaho *
*We aren’t endorsed by this school
Course
144
Subject
Mathematics
Date
May 7, 2024
Type
xlsx
Pages
6
Uploaded by ChefTurtle10390 on coursehero.com
Excel Skills Learned
Upon completing the sheet, you should have an understanding of:
1. Using cell references in formulas.
2. Reusing formulas via cut-paste.
Math Skills Learned
1.Converting between units.
Instructi
complet
name w
that the
tions
: Open the tab labeled "Conversions" and te the tasks indicated there. Start by entering your where indicated. Pay attention to the legend and note e sheet is currently not self-checking.
Quantity of
First Units
=
Second Units
1
kilogram (kg)
=
2.20462
pounds (lb)
1
fluid ounce (floz)
=
29.5735
milliliter (mL)
1
ounce (oz)
=
28.3495
gram (g)
1
kilogram (kg)
=
1000
gram (g)
1
gram (g)
=
1000
milligram (mg)
1
milligram (mg)
=
1000
microgram (mcg)
1
liter (L)
=
33.8140
fluid ounces (floz)
1
liter (L)
=
0.2642
gallons (gal)
1
teaspoon (tsp)
=
4.9289
milliliter (mL)
1
meter (m)
=
3.2808
feet (ft)
1
day (d)
=
24
hours (h)
Watch the video explanations to follow alo
Initial Units
x
First ratio
Units
x
25
floz/kg
x
4.929
mL/floz
x
0.454
2.5
g/L
x
0.035
oz/g
x
3.785
5
m^2/mL
x
3.281
ft/m
x
3.281
1 On this sheet, you will consider several conversions related to calculations you might see in a professional con
the given result. Remember that ratios can use either unit over the other, and that you should order ratios so th
First, examine this conversion factor table; you will use conversion factors from this table in your formulas in par
your multiplier will be the conversion factor itself; on the other hand, if you use a ratio of the First Units over the
For example, when multiplying by lb/kg, you would multiply by F4 or F4/D4; when multiplying by kg/lb, you woul
Conversio
n Factor
2
Now, use entries from the conversion table to perform the following conversions. Note that you may use entr
table above, even if a more direct conversion is possible. For each part, the number of ratios required is shown i
that your ratios for the formulas may be either one of the conversion factors above (like =F10 or =F10/B10) or th
=1/F9 or =B9/F9), as illustrated in the example. No special formatting is required for the cells containing your for
cells, enter the ratio of units that you multiplied by for each conversion. You should use the abbreviations provid
capitalization as given.
Initial quantity Second ratio
Example: convert fluid ounces per kilogram to milliliters per pound
A) Convert grams per liter to ounces per gallon
B) Convert square meter per mililiter to square feet per teaspoon
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help