Spreadsheet security, homework help
Briefly respond in one or two pages single-spaced paper to the following:1.Spreadsheet SecurityGeneral 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. 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. Why do you think most spreadsheets exclude such controls? Discuss 2.Spreadsheet IntegrityApplication 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. 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. Why do you think most spreadsheets exclude such controls? Discuss. 3.Spreadsheet TestingTesting 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. 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. 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.
THIS QUESTION IS UNSOLVED!
Request a custom answer for this question