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)
- 2:01 ul 4G 4. A sulms.su.edu.om While constructing a building, an engineer need to fix two steel beams together using a bracket as shown in Figure 1. Using absolute coordinate system, construct a G-code program for drilling hole number 3 only. To remove the metal chips the hole should be done in three equal steps. During the drilling, coolant should be on before spindle starts and stop after spindle stops. The spindle speed set to 1750 RPM. Drilling bit in rack number 2 and it should be 1 mm over the work piece. Drilling feed rate is 20 mm/min. Explain each code used in the program in a column 57.5- 12.5 Hole (4) Hole (3) 30 Hole (1) Hole (2) ΧΟ Υ0ΖΟ All dimensions shown are in mm Figure 1 B. -> 28 •..arrow_forwardPlease refer to the attached picturs of the problem statement. I have solved a, b, c, and g using kinematics and Newton's Second Law. I'm not sure how to answer d, e and f however. My answers are: a) aT=v0/ts b) ac/t=mu(g)+v0/ts c)truck stops before crate d) unsure e) unsure f) unsure g) mu=[(aTts)2]/[2d0-2v0ts-aTts2] mu=[aTv02]/[g(2d0aT-3v02)]arrow_forwardUse the following information to answer the next three questions Mobile power plants, such as the one illustrated below, are used in remote locations. Flowing water turns a turbine, which then moves a coil of wire through a magnetic field. Mobile Power Plant Moving water Stream flowing downhill Location I Water turning turbine Location II -Spinning turbine -Permanent magnet Rotating wire coil Split-ring commutator Metal brush 10. The components that connect to the spinning turbine in the illustration on the previous page form a O ammeter O generator O motor 1. O transformer Your reasoning: MacBook Proarrow_forward
- 2022 Tutorial 5 - Isometric Projection.pdf - Adobe Acrobat Reader DC (64-bit) File Edit View Sign Window Help Home Tools 2022 Tutorial 5 - Is... x 8 Q ↑ O Type here to search 2 / 4 QUESTION 2: Make an isometric drawing of the detail with corner A at the bottom. 99 O 8- PROJECTION 30° 135% 66 20 CIES √ l A Q 18°C Cloudy D Search "Highlight A & Select PDF File PExport PDF O Adobe Export PDF Convert PDF Files to Word. or Excel Online Convert to 2022 Tutorjection.pdf 0 Document Language: English (U.S.) Change Microsoft Word (.docx) Sign In Convert Edit PDF 4 40) Free 7-Day Trial A ENG 10:33 PM INTL 9/15/2022 X 2 € X V Convert, edit and e-sign PDF forms & agreementsarrow_forward*Composte FR PRYW Rhyming Dictionary. E Poetry Cat | Poetic.. n Dictionary [2] Hom 2 points PUT YOUR NUMBER ANSWER ONLY! NO LABELS NEEDED! * 3. Find the area of the composite figure. 4 cm 40 cm 40 cm Your answe ④This is a required question B cm 13 cm 2 points PUT YOUR NUMBER ANSWER ONLY! NO LABELS NEEDED! * 4. Find the area of the composite figure. 田 回 -arrow_forwardQuestion 4 List the steps in details to draw the shape below using AutoCAD commands 190 220 50 -90 - 50 114 81 R80 450 122 -R125 68 65 290 50 290 630arrow_forward
- A Final-163 - S1 1.pdf - Adobe Acrobat Reader DC (32-bit) O X File Edit View Sign Window Help Home Tools Final-163 - S1 1.pdf x Sign In 4 / 5 +) 138% Search 'Crop Page' Export PDF 2 Edit PDF Create PDF Comment Combine Files EI Organize Pages Q.3) For the shaded area shown in figure, determine the moment of inertia Ix and Iy. Compress PDF 20 mm 2 Redact 30 mm Protect 20 mm l Fill & Sign 10 mm 2 Send for Comme. Convert, edit and e-sign PDF forms & agreements Free 7-Day Trialarrow_forwardsample calculations 目 File Edit View Insert Format Data To 100% $ % .0 .00 12: fx | A 1 Variable Value Units diameter height m 4 volume m^3 3 The image above shows a section of a Google sheet. What formula should be written in cell B4 to calculate the volume of a cylinder with a diameter value in B2 and height in B3? a) =0.25*PI()*B2^2 * B3 b) =PI()*B2^2 * B3 c) =pi*diameter^2 * height d) =PI*B2^2 * B3 3 5arrow_forwardI only need the answer to part c and part d Newton's second law of motion was used to obtain the differential equation mi = -kx - câ that models harmonic motion. a) The dots denote differentiation with respect to time t. Explain the meaning of each term (there are three) and each factor (there are six) in the equation. If MKS (meters, kilograms, seconds) units are used, what are the units of each of the six factors? b) Suppose m =and k = 4 (MKS units). What values of c correspond to a system that is i) i) ii) underdamped, overdamped, and critically damped? c) Solve the critically damped case of the IVP = -4x - ck, x(0) = 1,¿(0) = -10. d) Find the value of t at which x(t) = 0arrow_forward
- My Questions | Answered: MEC A simply suppo C Search Textbool /ethuto.cut.ac.za/ultra/courses/_9063_1/cl/outline v Question Completion Status: 20 N 45° 30° 16N F2 The resultant force of and in the 7 and 7 The res notation is: notatic O A.287+6.14} B. 12.37° OC.0.22 degrees OD None of the above is correct A Moving to another question will save this response.arrow_forwardScenario You are assigned a role as a mechanical engineer for a vehicle design manufacturing company. Your department has a software to perform numerical differentiation and integration. To be able to verify the results of using the software and validate these results, your department manager has asked you to analytically perform some tasks to validate the results generated by the software. Q: is the last two digits of your student Id number. If your number is (20110092) then Q=92. P: is the last digit of your student Id Number. If your number is (20110092) then P=2, If that digit equals zero then use P=1. Example: If your number is (20110040) then P=1. Task 1 Determine the gradient of following functions at the given points: a) x(t) = (2t7 + P t-2)² + (6vi – 5) when t = 1 5s+7 b) v(s) = when s = 3 (s²-P)2 c) i(t) = 5(1 – In(2t – 1) ) when t= 1 sec. d) V(t) =5sin(100nt + 0.2) Volts , find i(t) = 10 × x10-6 dV©) Ampere when t= 1ms. dt e) y(t) = e¬(t-n) sin(Qt + P) when t = n radian f)…arrow_forwardRow indexing: Snow fall records stateSnowRecord contains the amount of snow fall (in cm) for various cities. Rows represent a city and columns represent the snow fall for a given month. Assign citySnow Record with all elements of row rowNum. Ex: If stateSnowRecord is [17.3, 20.3; 4.8, 6.2] and rowNum is 2, then citySnowRecord is [4.8, 6.2]. Function > 6 % 7 % 8 9 10 11 12 13 end function citySnowRecord = Get CitySnowFall (stateSnowRecord, rowNum) 2% Get CitySnow Fall: Returns all snow fall values for city in row rowNum % 4 % Inputs: stateSnowRecord matrix of snow fall records for cities for various months rowNum specified row of stateSnowRecord to return stateSnowRecord = [17.3, 20.3; 4.8, 6.2] Outputs: citySnowRecord - all snow fall values for a given city % Assign citySnowRecord with all elements of a row rowNum. citySnowRecord = stateSnowRecord (rowNum, :); Code to call your function > 1 GetCitySnow Fall([17.3, 20.3; 4.8, 6.2], 2) Previous Assessment: 1 of 2 Tests Passed (50%) Save…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