Trong một bảng tính, dữ liệu đầu vào như lít. Để chuyển đổicác giá trị quy mô khác nhau, sử dụng công thức sau đổi lít thùng, lít và lonĐể chuyển đổi nhiệt độ từ Fahrenheit sang Celsius, bạn có thể sử dụng công thức hoặc bạn có thể sử dụng tính toán mô tả ở đây. | Convert liters to barrels gallons quarts and pints In a worksheet data is input as liters. To convert the value to different scales use the following formulas. To convert liters to barrels gallons quarts and pints 1. Select cell B1 and enter 150. 2. Select cell B3 and type the formula B 1 to convert to barrels. 3. Select cell B4 and type the formula B 1 to convert to gallons. 4. Select cell B5 and type the formula B 1 to convert to quarts. 5. Select cell B6 and type the formula B 1 to convert to pints. 24 Chapter 1 Convert from Fahrenheit to Celsius To convert temperatures from Fahrenheit to Celsius you can use the formula Fahrenheit-32 5 9 or you can use the calculation described here. To convert from Fahrenheit to Celsius 1. In a worksheet enter a few temperatures in Fahrenheit in column A. 2. Select cells B2 B14 and type the following formula A2 32. 3. Press Ctrl Enter . B2 2J A2 32 A B I Õ- 1 Celsius Fahrenheit 2 30 C 86 F 3 25 C 77 F 4 20 C 68 F 5 15 C 59 F 6 10 C 58 F 7 5 C 41 F Ũ 0 C 32 F 9 -5 C 23 F 10 -10 C 14 F 11 -15 C 5 F 12 -20 C -4 F 13 -25 C -13 F 14 -30 C -22 F 15 Figure 1-24 Note You can create a user-defined format to insert the degree sign . Go to the Format menu and select Cells Number Custom. In the Type box select General and press OK. Select a cell hold down the Alt key type 0176 on the numeric keypad then release Alt and type either F or C without the quotes. Formulas in Excel 25 Convert from Celsius to Fahrenheit To convert temperatures from Celsius to Fahrenheit you can use the formula Celsius 9 5 32 or you can use the calculation described here. To convert from Celsius to Fahrenheit 1. In a worksheet enter a few temperatures in Celsius in column A. 2. Select cells B2 B14 and type the following formula A2-32 . 3. Press Ctrl Enter . B2 21 A2-32 A B c _ _ D 1 Fahrenheit Celsius 2 100 F 38 C 3 90 F 32 C 4 80 F 27 C 5 70 F 21 C 6 60 F 16 C 7 50 F 10 C 8 40 F 4 C 9 30 F -1 C 10 20 F -7 C 11 10 F
