answersLogoWhite

0


Best Answer

It displays the current content of cells and allows you to add in formulas, labels or values into a cell. You can also start the Insert Function dialog box by clicking on the fx at the beginning of the formula bar.



User Avatar

Wiki User

8y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

The formula bar is located above the cells C and D and in between the Cell and the Data bar on the Excel speadsheet. It will have a X a check and a Fx. That is the formula bar. It will display the contents of cells or allow you to type formulas.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

The Formula Bar is where you can type in formulas and data and see the cell contents when you place the cursor on a cell. This can help you to see how the data in the cell has been arrived at, by seeing the formula that is in the cell. The Insert Function button is on the Formula Bar, enabling you to enter functions. The Name Box is also on the formula bar, showing the address of the active cell or named cell range. As what is in cells is important and the importance of formulas for Excel, the Formula Bar is very important for Excel.

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

The Formula Bar is found in Excel, not Word. There is a formula dialog box which enables you to do simple formulas in tables in Word, but no actual formula bar. See the related question below.

This answer is:
User Avatar

User Avatar

Wiki User

16y ago

area near the top of the worksheet window that displays the contents of the active cell

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

It allows you to view and edit contents of a cell.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the purpose of a formula bar in a spreadsheet program?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the purpose of the entry and formula bar in a spreadsheet?

View existing contents of a cell, and enter a formula or other contents into the cell.


Where is the bar to add information on a spreadsheet?

The formula bar is located above the worksheet and below the menu bar.


What is a spreadsheet display bar?

You may be referring the formula bar. It displays the cells contents, which can be values or formulas.


Where would value be located in excel?

Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.


What is the meaning of the Formula Bar?

A formula bar is used to work in Microsoft Office, spreadsheet or others to format cells, combine text from two cells into one, format numbers to add, subtract etc. It's a bar where you can choose different formats for data.


What is the formula to convert bar to m?

Multiply the bar value by 1000. 12 bar = 12,000 mbar. In an Excel spreadsheet, if you bar version was in cell A2, you could put the following formula in B2 to calculate the mbar value. =A2*1000


Where is the formula bar located in Microsoft Excel?

You may mean the formula bar. It is at the top of the spreadsheet, immediately above the column heading letters. If you can not see the formula bar, go to the View menu and click the Formula bar option.


Where is the formula keyed in spreadsheets for Excel?

In the cell and on the formula bar at the top of the screen, just below the menu bar or ribbon.


Where does a formula appear on a worksheet?

It will appear in the cell as you type it in. When it has been put in, you will see it in the formula bar. If you set the spreadsheet to show formulas, you can see all the formulas in their cells.


Where can you enter a sum in excel?

A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.A sum can be entered in any cell on a spreadsheet or by typing it into the formula bar. You can use calculations in lots of ways to do a sum, including the SUM function, the SUBTOTAL function, using Alt and the equals sign and using the Autosum button.


The difination for entry bar?

An entry bar is the feild in a computer where data is entered in a spreadsheet! :) Chow, JamES An entry bar is the feild in a computer where data is entered in a spreadsheet! :) Chow, JamES


What is a columm in a spreadsheet?

A column in a spreadsheet is the straight up and down bar. These are labeled with letters A-Z.