When working with the use of a Sample of Spreadsheet you should take the time to study what is going on in each of the cells and charts. The main reason for this is that charts and cells are a way of representing a change in the data. When the change occurs, the overall view should be affected.
The next step is to compare the actual amount to what is shown in the chart by looking at the range of the cell. You may find that there is a discrepancy. In this case you would need to look at the cell range to see if there is a formula which was used to make the display of the cell’s value.
Many of the formulas that you will find in spreadsheets have a special function that changes the value of the cells. The formula that is found in the cell will override the displayed value if it is equal to or less than the formula. The last thing that you should remember is that changing the cell range by clicking the cell will change the displayed value.
The second step is to look at any clear message that is displayed when the change is made. This will allow you to click on the text that contains the formula and make sure that it is not affecting the values of the cells. This can be difficult if you do not know what the message means.
The third step is to look at the results of the change of cells. It is common to see the change in a format which is different from the original display. These are good steps to make sure that your code is compatible with the rest of the spreadsheet.
The fourth step is to look at the details that are outlined in the Clear Cells dialog box. There are some cells which will still display the previous value even after the change is made.
If you look carefully at the Clear Cell Dialog Box, you will find a list of displayed cells. These cells are the ones that were made change. If there are many changes that you are not able to understand, you should look at the other sections of the spreadsheet.
The fifth step is to look at the changed values by comparing the previous and new display text. You may also be able to see the formatting which occurred when the change occurred. You will find that the formatting that you see is different from the formatting that was done before the change.