0
What tool do you use to trace the relationship between the formulas in the cells of a worksheet?
Wiki User
∙ 9y ago
You use the auditing tools, which include the trace precedents and trace dependents commands.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What cell does formulas and functions in Excel make use of?
Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.
Worksheet version that shows the actual formulas entered in cells?
formulas version
In excel what can be used in place of a calculator?
Formulas in the cells in the worksheet.
The adjustments entered in the adjustments columns of a worksheet are?
enter the formulas in the appropriate cells on the worksheet. Then enter the adjustment amount in column.
What appear between cells in a worksheet but they do not print if the worksheet is printed?
Gridlines
Can Worksheet cells only contain numbers?
No. A worksheet can hold all sorts of data, like text, dates, number, logical values and formulas.
When you remove the boundary between two cells in a table or worksheet you are BLANK the cells?
merging
How do you find excel formulas?
If you mean to find which cells have formulas and not values, you do it using the Goto option. Press the F5 key and then click on Special, which opens another set of options. From there, select Formulas and all formulas in the worksheet will be selected. Pressing Ctrl and the ' key will show the formulas that are in cells.
How can you protect a formula in excel just the formulas not the spreadsheet?
Format the entrie spreadsheet with all cells unprotected, except for the cells containing formulas you want to protect. When you turn on worksheet protection, only those cells that are formatted to be protected, will be protected.There are two steps to protecting a worksheet:Format the cells you want to protect. Default is protection on for all cells, so if you do not want a cell to be protected, you need to slect cell format and uncheck the option to protect that cell.Activate protection for the worksheet. Default is protection off for the worksheet.
What is the process of changing the values in cells to see how those changes affect the outcome of formulas in your worksheet?
What-if analysis.
Where does a formula appear on a worksheet?
It will appear in the cell as you type it in. When it has been put in, you will see it in the formula bar. If you set the spreadsheet to show formulas, you can see all the formulas in their cells.
How did changing value affects the other part of the worksheet in Excel?
Worksheets have lots of formulas and they use values in cells. So if you change a value in a cell, any formula that uses that cell directly or indirectly can be affected by the change. How many other parts of the worksheet it will affect will depend on the particular worksheet, as each will have different formulas. Changing a value in a cell could affect one cell or many cells.
