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.
1 answer:
In order to keep the original number as 7.877 but make it display 7.9, you need to<u> use the </u><u>rounding off tool</u><u> to round it off to a single decimal place.</u>
<h2>Rounding off in Excel</h2>- 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.
You might be interested in
The “Sample Word” canyon, should be placed alphabetically in the list of words below after the Canvas at second place.
<h3>What is alphabetical order?</h3>The alphabetical order is the system of arrangement of the words or latter in a way such that the conventional way of alphabet order.
For example in word "Apple" and "Ant", word ant comes first in alphabetical order as the second letter of the "Ant" word comes before than the second latter of first word "Apple".
The Sample Word, given in the problem, is,
The alphabetical order given as,
First and second word is same in all the latter, but third word of "Canyon" and "Canvas" comes earlier. The word "Canyon" should place at second position as the 4th latter 'y' of this latter comes after 4th latter of canvas.
Thus, the “Sample Word” canyon, should be placed alphabetically in the list of words below after the Canvas at second place.
Learn more about alphabetical order here;
#SPJ1