
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
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 3ICA
A | B | C | D | E | F | |
1 | ||||||
2 | 45 | |||||
3 | meters | |||||
4 | horses | |||||
5 | canoes | |||||
6 | 99 | |||||
7 | four | |||||
8 | equator | |||||
9 | Dabo | |||||
10 | 33.3333 | |||||
11 |
The worksheet displayed was designed to reflect on our understanding of the use of cell references.
Answer the following questions using the worksheet.
- a. If we want to calculate the average of all of the cells in the range A2:A10, what do we type into cell B5?
- b. If we want to calculate the sum of each individual numeric value (by individual cell, not range), what do we type into cell B6?
- c. If we want to concatenate every cell that contains text (in order from lowest numbered row to highest numbered row) in the range A2:A10, what is the resulting string of text that would appear in cell B7?
- d. If we want to concatenate every cell that contains text (in order from highest numbered row to lowest numbered row) in the range A2:A10, what would we write in cell B8 to generate that string of text?
Expert Solution & Answer

Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The manometer fluid in the figure given below is mercury where D = 3 in and h = 1 in. Estimate the volume flow in the tube (ft3/s) if the flowing fluid is gasoline at 20°C and 1 atm. The density of mercury and gasoline are 26.34 slug/ft3 and 1.32 slug/ft3 respectively. The gravitational force is 32.2 ft/s2.
Using the Bernoulli equation to find the general solution. If an initial condition is given, find
the particular solution.
y' + xy = xy¯¹, y(0) = 3
Test for exactness. If exact, solve. If not, use an integrating factor as given or obtained by
inspection or by the theorems in the text.
a. 2xydx+x²dy = 0
b. (x2+y2)dx-2xydy = 0
c. 6xydx+5(y + x2)dy = 0
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Ch. 10.1 - Type 5 in cell E22 and 13 in cell E23; type =E22 +...Ch. 10.1 - Type 45 into cell G22 and =G22 + 10 in cell H22....Ch. 10.1 - Type 40 into cell A28 and =A28 + 10 in cell D28....Ch. 10.1 - Type 40 into cell A28 and =A28 + 5 in cell G28....Ch. 10.2 - Launch a new worksheet. Type the following Excel...Ch. 10.2 - As part of the design of a high-performance...Ch. 10.3 - Evaluate the following expressions. What is the...Ch. 10.3 - Prob. 8CCCh. 10.4 - This is a continuation of the worksheet you...Ch. 10.5 - Prob. 11CC
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
What types of coolant are used in vehicles?
Automotive Technology: Principles, Diagnosis, And Service (6th Edition) (halderman Automotive Series)
A nozzle at A discharges water with an initial velocity of 36 ft/s at an angle with the horizontal. Determine ...
Vector Mechanics For Engineers
Look at the following description of a problem domain:
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
17–1C A high-speed aircraft is cruising in still air. How does the temperature of air at the nose of the aircra...
Thermodynamics: An Engineering Approach
In Exercises 1 through 22, determine the output displayed in the text box or list box by the lines of code.
Introduction To Programming Using Visual Basic (11th Edition)
What are the design issues for character string types?
Concepts Of Programming Languages
Knowledge Booster
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
- Newton's law of cooling. A thermometer, reading 5°C, is brought into a room whose temperature is 22°C. One minute later the thermometer reading is 12°C. How long does it take until the reading is practically 22°C, say, 21.9°C?arrow_forwardSolve a. y' + 2xy = ex-x² b. y' + y sin x = ecosx, y(0) = −1 y(0) = −2.5arrow_forward= MMB 241 Tutorial 3.pdf 2/6 90% + + 5. The boat is traveling along the circular path with a speed of v = (0.0625t²) m/s, where t is in seconds. Determine the magnitude of its acceleration when t = 10 s. 40 m v = 0.0625² 6. If the motorcycle has a deceleration of at = (0.001s) m/s² and its speed at position A is 25 m/s, determine the magnitude of its acceleration when it passes point B. .A 90° 300 m n B 2arrow_forward
- = MMB 241 Tutorial 3.pdf 4/6 67% + 9. The car is traveling along the road with a speed of v = (2 s) m/s, where s is in meters. Determine the magnitude of its acceleration when s = 10 m. v = (2s) m/s 50 m 10. The platform is rotating about the vertical axis such that at any instant its angular position is u = (4t 3/2) rad, where t is in seconds. A ball rolls outward along the radial groove so that its position is r = (0.1+³) m, where t is in seconds. Determine the magnitudes of the velocity and acceleration of the ball when t = 1.5s.arrow_forwardThe population of a certain country is known to increase at a rate proportional to the number of people presently living in the country. If after two years the population has doubled, and after three years the population is 20,000, estimate the number of people initially living in the country.arrow_forward= MMB 241 Tutorial 3.pdf 6/6 100% + | 日 13. The slotted link is pinned at O, and as a result of the constant angular velocity *= 3 rad/s it drives the peg P for a short distance along the spiral guide r = (0.40) m, where 0 is in radians. Determine the radial and transverse components of the velocity and acceleration of P at the instant = 1/3 rad. 0.5 m P r = 0.40 =3 rad/sarrow_forward
- = MMB 241 Tutorial 3.pdf 1/6 90% + DYNAMICS OF PARTICLES (MMB 241) Tutorial 3 Topic: Kinematics of Particles:- Path and Polar coordinate systems and general curvilinear QUESTIONS motion. 1. Determine the acceleration at s = 2 m if v = (2 s) m/s², where s is in meters. At s = 0, v = 1 m/s. 3 m 2. Determine the acceleration when t=1s if v = (4t2+2) m/s, where t is in seconds. v=(4²+2) m/s 6 marrow_forward5.112 A mounting bracket for electronic components is formed from sheet metal with a uniform thickness. Locate the center of gravity of the bracket. 0.75 in. 3 in. ༧ Fig. P5.112 1.25 in. 0.75 in. y r = 0.625 in. 2.5 in. 1 in. 6 in. xarrow_forward4-105. Replace the force system acting on the beam by an equivalent resultant force and couple moment at point B. A 30 in. 4 in. 12 in. 16 in. B 30% 3 in. 10 in. 250 lb 260 lb 13 5 12 300 lbarrow_forward
- Sketch and Describe a hatch coaming and show how the hatch coamings are framed in to ships strucure?arrow_forwardSketch and describe hatch coamings. Describe structrual requirements to deck plating to compensate discontinuity for corners of a hatch. Show what is done to the deck plating when the decks are cut away and include the supporting members.arrow_forwardAn Inclining experiment done on a ship thats 6500 t, a mass of 30t was moved 6.0 m transvesly causing a 30 cm deflection in a 6m pendulum, calculate the transverse meta centre height.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY

Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press

Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON

Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education

Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY

Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning

Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license