CIS practice test – Flashcards

Unlock all answers in this set

Unlock answers
question
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 ____.
answer
True
question
The ____________________ function calculates the number of years between the two dates
answer
YEARFRAC
question
The ____________________ function returns the current date's serial number (based on the computer's internal clock)
answer
TODAY
question
The ____ function calculates the number of years between two dates.
answer
YEARFRAC
question
The TODAY function returns the current date's serial number (based on the computer's internal clock).
answer
TRUE
question
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.
answer
The actual processing of a Transaction has to be standard.
question
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.
answer
Information systems are only used by large organizations.
question
Organizational transactions are typically _____ volume, _____, and therefore _____ to computerize.
answer
high, repetitive,easy
question
Business transactions that are processed as they occur is an example of
answer
OLTP
question
The most fundamental information systems in an organization are:
answer
Transaction processing systems
question
When interest is credited to your savings account at your bank, it is called a:
answer
Transaction
question
Crediting interest to your savings account at your bank once a month, it is called a:
answer
process
question
When interest is credited to your savings account at your bank, it is called a:
answer
transaction
question
Data that have been processed by the organization's _____ are inputs into the organization's database.
answer
Transaction processing systems
question
Which of the following is not a characteristic of a transaction processing system?
answer
small amounts of data are processed
question
Which of the following is not an example of a transaction?
answer
printing a report
question
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.
answer
TPS need large computers to process the transactions.
question
Which of the following is not a function of functional area information systems?
answer
providing data from business events to the corporate database
question
Which of the following is not a process within an information system for Accounting and finance
answer
inventory management
question
Which of the following is not a process within an information system for Human Resource Management?
answer
firing decisions
question
Which of the following is false?
answer
The POM function within an organization monitors sales
question
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.
answer
ERP systems look the same to users as functional information systems.
question
Enterprise resource planning systems take a(n) _____ view of the overall organization.
answer
business process
question
_____ 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.
answer
Enterprise resource planning systems
question
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.
answer
Functional area information systems easily communicate with each other.
question
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
answer
typically fitting an organization's existing business processes
question
Enterprise resource planning systems are very _____ software products, meaning that companies typically have to change their _____ to accommodate how the software functions.
answer
structured, business processes
question
_____ are interorganizational ERP systems that provide Web-enabled links between an organization's key business systems and its customers, suppliers, business partners, and others.
answer
ERP II systems
question
_____ are the most successful solutions or problem-solving methods for achieving a business objective.
answer
Best practices
question
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
answer
They consist of modules
question
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.
answer
Operations management
question
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?
answer
Ad hoc
question
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?
answer
Exception
question
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
answer
Driving to the client's house
question
To effectively manage by exception (i.e., use exception reports), the company must first create:
answer
performance standards
question
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?
answer
Exception
question
_____ reports include only information that falls outside certain threshold standards.
answer
Exception
question
The ______________ process originates in the warehouse and end in the accounting department.
answer
procurement
question
The ____________ process originates in the sales department and ends in the accounting department.
answer
fulfillment
question
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.
answer
The warehouse forwards a purchase requisition in order to buy goods from a vendor.
question
reports contain special information not found in routine reports.
answer
Ad hoc
question
reports are produced at scheduled intervals.
answer
routine
question
reports summarize the performance of critical activities.
answer
key indicator
question
Which of the following was not included in early ERP systems?
answer
sales and marketing
question
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.
answer
These ERP systems have no optional modules.
question
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.
answer
An organization doesn't have to use the business processes coded into the ERP.
question
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
answer
Lack of documentation
question
The functional area information systems are the most fundamental information systems in the organization.
answer
F
question
When you make a purchase online, that transaction is an example of batch processing.
answer
F
question
In general, organizations try to automate data entry as much as possible.
answer
T
question
The data processed by transaction processing systems provide the inputs for other organizational information systems.
answer
T
question
Functional information systems support the entire enterprise or major portions of it.
answer
F
question
The information systems for Accounting and Finance could contain control and auditing process.
answer
T
question
The POM function within an organization monitors the customer sales activity.
answer
F
question
An example of a transaction in a HRIS application is adding a new employee.
answer
T
question
Information systems can be function-specific
answer
T
question
Historically, the functional area information systems were developed independently of one another.
answer
T
question
Information silos were particularly efficient when business processes crossed functional boundaries in an organization.
answer
F
question
Business processes may be located within one functional area or may span multiple functional areas.
answer
T
question
Best practices are the most successful solutions or problem-solving methods for achieving a business objective.
answer
T
question
Enterprise resource management is an enterprise-wide effort to acquire and retain customers.
answer
F
question
Financial management, operations management, and human resource management are extended ERP modules.
answer
F
question
When ERP systems are not appropriate in an organization, then that organization can use an enterprise application integration system.
answer
T
question
Organizations that use ERP systems are more agile and adaptive.
answer
T
question
ERP systems cannot manage cross departmental processes.
answer
F
question
Exception reports show a greater level of detail than is included in routine reports.
answer
F
question
Key-indicator reports shows data at a greater level of detail.
answer
F
question
Drill down reports are produced at scheduled intervals.
answer
F
question
An organization has to own all of the information systems it used.
answer
F
question
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.
answer
T
question
European railways improved its efficiencies by using SAP, which is a customer relationship management system.
answer
F
question
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.
answer
T
question
Greg is mowing lawns in the neighborhood for the summer. He does not need an information system.
answer
F
question
ConocoPhillips uses ________ to monitor _________ data.
answer
dashboards; real-time
question
ConocoPhillips addressed employee resistance to using PLOT by ____________.
answer
centralizing the monitoring process
question
Which of the following is NOT a benefit of PLOT for ConocoPhillips?
answer
data variabililty
question
____________ is NOT categorized as BI.
answer
hardware
question
__________ is a subset of BI according to Thomas Davenport.
answer
business analytics
question
BI answers the question _________________
answer
where is the problem
question
Business analytics answers the question __________
answer
what is the best or worst that can happen?
question
The most popular BI tool is
answer
excel
question
Blackstone Group initially focused on the most depressed housing markets in
answer
atlanta, GA
question
RentRange uses _____________ to provide information about purchasing foreclosed and low-priced single-family homes and then renting them out.
answer
predictive analytics
question
RentRange is currently in the _______ industry but could move to the ________ industry.
answer
housing; credit card
question
Which of the following is an informational role?
answer
disseminator
question
Which of the following is a decisional role?
answer
resource allocator
question
In which stage of the IDC do you examine the problem?
answer
intelligence
question
Validation of the model occurs in the _______ phase of the IDC.
answer
design
question
_________problems are fuzzy and complex.
answer
unstructured
question
The yearly employee evaluation is a(n) __________________ problem.
answer
semistructured
question
___________________ control is executing specific tasks efficiently and effectively.
answer
operational
question
R&D tasks are ________________.
answer
strategic and unstructured
question
Which of the following is NOT a BI tool? A. Dashboards B. Data dictionary C. Data mining D. Data visualization
answer
B. Data dictionary
question
Which of the following is NOT a major BI vendor? A. SAS B. Microsoft C. Cognos D. Business Objects
answer
B. Microsoft
question
In the past, BI was used to support __________.
answer
top managers
question
Small companies typically use _______ for their B
answer
excel
question
Data marts are used to __________________.
answer
develop few, related BI applications
question
CPM is closely aligned with __________
answer
support for organizational transformation
question
Which of the following is NOT a KPI?
answer
product quality
question
Airline predictions are off by an average of _______
answer
7 minutes
question
Which of the following is NOT a reason for flight delays? A. Weather B. Wind C. Pilots D. Passengers
answer
C. Pilots
question
Alaska Airlines used ______________ to solve their flight delay problems.
answer
crowdsourcing
question
GE's goal for Flight Quest is to ____________.
answer
create smart assistants for pilots
question
Cardlytics services the ________ industry.
answer
banking
question
A major issue facing Cardlytics is ________.
answer
privacy
question
The main purpose of Cardlytics is to ______________.
answer
track and understand consumer buying behavior
question
Multidimensional analysis is also called ________.
answer
OLAP
question
Data mining helps explain _____________ happened.
answer
why it
question
______________ analysis is the study of the impact that changes in one or more parts of a decision-making model have on other parts.
answer
sensitivity
question
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.
answer
what-if
question
__________ analysis focuses on the outputs rather than the inputs.
answer
goal-seeking
question
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.
answer
goal-seeking
question
_____________________ 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.
answer
drill down
question
____________ is the short-, medium-, and long-term trends of metrics, which is projected using forecasting methods.
answer
trend analysis
question
Status access is the latest data available on _____________, often in real time
answer
KPI
question
The color ___________ in the Management Cockpit represents performance of internal processes and employees.
answer
Blue
question
Reality mining is a type of _____________.
answer
data visualization technology
question
Environmental Systems Research Institute is an international supplier of _________.
answer
GIS
question
In the lost hiker example, which of the following was NOT used to improve the ArcGIS suggestions?
answer
Google
question
_____ percent of GIS users employ Environmental Systems Research Institute products.
answer
70
question
Sentiment analysis extracts _________ information in source materials, which is particularly useful in __________.
answer
subject; social media
question
Sentiment analysis algorithms use simple terms to express sentiment about a product or service, so ________ makes it __________ to classify online content as positive, negative, or neutral.
answer
sarcasm; difficult
question
The entertainment industry primarily uses sentiment analysis to improve their ______.
answer
marketing campaigns
question
The IDC is a linear process.
answer
F
question
BI encompasses applications, processes, and technology.
answer
T
question
BI can support organizational transformation.
answer
T
question
Sensitivity analysis studies the impact that changing outputs has on given inputs.
answer
F
question
DSS support semistructured and unstructured problems.
answer
T
question
Reality mining is data mining that uses GIS and GPS together.
answer
F
question
OR(FALSE,TRUE,TRUE) results in the final value of ____.
answer
TRUE
question
=MAX(A1:A10)=SMALL(A1:A10,COUNT(A1:A10))
answer
TRUE
question
The syntax for the YEARFRAC function is as follows: =YEARFRAC(start_date,end_date,basis).
answer
TRUE
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New