Concept explainers
(a)
Using the Excel Help menu, demonstrate the proper use of given function TRUNC(number, num_digits) with a simple example.
(a)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘TRUNC’ and click search, it will display various syntax functions.
Now click on the function “TRUNC function”, it will be shown the article for TRUNC function and given excel function is,
TRUNC(number, num_digits).
That is, truncates a number to an integer by eliminating the fractional part of the number.
Example:
Consider the function as,
TRUNC(5.342,1)
Here,
5.342 is refer to the number, and
1 is refer to the num_digits.
Refer to Figure 1, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(b)
Using the Excel Help menu, demonstrate the proper use of given function ROUND(number, num_digits) with a simple example.
(b)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘ROUND’ and click search, it will display various syntax functions.
Now click on the function “ROUND function”, it will be shown the article for ROUND function and given excel function is,
ROUND(number, num_digits)
That is, rounds a number to a specified number of digits.
Example:
ROUND(5.34268,3)
Here,
5.34268is refer to the number, and
3 is refer to the num_digits.
Refer to Figure 2, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(c)
Using the Excel Help menu, demonstrate the proper use of given function COMBIN(number, num_chosen) with a simple example.
(c)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘COMBIN’ and click search, it will display various syntax functions.
Now click on the function “COMBIN function”, it will be shown the article for COMBIN function and given excel function is,
COMBIN(number, num_chosen)
That is, to determine the total possible number of groups for a given number of items.
Example:
Consider three cards namely A, B and C. From these three cards there are different ways to combine the card into groups of two. They are, Group1: A and B; Group 2: Aand C; Group 3: B and C; Using excel, COMBIN(3,2) is equal to 3. Here, 3 is referred to number and 2 is referred to num_chosen.
Refer to Figure 3, in cell A1, type the formula as written as “=COMBIN(3,2)” and press enter key. The result obtained in the cell A1as
And another example is take any 5 colors, to find the combinations of any of three colors from the 5, in excel it can be find by the formula “=COMBIN(5,3)”, which will results into 10 combinations as shown below Figure 4.
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(d)
Using the Excel Help menu, demonstrate the proper use of given function DEGREES(angle) with a simple example.
(d)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘DEGREES’ and click search, it will display various syntax functions.
Now click on the function “DEGREES function”, it will be shown the article for DEGREES function and given excel function is,
DEGREES(angle)
That is, converts radians into degrees.
Example:
DEGREES(3.141592)
Here,
3.141592 is refer to the angle in radians
Refer to Figure 5, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(e)
Using the Excel Help menu, demonstrate the proper use of given function SLOPE(known_y’s,known_x’s) with a simple example.
(e)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘SLOPE’ and click search, it will display various syntax functions.
Now click on the function “SLOPE function”, it will be shown the article for SLOPE function and given excel function is,
SLOPE(known_y’s,known_x’s)
That is, returns the slope of a line fit to a set of data points.
Example:
Consider the table for known_y’s and known_x’s values as shown in Table 1.
Table 1
y-value | x-value |
1 | 2 |
2 | 4 |
3 | 6 |
4 | 8 |
5 | 10 |
And show it is in excel file as follows,
Refer to Figure 6, type the values in the appropriate cell. Then, in cell A8, type the formula as written as “=SLOPE(A2:A6,B2:B6)” and press enter key. The result obtained in the cell A8as
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(f)
Using the Excel Help menu, demonstrate the proper use of given function CEILING(number,significance) with a simple example.
(f)

Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘CEILING’ and click search, it will display various syntax functions.
Now click on the function “CEILING function”, it will be shown the article for CEILING function and given excel function is,
CEILING(number,significance)
That is, rounds up to the nearest given significance.
Example:
CEILING(3.842,1)
Here,
3.842 is refer to the number, and
1 is refer to the significance.
Refer to Figure 7, type
Conclusion:
Hence, the proper use of given functions with a simple example has been explained by using excel.
Want to see more full solutions like this?
Chapter 14 Solutions
Engineering Fundamentals: An Introduction to Engineering
- Solve for the following right triangle for missing parts: - Angle A - Angle B - Side a - Areaarrow_forwardYOUR TOP STADIA CROSSHAIR IN YOUR LEVEL YEILDS A Roo READING of 7.32 FT. YOUR BOTTOM STADIA CROSSHAIR READS 6.23 FT. How FAR AWAY FROM YOUR INSTRUMENT (LEVEL) IS YOUR STATION WHERE YOUR PHilly Roo IS LOCATED:arrow_forwardDetermin the internal angle given the following:arrow_forward
- Convert the followingarrow_forwardSlope Deflection for the fixed supported beam with a spring, k=2EI.arrow_forwardSITUATION. A uniform live load of 16 kN/m and a single concentrated live force of 34 kN are placed on the top beams. If the beams also support a uniform dead load of 3 kN/m, determinearrow_forward
- Complete the profile leveling notes in Table 1. Show the arithmetic check and sample calculations of your work. Draw a neat sideview sketch showing the location of all stations and indicate on the sketch all of the numbers in your completed table.arrow_forward3. A level loop was run starting at BM 20 and going clockwise around the loop shown below in Figure 2. The given known elevation of BM 20 is 1418.013 ft. When closing the level loop, BM 20 was found to have an elevation of 1417.890 ft. (a) Adjust the elevation of each station to correct for error. Show sample calculations of your work. (b) What is the accuracy ratio of the survey? BM 20 Elev. 1418.013 2.3 mi BM 20A Observed Elev. 1234.567 2.7 mi 1.6 mil 0.9 mi BM 20B Observed Elev. 1357.913 BM 20C Observed Elev. 1396.963arrow_forwardA W14 x 82 with 20 ft length column is part of a braced frame. The load and moments computed from service loads, and bending is about the x axis are (axial compressive dead load of 63 k; axial compressive live load of 76 k; upper dead moment of 32 ft-k; upper live moment of 56 ft-k; lower dead moment of 65 ft-k; lower live moment of 95 ft-k; the moments cause the member to bend in double curvature). Determine the lateral-torsional buckling modification factor C₁. ial live load ofarrow_forward
- PROBLEM 1 Find the reaction at A and F. Compute for the force in members AB, BD, and DF. Use Method of Joints OR Method of Sections OR both. 3m B D C E 3m 100KN 3m 4marrow_forwardI need detailed help solving this exercise from homework of Engineering Mathematics II.I do not really understand how to do, please do it step by step, not that long but clear. Thank you!P.S.: Please do not use AI, thanks!arrow_forwardI need detailed help solving this exercise from homework of Engineering Mathematics II.I do not really understand how to do, please do it step by step, not that long but clear. Thank you!P.S.: Please do not use AI, thanks!arrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage LearningResidential Construction Academy: House Wiring (M...Civil EngineeringISBN:9781285852225Author:Gregory W FletcherPublisher:Cengage LearningFundamentals Of Construction EstimatingCivil EngineeringISBN:9781337399395Author:Pratt, David J.Publisher:Cengage,


