0
Which operator has the highest priority in the order of evalution in a worksheet formula?
Wiki User
∙ 8y ago
The power of operator, like 10^2. However, using brackets, you can override the order. So, in the following formula the ^ is done first:
=5*10^2
In the next formula, the * is done first:
=(5*10)^2
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
In Excel the plus sign is an example of an operand in a worksheet formula?
The plus sign is an operator, not an operand. An operand is something that an operator operates on. For example, A3 and 10 are the operands in the following formula and the operator is the plus sign. =A3+10
What formula is a formula that links a chart object to the source worksheet?
se
What is a general name of equation in worksheet?
A formula.
Where does the formula bar appear in a worksheet?
It is just above the worksheet and below the toolbars.
What is an equation that performs mathematical calculations on values in a worksheet?
It is called a formula.
Where on a worksheet do you type data?
cell or formula bar
What separates more than one cell in Excel?
On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)
What is a tool that changes the cell value in a worksheet to a specified value highest value or lowest value for a worksheet cell formula?
The Solver.
What is the expression used to calculate values displayed in a worksheet called?
A formula.
In excel if the formula equals A1 plus B1 what is the operator?
For =A1+B1, the operator is the plus sign (+).
What is located under the ribbon and just above the worksheet grid?
The Formula Bar.
An equation that calculates a new value from values currently in a worksheet is called?
Formula
