Special introduction to excel



Download 1.18 Mb.
Page1/11
Date09.06.2018
Size1.18 Mb.
#54022
  1   2   3   4   5   6   7   8   9   10   11

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”:





Download 1.18 Mb.

Share with your friends:
  1   2   3   4   5   6   7   8   9   10   11




The database is protected by copyright ©ininet.org 2024
send message

    Main page