Business Math Using Excel, 2nd Edition Solution Manual

BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B 1 Chapter 02 – Quiz 02 2 C D Results as a Fraction in Lowest Terms Results as a Decimal to the Nearest Hundredth E F G H 3 4 Adding Fractions 5 6 7 8 9 10 11 Subtracting Fractions 12 13 14 15 16 17 18 Multiplying Fractions 19 20 21 22 23 24 25 Dividing Fractions 26 27 28 29 30 31 32 Directions: a. Key 5/6 in Cell A5 and 1/2 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result 33 as a decimal to the nearest hundredth. 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 7/12 in Cell A6 and 1/3 in Cell B6 (2) 2/3 in Cell A7 and 3/4 in Cell B7 35 (3) 2/5 in Cell A8 and 1 1/3 in Cell B8 (4) 5 1/6 in Cell A9 and 2 1/4 in Cell B9 36 c. Key 5/8 in Cell A12 and 3/8 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, 37 showing the result as a decimal to the nearest hundredth. 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/5 in Cell A13 and 2/3 in Cell B13 (2) 3/8 in Cell A14 and 1/4 in Cell B14 39 (3) 6 7/8 in Cell A15 and 1/5 in Cell B15 (4) 12 4/5 in Cell A16 and 1 2/3 in Cell B16 40 e. Key 7 5/7 in Cell A19 and 6 1/3 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by Cell B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, 41 showing the result as a decimal to the nearest hundredth. 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 3 5/6 in Cell A20 and 3 7/8 in Cell B20 (2) 1/16 in Cell A21 and 3/5 in Cell B21 43 (3) 12 5/6 in Cell A22 and 3 3/4 in Cell B22 (4) 8/9 in Cell A23 and 1/5 in Cell B23 44 g. Key 5/6 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two cells in Cell D26, 45 showing the result as a decimal to the nearest hundredth. 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 9/16 in Cell A27 and 1/4 in Cell B27 (2) 18 in Cell A28 and 1/6 in Cell B28 47 (3) 2 5/6 in Cell A29 and 7/8 in Cell B29 (4) 12 in Cell A30 and 3 1/4 in Cell B30 48 49 i. Save the file as ch02qz01a.xlsx. 50 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B C D E F G H 1 Chapter 02 – Quiz 02 (Answers) 2 Results as a Results as a Fraction in Decimal to the Lowest Terms Nearest Hundredth 3 4 Adding Fractions 5/6 1/2 1 1/3 1.33 5 7/12 1/3 11/12 0.92 6 2/3 3/4 1 5/12 1.42 7 2/5 1 1/3 1 11/15 1.73 8 5 1/6 2 1/4 7 5/12 7.42 9 10 11 Subtracting Fractions 12 5/8 3/8 1/4 0.25 13 4/5 2/3 2/15 0.13 14 3/8 1/4 1/8 0.13 15 6 7/8 1/5 6 27/40 6.68 16 12 4/5 1 2/3 11 2/15 11.13 17 18 Multiplying Fractions 19 7 5/7 6 1/3 48 6/7 48.86 20 3 5/6 3 7/8 14 41/48 14.85 21 1/16 3/5 3/80 0.04 22 12 5/6 3 3/4 48 1/8 48.13 23 8/9 1/5 8/45 0.18 24 25 Dividing Fractions 26 5/6 1/3 2 1/2 2.50 27 9/16 1/4 2 1/4 2.25 28 18 1/6 108 108.00 29 2 5/6 7/8 3 5/21 3.24 30 12 3 1/4 3 9/13 3.69 31 32 Directions: a. Key 5/6 in Cell A5 and 1/2 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result 33 as a decimal to the nearest hundredth. 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 7/12 in Cell A6 and 1/3 in Cell B6 (2) 2/3 in Cell A7 and 3/4 in Cell B7 35 (3) 2/5 in Cell A8 and 1 1/3 in Cell B8 (4) 5 1/6 in Cell A9 and 2 1/4 in Cell B9 36 c. Key 5/8 in Cell A12 and 3/8 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, 37 showing the result as a decimal to the nearest hundredth. 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/5 in Cell A13 and 2/3 in Cell B13 (2) 3/8 in Cell A14 and 1/4 in Cell B14 39 (3) 6 7/8 in Cell A15 and 1/5 in Cell B15 (4) 12 4/5 in Cell A16 and 1 2/3 in Cell B16 40 e. Key 7 5/7 in Cell A19 and 6 1/3 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by Cell B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, 41 showing the result as a decimal to the nearest hundredth. 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 3 5/6 in Cell A20 and 3 7/8 in Cell B20 (2) 1/16 in Cell A21 and 3/5 in Cell B21 43 (3) 12 5/6 in Cell A22 and 3 3/4 in Cell B22 (4) 8/9 in Cell A23 and 1/5 in Cell B23 44 g. Key 5/6 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two cells in Cell D26, 45 showing the result as a decimal to the nearest hundredth. 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 9/16 in Cell A27 and 1/4 in Cell B27 (2) 18 in Cell A28 and 1/6 in Cell B28 47 (3) 2 5/6 in Cell A29 and 7/8 in Cell B29 (4) 12 in Cell A30 and 3 1/4 in Cell B30 48 49 i. Save the file as ch02qz01a.xlsx. 50 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B 1 Chapter 02 – Quiz 01 2 C D Results as a Fraction in Lowest Terms Results as a Decimal to the Nearest Hundredth E F G 3 4 Adding Fractions 5 6 7 8 9 10 11 Subtracting Fractions 12 13 14 15 16 17 18 Multiplying Fractions 19 20 21 22 23 24 25 Dividing Fractions 26 27 28 29 30 31 32 Directions: a. Key 13/24 in Cell A5 and 3/8 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result 33 as a decimal to the nearest hundredth. 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/9 in Cell A6 and 1/3 in Cell B6 (2) 1/4 in Cell A7 and 5/6 in Cell B7 35 (3) 1/9 in Cell A8 and 3 1/3 in Cell B8 (4) 8 1/2 in Cell A9 and 6 1/4 in Cell B9 36 c. Key 5/6 in Cell A12 and 1/6 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, 37 showing the result as a decimal to the nearest hundredth. 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/5 in Cell A13 and 1/16 in Cell B13 (2) 2/3 in Cell A14 and 1/12 in Cell B14 39 (3) 6 3/8 in Cell A15 and 1/4 in Cell B15 (4) 4 3/8 in Cell A16 and 2 1/6 in Cell B16 40 e. Key 5 1/2 in Cell A19 and 2 1/6 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, 41 showing the results as a decimal to the nearest hundredth. 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 8 1/3 in Cell A20 and 2 1/5 in Cell B20 (2) 7/10 in Cell A21 and 1 2/5 in Cell B21 43 (3) 3 7/9 in Cell A22 and 6 3/32 in Cell B22 (4) 16/25 in Cell A23 and 5/8 in Cell B23 44 g. Key 1/2 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two cells in Cell D26, 45 showing the result as a decimal to the nearest hundredth. 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 17/20 in Cell A27 and 1/5 in Cell B27 (2) 18/19 in Cell A28 and 3/38 in Cell B28 47 (3) 7 1/25 in Cell A29 and 2 7/50 in Cell B29 (4) 18 in Cell A30 and 6 5/6 in Cell B30 48 49 i. Save the file as ch02qz01a.xlsx. 50 H BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B C D E F G H 1 Chapter 02 – Quiz 01 (Answers) 2 Results as a Results as a Fraction in Decimal to the Lowest Terms Nearest Hundredth 3 4 Adding Fractions 13/24 3/8 11/12 0.92 5 4/9 1/3 7/9 0.78 6 1/4 5/6 1 1/12 1.08 7 1/9 3 1/3 3 4/9 3.44 8 8 1/2 6 1/4 14 3/4 14.75 9 10 11 Subtracting Fractions 12 5/6 1/6 2/3 0.67 13 4/5 1/16 59/80 0.74 14 2/3 1/12 7/12 0.58 15 6 3/8 1/4 6 1/8 6.13 16 4 3/8 2 1/6 2 5/24 2.21 17 18 Multiplying Fractions 19 5 1/2 2 1/6 11 11/12 11.92 20 8 1/3 2 1/5 18 1/3 18.33 21 7/10 1 2/5 49/50 0.98 22 3 7/9 6 3/32 23 1/48 23.02 23 16/25 5/8 2/5 0.40 24 25 Dividing Fractions 26 1/2 1/3 1 1/2 1.50 27 17/20 1/5 4 1/4 4.25 28 18/19 3/38 12 12.00 29 7 1/25 2 7/50 3 31/107 3.29 30 18 6 5/6 2 26/41 2.63 31 32 Directions: a. Key 13/24 in Cell A5 and 3/8 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result 33 as a decimal to the nearest hundredth. 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/9 in Cell A6 and 1/3 in Cell B6 (2) 1/4 in Cell A7 and 5/6 in Cell B7 35 (3) 1/9 in Cell A8 and 3 1/3 in Cell B8 (4) 8 1/2 in Cell A9 and 6 1/4 in Cell B9 36 c. Key 5/6 in Cell A12 and 1/6 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, 37 showing the result as a decimal to the nearest hundredth. 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 4/5 in Cell A13 and 1/16 in Cell B13 (2) 2/3 in Cell A14 and 1/12 in Cell B14 39 (3) 6 3/8 in Cell A15 and 1/4 in Cell B15 (4) 4 3/8 in Cell A16 and 2 1/6 in Cell B16 40 e. Key 5 1/2 in Cell A19 and 2 1/6 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, 41 showing the results as a decimal to the nearest hundredth. 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 8 1/3 in Cell A20 and 2 1/5 in Cell B20 (2) 7/10 in Cell A21 and 1 2/5 in Cell B21 43 (3) 3 7/9 in Cell A22 and 6 3/32 in Cell B22 (4) 16/25 in Cell A23 and 5/8 in Cell B23 44 g. Key 1/2 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two cells in Cell D26, 45 showing the result as a decimal to the nearest hundredth. 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 17/20 in Cell A27 and 1/5 in Cell B27 (2) 18/19 in Cell A28 and 3/38 in Cell B28 47 (3) 7 1/25 in Cell A29 and 2 7/50 in Cell B29 (4) 18 in Cell A30 and 6 5/6 in Cell B30 48 49 i. Save the file as ch02qz01a.xlsx. 50 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D Total Decimal Equivalent Chapter 02 – Practice 04 2 3 4 5 6 7 8 9 4 7/8 12 3/7 3/4 5 67 1/2 2/3 4/5 5/8 2/5 13 2/5 10 Directions: 12 1. Use the Pointing Method to enter a formula to divide fractions. 13 2. Format Column C for Fraction. Set Type to Up to three digits. 14 3. Click on Cell C5, enter (=). 15 4. Click on Cell A5, enter (/), click on Cell B5, and press Enter. 16 5. Copy the formula in Cell C5 into the remaining cells in the column. 17 6. Format the cells in Column D for Number. Set Decimal places to 2. 7. Enter formulas in Column D to divide the fractions in Column A by 18 the fractions in Column B. 19 8. Save the file as ch02pr04a.xlsx. 11 20 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D Chapter 02 – Practice 04 (Answers) 2 3 Total 4 5 6 7 8 9 4 7/8 12 3/7 3/4 5 67 1/2 2/3 4/5 5/8 2/5 13 2/5 7 5/16 15 15/28 1 1/5 12 1/2 5 5/134 Decimal Equivalent 7.31 15.54 1.20 12.50 5.04 10 Directions: 12 1. Use the Pointing Method to enter a formula to divide fractions. 13 2. Format Column C for Fraction. Set Type to Up to three digits. 14 3. Click on Cell C5, enter (=). 15 4. Click on Cell A5, enter (/), click on Cell B5, and press Enter. 16 5. Copy the formula in Cell C5 into the remaining cells in the column. 17 6. Format the cells in Column D for Number. Set Decimal places to 2. 7. Enter formulas in Column D to divide the fractions in Column A by 18 the fractions in Column B. 19 8. Save the file as ch02pr04a.xlsx. 11 20 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D Chapter 02 – Practice 03 2 Total 3 4 5 6 7 8 9 2/3 6 5/6 6/7 25 1/8 12 3/4 4/5 1 5/8 7/8 1/5 4/5 5 2/3 5/6 4/5 9 2/5 1 3/4 8/9 5/7 13 1/6 10 Directions: 1. Use the Pointing Method to enter a formula to multiply fractions in 12 Cell D4. 2. Format Column D for Fraction. Set Type to Up to three digits. 13 14 3. Click on Cell D4, and enter (=). 15 4. Click on Cell A4, key (*), click on Cell B4, key (*), and click on Cell C4. 16 5. Press Enter. 17 6. Copy the formula in Cell D4 into the remaining cells in the column. 18 7. Save the file as ch02pr03a.xlsx. 11 19 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D 4/5 9 2/5 1 3/4 8/9 5/7 13 1/6 Total 13/15 56 49/240 3/10 17 13/15 51 17/28 8 7/9 Chapter 02 – Practice 03 (Answers) 2 3 4 5 6 7 8 9 2/3 6 5/6 6/7 25 1/8 12 3/4 4/5 1 5/8 7/8 1/5 4/5 5 2/3 5/6 10 Directions: 1. Use the Pointing Method to enter a formula to multiply fractions in 12 Cell D4. 2. Format Column D for Fraction. Set Type to Up to three digits. 13 14 3. Click on Cell D4, and enter (=). 15 4. Click on Cell A4, key (*), click on Cell B4, key (*), and click on Cell C4. 16 5. Press Enter. 17 6. Copy the formula in Cell D4 into the remaining cells in the column. 18 7. Save the file as ch02pr03a.xlsx. 11 19 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B C D E F G 1 Chapter 02 – Practice 02 2 3 Adding Fractions 4 3/4 4 5/6 11 2/7 5 2/3 4 1/2 1 1/2 6 1 2/5 9 1/3 11 4/5 7 3/4 1 2/3 1 3/5 8 1 1/6 4/9 2/5 9 Total 10 11 Subtracting Fractions 12 11 4/5 7/12 13 7 1/2 3/7 14 Total 15 16 Directions: 17 1. Use the AutoSum button to enter the formula in Cell B9 to add Column B. 18 2. Format Cell B9 for Fraction. Set Type to Up to two digits. 19 3. Click on Cell B9. 20 4. Click the Copy button. The selected cell blinks. 21 5. Highlight Cells C9 and D9. 22 6. Click Paste or press Enter. The results appear in Cells C9 and D9. 23 7. Click on Cell B14. Use the Pointing Method to enter the formula to subtract Cell B13 from Cell B12. 24 8. Enter (=) and point to Cell B12. 25 9. Key (-) and point to Cell B13. 26 10. Press Enter to subtract the two cells. 27 11. Format Cell B14 for Fraction. Set Type to Up to two digits. 28 12. Click on Cell B14. 29 13. Click the Copy button. 30 14. Highlight Cell D9. 31 15. Click Paste or press Enter. The result appears in Cell D14. 32 16. Save the file as ch02pr02a.xlsx. 33 H BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B C D E F G 1 Chapter 02 – Practice 02 (Answers) 2 3 Adding Fractions 4 3/4 4 5/6 11 2/7 5 2/3 4 1/2 1 1/2 6 1 2/5 9 1/3 11 4/5 7 3/4 1 2/3 1 3/5 8 1 1/6 4/9 2/5 9 Total 4 11/15 20 7/9 26 41/70 10 11 Subtracting Fractions 12 11 4/5 7/12 13 7 1/2 3/7 14 Total 4 3/10 13/84 15 16 Directions: 17 1. Use the AutoSum button to enter the formula in Cell B9 to add Column B. 18 2. Format Cell B9 for Fraction. Set Type to Up to two digits. 19 3. Click on Cell B9. 20 4. Click the Copy button. The selected cell blinks. 21 5. Highlight Cells C9 and D9. 22 6. Click Paste or press Enter. The results appear in Cells C9 and D9. 23 7. Click on Cell B14. Use the Pointing Method to enter the formula to subtract Cell B13 from Cell B12. 24 8. Enter (=) and point to Cell B12. 25 9. Key (-) and point to Cell B13. 26 10. Press Enter to subtract the two cells. 27 11. Format Cell B14 for Fraction. Set Type to Up to two digits. 28 12. Click on Cell B14. 29 13. Click the Copy button. 30 14. Highlight Cell D9. 31 15. Click Paste or press Enter. The result appears in Cell D14. 32 16. Save the file as ch02pr02a.xlsx. 33 H BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Practice 01 2 3 Entering fractions to display in hundredths and their decimal equivalents. 4 5 6 7 8 9 10 11 12 13 14 Directions: 16 1. Click on Cell A4. 2. Key a zero followed by a space followed by the fraction 5/8 in x/y format 17 (where x is the numerator and y is the denominator.) 18 3. Press Enter. 19 4. The fraction appears in the cell, and the decimal equivalent is shown in the formula bar. 5. Repeat steps 2 and 3 for fractions 13/25 in Cell A6, 16/24 in Cell A8, and 25/40 in Cell A10. Notice that fractions are displayed in lowest terms, so 16/24 is displayed as 2/3 20 and 25/40 is displayed as 5/8. 6. Enter the mixed number 2 5/6 in Cell A12. Key 2 followed by a space followed by the 21 fraction 5/6 in x/y format. 22 7. Press Enter. 23 8. Click on Cell B4. 9. Repeat steps 2 and 3 putting the same fractions in different cells: 5/8 in Cell B4, 24 13/25 in Cell B6, 16/24 in Cell B8, 25/40 in Cell B10, and 2 5/6 in Cell B12. 15 25 To display the fractions in hundredths: 27 10. Select Cell A4. 11. Click on Home/Cells/Format/Format Cells. On the Number tab, select Category: Fraction and Type: As hundredths. Click OK. 28 29 12. The fraction should display in hundredths. 30 13. Repeat step 11 for fractions in Cells A6, A8, A10, and A12. 26 31 To display the fractions in decimal equivalents: 33 14. Select Cell B4. 15. Click on Home/Cells/Format Cells. On the Number tab, select Category: Number, Decimal places = 2 and click OK. 34 35 16. Repeat step 15 for fractions in Cells B6, B8, B10, and B12. 36 17. Save the file as ch02pr01a.xlsx. 32 37 I BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Practice 01 (Answers) 2 3 4 Entering fractions to display in hundredths and their decimal equivalents. 63/100 0.63 5 6 52/100 0.52 67/100 0.67 63/100 0.63 2 83/100 2.83 7 8 9 10 11 12 13 14 Directions: 16 1. Click on Cell A4. 2. Key a zero followed by a space followed by the fraction 5/8 in x/y format 17 (where x is the numerator and y is the denominator.) 18 3. Press Enter. 19 4. The fraction appears in the cell, and the decimal equivalent is shown in the formula bar. 5. Repeat steps 2 and 3 for fractions 13/25 in Cell A6, 16/24 in Cell A8, and 25/40 in Cell A10. Notice that fractions are displayed in lowest terms, so 16/24 is displayed as 2/3 20 and 25/40 is displayed as 5/8. 6. Enter the mixed number 2 5/6 in Cell A12. Key 2 followed by a space followed by the 21 fraction 5/6 in x/y format. 22 7. Press Enter. 23 8. Click on Cell B4. 9. Repeat steps 2 and 3 putting the same fractions in different cells: 5/8 in Cell B4, 24 13/25 in Cell B6, 16/24 in Cell B8, 25/40 in Cell B10, and 2 5/6 in Cell B12. 15 25 To display the fractions in hundredths: 27 10. Select Cell A4. 11. Click on Home/Cells/Format/Format Cells. On the Number tab, select Category: Fraction and Type: As hundredths. Click OK. 28 29 12. The fraction should display in hundredths. 30 13. Repeat step 11 for fractions in Cells A6, A8, A10, and A12. 26 31 To display the fractions in decimal equivalents: 33 14. Select Cell B4. 15. Click on Home/Cells/Format Cells. On the Number tab, select Category: Number, Decimal places = 2 and click OK. 34 35 16. Repeat step 15 for fractions in Cells B6, B8, B10, and B12. 36 17. Save the file as ch02pr01a.xlxs. 32 37 I BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B 1 Chapter 02 Exercise 08 C D 2 3 Adding Fractions 4 5 6 7 8 11 3/8 7 4 6/7 1/8 5 1/6 5/12 56 7/8 2 4/5 2/5 14 5/8 1/3 3/8 2/35 1/5 3 1/12 9 10 Subtracting Fractions 11 12 13 14 15 25 5/6 16 2/3 3 1/8 35 1/3 4/5 4 2/5 1/3 1/5 14 5/12 16 17 Multiplying Fractions 18 19 20 21 22 3/8 17 14 3/4 2 1/8 15 5/6 5/6 32 7/8 12 4/5 12 2/5 3/8 1/3 5/8 1/6 3/5 3 1/12 23 24 Dividing Fractions 25 26 27 28 29 5 5/6 6 2/9 3 6 1/8 16 1/3 1/5 2/5 1/3 1/5 33 3/4 30 31 Directions: 32 Adding Fractions 33 a. Format Column D for Fraction. Set Type for Up to two digits. 34 b. Key a formula in Cell D4 to add Cells A4, B4, and C4. 35 c. Copy the formula from Cell D4 into the remaining cells in Column D. 36 d. Format Column E to show a decimal to the nearest thousandth. 37 e. Key a formula in Cell E4 to add Cells A4, B4, and C4. 38 f. Copy the formula from Cell E4 into the remaining cells in Column D. 39 Subtracting Fractions 40 a. Format Column C for Fraction. Set Type for Up to two digits. 41 b. Key a formula in Cell C11 to subtract Cell B11 from Cell A11. 42 c. Copy the formula from Cell C11 into the remaining cells in Column C. 43 Multiplying Fractions 44 a. Format Column D for Fraction. Set Type for Up to three digits. 45 b. Key a formula in Cell D18 to multiply Cells A18, B18, and C18. 46 c. Copy the formula from Cell D18 into the remaining cells in Column D. 47 Dividing Fractions 48 a. Format Column C for Fraction. Set Type for Up to three digits. 49 b. Key a formula in Cell C25 to divide Cell A25 by Cell B25. 50 c. Copy the formula from Cell C25 into the remaining cells in Column C. 51 d. Save the file as ch02ex08a.xlsx. 52 E BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B 1 Chapter 02 Exercise 08 (Answers) C D 5/12 56 7/8 2 4/5 2/5 14 5/8 1/3 3/8 2/35 1/5 3 1/12 12 1/8 64 1/4 7 5/7 29/40 22 7/8 4/5 4 2/5 1/3 1/5 14 5/12 25 1/30 12 4/15 2 2/3 – 3/40 20 11/12 5/6 32 7/8 12 4/5 12 2/5 3/8 1/3 5/8 1/6 3/5 3 1/12 E 2 3 Adding Fractions 4 5 6 7 8 11 3/8 7 4 6/7 1/8 5 1/6 9 10 Subtracting Fractions 11 12 13 14 15 25 5/6 16 2/3 3 1/8 35 1/3 16 17 Multiplying Fractions 18 19 20 21 22 3/8 17 14 3/4 2 1/8 15 5/6 5/48 349 19/64 31 7/15 15 81/100 18 59/192 23 24 Dividing Fractions 25 26 27 28 29 5 5/6 6 2/9 3 6 1/8 16 1/3 1/5 2/5 1/3 1/5 33 3/4 29 15 9 30 1/6 5/9 5/8 196/405 30 31 Directions: 32 Adding Fractions 33 a. Format Column D for Fraction. Set Type for Up to two digits. 34 b. Key a formula in Cell D4 to add Cells A4, B4, and C4. 35 c. Copy the formula from Cell D4 into the remaining cells in Column D. 36 d. Format Column E to show a decimal to the nearest thousandth. 37 e. Key a formula in Cell E4 to add Cells A4, B4, and C4. 38 f. Copy the formula from Cell E4 into the remaining cells in Column D. 39 Subtracting Fractions 40 a. Format Column C for Fraction. Set Type for Up to two digits. 41 b. Key a formula in Cell C11 to subtract Cell B11 from Cell A11. 42 c. Copy the formula from Cell C11 into the remaining cells in Column C. 43 Multiplying Fractions 44 a. Format Column D for Fraction. Set Type for Up to three digits. 45 b. Key a formula in Cell D18 to multiply Cells A18, B18, and C18. 46 c. Copy the formula from Cell D18 into the remaining cells in Column D. 47 Dividing Fractions 48 a. Format Column C for Fraction. Set Type for Up to three digits. 49 b. Key a formula in Cell C25 to divide Cell A25 by Cell B25. 50 c. Copy the formula from Cell C25 into the remaining cells in Column C. 51 d. Save the file as ch02ex08a.xlsx. 52 12.125 64.250 7.714 0.725 22.875 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B 1 Chapter 02 – Exercise 07 2 C D Results as a Fraction in Lowest Terms Results as a Decimal to the Nearest Hundredth E F G H 3 4 Adding Fractions 5 6 7 8 9 10 11 Subtracting Fractions 12 13 14 15 16 17 18 Multiplying Fractions 19 20 21 22 23 24 25 Dividing Fractions 26 27 28 29 30 31 32 Directions: a. Key 3/5 in Cell A5 and 1/3 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result as a decimal to the nearest hundredth. 33 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 7/12 in Cell A6 and 2/3 in Cell B6 (2) 3/4 in Cell A7 and 1/6 in Cell B7 35 (3) 2/5 in Cell A8 and 3 7/8 in Cell B8 (4) 6 7/8 in Cell A9 and 3 1/4 in Cell B9 36 c. Key 3/8 in Cell A12 and 1/8 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, showing the result as a decimal to the nearest hundredth. 37 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 2/5 in Cell A13 and 3/8 in Cell B13 (2) 1/3 in Cell A14 and 1/4 in Cell B14 39 (3) 7 1/8 in Cell A15 and 3/4 in Cell B15 (4) 12 5/8 in Cell A16 and 10 2/3 in Cell B16 40 e. Key 7 1/4 in Cell A19 and 15 1/3 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by Cell B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, showing the result as a decimal to the nearest hundredth. 41 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 13 5/6 in Cell A20 and 6 2/3 in Cell B20 (2) 1/16 in Cell A21 and 2/5 in Cell B21 43 (3) 17/20 in Cell A22 and 7 2/3 in Cell B22 (4) 8/9 in Cell A23 and 7/8 in Cell B23 44 g. Key 2/3 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two cells in Cell D26, showing the result as a decimal to the nearest hundredth. 45 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. (1) 7/8 in Cell A27 and 1/4 in Cell B27 (2) 15/19 in Cell A28 and 1/5 in Cell B28 47 (3) 2 5/6 in Cell A29 and 1 1/3 in Cell B29 (4) 8 in Cell A30 and 2 1/4 in Cell B30 48 49 i. Save the file as ch02ex07a.xlsx. 50 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A B C D E F G H 1 Chapter 02 – Exercise 07 (Answers) 2 Results as a Results as a Fraction in Decimal to the Lowest Terms Nearest Hundredth 3 4 Adding Fractions 5 3/5 1/3 14/15 0.93 6 7/12 2/3 1 1/4 1.25 7 3/4 1/6 11/12 0.92 8 2/5 3 7/8 4 11/40 4.28 9 6 7/8 3 1/4 10 1/8 10.13 10 11 Subtracting Fractions 12 3/8 1/8 1/4 0.25 13 2/5 3/8 1/40 0.03 14 1/3 1/4 1/12 0.08 15 7 1/8 3/4 6 3/8 6.38 16 12 5/8 10 2/3 1 23/24 1.96 17 18 Multiplying Fractions 19 7 1/4 15 1/3 111 1/6 111.17 20 13 5/6 6 2/3 92 2/9 92.22 21 1/16 2/5 1/40 0.03 22 17/20 7 2/3 6 31/60 6.52 23 8/9 7/8 7/9 0.78 24 25 Dividing Fractions 26 2/3 1/3 2 2.00 27 7/8 1/4 3 1/2 3.50 28 15/19 1/5 3 18/19 3.95 29 2 5/6 1 1/3 2 1/8 2.13 30 8 2 1/4 3 5/9 3.56 31 32 Directions: a. Key 3/5 in Cell A5 and 1/3 in Cell B5. Key a formula to add those two cells in Cell C5, showing the result as a fraction in lowest terms. Key a formula to add those two cells in Cell D5, showing the result as a decimal to the nearest hundredth. 33 34 b. Repeat step a for the following fractions, placing the formulas in the adjacent cells in Columns C & D. 35 (1) 7/12 in Cell A6 and 2/3 in Cell B6 (2) 3/4 in Cell A7 and 1/6 in Cell B7 36 (3) 2/5 in Cell A8 and 3 7/8 in Cell B8 (4) 6 7/8 in Cell A9 and 3 1/4 in Cell B9 c. Key 3/8 in Cell A12 and 1/8 in Cell B12. Key a formula in Cell C12 to subtract Cell B12 from Cell A12, showing the result as a fraction in lowest terms. Key a formula to subtract those two cells in Cell D12, showing the result as a decimal to the nearest hundredth. 37 38 d. Repeat step c for the following fractions, placing the formulas in the adjacent cells in Columns C & D. 39 (1) 2/5 in Cell A13 and 3/8 in Cell B13 (2) 1/3 in Cell A14 and 1/4 in Cell B14 40 (3) 7 1/8 in Cell A15 and 3/4 in Cell B15 (4) 12 5/8 in Cell A16 and 10 2/3 in Cell B16 e. Key 7 1/4 in Cell A19 and 15 1/3 in Cell B19. Key a formula in Cell C19 to multiply Cell A19 by Cell B19, showing the result as a fraction in lowest terms. Key a formula to multiply those two cells in Cell D19, showing the result as a decimal to the nearest hundredth. 41 42 f. Repeat step e for the following fractions, placing the formulas in the adjacent cells in Columns C & D. 43 (1) 13 5/6 in Cell A20 and 6 2/3 in Cell B20 (2) 1/16 in Cell A21 and 2/5 in Cell B21 44 (3) 17/20 in Cell A22 and 7 2/3 in Cell B22 (4) 8/9 in Cell A23 and 7/8 in Cell B23 g. Key 2/3 in Cell A26 and 1/3 in Cell B26. Key a formula in Cell C26 to divide Cell A26 by Cell B26, showing the result as a fraction in lowest terms. Key a formula to divide those two 45 cells in Cell D26, showing the result as a decimal to the nearest hundredth. 46 h. Repeat step g for the following fractions, placing the formulas in the adjacent cells in Columns C & D. 47 (1) 7/8 in Cell A27 and 1/4 in Cell B27 (2) 15/19 in Cell A28 and 1/5 in Cell B28 48 (3) 2 5/6 in Cell A29 and 1 1/3 in Cell B29 (4) 8 in Cell A30 and 2 1/4 in Cell B30 49 i. Save the file as ch02ex07a.xlsx. 50 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 06 2 Total 3 4 5 6 7 8 9 3 3/4 12 5/6 118 2/3 26 4/7 6 5/8 11 7/8 5 1/2 4 1/4 11 3/5 2/3 1 5/6 10 Directions: a. Format Column C for Fraction. Set Type to 12 Up to three digits. b. Click Cell C4. 13 14 c. Key in the formula to divide Cell A4 by Cell B4. d. Copy the formula in Cell C4 to the remaining 15 cells in the column. 16 e. Save the file as ch02ex06a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 06 (Answers) 2 3 4 5 6 7 8 9 3 3/4 12 5/6 118 2/3 26 4/7 6 5/8 11 7/8 5 1/2 4 1/4 11 3/5 2/3 1 5/6 Total 15/22 3 5/24 474 2/3 2 59/203 9 15/16 6 21/44 10 Directions: a. Format Column C for Fraction. Set Type to 12 Up to three digits. b. Click Cell C4. 13 14 c. Key in the formula to divide Cell A4 by Cell B4. d. Copy the formula in Cell C4 to the remaining 15 cells in the column. 16 e. Save the file as ch02ex06a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D Chapter 02 – Exercise 05 2 Total 3 4 5 6 7 8 9 3 3/4 12 5/6 118 2/3 23 5/7 5/8 7/8 5 1/2 4 1/4 11 5/6 2/3 1 5/6 6 3/4 1/6 1/7 5 4 10 Directions: 12 a. Format Column D for Fraction. Set Type to Up to three digits. 13 b. Click Cell D4. 14 c. Key in the formula to multiply Cell A4, Cell B4, and Cell C4. 15 d. Copy the formula in Cell D4 to the remaining cells in the column. 16 e. Save the file as ch02ex05a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D 6 3/4 1/6 1/7 5 4 Total 123 3/4 38 1/2 4 17/18 40 13/147 2 1/12 6 5/12 Chapter 02 – Exercise 05 (Answers) 2 3 4 5 6 7 8 9 3 3/4 12 5/6 118 2/3 23 5/7 5/8 7/8 5 1/2 4 1/4 11 5/6 2/3 1 5/6 10 Directions: 12 a. Format Column D for Fraction. Set Type to Up to three digits. 13 b. Click Cell D4. 14 c. Key in the formula to multiply Cell A4, Cell B4, and Cell C4. 15 d. Copy the formula in Cell D4 to the remaining cells in the column. 16 e. Save the file as ch02ex05a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 04 2 Total 3 4 5 6 7 8 510 17 2/7 6 1/2 9 3/7 9 1/2 15 1/3 9 3/8 3 5/8 3 5/7 2/3 9 Directions: a. Format Column C for Fraction. Set Type to 11 Up to two digits. 12 b. Click on Cell C4. c. Key in the formula to subtract Cell B4 from 13 Cell A4. d. Copy the formula in Cell C4 to the remaining Cells in the column. 14 15 e. Save the file as ch02ex04a.xlsx. 10 16 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 04 (Answers) 2 3 4 5 6 7 8 510 17 2/7 6 1/2 9 3/7 9 1/2 15 1/3 9 3/8 3 5/8 3 5/7 2/3 Total 494 2/3 7 51/56 2 7/8 5 5/7 8 5/6 9 Directions: a. Format Column C for Fraction. Set Type to 11 Up to two digits. 12 b. Click on Cell C4. c. Key in the formula to subtract Cell B4 from 13 Cell A4. d. Copy the formula in Cell C4 to the remaining Cells in the column. 14 15 e. Save the file as ch02ex04a.xlsx. 10 16 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 03 2 Total 3 4 5 6 7 8 9 5/9 21/50 2/5 11 1/2 24 1/2 11 5/7 7/9 6/25 4/5 6 1/4 17 3/8 6 4/11 10 Directions: a. Format Column C for Fraction. Set Type to 12 Up to two digits. b. Click on Cell C4. 13 14 c. Key in the formula to add Cell A4 to Cell B4. d. Copy the formula in Cell C4 to the remaining 15 cells in the column. 16 e. Save the file as ch02ex03a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C Chapter 02 – Exercise 03 (Answers) 2 3 4 5 6 7 8 9 5/9 21/50 2/5 11 1/2 24 1/2 11 5/7 7/9 6/25 4/5 6 1/4 17 3/8 6 4/11 Total 1 1/3 33/50 1 1/5 17 3/4 41 7/8 18 6/77 10 Directions: a. Format Column C for Fraction. Set Type to 12 Up to two digits. b. Click on Cell C4. 13 14 c. Key in the formula to add Cell A4 to Cell B4. d. Copy the formula in Cell C4 to the remaining 15 cells in the column. 16 e. Save the file as ch02ex03a.xlsx. 11 17 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Exercise 02 2 3 Entering fractions. 4 5 6 7 8 Entering fractions and displaying them as decimals with two decimal places. 9 10 11 12 Directions: 14 a. Click on Cell A4. 15 b. Key 5/6 so it will display as a fraction. 16 c. Press Enter. d. The fraction appears in the cell, and the decimal equivalent is shown in the formula bar. 17 e. Repeat steps b through d for the following fractions, placing them in the 18 referenced cell: 2 3/8 in Cell A5 and 3 2/3 in Cell A6. 19 f. Click on Cell A9. 20 g. Key 5/6 as a fraction. 21 h. Press Enter. I. Format the fraction using the Format Cells dialog box so it will display as a 22 decimal with two places. j. Repeat steps g through i for the following fractions, placing them in the 23 referenced cell: 2 3/8 in Cell A10 and 3 2/3 in Cell A11. 24 k. Save the file as ch02ex02a.xlsx. 13 25 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Exercise 02 (Answers) 2 Entering fractions. 5/6 4 2 3/8 5 3 2/3 6 3 7 8 Entering fractions and displaying them as decimals with two decimal places. 0.83 9 2.38 10 3.67 11 12 Directions: 14 a. Click on Cell A4. 15 b. Key 5/6 so it will display as a fraction. 16 c. Press Enter. d. The fraction appears in the cell, and the decimal equivalent is shown in the formula bar. 17 e. Repeat steps b through d for the following fractions, placing them in the 18 referenced cell: 2 3/8 in Cell A5 and 3 2/3 in Cell A6. 19 f. Click on Cell A9. 20 g. Key 5/6 as a fraction. 21 h. Press Enter. I. Format the fraction using the Format Cells dialog box so it will display as a 22 decimal with two places. j. Repeat steps g through i for the following fractions, placing them in the 23 referenced cell: 2 3/8 in Cell A10 and 3 2/3 in Cell A11. 24 k. Save the file as ch02ex02a.xlsx. 13 25 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Exercise 01 2 3 Entering fractions. 4 5 6 7 8 Entering fractions and displaying them as decimals with two decimal places. 9 10 11 12 Directions: 14 a. Click on Cell A4. 15 b. Key 3/4 so it will display as a fraction. 16 c. Press Enter. d. The fraction appears in the cell, and the decimal equivalent is shown in 17 the formula bar. e. Repeat steps b through d for the following fractions, placing them in the 18 referenced cell: 7/8 in Cell A5 and 6 1/3 in Cell A6. f. Click on Cell A9. 19 20 g. Key 3/4 as a fraction. 21 h. Press Enter. i. Format the fraction using the Format Cells dialog box so it will display as a 22 decimal with two places. j. Repeat steps g through i for the following fractions, placing them in the 23 referenced cell: 7/8 in Cell A10 and 6 1/3 in Cell A11. k. Save the file as ch02ex01a.xlsx. 24 13 25 BUSINESS MATH Name ______________________________ USING EXCEL Date ______________________________ A 1 B C D E F G H Chapter 02 – Exercise 01 (Answers) 2 Entering fractions. 3/4 4 7/8 5 6 1/3 6 3 7 8 Entering fractions and displaying them as decimals with two decimal places. 0.75 9 0.88 10 6.33 11 12 Directions: 14 a. Click on Cell A4. 15 b. Key 3/4 so it will display as a fraction. 16 c. Press Enter. d. The fraction appears in the cell, and the decimal equivalent is shown in 17 the formula bar. e. Repeat steps b through d for the following fractions, placing them in the 18 referenced cell: 7/8 in Cell A5 and 6 1/3 in Cell A6. f. Click on Cell A9. 19 20 g. Key 3/4 as a fraction. 21 h. Press Enter. i. Format the fraction using the Format Cells dialog box so it will display as a 22 decimal with two places. j. Repeat steps g through i for the following fractions, placing them in the 23 referenced cell: 7/8 in Cell A10 and 6 1/3 in Cell A11. k. Save the file as ch02ex01a.xlsx. 24 13 25