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 (MindTap Course List)
- Show the details of your solution. Three decimals.arrow_forwardKindly answer the entire question(Q3) in the image given below. For your information, the unknown,w is given as 2. w=2arrow_forwardAnswer the following questions completely. Minimize rounding of rounding of numbers to obtain a more precise answer. Solution which is supported by a sketch must be labeled completely showing known and unknown quantitiesarrow_forward
- A circular pool of water has a fountain in its center, as shown in the figure below. A man measures the circumference C of the pool. He then measures with a protractor the angle of elevation ϕ from the outer edge of the pool (level with the bottom of the fountain) to the top of the fountain's water spout. Find the height from the bottom of the fountain to the top of the water spout. (Use any variable or symbol stated above as necessary.)arrow_forwardPlease include the figured and please write the true answer. Please make sure that it is 2 decimal points in every answer. Please double check your calculations and please put the formula that had been used and the explanationarrow_forwardUse Excel to plot the following data. Use two different y axes. Use a scale of zero to 40° C for temperature, and zero to 12 km/h for wind speed.arrow_forward
- Note: Write the equations used and box the final answer. Write your final answer in two decimal places.arrow_forwardObserve three decimal places and box the final answer.arrow_forwardRead the question carefully and give me right solution according to the question. Make sure your calculations clearlyarrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning