CIS Practice Test with Complete
Solutions
The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3
contains the date 12/31/2009 is ____. - ANS-True
The ____________________ function calculates the number of years between the two
dates - ANS-YEARFRAC
The ____________________ function returns the current date's serial number (based
on the computer's internal clock) - ANS-TODAY
The ____ function calculates the number of years between two dates. - ANS-
YEARFRAC
The TODAY function returns the current date's serial number (based on the computer's
internal clock). - ANS-TRUE
Which of the following is true?
Answers:
Transactions are only critical to the area they occur in.
Transactions can only involve one database.
Transactions can only involve one computer.
The actual processing of a Transaction has to be standard.
Transactions generate a small volume of data. - ANS-The actual processing of a
Transaction has to be standard.
Which of the following is false?
Corporate data is supplied by Transaction processing systems.
Information systems are only used by large organizations.
Reports from information systems are used in all levels of the organization.
Data from TPS systems feeds ERP systems.
Information systems within an organization support internal and external processes. -
ANS-Information systems are only used by large organizations.
Organizational transactions are typically _____ volume, _____, and therefore _____ to
computerize. - ANS-high, repetitive,easy
Business transactions that are processed as they occur is an example of - ANS-OLTP
, The most fundamental information systems in an organization are: - ANS-Transaction
processing systems
When interest is credited to your savings account at your bank, it is called a: - ANS-
Transaction
Crediting interest to your savings account at your bank once a month, it is called a: -
ANS-process
When interest is credited to your savings account at your bank, it is called a: - ANS-
transaction
Data that have been processed by the organization's _____ are inputs into the
organization's database. - ANS-Transaction processing systems
Which of the following is not a characteristic of a transaction processing system? - ANS-
small amounts of data are processed
Which of the following is not an example of a transaction? - ANS-printing a report
Which of the following is false?
Selected Answer:
TPS need large computers to process the transactions.
Business transactions can be processed when they occur.
Business transactions can be processed after they occur.
Data for transactions can be collected by sensors.
A transaction is a business event. - ANS-TPS need large computers to process the
transactions.
Which of the following is not a function of functional area information systems? - ANS-
providing data from business events to the corporate database
Which of the following is not a process within an information system for Accounting and
finance - ANS-inventory management
Which of the following is not a process within an information system for Human
Resource Management? - ANS-firing decisions
Which of the following has not been identified as a reason for ERP implementation
failure?
Failure to include affected employees in planning
The complexity of the planning
Lack of documentation
Insufficient training
No change management processes - ANS-Lack of documentation
Solutions
The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3
contains the date 12/31/2009 is ____. - ANS-True
The ____________________ function calculates the number of years between the two
dates - ANS-YEARFRAC
The ____________________ function returns the current date's serial number (based
on the computer's internal clock) - ANS-TODAY
The ____ function calculates the number of years between two dates. - ANS-
YEARFRAC
The TODAY function returns the current date's serial number (based on the computer's
internal clock). - ANS-TRUE
Which of the following is true?
Answers:
Transactions are only critical to the area they occur in.
Transactions can only involve one database.
Transactions can only involve one computer.
The actual processing of a Transaction has to be standard.
Transactions generate a small volume of data. - ANS-The actual processing of a
Transaction has to be standard.
Which of the following is false?
Corporate data is supplied by Transaction processing systems.
Information systems are only used by large organizations.
Reports from information systems are used in all levels of the organization.
Data from TPS systems feeds ERP systems.
Information systems within an organization support internal and external processes. -
ANS-Information systems are only used by large organizations.
Organizational transactions are typically _____ volume, _____, and therefore _____ to
computerize. - ANS-high, repetitive,easy
Business transactions that are processed as they occur is an example of - ANS-OLTP
, The most fundamental information systems in an organization are: - ANS-Transaction
processing systems
When interest is credited to your savings account at your bank, it is called a: - ANS-
Transaction
Crediting interest to your savings account at your bank once a month, it is called a: -
ANS-process
When interest is credited to your savings account at your bank, it is called a: - ANS-
transaction
Data that have been processed by the organization's _____ are inputs into the
organization's database. - ANS-Transaction processing systems
Which of the following is not a characteristic of a transaction processing system? - ANS-
small amounts of data are processed
Which of the following is not an example of a transaction? - ANS-printing a report
Which of the following is false?
Selected Answer:
TPS need large computers to process the transactions.
Business transactions can be processed when they occur.
Business transactions can be processed after they occur.
Data for transactions can be collected by sensors.
A transaction is a business event. - ANS-TPS need large computers to process the
transactions.
Which of the following is not a function of functional area information systems? - ANS-
providing data from business events to the corporate database
Which of the following is not a process within an information system for Accounting and
finance - ANS-inventory management
Which of the following is not a process within an information system for Human
Resource Management? - ANS-firing decisions
Which of the following has not been identified as a reason for ERP implementation
failure?
Failure to include affected employees in planning
The complexity of the planning
Lack of documentation
Insufficient training
No change management processes - ANS-Lack of documentation
