MGCR 331 – Sample exam questions for midterm
These questions come from different previous exams.
1. Which of the following is not included in Friedman’s 10 major forces of globalization?
A) outsourcing
B) supply chain management
C) unification of Germany
D) wireless technologies
E) growth of China’s economy
2. Friedman’s ten forces, or “flatteners,” contributed to the emergence of era 3.0 and the flat
world. What is he referring to by the word “flat”?
A) the world is not round.
B) the deserts of the world
C) economic growth is becoming flat
D) the global competitive playing field is being leveled
E) none of the above
3. Which of the following has been made possible only through IT?
A) register for classes from home
B) research class papers and presentations
C) perform banking transactions
D) pay your bills
E) make travel reservations (hotel, airline, rental car).
4. The major capabilities of information systems in organizations would not include:
A) performing high-speed, high-volume, numerical computations
B) providing effective communication and collaboration within organizations
C) storing huge amounts of data efficiently
D) permitting everyone with easy access to their hardware and data
E) increasing the effectiveness and efficiency of employees’ work
5. Today, competitors may only need to set up a website to enter a particular market. Because of
this facility, we say that the web:
A) can make the companies smarter
B) can make the companies look small
C) can eliminate the entry barriers
D) can be used to give wrong impressions
E) all of the above
6. Porter’s competitive forces model identifies five major forces that could threaten a company’s
position in a given industry. These forces do not include:
A) the threat of new technology
B) the bargaining power of suppliers
C) the bargaining power of customers
D) the threat of substitute products or services
E) the rivalries among existing firms in the industry
7. In this type of e-commerce, the sellers are organizations and the buyers are individuals.
A) government-to-citizen
B) consumer-to-consumer
C) business-to-business
D) business-to-consumer
E) none of the above
8. What is the main difference between vertical and horizontal exchanges?
A) Horizontal exchanges are for a given industry; vertical exchanges are for across many
industries.
B) Vertical exchanges are for a given industry; horizontal exchanges are for across many
industries.
C) Vertical exchanges are for returning products; horizontal exchanges are for refunding money.
D) A vertical exchange is in a multi-story building; a horizontal exchange is in a single-story
building.
E) There is no difference; both refer to exchanging goods.
9. True smart cards contain a ______that can store a considerable amount of information.
A) picture of the bank
B) magnetic strip
C) card number
D) chip
E) all of the above
10. _______________attempts to predict the impact of a change in the assumptions (input data)
on the proposed solution.
A) Input analysis
B) Goal-Seek analysis
C) Information analysis
D) Opportunity analysis
E) What-if analysis
11. The “explanation subsystem” or “justifier” of an Expert System is used to:
A) explain its recommendations
B) justify the expenditures
C) determine the answers to questions
D) justify the documents’ alignments
E) none of the above
12. The flow of knowledge from an expert to an expert system and then to the user involves all
of the following activities, except:
A) acquire the knowledge from experts
B) make inferences from the stored knowledge
C) transfer the knowledge to the user
D) organize the knowledge as rules
E) determine the value of the knowledge
13. What does Porter’s Five Forces Model determine?
A. The relative attractiveness/profitability of an industry
B. The competitive advantage of a competitor
C. The distribution chain of a competitor
D. The relative attractiveness of another business
E. None of the above
14. Which statement describes switching costs?
A. There are many alternatives to using the product or service
B. There are few alternatives to using the product or service
C. High costs that make customers reluctant to switch to another product or service
D. Low costs that make customers want to switch to another product or service
E. None of the above
5. In Excel cell reference, $ indicates that the letter or number next to $ is not changed while
dragging the bottom right edge of the cell in any direction.
A. True
B. False
16. Consider the worksheet below, the formula in curser cell is =B$1 . If the edge of curser cell is
dragged to next cell in the direction of arrow, the next cell will have _____.
A.
B.
C.
D.
E.
Formula
Formula
Formula
Formula
Formula
=B$1 and value 2
=B$2 and value 5
=$C$1 and value 3
=C$2 and value 6
=C$1 and value 3
17. Consider the worksheet below, the formula in curser cell is “=B$1” . If the edge of curser cell
is dragged to next cell in the direction of arrow, the next cell will have _____.
A.
B.
C.
D.
E.
Formula
Formula
Formula
Formula
Formula
=B$1 and value 3
=B$2 and value 5
=B$1 and value 2
=$B$1 and value 2
=C$1 and value 3
18. In the Excel sheet on right, the formula
=IF(A2=”apple”, ”A”, ”T”)
will result to ______.
A.
B.
C.
D.
E.
P
B
K
T
A
19. In the Excel sheet on right, the formula
=COUNTIF(A1:A5,”<>4”) will result to ______.
A.
B.
C.
D.
E.
5
3
2
0
None of the above
20. In the Excel sheet on right, the formula
=SUMIF(A1:A5,”<>4”,B3:B5) will result to ______.
A.
B.
C.
D.
E.
20
62
37
39
None of the above
21. Consider the worksheet, the formula
=COUNTIF(A1:A5,”<>4”)+SUMIF(B2:B4,”<=6“ )
will be _____.
A.
B.
C.
D.
E.
33
14
31
36
None of the above
22. Consider the worksheet below, the formula in curser cell is “=B5&A1”. When you hit enter
key, the value in the cell will be _____.
A.
B.
C.
D.
E.
531
315
215
36
Not allowed to enter such function
1. Porter’s competitive forces model helps organizations identify _____, where his value
chain model helps organizations identify specific _____.
A) Competitive opportunities, activities
B) General strategies, activities
C) Activities, competitive opportunities
D) Activities, general strategies
E) Primary activities, support activities
2. _____ activities create value for which customers are willing to pay, where _____
activities do not add value directly to the firm’s products or services.
A) Support, primary
B) Human resource management, inbound logistics
C) Procurement, operations
D) Primary, support
E) Accounting, outbound logistics
3. Wal-Mart’s automatic replenishment system, which enables the company to reduce
inventory storage requirements, is an example of which strategy for competitive
advantage?
A) cost leadership
B) differentiation
C) innovation
D) operational effectiveness
E) customer-orientation
4. Supply chains are composed of only physical product flows.
A) True
B) False
5. Dashboards provide rapid access to timely information and direct access to structured
information in the form of reports.
A) True
B) False
6. Decisions today are becoming _____ complex, due to _____ uncertainty in the decision
environment.
A) less, decreased
B) more, decreased
C) less, increased
D) more, increased
E) about the same, decreased
7. Which of the following is not a characteristic of a structured decision?
A) Routine
B) Repetitive
C) No human intuition involved
D) Fuzzy and complex
E) Standard solutions exist
8. When there is no well-understood or agreed-on procedure for making a decision, it is
said to be
A) undocumented
B) structured
C) unstructured
D) semistructured
E) documented
9. Which type of decision requires a combination of standard solution procedures and
individual judgment?
A) Structured
B) Semistructured
C) Unstructured
D) Informational
E) Wisdom
10. Computer support is least for which of the following problems?
A) Semistructured and strategic planning
B) Unstructured and strategic planning
C) Semistructured and management control
D) Unstructured and operational control
E) Structured and strategic planning
11. The study of the impact that changes in one (or more) parts of a model would have on
other parts of the model is ________________
A) drill-down
B) sensitivity analysis
C) forecasting
D) goal-seeking
E) optimization
12. Which of the following information systems are supported by graphics and provide
exception reporting and drill down?
A) Decision support systems
B) Digital dashboards
C) Functional area information systems
D) Group decision support systems
E) Expert systems
13. Expert systems
A) solve problems too difficult for human experts
B) are based on procedural computer programming languages
C) work in limited domains
D) can apply to any business problem
E) share characteristics with mainframe computing
14. A category of AI that attempts to emulate the way the human brain works is
____________
A) artificial intelligence
B) expert system
C) neural network
D) intelligent agent
E) genetic algorithm
15. Which of the following is a benefit of natural language understanding?
A) easy to use
B) more people can speak than can type
C) faster than typing
D) manual freedom
E) all of the above
