EBK THINKING LIKE AN ENGINEER
EBK THINKING LIKE AN ENGINEER
4th Edition
ISBN: 8220103633512
Author: 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.

EBK THINKING LIKE AN ENGINEER, 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.

EBK THINKING LIKE AN ENGINEER, 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.

EBK THINKING LIKE AN ENGINEER, 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.

EBK THINKING LIKE AN ENGINEER, 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
In a structural reliability problem, the resistance (capacity) R and load effect (demand) S random variables associated with a failure mode of the structure of interest are normally distributed and statistically independent with the following probability distribution parameters (or statistics) in consistent units: MR = 12, σR = 3 μs = 5, σs = 2 (a) Determine the exact probability of failure pF ·
The resistance R and load effect S for a given failure mode are statistically independent random variables with marginal PDF's 1 fR (r) = 0≤r≤100 100' fs(s)=0.05e-0.05s (a) Determine the probability of failure by computing the probability content of the failure domain defined as {r
Please solve this problem as soon as possible My ID# 016948724

Chapter 10 Solutions

EBK THINKING LIKE AN ENGINEER

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
International Edition---engineering Mechanics: St...
Mechanical Engineering
ISBN:9781305501607
Author:Andrew Pytel And Jaan Kiusalaas
Publisher:CENGAGE L
Text book image
Principles of Heat Transfer (Activate Learning wi...
Mechanical Engineering
ISBN:9781305387102
Author:Kreith, Frank; Manglik, Raj M.
Publisher:Cengage Learning
Text book image
Automotive Technology: A Systems Approach (MindTa...
Mechanical Engineering
ISBN:9781133612315
Author:Jack Erjavec, Rob Thompson
Publisher:Cengage Learning
Text book image
Refrigeration and Air Conditioning Technology (Mi...
Mechanical Engineering
ISBN:9781305578296
Author:John Tomczyk, Eugene Silberstein, Bill Whitman, Bill Johnson
Publisher:Cengage Learning
Text book image
Precision Machining Technology (MindTap Course Li...
Mechanical Engineering
ISBN:9781285444543
Author:Peter J. Hoffman, Eric S. Hopewell, Brian Janes
Publisher:Cengage Learning
Text book image
Electrical Transformers and Rotating Machines
Mechanical Engineering
ISBN:9781305494817
Author:Stephen L. Herman
Publisher:Cengage Learning
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license