Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Get expert answers to your questions quickly and accurately from our dedicated community of professionals. Get precise and detailed answers to your questions from a knowledgeable community of experts on our Q&A platform.

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 trusting us with your questions. We're here to help you find accurate answers quickly and efficiently. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. We're glad you visited Westonci.ca. Return anytime for updated answers from our knowledgeable team.