answersLogoWhite

0


Best Answer

formula bar

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What display the contents of the active cell?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What does the formula box display?

It displays contents of the active cell.


Do the contents of the active cell display in the name box?

yes


When you change the contents of a cell you are the cell?

You are editing the active cell.


What does align center mean?

Configure a cell to display the cell contents in the middle of the cell (with the same amount of space on both sides of the contents).


In Excel what is displayed in the active cell entry in the formula bar and a flashing insertion point in the active cell?

cell contents


In excel why does text appear as hash?

If you see a cell with a lot of has symbols in it, like #####, it usually means the cell is not wide enough to display its contents. This normally applies to numbers, not text. If you widen the column that the cell is in, it will display the contents correctly.


What sign is used n Excel to fill a column that is too narrow to display its contents?

A series of # symbols will fill the cell to indicate it is not wide enough to display the contents.


What function you should use to have the contents of a cell display differently based upon the value in the cell?

conditional formatting


What are two types of cell contents excel?

The cell contents are what is actually typed into a cell. This is not always the same as what is displayed. So you can type a formula into a cell, which would be its contents, and the formula will do a calculation and display a result, which is the cell display. When you look at the cell you would see the result of the formula, but not the formula itself. The cell contents are always displayed on the formula bar. If you just type a number in, then the cell content and cell display can be the same. What you could then do is to format the cell and the number would be displayed in that format.


Why do you manipulate a spreadsheet cell?

to get them to look how you want them to look


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 does it mean when a cell in a spreadsheet is active?

The Active Cell on a spreadsheet is the cell where the cursor is pointing. That means that you can write to or erase the contents that cell location directly. A spreadsheet program has the entire array in memory, but the Active Cell is the place where it is 'looking or thinking about' at any particular moment.