ExamTopics Logo
Mail Us[email protected]
Menu
Iia Discussions
exam questions

Exam IIA-CIA-Part1 All Questions

View all questions & answers for the IIA-CIA-Part1 exam
Go to Exam

Exam IIA-CIA-Part1 topic 6 question 13 discussion

Actual exam question from IIA's IIA-CIA-Part1
Question #: 13
Topic #: 6
[All IIA-CIA-Part1 Questions]

An internal auditor uses a predefined macro provided in a popular spreadsheet application to verify the present value of the organization's investments. Which of the following is the most appropriate course of action regarding the auditor's use of this functionality?

  • A. The auditor should accept the calculations generated by the function, as any further work or documentation would be inefficient.
  • B. The auditor should perform a manual recalculation of several results to validate and document the results.
  • C. The auditor should review the programming of the macro before its use to ensure that it is appropriate for the required calculations.
  • D. The auditor should tabulate the results in the spreadsheet to ensure the macro has generated the correct results for all calculations.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Nimishagoel at Dec. 8, 2020, 4:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Nimishagoel
Highly Voted 1 year, 7 months ago
I don't agree with B. It should be C. If a spreadsheet has a macro that generally means the calculations are tough or complicated to be done manually. To just check the macro and whether or not it has been applied correctly should be enough
upvoted 5 times
...
John1237
Most Recent 1 month, 2 weeks ago
Why is it B and not C? 1- A macro can be used because of the quantity of data and not its complexities 2- It is not sure that the auditor will be competent to analyze the macro (this could also be time consuming) 3- The auditor is interested in a reliable result. By testing the data fields, the auditor can know if the macro functionalities are acceptable.
upvoted 2 times
...
poundr
9 months, 1 week ago
" to verify the present value of the organization's investments" can be achieved via manual re-performance
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago