Spreadsheet security, homework help

Briefly respond in one or two pages single-spaced paper to the following:

1.Spreadsheet Security

1. General Controls. Identify two general controls that may be used to protect spreadsheets. Explain how the identified controls ensure spreadsheet security. Hint: Search for “spreadsheet security” or “spreadsheet control.”
2. Automated Protection Controls. Review automated protection controls integrated into Microsoft (MS) Excel by completing Atomic Learning tutorials. Complete the Excel 2016: Protecting your Spreadsheets: A. Protecting Your Spreadsheet (required) module tutorials. List the modules completed, provide a brief synopsis what you learned within each module (You do not have to provide a synopsis of each individual tutorial video), and comment on the usefulness of the MS Excel protection functions. Note: Atomic Learning modules are required.
3. Why do you think most spreadsheets exclude such controls? Discuss

2.Spreadsheet Integrity

1. Application Controls. Identify two application controls used to ensure spreadsheet integrity. Explain how the identified controls ensure spreadsheet data integrity. Hint: Search for “spreadsheet integrity” or “spreadsheet integrity controls.”
2. Automated Data Validation Controls. Review automated data validation controls such those integrated into MS Excel by completing Atomic Learning tutorials. Complete the Excel 2016: Evaluating Data: B. Data Validation (required) module tutorials. List the modules completed, provide a synopsis what you learned within each module (You do not have to provide a brief synopsis of each individual video tutorial video and comment on the usefulness of the MS Excel validation functions. Note: Atomic Learning modules are required.
3. Why do you think most spreadsheets exclude such controls? Discuss.

3.Spreadsheet Testing

1. Testing Procedures. Identify and explain two testing procedures that may be used to assess spreadsheet integrity. Explain how the identified controls ensure spreadsheet data integrity/security. Hint: Search for “spreadsheet testing” or “spreadsheet testing tools.”
2. Automated Testing Tools. Review automated testing functions such those integrated into MS Excel by completing Atomic Learning tutorials. Complete the Excel 2016: Frequently Used Formulas & Functions Training: D. Auditing and Error Checking (required) module tutorials. List the modules completed, provide a brief synopsis what you learned within each module (You do not have to provide a synopsis of each individual tutorial video), and comment on the usefulness of the MS Excel assessment functions. Note: Atomic Learning modules are required.
3. Why do you think most users fail to test their spreadsheets? Discuss.

4.Spreadsheet Compliance. Explain why spreadsheet control represents a significant Sarbanes-Oxley compliance concern for organizations (see Bellino et al. 2010, Panko 2007, PWC 2004 but also conduct your own research and draw your own conclusions). Hint: Search for “spreadsheets and compliance” or “spreadsheets and Sarbanes Oxley.”