0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do you insert the formula of mean in excel?
=AVERAGE(Firstcell:lastcell) i think
What can be used to find an Excel function by typing a description of the formula?
You can use the Insert Function button fx on the Formula bar to find an Excel function by typing a description of the formula at the Insert Function dialog box, in the Search for a function text box and then click Go.
What is the Fx formula on Excel?
Fx represents functions. It is on the Formula Bar and on the Insert Function Button. Clicking on it starts the process of allowing you to enter a function.
In Excel what does plus mean?
It has no special name. It is just the plus sign.
Does functions inserted from the Insert Functions button and from the SUM list require the Excel user to type the equals sign for each formula?
yes
How do you get to the functions in excel?
There are lots of ways. Go to the Insert Menu and choose Function. Click on the Fx just beside the formula bar, or on the Formulas ribbon.
How can insert a row in excel sheet without changing the formula?
Change the formula to use absolute references instead of relative references. Instead of =A2+B3, use =$A$2+$B$3.
In Excel what displays the cell address the Insert Function button and the contents of the current cell?
The Formula Bar shows those things. Included in it is what is specifically known as the Name Box, which is where the address is shown. The Insert Function button is beside that and then the Formula Box part, when you can see the contents of the cell.
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
What is a feature of Excel that allows you to create curved or stylized text for a chart?
Excel does not create stylized text, but you can insert WordArt. You will find the WordArt option in Excel 2007 on the Insert tab in the Text section.
How do you insert the Name Box in Excel?
The Name Box is on the Formula Bar, so if it is visible, then so will the Name Box. It can be hidden or shown through the View section of Options.
How do you insert brackets in cells?
To insert a bracket in a cell, you just press the [ or ] key.If you are trying to enter braces { or } (usually Shift-[ and Shift-]) to indicate an array formula, you use a special procedure:Type your array formula in a cell.Press CTRL+SHIFT+ENTER.If you edit the formula, you need to press Press CTRL+SHIFT+ENTER again to let Excel know you want an array formula.
