Chapter 14, Problem 1P

(a)

To determine

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

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 $5.342$ in the cell A1. Then, in cell A2, type the formula as “=TRUNC(A1,1)” and press enter key. The result obtained in the cell A2 as $5.3$.

Conclusion:

Hence, the proper use of given function with a simple example has been explained by using excel.

(b)

To determine

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

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 $5.34268$ in the cell A1. Then, in cell A2, type the formula as “=ROUND(A1,3)” and press enter key. The result obtained in the cell A2 as $5.343$.

Conclusion:

Hence, the proper use of given function with a simple example has been explained by using excel.

(c)

To determine

Using the Excel Help menu, demonstrate the proper use of given function COMBIN(number, num_chosen) with a simple example.

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 $3$.

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)

To determine

Using the Excel Help menu, demonstrate the proper use of given function DEGREES(angle) with a simple example.

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 $3.141592$ in the cell A1. Then, in cell A2, type the formula as written as “=DEGREES(A1)” and press enter key. The result obtained in the cell A2 as $180$.

Conclusion:

Hence, the proper use of given function with a simple example has been explained by using excel.

(e)

To determine

Using the Excel Help menu, demonstrate the proper use of given function SLOPE(known_y’s,known_x’s) with a simple example.

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 $0.5$.

Conclusion:

Hence, the proper use of given function with a simple example has been explained by using excel.

(f)

To determine

Using the Excel Help menu, demonstrate the proper use of given function CEILING(number,significance) with a simple example.

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 $3.842$ in the cell A1. Then, in cell A2, type the formula as “=CEILING(A1,3)” and press enter key. The result obtained in the cell A2 as $4$.

Conclusion:

Hence, the proper use of given functions with a simple example has been explained by using excel.