0
A(n) tells Excel what kind of math to do with the numbers or cell references?
Wiki User
∙ 7y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What consists of cell references numbers and arithmetic operators that instruct Excel to perform a calculation?
A formula.
What cell reference tells Excel to substitute new cell references within the copied formulas as necessary?
A relative reference in a formula will change when it is copied.
Can you use numbers or cell references in formulas?
You can use both numbers and cell references in formulas.
What changes when it is copied or moved in Excel?
Relative cell references and some mixed cell references will change when a formula is copied.
In Excel when cell references are copied each cell reference that Excel automatically adjusts for the new position is called what?
relative cell address
What are horizontal references in excel?
Horizontal references in Excel refer to a method of referencing data in a row. This means that data is organized in rows and referenced using row numbers. Horizontal references allow you to use formulas to work with data across an entire row instead of just a single cell.
What is an experession in excel?
It can be a formula put into a cell. There are lots of variations, using numbers, dates, cell references and other things. Something simple like: =10+2 =A14-C12
In excel if you copy a formula to another location and the cell references change to reflect the position of its copied location the formula contains a what?
It contains relative cell references.
What is an absolute formula in Excel?
It would be a formula that includes absolute references in cells. When such a formula is copied, those cell references will not change. An absolute cell reference includes cell references with two dollar signs in them, like: $A$2.
What are the processes of adjusting the row and column portion of cell references in excel?
You can do this using relative reference.
Which function of Excel does not work with 3D formulas?
There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.
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.
