Description
help wit assignment for :
- Blaustein, R. (2009, January 1). Eliminating Spreadsheet risks. IIA Online. Retrieved from https://iaonline.theiia.org/eliminating-spreadsheet-risks.
- European Spreadsheet Risks Interest Group (EuSpRig) (n.d.). Best Practice. EuSpRig. Retrieved from http://www.eusprig.org/index.htm.
- Excel 2016 Training (n.d.). Hoonuit/Atomic Learning. Avail https://www.atomiclearning.com.
- Metz, L. R. (2007). Five Common Spreadsheet Risks and Ways to Control Them. IIA Online. Retrieved from https://iaonline.theiia.org/five-common-spreadsheet-risks-and-ways-to-control-them.
- Panko, R R. (2006). Recommended Practices for Spreadsheet Testing. Proceedings of EuSpRIG 2006 Conference, Cambridge, UK: European Spreadsheet Risks Interest Group (EuSpRIG).
Note: Hoonuit/Atomic Learning may be accessed via Blackboard (under the “Student Tools” button) or via the website (http://www.atomiclearning.com/login/ut/, log on using Spartans Domain user ID and password). Search for tutorials using the search box (search for “Excel 2016”) or drop-down menus.
Explanation & Answer
Hi, here is your assignment :). On the cover page, in which it was stated on the instruction, please put the team members and the leaders.But, if it is individual, just only put your name okay :)
1
SUPPLEMENTAL PREP: SPREADSHEET ANALYTICS (EXCEL)
ACC 351: Accounting Information Systems
Instructor: Dr. M. Walters
Team Members:
Team Leader:
Date:
2
1. Spreadsheet Security.
a. General Controls.
1. File-level: this alludes to the capability to protect the spreadsheet report through
determining a password key so clients cannot open or change it.
2. File encryption: when you choose this control, you can get the best password to lock your
spreadsheet for security (Blaustein, 2009).
b. Microsoft (MS) Excel Atomic Learning Tutorials (Auto Protection Controls) (Metz, 2007).
A. Protecting Your Spreadsheet module tutorials.
In this module, I have learned lots of information regarding the protection and unprotect
the workbook/spreadsheet on excel. This learning is very important, as it helps the users to lock
the workbook to avoid other users open it. I have learned how to properly conduct the
procedures for unlocking the spreadsheet in times that we might forget the password on it.
c. Most spreadsheets exclude General controls
This is becau...
Review
Review
