Preview Extract

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

## Document Preview (28 of 285 Pages)

You are viewing preview pages of the document. Purchase to get full access instantly.

-37%

### Business Math Using Excel, 2nd Edition Solution Manual

$18.99 ~~$29.99~~Save:$11.00(37%)

24/7 Live Chat

Instant Download

100% Confidential

Store

##### Benjamin Harris

0 (0 Reviews)

## Best Selling

The World Of Customer Service, 3rd Edition Test Bank

$18.99 ~~$29.99~~Save:$11.00(37%)

Chemistry: Principles And Reactions, 7th Edition Test Bank

$18.99 ~~$29.99~~Save:$11.00(37%)

Test Bank for Hospitality Facilities Management and Design, 4th Edition

$18.99 ~~$29.99~~Save:$11.00(37%)

Solution Manual for Designing the User Interface: Strategies for Effective Human-Computer Interaction, 6th Edition

$18.99 ~~$29.99~~Save:$11.00(37%)

Data Structures and Other Objects Using C++ 4th Edition Solution Manual

$18.99 ~~$29.99~~Save:$11.00(37%)

2023-2024 ATI Pediatrics Proctored Exam with Answers (139 Solved Questions)

$18.99 ~~$29.99~~Save:$11.00(37%)