Dale - Computer Science Illuminated 409

# Dale - Computer Science Illuminated 409 - cells A more...

This preview shows page 1. Sign up to view the full content.

Circular reference A set of formulas that ulti- mately, and erroneously, rely on each other to compute their results 382 Chapter 12 Information Systems Figure 12.5 A circular reference situa- tion that cannot be resolved Contents Cell =B7*COUNT(F8. .K8) A1 =A14+SUM(E40. .E50) B7 =G18+G19–D13 E45 =D12/A1 D13 Circular References Note that spreadsheet formulas could be defined such that they create a circular reference that can never be resolved because the result of one formula is ultimately based on another, and vice versa. For instance, if cell B15 contains the formula =D22+D23 and cell D22 contains the formula =B15+B16 there is a circular reference. Cell B15 uses the value in cell D22 for its result, but cell D22 relies on B15 for its result. Circular references are not usually this blatant and may involve many
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: cells. A more complicated situation is presented in Figure 12.5. Ultimately, cell A1 relies on cell D13 for its value, and vice versa. Spreadsheet software usually detects these problems and indicates the error. Spreadsheet Analysis One reason spreadsheets are so useful is their versatility. The user of a spreadsheet determines what the data represents and how it is related to other data. Therefore, spreadsheet analysis can be applied to just about any topic area. We might, for instance, use a spreadsheet to: ± track sales ± analyze sport statistics ± maintain student grades ± keep a car maintenance log ± record and summarize travel expenses ± track project activities and schedules ± plan stock purchases...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online