Question

Cell d1 contains the value 7. 877. You want cell d1 to display this value as 7. 9 but keep the original number in calculations. How can you accomplish this?.

Answer 1

In order to keep the original number as 7.877 but make it display 7.9, you need to use the rounding off tool to round it off to a single decimal place.

Rounding off in Excel

• Rounding off to various decimal places is allowed in Excel.
• The roundoff button is found in the Home tab, under the "Number" ribbon.

To round up to 7.9, go to the Number ribbon and use the one with the arrow pointing right as indicted in the attachment. This will take 7.877 to 7.9 while leaving the 7.877 intact.

Find out more about Excel problems at brainly.com/question/26124195.