Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
4th Edition
ISBN: 9780134639673
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. Ohland
Publisher: PEARSON
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 13ICA

Chapter 10, Problem 13ICA, Refer to the following worksheet. In all questions, give the requested answers in Excel notation, , example  1 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. Chapter 10, Problem 13ICA, Refer to the following worksheet. In all questions, give the requested answers in Excel notation, , example  2 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 = πr2 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. Chapter 10, Problem 13ICA, Refer to the following worksheet. In all questions, give the requested answers in Excel notation, , example  3 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)_)

Blurred answer
Students have asked these similar questions
Oo.33. Subject:- Mechanical engineering
Write the (1) two subscripts and (2) sign of the stress components (\sigma, \tau) under the given coordinate system. You need to answer all 1) to 4). For example, you may answer using the  format as: 1) \sigma_cc, +
Please provide the correct matlab code for the following question.

Chapter 10 Solutions

Thinking Like an Engineer: An Active Learning Approach (4th Edition)

Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - ICA 10-5 The worksheet shown here was designed to...Ch. 10 - The worksheet provided was designed to calculate...Ch. 10 - Some alternate energy technologies, such as wind...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - Refer to the following worksheet. The following...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Refer to the following worksheet. In all...Ch. 10 - Prob. 14ICACh. 10 - A bioengineer conducts clinical trials on...Ch. 10 - Refer to the Worksheet shown, set up to calculate...Ch. 10 - You are interested in analyzing different implant...Ch. 10 - You have a large stock of several values of...Ch. 10 - We accidentally drop a tomato from the balcony of...Ch. 10 - You are interested in calculating the best place...Ch. 10 - 1. A history major of your acquaintance is...Ch. 10 - Prob. 2RQCh. 10 - 3. A phase diagram for carbon and platinum is...Ch. 10 - 4. A simplified phase diagram for cobalt and...Ch. 10 - 5. You enjoy drinking coffee but are particular...Ch. 10 - 6. In the 1950s, a team at Los Alamos National...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - 11. When liquid and vapor coexist in a container...Ch. 10 - 12. The ideal gas law assumes that molecules...Ch. 10 - One of the NAE Grand Challenges for Engineering is...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 16RQ

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Knowledge Booster
Background pattern image
Mechanical Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Text book image
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Text book image
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Text book image
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Text book image
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Text book image
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
First Law of Thermodynamics, Basic Introduction - Internal Energy, Heat and Work - Chemistry; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=NyOYW07-L5g;License: Standard youtube license