Info Systems
10. Technology experts in the area of user-interface design: a. work to make sure systems are intuitive and easy to use. b. leverage technology to make legacy systems more efficient. c. specialize in technology for competitive advantage. d. focus on effective back-up systems for critical business data. e. provide direction on technology-related security issues.
A
11. Technology experts in the area of process design: a. work to make sure systems are easy to use. b. leverage technology to make firms more efficient. c. specialize in technology for competitive advantage. d. focus on systems dealing with critical business data. e. provide direction on technology-related security issues.
A
6. Another reason fueling the boom in fast-growing technology services is ___________________, which, when done right, can virally spread awareness of a firm with nary a dime of conventional ad spending a. legacy systems a. App stores b. Big data and business analytics c. Esoko and M-Pesa d. Sproxil e. Legacy systems
A
9. Crowdsourcing tools and question-and-answer sites like _____ allow firms to reach out for expertise beyond their organizations. a. Quora b. Oculus VR c. Alibaba d. Twitter e. M-PESA
A
Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so? a.=ROUND(A5,2) b.=MROUND(A5,2) c.=ROUND(A5,2.0) d.=MROUND(A5,0.2)
A
Data mining is leveraged by some firms to determine which products customers buy together, and how an organization can use this information to cross-sell more products or services. This area of application of data mining is referred to as: a. market basket analysis. b. expert systems. c. customer churn. d. customer segmentation. e. vertical integration.
A
Enabling management to make better decisions regarding organizing and scheduling sourcing, production, and distribution is a central feature of A) SCMs. B) TPSs. C) KMSs. D) ERPs.
A
Executive support systems are information systems that support the A) long-range planning activities of senior management. B) knowledge and data workers in an organization. C) decision making and administrative activities of middle managers. D) day-to-day processes of production.
A
Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this? a.=DAY(A1) b.=DAY("A1'') c.=DATE(DAY(A1)) d.=DATE("DAY"(A1))
A
In database systems, a _____ refers to a list of data. a. file b. column c. field d. row e. record
A
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use? a. =ROUND(AVERAGE(C3:C50),0) b. =AVERAGE((C3:C50), ROUND, 0)) c. =ROUND(C3:C50) d. =AVERAGE(ROUND(C3:C50),0)
A
Jose inserts the formula =DATE(2021, 2, 15) in cell A15. When he presses ENTER, 2/15/2021 will appear in the cell. a. True b. False
A
Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5. Now she wants to add 30 workdays to the start date. She can do this using the following formula: = WORKDAY (E2, 30, F2:F5). a. True b. False
A
The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed? a. =IF(B2>=60, "Pass", "Fail") b. =OR(B2>=60, "Pass", "Fail") c. =AND(B2>=60, "Pass", "Fail") d. =NOT(OR((B2>=60, "Pass", "Fail"))
A
What is the correct formula to insert the date January 12, 1998 into a cell? a.=DATE(1998,1,12) b.=DATE(1998,12,1) c.=DATE(12-1-1998) d. =DATE(1/12/1998)
A
Which systems are typically a major source of data for other systems? A) transaction processing systems B) management information systems C) executive support systems D) decision-support systems
A
You have been hired by Inspiration Inc., to help improve their profit margin. Inspiration Inc. is a business communications consultancy that services many clients in different industries throughout the United States. The end products of the company are customized recommendations for the best use of a client's existing resources for improving internal communications, typically delivered via documentation in different media. The company has approximately 100 consultants, all of whom are in their central headquarters in Chicago. What system do you recommend improving the company's business processes and increase their profit margin? A) extranet, to enable quick collaboration over the Internet, minimize the time spent communicating with the client, and minimize the amount of paperwork needed B) CRM, to maintain easily accessible customer records to minimize the time spent looking for client data C) KMS, for minimizing redundant work on similar clients D) marketing system, for improving sales levels
A
Which of the following is the temporary Windows storage area that holds selections you copy or cut? a. Clipboard b. Backstage c. Name box d. Worksheet window
A) clipboard
Big data does not refer to a. datasets with fewer than a billion records. b. datasets with unstructured data. c. machine-generated data (i.e. from sensors). d. data created by social media (i.e. tweets, Facebook Likes).
A) datasets with fewer than a billion records.
The IF function can use which of the following comparison operators? Select all the options that apply. a.= (equal) b.> (greater than) c. * (multiplication) d. <> (not equal)
A, B, D
1) Which type of system would you use to change a production schedule if a key supplier was late in delivering goods? A) ESS B) TPS C) MIS D) DSS
B
1. Select the accurate statement(s). 1) The world's most valuable retailer, China's Alibana, also carries the world's largest product inventory. 2) Uber, the world's largest taxi service, owns no vehicles for hire. 3) Airbnb, the world's largest accommodation provider, owns several major hotel corporations 4) Facebook, does not create media content. a) All are accurate b) Statements 2 and 4 are accurate c) Statement 4 is accurate d) Statement 1 is accurate
B
4. Tech firms are among the best performing firms in the world. According to the chapter, which firm is the most valuable firm in the United States and has also posted some of the most profitable quarters of any business in any industry. a. Amazon b. Apple c. Google d. IBM
B
8. A company uses radio frequency identification (RFID) tags to keep track of its inventory. This is an example of the impact of technology in the area of _____. a. accounting b. operations c. advertising d. human resources e. finance
B
A(n) ________ system collects data from various key business processes and stores the data in a single, comprehensive data repository, usable by other parts of the business. A) transaction B) enterprise C) automatic reporting D) management information
B
Computer-driven investment models can be very effective when the market behaves as it has in the past. However, in terms of historical consistency, they are vulnerable to failure in the face of: a. brute force attacks. b. black swans. c. zero-day exploits. d. calendar rivalry metrics. e. distributed denial of service.
B
Data becomes _____ when it is presented in a context so that it can answer a question or support decision-making. a. knowledge b. information c. a database d. wisdom e. a relational language
B
In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours? a. MIN b. MEDIAN c. INT d. MAX
B
In the formula =B6*$B$2, which of the following describes $B$2? a. Relative cell reference b. Absolute cell reference c. Function d. Average
B
Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12. a. True b. False
B
Which of the following is an example of a cross-functional business process? A) identifying customers B) creating a new product C) assembling a product D) paying creditors
B
You work for a highly successful advertiser that is just about to expand nationally. Of utmost importance will be finding a way to store and disseminate their clients' continually updated branding guides, which include multiple image files and text documents, to all the firm's branches. What system will best serve these needs? A) an intranet with KMS capabilities B) an extranet with KMS capabilities C) a TPS with KMS capabilities D) a CRM
B
_____ is a class of computer software that seeks to reproduce or mimic human thought, decision- making, or brain functions. a. Biometrics b. Artificial intelligence c. Android d. Legacy software e. Intranet
B
_____ put(s) users in control so that they can create custom reports on an as-needed basis by selecting fields, ranges, summary conditions, and other parameters. a. Canned reports b. Ad hoc reporting tools c. Dashboards d. Data cubes e. Online analytical processing
B
_______ systems integrate supplier, manufacturer, distributor, and customer logistics processes. A) Collaborative distribution B) Supply-chain management C) Reverse logistics D) Enterprise planning
B
A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data? a. text mining tools b. sentiment analysis software c. Web usage mining technologies d. data mining software for identifying associations
B) Sentiment analysis software
Data mining is a tool for allowing users to a. quickly compare transaction data gathered over many years. b. find hidden relationships in data. c. obtain online answers to ad-hoc questions in a rapid amount of time. d. summarize massive amounts of data into much smaller, traditional reports.
B) find hidden relationships in data.
12. Technology experts in the area of _____ specialize in technology for competitive advantage. a. user-interface design b. process design c. strategy d. database design e. hardware
C
13. Experts working in the area of _____ work to make sure systems are easy to use, while people working in the area of _____ work to leverage technology to make firms more efficient. a. user-interface design; process design b. process design; user-interface design c. strategy; process design d. process design; strategy e. strategy; user-interface design
C
A data cube refers to a: a. secure, cloud-based off-site location used for data storage, analysis, and reporting. b. heads-up display of critical indicators that allow managers to get a graphical glance at key performance metrics. c. special database used to store data in OLAP reporting. d. firm that collects data with the intention of reselling it to others. e. combination of fields used to uniquely identify a record, and to relate separate tables in a database.
C
In database systems, a table is also known as a _____. a. field b. record c. file d. row e. key
C
Knowledge is defined as: a. raw facts and figures. b. the data presented in a context so that it can answer a question or support decision-making. c. the insight derived from experience and expertise. d. a listing of primary data. e. the process of breaking a complex topic into smaller parts.
C
Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use? a. IFERROR b. VLOOKUP c. IF d. RAND
C
To have Excel enter the lowest price from a range of prices, which of the following would you use? a. MAX function b. COUNT function c. MIN function d. COUNTA function
C
Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016? a.=MONTH(F5) b.=MONTH("F5") c.=MONTH(DATE(2016,7,0)) d.=MONTH(DAY(2016,7,0)
C
Which of the following conditions is essential for data mining to work? a. The data must be collected from proprietary sources and not from data aggregators. b. The organization must leverage standard relational databases as opposed to inferior hierarchical and analytical databases. c. The events in the data should reflect current and future trends. d. The data mining software must necessarily incorporate ad hoc reporting tools and dashboards. e. The data should have passed the Diehard suite of stringent tests for randomness.
C
Which type of system would you use to determine the five suppliers with the worst record in delivering goods on time? A) ESS B) TPS C) MIS D) DSS
C
Which types of systems consolidate the relevant knowledge and experience in the firm to make it available to improve business processes and management decision making? A) TPS B) extranets C) KMS D) CRM
C
_____ refers to the process of combining aspects of reporting, data exploration and ad hoc queries, and sophisticated data modeling and analysis. a. Logistics b. Queritic modeling c. Business intelligence d. Electronic trading e. Big Data
C
________ systems are especially suited to situations in which the procedure for arriving at a solution may not be fully defined in advance. A) Management information B) Transaction processing C) Decision-support D) Knowledge management
C
You have been hired by a worldwide non-profit agency to implement a system to handle their donations. The system must be able to handle and record telephone, SMS, and Internet donations, provide up-to-the-minute reports, and create highly customizable mailing lists. In addition, event fundraisers need to be able to quickly access a donor's information and history. Which of the following systems will best meet these needs? A) TPS B) TPS with DSS capabilities C) TPS with MIS capabilities D) TPS with ESS capabilities
C) TPS with MIS capabilities
You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of a. identifying associations. b. identifying clusters. c. identifying sequences. d. classification.
C) identifying sequences
To monitor the status of internal operations and the firm's relations with the external environment, managers need ________ systems. A) decision-support B) knowledge C) transaction processing D) management information
C) transaction processing
3. Tech impact is reaching even beyond the confines of Earth itself. According to an example in your chapter, how was a tool on the International Space Station recently acquired? a. It was purchased via China's Alibaba - showing global sourcing extends to the extraterrestrial. b. It was delivered to the launch site when summoned from Space using the FedEx app. c. It was an out-of-print product that an Etsy producer was able to craft and deliver for the next resupply flight. d. It was printed on-demand using 3D printing technology.
D
5. One contributor to the easy with which young entrepreneurs can have success is low-cost distribution to massive markets worldwide. This is enabled by: a. legacy systems b. big data and business analytics c. Esoko and M-Pesa d. App stores e. Sproxil
D
A(n) _____ is an AI system that examines data and hunts down and exposes patterns, in order to build models to exploit findings. a. Hadoop b. canned report c. data aggregator d. neural network e. e-discovery
D
ESS are specifically designed to serve which level of the organization? A) operational B) end-user C) middle management D) senior management
D
The four major enterprise applications are A) SCMs, CRMs, DSSs, and KMSs. B) SCMs, CRMs, ESSs, and KMSs. C) enterprise systems, SCMs, DSSs, and CRMs. D) enterprise systems, SCMs, CRMs, and KMSs.
D
Which of the following functions would you use to calculate the arithmetic mean of a price list? a. MAX b. COUNT c. SUM d. AVERAGE
D
Which type of system would you use to forecast the return on investment if you used new suppliers with better delivery track records? A) ESS B) TPS C) MIS D) DSS
D
You are planning the launch of your new company, an application service provider that provides an online timesheet and project tracking application. To best communicate with and manage your relationship with your users, you would want to implement a(n) A) extranet. B) intranet. C) KMS. D) CMS.
D
_____ is a method of querying and reporting that takes data from standard relational databases, calculates and summarizes the data, and then stores the data in a special database called a data cube. a. Ad hoc reporting b. E-discovery c. Data aggregation d. Online analytical processing e. Data adjacency
D
_____ is the term used to describe raw facts and figures. a. Information b. Knowledge c. Analytics d. Data e. Intelligence
D
Non-typical business problems with causes and effects that are rapidly changing are typically handled by which type of information system? A) MIS B) TPS C) ESS D) DSS
D) DSS
Data cleansing not only corrects errors but also a. establishes logical relationships between data. b. structures data. c. normalizes data. d. enforces consistency among different sets of data.
D) enforces consistency among different sets of data
A relocation control system that reports summaries on the total moving, house hunting, and home financing costs for employees in all company divisions would fall into the category of A) knowledge management systems. B) transaction processing systems. C) executive support systems. D) management information systems.
D) management information systems
You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of a. identifying associations. b. identifying clusters. c. identifying sequences. d. classification.
D. Classification
2. Some of the radical changes brought about by new technologies include: a. the stagnation of advertising. b. the proliferation of telecommunications into the hands of a few. c. an increase in computing costs owing to the growth of licensed software. d. a decrease in the standards of corporate ethics. e. the creation of an unprecedented set of security and espionage threats.
E
7. The _____ is a piece of U.S. legislation that raises executive and board responsibility and ties criminal penalties to certain accounting and financial violations. a. Civil Rights Act b. Fair Labor Standards Act c. Sherman Antitrust Act d. Norris-LaGuardia Act e. Sarbanes-Oxley Act
E
A _____ is a system that provides rewards and usage incentives, typically in exchange for a method that provides a more detailed tracking and recording of consumer activity. a. sugging report b. canned report c. dashboard d. legacy system e. loyalty program
E
A(n) _____ refers to a heads-up display of critical indicators that allow managers to get a graphical glance at key performance metrics. a. interstitial b. embassy c. canned report d. prediction interface e. dashboard
E
Firms that collect and resell data are known as: a. data barons. b. data mongers. c. knowledge consultancies. d. data miners. e. data aggregators.
E
If a customer pays a retailer in cash, he is likely to remain a mystery to the retailer because his name is not attached to the money. Retailers can tie the customer to cash transactions and track the customer's activity if they can convince the customer to use a _____. a. transaction processing system b. point-of-sale terminal c. data cube d. dashboard e. loyalty card
E
_____ are model-building techniques where computers examine many potential solutions to a problem, iteratively modifying various mathematical models, and comparing the mutated models to search for a best alternative function. a. Expert systems b. Ad hoc reporting tools c. Iterative mutations d. Sampled alliterations e. Genetic algorithms
E
_____ is the process of using computers to identify hidden patterns in and to build models from large data sets. a. Data harvesting b. E-discovery c. Optimization d. Report canning e. Data mining
E
