0
What value will display if the formula55.00 5 is entered into a cell?
Wiki User
∙ 9y ago
Your operators did not show in your question. Taking the 4 most likely formulas, these are the formulas and answers:
=55.00 * 5 gives 275
=55.00 / 5 gives 11
=55.00 + 5 gives 60
=55.00 - 5 gives 55
Note that the two decimal places will not show in the results, unless the cells in which the formulas are entered are formatted to show 2 decimal places. Within the formulas themselves the .00 part will be dropped, even if you type them in.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What are cell display and cell contents in a spreadsheet?
Cell display is what you see when you look at a cell and cell contents are what is in the cell. Sometimes they are the same, like when you type a number into a cell. Sometimes they are different, like when you type in a formula. When you've entered the formula the cell will normally show some value that the formula creates, like a total. So you might see a number, which is the cell display, but the cell still contains a formula, which is the cell content. If you put the cursor onto a cell and look at the formula bar, it will show you what is in the cell. Formatting a cell can also change the cell display, but not the contents. If you put a number into a cell and format it to currency, you will see the currency value, with a currency symbol and probably two decimal places, but the cell still just contains the number you originally entered.
What arithmetic operator directs excel to perform multiplication?
The asterisk * character is used to multiply two values. For example =3*4 entered into a cell will display the product 12. If you use cell references (like =2*a1) then the cell will display 2 times the value in cell A1.
When a number is entered in a cell the cell contains?
A value or data.
What if your instructions tell you to type in a percentage in cell E15 How should you type that number?
Percentages are entered as decimals. For example 12% is entered as .12. You can format a cell to display the contents as percent, if you like.
Does the formula bar in Excel display the value or formula of an active cell?
It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.
What consists of text that you type until you press the ENTER key?
Formulas display as text while you are entering them in a cell. They display a calculated value after you press the ENTER key. For example, you can type =8+2 in a cell and when you press ENTER, the cell will display the value 10.
A number or date entered into a cell of a spreadsheet is called a?
Data
Can I display a formula instead of the value in a spreadsheet?
To display the formula, not its results, in a cell, a user can choose a format for "text."
What function you should use to have the contents of a cell display differently based upon the value in the cell?
conditional formatting
In excel if value is in one column automaticlly put formula in another column?
There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.
Is the entry bar the area where the text a number or formula is displayed for the active cell?
The proper name is the formula bar, but yes a formula or value can be seen there when you have entered a value or formula in a cell.
Where does the answer will display after entering the formula into the cell?
The answer will display in the cell itself.
