0
How can a change of data entered in a cell in excel affect the other cell on a different sheet?
Wiki User
∙ 14y ago
You can have formulas on a sheet that refer to another sheet or even another file. For example on Sheet3 you could have the following formula which adds values in cells on Sheet1 and Sheet2.
=Sheet1!A3 + Sheet2!C5
That would add those two values and have the result in whatever cell you put that formula. If the values in either of those two cells are changed, then the formula will automatically update the result.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How can excel change values affect business decisions?
Excel allows you to change values in a worksheet quickly and easily. How is this helpful in running a business? How can changing values affect business decisions?
What is a number that can be entered into a cell on Excel?
Which of the following is a number that can be entered into a cell?
What should the Save As file type be if saving Excel?
That will depend on what you want to do. If you are in Excel saving as a standard Excel file, you don't need to change the file type. It is only if you want to save into a different format, that you would change the File Type. What you change it to, would depend on what you need. You might want to change to a different version of Excel or maybe into a completely different format, such as a text file. If you are working in a different application, saving something to be used in Excel, then again it will depend on what format you actually need.
When data is entered into a cell by pressing the enter key the cell pointer will?
It will normally move to the cell underneath it, but you can change the settings in Excel so that it does not do that.
What MS Excel stores?
It stores data. Mainly that data is numbers, but it can also be text, dates or logical data. Excel also stores the formulas that are entered and the formatting of data that is entered.
How do you make cells change color automatically depending on what date is entered in 2007 excel?
Use conditional formatting to set the condition when you enter a particular date.
When a file is saved Excel automatically appends the extension to the entered file name which stands for Excel workbook?
xlsx
What feature enables you to change information already entered in a cell in keyboarding?
The ability to edit, but this has nothing to do with keyboarding, other than you can use a keyboard to edit a cell in Excel.
Does cell references in formulas have to be entered in uppercase?
No. You can type in lower or upper case and you can include spaces. When the formula has been entered Excel will change cell references and function names to uppercase and remove unnecessary spaces.
How do you cancel the formula that you entered into an excel?
You place your cursor in the cell, and delete the formula.
What formula version verified what your entered in formulas on excel?
The correct answer is NUMBERS.
What are words entered into excel sheet called?
labels or cell content
