Answered

Get personalized and accurate responses to your questions with IDNLearn.com. Discover comprehensive answers to your questions from our community of experienced professionals.

Select the correct answer.
Walden is looking at his company’s regional sales numbers. He needs a quick estimate of the total sales across regions. The numbers are confusing to read because of the trailing decimals. What function can Walden use to round the numbers to the nearest whole number?

A.
=ROUND(number)
B.
=ROUND(0)
C.
=ROUND(number, 0)
D.
=ROUND(1)
E.
=ROUND(number, 1)

Sagot :

Answer:

C. =ROUND(number, 0)

Explanation:

The ROUND function in MS Excel is used in rounding off numbers input in the function to a specified number of decimal places

The cell address containing the original number to be rounded off, or the original number is entered as the first argument of the function, while the second argument is the number of digits the original number is to be rounded to

In order to round to the nearest whole number, the second argument would be 0 which result in the removal of the numbers after the decimal place and rounding the last integer on the bases of the value of the number after the decimal point

Therefore, to round the original number to the nearest whole number, the function Walden should use is =ROUND(number, 0).

Thank you for being part of this discussion. Keep exploring, asking questions, and sharing your insights with the community. Together, we can find the best solutions. IDNLearn.com is your reliable source for accurate answers. Thank you for visiting, and we hope to assist you again.