CIS practice test

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 ____.

True

The ____________________ function calculates the number of years between the two dates

YEARFRAC

The ____________________ function returns the current date’s serial number (based on the computer’s internal clock)

TODAY

The ____ function calculates the number of years between two dates.

YEARFRAC

The TODAY function returns the current date’s serial number (based on the computer’s internal clock).

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.

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.

Business transactions that are processed as they occur is an example of

OLTP

The most fundamental information systems in an organization are:

Transaction processing systems

When interest is credited to your savings account at your bank, it is called a:

Transaction

Crediting interest to your savings account at your bank once a month, it is called a:

process

When interest is credited to your savings account at your bank, it is called a:

transaction

Data that have been processed by the organization’s _____ are inputs into the organization’s database.

Transaction processing systems

Which of the following is not a characteristic of a transaction processing system?

small amounts of data are processed

Which of the following is not an example of a transaction?

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.

TPS need large computers to process the transactions.

Which of the following is not a function of functional area information systems?

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

inventory management

Which of the following is not a process within an information system for Human Resource Management?

firing decisions

Which of the following is false?

The POM function within an organization monitors sales

Which of the following is false?
Selected Answer:

ERP systems are an evolution of functional information systems.
Correct ERP systems look the same to users as functional information systems.
ERP systems have much the same functionality as functional information systems.
ERP systems produce the same reports as functional information systems.
ERP systems use the same data as functional information systems.

_____ integrate the planning, management, and use of all of an organization’s resources, and are designed to tightly integrate the functional areas of the organization.

Enterprise resource planning systems

Which of the following is false?
Selected Answer:

Functional area information systems were usually developed independently.
Correct Functional area information systems easily communicate with each other.
ERP systems are designed to integrate business processes.
ERP systems use a common database.
ERP systems integrate functional areas within an organization.

Functional area information systems easily communicate with each other.

The characteristics of ERP systems include all of the following except:

integrating the planning, management, and use of all resources of the organization
providing information necessary to control the business processes of the organization
including a set of interdependent software modules
typically fitting an organization’s existing business processes
they are expensive and time-consuming

typically fitting an organization’s existing business processes

Enterprise resource planning systems are very _____ software products, meaning that companies typically have to change their _____ to accommodate how the software functions.

structured, business processes

_____ are interorganizational ERP systems that provide Web-enabled links between an organization’s key business systems and its customers, suppliers, business partners, and others.

ERP II systems

_____ are the most successful solutions or problem-solving methods for achieving a business objective.

Best practices

The drawbacks of ERP systems include all of the following except:

Answers:
They are complex
They are expensive
They are time-consuming to implement
Companies may need to change existing business processes to fit the software
They consist of modules

They consist of modules

Kathy has taken a job with her ideal company and is excited to start in their sales department. During orientation, she is told that the company is very proud of their ERP system from SAP. Looking at the list of modules the company has, Kathy wonders which one she won’t be using. From the list below, which one would you tell Kathy is the one she won’t be using.

Operations management

Greg is mowing lawns in the neighborhood for the summer. Which type of report would he used to see which if a particular client still owe him money?

Ad hoc

Greg is mowing lawns in the neighborhood for the summer. Which type of report would he used to see which of his clients still owe him money?

Exception

Greg is mowing lawns in the neighborhood for the summer. Which of the following is not an example of a transaction he has in his business?

Adding a new client to his list
Mowing a client’s lawn
Buying gas for his mower
Driving to the client’s house
Getting paid by the client

Driving to the client’s house

To effectively manage by exception (i.e., use exception reports), the company must first create:

performance standards

When the chief financial officer of a company wants a report on business units who have spent 10 percent more than their allotted budget, she would be requesting which type of report?

The ______________ process originates in the warehouse and end in the accounting department.

procurement

The ____________ process originates in the sales department and ends in the accounting department.

fulfillment

Which of the following activities does not occur within the order fulfillment process?

The sales department receives a customer inquiry and issues a quotation indicating price and availability.
The sales department forwards a sales order to the warehouse.
The warehouse forwards a purchase requisition in order to buy goods from a vendor.
The warehouse prepares the shipment and produces internal documentation.
The accounting department issues an invoice to the customer.

The warehouse forwards a purchase requisition in order to buy goods from a vendor.

reports contain special information not found in routine reports.

Ad hoc

reports are produced at scheduled intervals.

routine

reports summarize the performance of critical activities.

key indicator

Which of the following was not included in early ERP systems?

sales and marketing

Which of the following is false about ERP II systems?

They utilize the Web.
They include human resources processes.
Functionality is delivered as e-business suites.
They support internal- facing applications as well as external-facing applications.
These ERP systems have no optional modules.

