Discuss what options of internal controls and audit trails are available in this spreadsheet program, EXCEL...

Discuss what options of internal controls and audit trails are available in this spreadsheet program, EXCEL and how these work in terms of data accuracy, security and integrity. List at least two examples for each of the internal control procedure and the audit trail feature.

Solutions

Expert Solution

Answer: Internal controls and Audit trails ,Data Accuracy, Security and Integrity in Spreadsheet Program Excel:

Spreadsheet controls are a set of steps that an organization's accounting personnel can take to ensure accuracy and integrity of financial records and bookkeeping procedures. ... An effective spreadsheet control program should provide: User access control including usernames, passwords, and biometric verification.

Spreadhsheet of Excel maintains 15 figures in its numbers, but they are not always accurate: the bottom line should be the same as the top line.

Normally the system of Excel is being prepared for multiuser hence Security is not the issue here. Still we can have the security system install in our Spreadhsheet as follows"

How to Lock All the Cells in an Excel Worksheet

Navigate to the Review tab.
Click Protect Sheet. ...
Click OK to protect the sheet.
Select all the cells you don't want to be locked. ...
Right-click on your selection, select Format Cells, and click on the Protection tab. :In fact, the only native Excel protection system with reasonable integrity is the file encryption offered with recent versions of Excel.

Through this process, we can maintain security and integrity of our Spreadsheets.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Create a spreadsheet in Excel that lists at least three financing options available to firms. You...

Create a spreadsheet in Excel that lists at least three financing options available to firms. You can find an Excel template of this in the attached Financing options spreadsheet.xlsx. Identify and describe each of the instruments, state who would be the targeted market for this instrument, explain the process that the firm must take to get this financing option and state the regulations related to the option. Financing Options Financing Option Description Market Process Regulations

1. Explain what “internal controls” are and how they relate to the audit. What effect do...

1. Explain what “internal controls” are and how they relate to the audit. What effect do internal controls have on the job of the independentauditor?Your answer should discuss the relationship between internal controls and the financial statements. In answering your questions, consider whether good internal controls contribute to the accuracy of financial statements. On the other hand, explore the possibility that financial statements can be accurate even if internal controls are poor. You may give an example of an internal...

What type of audit opinion was given for the financial statements and the internal financial controls...

What type of audit opinion was given for the financial statements and the internal financial controls for Nike on their 10k report? Explain the key items discussed in the audit report.

What are the goals of conducting an audit of financial statements and internal controls? Who typically...

What are the goals of conducting an audit of financial statements and internal controls? Who typically conducts such audits, how often, and for whom?

Some argue that powerful audit trails may be one of the best security measures available. Do...

Some argue that powerful audit trails may be one of the best security measures available. Do you agree or disagree with this premise? Be sure to explain and provide support for your position.

Discuss the internal controls in a business. What are they? Describe in detail. Why are they...

Discuss the internal controls in a business. What are they? Describe in detail. Why are they important?

Discuss the importance of understanding internal control in developing an effective audit program. In that context,...

Discuss the importance of understanding internal control in developing an effective audit program. In that context, include in your discussion a general overall position and specifically the internal control questionnaires for either the Revenue and collection Cycle or Production (Inventory) Cycle, which also includes internal control over Inventory Transaction Processing. Matters such as seperation of duties should be part of your response. Include in your answer several (3 would be enough) important considerations to satisfy sound internal control for each...

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 10-year analysis period, double declining depreciation is used, 21% corporate tax rate, an initial cost of $200,000, an annual benefit of $60,000 and no salvage value but instead you must pay a disposal fee of $20,000 that your corporate accountant determined is 100% tax deductible.

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 7-year property, MACRS depreciation is used, 21% corporate tax rate, an initial cost of $800,000, an annual benefit of $150,000 and a salvage value of $100,000. Do not forget the recaptured depreciation.

What actions are available to you regarding your planned reliance on the internal controls? Explain the...

What actions are available to you regarding your planned reliance on the internal controls? Explain the pros and cons of each action.

Subjects