CHAPTER 10
INFORMATION SYSTEMS CONTROLS FOR SYSTEMS RELIABILITY – PART 3: PROCESSING INTEGRITY AND AVAILABILITY
SPECIAL INTRODUCTION TO EXCEL
This chapter includes a number of problems that use Excel’s built-in Data Validation tool to help students better understand processing integrity controls by programming them in a spreadsheet. Some students will already
be familiar with this tool, others will not. Therefore, this brief introductory tutorial may be useful as a hand-out prior to assigning the Excel questions in this chapter.
The Data Validation tool is found on the “Data” tab, as shown below:
Click on “Data Validation” and then choose the option “data validation”: