List four of the recommended methods for minimizing the potential for errors when using spreadsheets.

What will be an ideal response?


ANS:
The recommended methods for minimizing the potential for errors when using spreadsheets include:
1. Double-check all numbers that are entered into a spreadsheet for accuracy.
2. Triple-check every single formula in a spreadsheet, including using the Formula Auditing mode to print out all formulas.
3. Make comments in specific cells regarding assumptions.
4. Create a notes section at the bottom or top of the spreadsheet containing assumptions or other data the reader should be aware of.
5. Double-check each inserted row or column to make sure it appears in the applicable formulas.
6. Have someone else carefully review each spreadsheet, including formulas.
7. Before using a new function, completely understand exactly what it does and ensure that it is working 100 percent correctly.
8. Use a calculator to spot-check spreadsheets to make sure the formulas are accurate.
9. Use the Protect feature to protect cells, particularly formulas, from being changed accidentally.

Legal Studies & Paralegal

You might also like to view...

__________________________ handle a variety of matters/cases in such areas as child support, child custody, disability claims, bankruptcies, and landlord-tenant disputes.?

A. ?Legal services offices B. ?Boutique firms C. ?Corporate law departments D. ?Government law practices E. ?none of the above

Legal Studies & Paralegal

How would you conduct online legal research of state court dockets in your jurisdiction?

What will be an ideal response?

Legal Studies & Paralegal

A treatise may help establish

a. damages. b. standard of care. c. expert credentials. d. negligence.

Legal Studies & Paralegal

Cross examination is:

A. The direct questioning of a witness as called by that attorney B. The questioning of the opposing attorney's witnesses after the first attorney has had the opportunity to question them C. The judge questioning a witness after both attorneys have had the opportunity to question them D. None of the above

Legal Studies & Paralegal