ExamGecko
Question list
Search
Search

Related questions

Question 131 - CISA discussion

Report
Export

Which of the following is MOST important for an IS auditor to review when evaluating the accuracy of a spreadsheet that contains several macros?

A.
Encryption of the spreadsheet
Answers
A.
Encryption of the spreadsheet
B.
Version history
Answers
B.
Version history
C.
Formulas within macros
Answers
C.
Formulas within macros
D.
Reconciliation of key calculations
Answers
D.
Reconciliation of key calculations
Suggested answer: C

Explanation:

The most important thing for an IS auditor to review when evaluating the accuracy of a spreadsheet that contains several macros is the formulas within macros. Macros are sequences of commands or instructions that can automate tasks or calculations in a spreadsheet. Formulas are expressions that perform calculations on values or data in a spreadsheet. The accuracy of a spreadsheet depends largely on whether the formulas within macros are correct, consistent, and complete. The IS auditor should review the formulas within macros to verify that they produce the expected results and do not contain any errors or inconsistencies. The other options are not as important as formulas within macros, as they do not directly affect the accuracy of a spreadsheet. Encryption of the spreadsheet is a security control that can protect the confidentiality and integrity of the spreadsheet, but it does not ensure its accuracy. Version history is a document control feature that can track and manage changes to the spreadsheet, but it does not verify its accuracy. Reconciliation of key calculations is a validation technique that can compare and confirm the results of calculations with other sources, but it does not evaluate the accuracy of formulas within macros.Reference:CISA Review Manual (Digital Version), Chapter 3, Section 3.2

asked 18/09/2024
Henry R L Thom
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first