Chapter 10, Problem 13ICA

Refer to the following worksheet. In all questions, give the requested answers in Excel notation, indicating EXACTLY what you would type into the cell given to properly execute the required procedures.

1. a. In column B, you wish to determine the radius of a cylinder. The volume (column A) and height (cell B3) have been provided. Recall that the volume of a cylinder is given by V = πr² H. Assume you will write the formula in cell B8 and copy it down the column to cell B100. In the expression, fill in the blanks with any Excel functions and fill in the boxes with any dollar signs necessary for relative, mixed, or absolute references.
2. b. In column C, the area of a cylinder corresponding to the radius (in column B) and the height (cell B3) has been determined in units of square feet. In column D, you wish to express these values in units of square centimeters. Fill in any Excel mathematical operators or parenthesis for the expression to correctly complete this conversion.

= C8___2.54___2___12___2

1. c. In columns E–G, we wish to determine the dimensions of a rectangular container with the same volume as the cylinders given in column A. The rectangle will be the same height as the cylinder (cell B3) but will have three possible widths (contained in cells E4 – G4). Fill in the following boxes with any dollar signs necessary for relative, mixed, or absolute references to allow the expression to determine the length in cell E8 and be copied across to columns F and G, then down all three columns to row 100.
2. d. In column H, we wish to tell the user how the length and radius of the different containers compare. Complete the following IF statement for cell H8 to display the maximum value of the length calculations (cells E8 through G8) if the maximum value of the length calculations is greater than the corresponding radius calculation; otherwise display the letter R.

   =IF(_(1)_,_(2)_,_(3)_)

3. e. Fill in the following IF statement for cell J8 to display the sum of Length 1 and Length 2 if the sum of these lengths is greater than Length 3; otherwise, leave it blank.

   IF(_(1)_,_(2)_,_(3)_)