What are the three basic approaches that can help in the verification of spreadsheets?
What will be an ideal response?
The three basic approaches involve:
• Improving the design and format of the spreadsheet itself: After the inputs, outputs, and key relationships are well understood, a logical design of the spreadsheet can be sketched.
• Improving the process used to develop a spreadsheet: If a conceptual design of the spreadsheet is sketched, every part should be worked on individually before moving on to the others to ensure that it is correct.
• Inspecting the results carefully and using appropriate tools available in Excel: The Data Validation tool can signal errors if an input value is not the right type. The Excel Auditing tool helps to validate the logic of formulas by visually showing the relationships between input data and cell formulas.
You might also like to view...
After computing averages and measures of dispersion for the major variables and applying advanced statistical techniques and decision models in the hope of discovering additional findings from the gathered information, researchers ________
A) define the problem, the decision alternatives, and the research objectives B) present findings relevant to the major marketing decisions facing management C) evaluate the costs associated with data collected D) analyze the appropriateness of the data sources used E) develop the research plan
If for the next 40 years you place $3,000 in equal year-end-deposits into an account earning 8% per year, how much money will be in the account at the end of that time period?
A) $120,000.00 B) $777,169.56 C) $839,343.12 D) $2,606,942.58