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
- A moodle.unizwa.edu.om The cross-sectional dimensions of the T-beam is shown in figure below. To Determine the location of centroid (x,y); tick any correct sentences from the following: Given Data: a = 25 mm b = 250 mm c = 50 mm d = 150 mmarrow_forwardPlease write legibly. Thank You and God Bless. Please See Attached photo Find the Fourier Series to represent a function of the given problem:arrow_forwardCalculate the following: Total area of the figure, in² xbar (location of the centroid along x axis), in ybar (location of the centroid along y axis), inarrow_forward
- Subject : Structural Theory Use P= 60 Please solve this with complete and detailed solution. Make your solution readable, clear, and understandable. Note : Please don't post it on google because I don't want my instructor to seet it. Thank you so much.arrow_forwardCalculate the following: Total area of the figure, mm² xbar (location of the centroid along x axis), mm ybar (location of the centroid along y axis), mmarrow_forwardP1. 4 List the given, required, graph and box the final answer Note: number 3 iz just a reference since it is stated at the Problem 4arrow_forward
- Slove the following equation using grammars rule: X + 2y + Z = 3 2X + y - Z = 0 X - y + Z = 0arrow_forwardLocate the centroid C(x, y) of the plane area shown below. Arrange your calculations in a tabular form and enter them in the table given below. Segment 30 mm 54 mm A [mm²] 54 mm x [mm] 72 mm ỹ [mm] X 48 mm xA [mm³] ỹA [mm³]arrow_forwardHow do you solve for the values encircled with blue ink below (please specify and solve)?arrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning