VI-Debugging

VI-Debugging - VI Debugging Testing your model(with small...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Debugging 1 VI. Debugging Testing your model (with small numbers) During the process of building a spreadsheet model get in the habit of testing it. It’s easiest to spot possible errors if you use small numbers and numbers (say multiples of 10) that are relatively easy to spot check. For example, enter a few small, simple values in the model below makes it easy to spot any errors in formulas. Then replace the test values with actual values.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Debugging 2 Audit features Excel includes an Auditing Toolbar to help you track how values in your worksheet are related. Turn on the Auditing Toolbar with Tools, Auditing, Show Auditing Toolbar. The four auditing features accessible from the toolbar are trace precedents, trace dependents, trace error, and circle invalid data. The example above shows a trace of precedents for Cell E4. The example above shows an error trace for Cell E6.
Background image of page 2
Debugging 3 Handling error values If a formula can’t properly evaluate a result, Excel will display an error value. An
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

VI-Debugging - VI Debugging Testing your model(with small...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online