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.
- a. What is the cell address of the word “Dabo”?
- b. Using cell concatenation with the ampersand operator, what formula would you type into a cell to create the word “fourequator”?
- c. Using cell concatenation with the CONCAT function, what formula would you type into a cell to create the word “Dabocanoes”?
a.
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
Explanation of Solution
Given data:
The worksheet is given as follows.
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
Conclusion:
Hence, the cell address of the word “Dabo” in the given worksheet is
b.
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
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.
Step 2:
Type the formula “
From Figure 2, the desired result (that is fourequator) is obtained by using the formula
Conclusion:
Hence, the required formula to create the word “fourequator” using cell concatenation with the ampersand operator is
c.
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
Explanation of Solution
Follow the below steps to concatenate two cells with the CONCAT function.
Step 2:
Type the formula “
From Figure 3, the desired result (that is Dabocanoes) is obtained by using the formula
Conclusion:
Hence, the required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function is
Want to see more full solutions like this?
Chapter 10 Solutions
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
- Seawater can be purified by distillation into potable water. If it costs 15 cents per kilowatt-hour for energy, what is the cost of energy to produce 100.0 gallons of drinking water at 100.0 ˚C if the seawater starts at 25.00 ˚C? (1 watt × 1 second = 1 joule). Enter your answer to the nearest penny.arrow_forwardEngr 215 Matlab Fahrenheit to Celsius using multiple statements Given a Fahrenheit value temperatureFahrenheit, write a statement that assigns temperatureCelsius with the equivalent Celsius value. While the equation is C = 5/9 * (F - 32), as an exercise use two statements, the first of which is "fractionalMultiplier = 5/9;"]arrow_forwardEngineering Economy A company has determined the price and the monthly demand of its products are related by the equation D = √775 - p, where p is the price per unit in dollar and D, is the monthly demand. The associated fixed costs are $2,125 per month and the variable costs are $100/ unit. Use this information to answer the following: a)What is the optimal number of units that should be produced and sold each month? b) What is the maximum profit? c)Determine the value of D that represents the break-even point?arrow_forward
- The following table lists molecular weight data for a polypropylene material. Compute the number-average molecular weight, Molecular Weight Range (g/mol)//// xi////// wi 8,000–16,000//// 0.05/// 0.02 16,000–24,000 ///0.16// 0.10 24,000–32,000 ///0.24// 0.20 32,000–40,000 ///0.28// 0.30 40,000–48,000 ///0.20// 0.27 48,000–56,000 ///0.07// 0.11 Round your answer to 0 decimal places.arrow_forwardI posted this question six times and no body wants to try the last question. I only need question (e). I need the graph ONLY. The question is solved from (a) to (d). If you want the answers from (a) to (d) . Here it is: Answer : (a) 3.98675 bar (b) 927 kg/m3 (c) 43.83 m (d) (rho)(g) NOTE : Please I need the graph only. The last question (Question e). Atleast try it.arrow_forwardThe amount of time it takes for a pendulum to swing “to-and-fro” through one complete cycle is called the “period” and is calculated using the following equation: where T = period in seconds, I = mass moment of inertia, m = mass of pendulum in kilograms g = gravitational acceleration, 9.8 m/s2, h = effective length of pendulum in meters What is the appropriate unit for I if the preceding equation is to be homogeneous in units? Please show all of your work.arrow_forward
- Briefly explain each of the following block (one sentence or less)a) G96 S200 M03b) G00G42X20.0Z2.0c) G92 X59.0 Z-50.0 R-2.5 F0.25 d) G72 P10 Q20 U1.0 W0.5 F0.2arrow_forward[Engineering Thermodynamics] Please finish the answer with a diagram for reference to me (if needed). Show the answer step by step and clear to see. If you need to answer with words, please type directly. (to avoid cant see clear by handwriting) Thank you. P.S. Use the online software http://www.peacesoftware.de/einigewerte/r134a_e.html or property table and p-h diagram for R134a where necessary.arrow_forwardAn aluminum plate measuring 15 cm long, 10 cm wide and 1 cm thick was cooled in air. At the time of cooling, the ambient temperature was equal to 23 °C. Experimental data were measured and are shown in Table 1. Calculate the Heat exchanged by the body in J. Consider in the answer one decimal place after the comma. Table 1 - Experimental data t(s) T (oC) 0 63 146 58 375 52 475 50 625 47 730 45 917 42 1056 40 1224 38 1391 36 1613 34 1895 32 Aluminum data: density = 2702 kg/m3; Cp = 903 J/kg K and k = 237 W/m Karrow_forward
- Hi please help with this question thank you I just can't seem to work it out even with the given formulas. Thanks! also, I have tried these but they seem to be incorrect, or maybe parts of the calculation may be incorrect since when I submit these all together and I can't really work out where I am going wrong: sigma 1 = 73.31 MPa theta 1 = 56.87 degrees sigma 2 = 18.68 MPa theta 2 = 146.875 degrees Tmax in plane = 27.315 MPa theta s = 101.87 degreesarrow_forwardThe following table lists molecular weight data for a polypropylene material. Compute the weight-average molecular weight, Molecular Weight Range (g/mol)//// xi////// wi 8,000–16,000//// 0.05/// 0.02 16,000–24,000 ///0.16// 0.10 24,000–32,000 ///0.24// 0.20 32,000–40,000 ///0.28// 0.30 40,000–48,000 ///0.20// 0.27 48,000–56,000 ///0.07// 0.11 Round your answer to 0 decimal places.arrow_forwardPlease provide equations that you are using so I can follow along and learn how to do this and include conversions and units. In Jamestown, NY, a coal power plan consumes coal at a rate of 80 tons/hr. When coal burns, it generates approximately 30,000 kJ for every kg of coal burned. The cooling course for the plant is the nearby Chadakoin River nearby and, by code, the power plant cannot reject more than 13.19 x 109 MJ into the river annually. Determine the maximum average power output of this plant and it's maximum thermal efficiency. To check your work, enter the efficiency, as a decimal, in the box provided.arrow_forward
- 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