0
Because it means that if you change the value in a particular cell, the formula will automatically update its result. Say you want to add 45 and 19. If you put 45 into cell A1 and 19 into cell A2 then in cell A3 you could have a formula:
=45+19
That formula will give the result 64, which is correct. But if you then wanted to change one of the two original values, you would have to change the formula again to get the correct result. If you put 30 into A1 without changing the formula in A3, A3 will still show 64. It is still being told to add 45 and 19. The formula has no connection to the cells A1 and A2. You would have to change the formula in A3 to be =30+19 to get the correct result if you want to add 30 and 19. That means you keep having to change the formula to add different numbers, which is not very efficient. So what we do is put cell addresses instead of values into formulas. So into A3 you would put:
=A1+A2
For the original two values it will give 64. Then, without having to change the formula, if you change the 45 in A1 to 30, the formula will automatically add the 30 and 19 giving you 49, because the formula is telling it to add whatever values are in those two cells. So no matter what two values you put into A1 and A2, the formula in A3 will always add them.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Are cell addresses used to develop formulas-not values themselves?
Yes, cell addresses are used rather than values in formulas. The values are put into the cells. This makes the spreadsheet more flexible, as you can change values in the cells rather than having to change formulas. It also means formulas can be copied and made to use other cells. So there are good reasons for using cell addresses in formulas.
Arithmetic operator that divides contents of cell?
The / is used for division in spreadsheet formulas.
What does cell mean in ict?
Spreadsheet CellsIn the same way that each field in a database can only hold one type of data, each cell in a spreadsheet can only deal with one type of data at a time.For example, it is not possible to enter text and numbers in the same cell, and then be able to use the number in a calculation. The entire contents of the cell would be treated as text.Spreadsheets are widely used because they allow you to use formulas to perform repetitive calculations. Formulas use cell names to perform calculations.Answer to formulas will change when values in the cells it refers to change. This makes a spreadsheet dynamic and powerful.
Why is it important to use cell addresses in a formula instead of just using the numbers typed into the cell with Excel?
Because it gives a spreadsheet more flexibility. For the type of things that spreadsheets are used for, figures change frequently. In order to deal with this, formulas would have to change when changes are made to values if values were put directly into formulas. By using cell references then the formulas can do the calculations whatever values are in the cells. This speeds up the spreadsheet, as you may only have to change one value and this can then change a whole range of totals. So you can very quickly see the effects of changing values, without having to rewrite formulas. Using cell references also means formulas can be copied and so deal with other combinations of cell references.
Is autocomplete fils in formulas and cell addresses across a range of cells?
No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.
How is active cell used in a sentence in a spreadsheet?
The active cell is where things will go when you start to type something into a spreadsheet.
What is a cell cursor?
A cursor that is used when selecting a whole cell in an excel spreadsheet.
Why does each cell in a spreadsheet have coordinates?
A computer spreadsheet worksheet is a two dimensional array. Each cell has a unique row and column number (and where there is more than one sheet in the workbook a unique sheet identifier. This enables the contents of a cell to be found and read from/written to specifically and therfore allows cells to be used in complex formulas.
What is auditing in excel?
Auditing is the process of checking formulas and the spreadsheet in general to find errors and correct errors. It enables you to do things like find out if a cell is being used by another formula or find out what cells a formula uses. This enables you to ensure that cells that should be included in a formula, like when you are totalling a range of cells, are included. It can also help identify cells that are in a spreadsheet with values that are not being used. This could enable you to correct formulas that should include a cell, or get rid of cells with values that are not needed. It also may help to define more efficient formulas and simplify a spreadsheet.
What are the features of a spreadsheet?
1. Rows and Columns 2. Cell formatting 3. Cell Merging 4. Copy, paste and cut 5. Multiple worksheets 6. Graphs and Charts 7. Inserting/deleting columns and rows 8. Functions 9. Formulas That's all I can think of! I hope it helps you!
What is a cell in ms excel?
the intersection of a row and a column is known as a cell. It is the basic storage unit for data in a spreadsheet. It is usually used for calculations. You need to know certain formulas to perform the calculations or if you have any problem in learning these formulas you can use the auto sum button which is present at the standard toolbar
Is getting data from a cell in a spreadsheet called referencing?
Yes, that term is used. By referencing a cell you can use the value that is in that cell.
