Engineering › CONVERT135 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeCONVERT

CONVERT: units for an overseas buyer

Teguh exports specialty coffee beans to a buyer in the United States. The buyer asks for each lot's weight in pounds and the roasting temperature in degrees Fahrenheit.

Task

Fill in with CONVERT:

D2:D5: the weight (column B, kg) in pounds, unit code "lbm".
E2:E5: the roasting temperature (column C, °C) in °F, unit codes "C" to "F".

Cells to fillD2:D5E2:E5

Required functionsCONVERT

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
The shape is CONVERT(number, from_unit, to_unit). Units are written as text codes, such as "kg", "lbm", "km", "mi".
Hint 2
Unit codes are case-sensitive: "kg" works, "KG" returns #N/A.
Hint 3
Pattern: =CONVERT(B2, "kg", …), then copy down. For temperature, change the number and the unit codes.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2:D5

=CONVERT(B2,"kg","lbm")

Write it in D2, then fill down to D5.

E2:E5

=CONVERT(C2,"C","F")

Write it in E2, then fill down to E5.

Explanation

=CONVERT(B2,"kg","lbm") turns 60 kg into about 132.28 pounds, and =CONVERT(C2,"C","F") turns 210 °C into 410 °F. "lbm" means pound mass. Other common codes: "m" and "ft" for length, "l" and "gal" for volume. If a unit code is wrong or the units measure different things (say kg to km), the result is #N/A.

Starting worksheet: Sheet1
Row	A	B	C	D	E
1	Lot	Weight (kg)	Roast temp (°C)	Weight (lb)	Temp (°F)
2	Gayo	60	210
3	Toraja	45	205
4	Kintamani	30	220
5	Flores Bajawa	75	215
6
7
8
9
10
11
12
13
14

Fill in the requested cells, then press Check answer.

Validation result