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

Videos

Textbook Question
Book Icon
Chapter 10, Problem 1ICA
  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          

The worksheet displayed was designed to reflect on our understanding of the use of cell references.

Answer the following questions using the worksheet.

  1. a. What is the cell address of the word “Dabo”?
  2. b. Using cell concatenation with the ampersand operator, what formula would you type into a cell to create the word “fourequator”?
  3. c. Using cell concatenation with the CONCAT function, what formula would you type into a cell to create the word “Dabocanoes”?

a.

Expert Solution
Check Mark
To determine

Find the cell address of the word “Dabo” in the given worksheet.

Answer to Problem 1ICA

The cell address of the word “Dabo” in the given worksheet is A9_.

Explanation of Solution

Given data:

The worksheet is given as follows.

Thinking Like an Engineer: An Active Learning Approach (4th Edition), Chapter 10, Problem 1ICA , additional homework tip  1

Description:

Intersection between row and column on a spread sheet is called as a cell. Alphabets are used to represent column and numbers are used to represent row. Cell address is the selected cell in the spread sheet.

In the given worksheet, “Dabo” is typed in a cell, which is the intersection of column A and 9th row of the spread sheet. Therefore, the cell address of the word “Dabo” in the given worksheet is A9.

Conclusion:

Hence, the cell address of the word “Dabo” in the given worksheet is A9_.

b.

Expert Solution
Check Mark
To determine

Write the required formula to create the word “fourequator” using cell concatenation with the ampersand operator.

Answer to Problem 1ICA

The required formula to create the word “fourequator” using cell concatenation with the ampersand operator is =$A$7&$A$8_.

Explanation of Solution

Follow the steps to concatenate two cells with the ampersand operator.

Step 1:

Enter the given data in new worksheet as shown in Figure 1.

Thinking Like an Engineer: An Active Learning Approach (4th Edition), Chapter 10, Problem 1ICA , additional homework tip  2

Step 2:

Type the formula “=$A$7&$A$8” in cell B8 to concatenate cell A7 and A8 as shown in Figure 2.

Thinking Like an Engineer: An Active Learning Approach (4th Edition), Chapter 10, Problem 1ICA , additional homework tip  3

From Figure 2, the desired result (that is fourequator) is obtained by using the formula =$A$7&$A$8 in cell B8.

Conclusion:

Hence, the required formula to create the word “fourequator” using cell concatenation with the ampersand operator is =$A$7&$A$8_.

c.

Expert Solution
Check Mark
To determine

Write the required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function.

Answer to Problem 1ICA

The required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function is =CONCATENATE(A9,A5)_.

Explanation of Solution

Follow the below steps to concatenate two cells with the CONCAT function.

Step 2:

Type the formula “=CONCATENATE(A9,A5)” in cell B9 to concatenate cell A9 and A5 as shown in Figure 3.

Thinking Like an Engineer: An Active Learning Approach (4th Edition), Chapter 10, Problem 1ICA , additional homework tip  4

From Figure 3, the desired result (that is Dabocanoes) is obtained by using the formula =CONCATENATE(A9,A5) in cell B9.

Conclusion:

Hence, the required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function is =CONCATENATE(A9,A5)_.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
3. 9. 10. The centrifugal tension in belts (a) increases power transmitted (b) decreases power transmitted (c) have no effect on the power transmitted (d) increases power transmitted upto a certain speed and then decreases When the belt is stationary, it is subjected to some tension, known as initial tension. The value of this tension is equal to the (a) tension in the tight side of the belt (b) tension in the slack side of the belt (c) sum of the tensions in the tight side and slack side of the belt (d) average tension of the tight side and slack side of the belt The relation between the pitch of the chain (p) and pitch circle diameter of the sprocket (d) is given by 60° (a) p=d sin (c) p=d sin (120° T where T Number of teeth on the sprocket. 90° (b) p=d sin T 180° (d) p=d sin T
OBJECTIVE TYPE QUESTIONS 1. The maximum fluctuation of energy is the 2. (a) sum of maximum and minimum energies (b) difference between the maximum and minimum energies (c) ratio of the maximum energy and minimum energy (d) ratio of the mean resisting torque to the work done per cycle In a turning moment diagram, the variations of energy above and below the mean resisting torque line is called (a) fluctuation of energy (b) maximum fluctuation of energy (c) coefficient of fluctuation of energy (d) none of the above Chapter 16: Turning Moment Diagrams and Flywheel 611 The ratio of the maximum fluctuation of speed to the mean speed is called 3. (a) fluctuation of speed (c) coefficient of fluctuation of speed 4. (b) maximum fluctuation of speed (a) none of these The ratio of the maximum fluctuation of energy to the.......... is called coefficient of fluctuation of energy. (a) minimum fluctuation of energy (b) work done per cycle The maximum fluctuation of energy in a flywheel is equal to 5.…
OBJECTIVE TYPE QUESTIONS 1. The velocity ratio of two pulleys connected by an open belt or crossed belt is 2. (a) directly proportional to their diameters (b) inversely proportional to their diameters (c) directly proportional to the square of their diameters (d) inversely proportional to the square of their diameters Two pulleys of diameters d, and d, and at distance x apart are connected by means of an open belt drive. The length of the belt is (a)(d+d₁)+2x+ (d₁+d₂)² 4x (b)(d₁-d₂)+2x+ (d₁-d₂)² 4x (c)(d₁+d₂)+ +2x+ (d₁-d₂)² 4x (d)(d-d₂)+2x+ (d₁ +d₂)² 4x 3. In a cone pulley, if the sum of radii of the pulleys on the driving and driven shafts is constant, then (a) open belt drive is recommended (b) cross belt drive is recommended (c) both open belt drive and cross belt drive are recommended (d) the drive is recommended depending upon the torque transmitted Due to slip of the belt, the velocity ratio of the belt drive 4. (a) decreases 5. (b) increases (c) does not change When two pulleys…

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
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
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license