answersLogoWhite

0


Best Answer

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

User Avatar

Wiki User

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

Wiki User

11y ago

You use cell addresses in formulas because it means formulas do not have to change if values. The formula =10+5 will only add 10 and 5, so if you want to add other values, you need to change it. The formula =A2+B2 adds whatever is in those two cells. So you can change the values in those two cells and the formula does not need to be changed in order to add them together.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When do you use with a cell address in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How can recognize cell in excel?

By looking on the cell address


What is the first cell address in an excel sheet?

A1 is the address of the first cell.


How do you get to cell a in Excel?

You can click on a cell to get to it. You can use keyboard commands to get to it. You can use the Goto command, by pressing the F5 key. You can type a cell address into the Name box.


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 is the location called that excel adjusts the cell address to when coping a formula?

Relative Address


In Excel a cell reference of B17 is it an invalid cell reference?

No it is not invalid. It is the cell address of the cell where column B meets row 17. It is a relative cell address.


Why IZ10 is invalid cell address?

IZ10 would be an invalid address in version 2003 of Excel and earlier versions. The last column in Excel 2003 is column IV, so there is no column IZ. In versions from Excel 2007 onwards, IZ10 would be a valid cell address.


What is the name of individual box in Microsoft Excel 2007?

Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.


Is A5 a cell address in excel?

Yes. It would be the cell where column A intersects with row 5.


What is the cell address of the last cell of the Microsoft Excel 2003?

The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.


What is an absloute cell reference?

1. An absolute cell address is a cell address that does not change when you move a formula from one cell to another. You display absolute cell addresses by adding $ to the address:


Which is the valid cell address?

A cell address in programs such as Excel normally starts with a letter (or more than one letter, if you use more than 26 columns), followed by a number. For example: A13, D53, AD1003.