Chapter 10.2, Problem 6CC

As part of the design of a high-performance engine, you are analyzing properties of spherical ceramic ball bearings. Since many ceramic materials are considerably less dense than the metals typically used in such applications, the centrifugal load added by the bearings can be significantly reduced by the use of ceramics.

	A	B	C	D	E	F	G
1
2	Mass of Ball Bearings (m) [g]
3		Specific Gravity
4	Radius (r) [cm]	3.12	3.18	3.22	3.31	3.37
5	1.00	13.1	13.3	13.5	13.9	14.1
6	1.05	15.1	15.4	15.6	16.1	16.3
7	1.10	17.4	17.7	18.0	18.5	18.8
8	1.15	19.9	20.3	20.5	21.1	21.5
9	1.20	22.6	23.0	23.3	24.0	24.4
10	1.25	25.5	26.0	26.3	27.1	27.6
11	1.30	28.7	29.3	29.6	30.5	31.0

Which of the following could be typed in cell B5 and copied across to cell F5, then down to cell F11 to calculate the masses of the various ball bearings shown in the table? If more than one answer is correct, indicate all that apply.

1. A.    = 4/3 * PI * $A5 ^ 3 * $B4
2. B.     = 4/3 * PI() * $A5 ^ 3 * B$4
3. C.     = 4/3 * PI() * $A$5 ^ 3 * $B$4
4. D.    = 4/3 * PI * A$5 ^ 3 * B$4
5. E.     = 4/3 * PI() * A5 ^ 3 * B4