0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Assume that cell C5 contains a formula By default where would you see the formula displayed?
In the formula bar.
What happens when the formula is complete and you exit the cell?
The formula will be entered and a calculation will be done and a result displayed.
In Excel what bar is data displayed as you type?
The Formula Bar.
What is the expression used to calculate values displayed in a worksheet called?
A formula.
When a formula is in an active cell the underlying formula is visible in the what Formula Bar or Worksheet or Status bar or Name Box?
If there is a formula in the active cell, then the formula will be displayed in the formula bar and the result of the formula will appear in the cell.
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.
What does the formula of water look like?
The formula is displayed as: H2O The H is the chemical symbol for hydrogen, and the O is the chemical symbol of oxygen.
What would the formula BeS be written out as?
BeS is the chemical formula of beryllium sulfide.
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.
If you used the Excel formula SUM(A2A4) what will be calculated?
The values in cells A2, A3 & A4 will be added together - and the result displayed in the cell that contains the 'sum' formula.
Where is the address for the active cell displayed?
In the name box, beside the formula bar.
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