These ERP systems have no optional modules.

Which of the following is false?

Breaking down functional silos makes an organization more adaptive.
An organization doesn’t have to use the business processes coded into the ERP.
ERP systems change an organization’s business processes.
ERP systems are time consuming to implement.
ERP systems require functional areas to work together.

An organization doesn’t have to use the business processes coded into the ERP.

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

Lack of documentation

Differentiate between transaction processing systems and functional area information systems.

When ERP systems are not appropriate in an organization, then that organization can use an enterprise application integration system.

T

Organizations that use ERP systems are more agile and adaptive.

T

ERP systems cannot manage cross departmental processes.

F

Exception reports show a greater level of detail than is included in routine reports.

F

Key-indicator reports shows data at a greater level of detail.

F

Drill down reports are produced at scheduled intervals.

F

An organization has to own all of the information systems it used.

F

In addition to cost savings and in labor and time, the new IS added a level of reliability and quick access to information that employees had not even realized they needed.

T

European railways improved its efficiencies by using SAP, which is a customer relationship management system.

F

A company that implements an ERP system must reworking their business processes to meet the procedures established by their ERP systems to gain significant benefits.

T

Greg is mowing lawns in the neighborhood for the summer. He does not need an information system.

F

ConocoPhillips uses ________ to monitor _________ data.

dashboards; real-time

ConocoPhillips addressed employee resistance to using PLOT by ____________.

centralizing the monitoring process

Which of the following is NOT a benefit of PLOT for ConocoPhillips?

data variabililty

____________ is NOT categorized as BI.

hardware

__________ is a subset of BI according to Thomas Davenport.

business analytics

BI answers the question _________________

where is the problem

Business analytics answers the question __________

what is the best or worst that can happen?

The most popular BI tool is

excel

Blackstone Group initially focused on the most depressed housing markets in

atlanta, GA

RentRange uses _____________ to provide information about purchasing foreclosed and low-priced single-family homes and then renting them out.

predictive analytics

RentRange is currently in the _______ industry but could move to the ________ industry.

housing; credit card

Which of the following is an informational role?

disseminator

Which of the following is a decisional role?

resource allocator

In which stage of the IDC do you examine the problem?

intelligence

Validation of the model occurs in the _______ phase of the IDC.

design

_________problems are fuzzy and complex.

unstructured

The yearly employee evaluation is a(n) __________________ problem.

semistructured

___________________ control is executing specific tasks efficiently and effectively.

operational

R&D tasks are ________________.

strategic and unstructured

Which of the following is NOT a BI tool?

A. Dashboards
B. Data dictionary
C. Data mining
D. Data visualization

B. Data dictionary

Which of the following is NOT a major BI vendor?

A. SAS
B. Microsoft
C. Cognos
D. Business Objects

B. Microsoft

In the past, BI was used to support __________.

top managers

Small companies typically use _______ for their B

excel

Data marts are used to __________________.

develop few, related BI applications

CPM is closely aligned with __________

support for organizational transformation

Which of the following is NOT a KPI?

product quality

Airline predictions are off by an average of _______

7 minutes

Which of the following is NOT a reason for flight delays?

A. Weather
B. Wind
C. Pilots
D. Passengers

C. Pilots

Alaska Airlines used ______________ to solve their flight delay problems.

crowdsourcing

GE’s goal for Flight Quest is to ____________.

create smart assistants for pilots

Cardlytics services the ________ industry.

banking

A major issue facing Cardlytics is ________.

privacy

The main purpose of Cardlytics is to ______________.

track and understand consumer buying behavior

Multidimensional analysis is also called ________.

OLAP

Data mining helps explain _____________ happened.

why it

______________ analysis is the study of the impact that changes in one or more parts of a decision-making model have on other parts.

sensitivity

If you are trying to figure out the impact of a 2 versus a 4 percent inflation rate on your profit, that is a ______________ analysis.

what-if

__________ analysis focuses on the outputs rather than the inputs.

goal-seeking

Suppose you want to ensure your Northwest Division generates at least $2 million in revenue. You then use _____________ analysis to determine how much advertising dollars and how many salesmen need to be hired.

goal-seeking

_____________________ is the ability to go to details, at several levels; it can be done by a series of menus or by clicking on a drillable portion of the screen.

drill down

____________ is the short-, medium-, and long-term trends of metrics, which is projected using forecasting methods.

trend analysis

Status access is the latest data available on _____________, often in real time

KPI

The color ___________ in the Management Cockpit represents performance of internal processes and employees.

Blue

Reality mining is a type of _____________.

data visualization technology

Environmental Systems Research Institute is an international supplier of _________.

GIS

In the lost hiker example, which of the following was NOT used to improve the ArcGIS suggestions?