Which of the following controls within a spreadsheet would address the risk of logic errors? 1. The spreadsheet contains formulas that foot and cross-foot data. 2. The spreadsheet is locked to protect cell formulas from being inadvertently changed. 3. Spreadsheets are included in nightly backup processes. 4. Check-in and check-out software is used to manage version control.
A) 1 and 2 only
B) 1 and 3 only
C) 2 and 4 only
D) 3 and 4 only

Question

Quizplus · Accepted Answer

Formulas that foot and cross-foot data help ensure calculations are correct, addressing logic errors. Locking the spreadsheet protects formulas from accidental changes, preventing logic errors.

Which of the Following Controls Within a Spreadsheet Would Address