ISYS 363
In the Excel image, cell a3 contains a formula that subtracts A1 from A2. If the user hits the enter key what will appear in cell a3
#value!
Put the steps of the information processing cycle in the correct order, with the first step at the top.
1) input 2) process 3) output 4) store
put the steps in order for opening google sheets
1) login to your google account 2) click the apps launcher 3) select google sheets
Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order, placing the first step at the top.
1) open the file menu 2) name the file 3) determine where the file shall be stored 4) select Save (or save as)
Place the following steps in order to create a VLookup.
1) select and name the range of cell for the VLookup to search 2) click the insert function button 3) search for and select the Vlookup function 4) enter the necessary arguments 5) click OK
A SWOT analysis examimes which 3 of the following?
A firm's internal strengths. A firm's external threats. A firm's internal weaknesses.
How do managers use personal computers for their business needs? More than one answer may be correct.
Creating and using databases and spreadsheets Communicating via e-mail
What was the driving principle behind McGregor's Theory Y?
Employees are capable of working without constant supervision.
Frederick Taylor's four principles of scientific management can be described as ______.
Task measurement, employee development, worker-manager collaboration, and management training
In the 1980s, Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. Three advantages they described included were:
The first firm to enter the market has an opportunity to secure important raw materials and to develop necessary logistics lines ahead of any other competitors. The firm's employees will learn from experience how to use technologies and processes to develop the product. Consumers often become accustomed to products that they adopt and a firm that attempts to compete must create a product that meets the specifications established by the initial entrants.
According to the Hawthorne effect, when do employees become more productive?
When they know their work is being monitored.
A SWOT analysis examimes which 3 of the following?
a firm's internal strengths a firm's internal weaknesses a firm's external threats
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) reference.
absolute
Attributes that allow firms to provide goods and services with higher perceived values than their competitors are referred to as competitive
advantage
According to Mary Parker Follett, a successful business depends on ______.
competence and expertise
Management Information Systems allow managers to build upon an organization's existing strengths to create
competitive advantage
Management Information Systems allow managers to build upon an organization's existing strengths to create
competitive advantages
The ability for a firm to enjoy significant profit margins decreases as the number of offering essentially the same products or services increases.
competitors
Because employee education and training are so critical in ensuring that all employees can participate in Lean manufacturing processes, ___ systems play a key role in Lean implementation.
human recourses management
Because employee education and training are so critical in ensuring that all employees can participate in Lean manufacturing processes, ___ systems play a key role in Lean implementation.
human resources management
In a PESTEL analysis managers examine ___ factors.
legal
Useful to showing parts of a whole, the ___ is created by highlighting the desired data and choosing from the Insert menu.
pie chart
You created a spreadsheet in Calc and wish to send the data to a friend who only uses Excel. You can do this by using the ___ feature.
save as
Because of its focus on reducing variation to eliminate product defects, which process methodology relies most heavily upon data analysis?
six sigma
By improving communications throughout the organization, as well as gaining better perceptions of consumers' opinions using CRM software, managers are able to monitor which PESTEL factor?
socio-cultural
Managers often use the PESTEL analysis to examine the political, economic, environmental, legal and which 2 other issues facing an organization?
socio-cultural technological
A function that looks for a value in the leftmost column of a table, and then returns a value located in the same row as the first value, is called a
vlookup
When a large number of buyers seek to purchase a firm's products even when prices increase, Porter's force of customers can be said to have ___. This tends to strengthen the firm's profitability.
weakened
You need to add elements to your chart in Excel. Place the following steps in order with the first step at the top.
1) select the chat 2) if not already open, select the design tab 3) open the add chart element menu 4) add the desired elements
Which three of the following scenarios depict an employment situation that Elton Mayo believed would result in an employee becoming more engaged and productive?
A sales tracking report at a furniture store shows how each salesperson's daily sales help the store reach its quarterly quota. Managers at a software company have weekly meetings with their customer service staff. As a regular part of the agenda, managers report the number of customers who continued to use their product after the customer service department helped with a software malfunction or error. At a software company, project managers working on bringing new products to the market receive monthly updates on how past products are selling and helping the company achieve its goals
Modern supply chain management systems access National Weather Service databases to track weather events that could impact logistics. This is an example of using MIS to monitor which element of a PESTEL analysis?
Environmental
What are three advantages of using personal computers in business?
Flexibility of use Efficiency Improved team communications
Which 2 of the following statements accurately reflect Frederick Taylor's foundational beliefs?
Helping workers become more productive leads to jobs for more workers. When the company is successful, its employees are successful.
Select the scenarios below that show how Frederick Taylor's scientific management has influenced today's business decisions. More than one answer may be correct.
In some urban school districts, teachers work in teams of two so less experienced teachers learn from seasoned co-teachers. In addition to their administrative responsibilities, the principal and assistant principal assign the teams and hold staff trainings throughout the year. These schools find that this system benefits both teachers and students. A political campaign director needs to hire paid workers and volunteers on all levels, from supervisors to canvassers. Instead of seeking mostly campaign veterans, the director recruits from groups who have shown great interest in "the cause." They'll be trained and supplied with what they need to do good work. Supervisors in a large warehouse notice that the robots are working faster than the humans. Employees scanning and sending items off to shipping are becoming frustrated and even physically hurt moving the items that the robots pick off the shelves. Management decides to recalibrate the robots' speed to coordinate with the humans' speed.
Which three of the following scenarios depict an employment situation that Elton Mayo believed would result in an employee becoming more engaged and productive?
Managers at a software company have weekly meetings with their customer service staff. As a regular part of the agenda, managers report the number of customers who continued to use their product after the customer service department helped with a software malfunction or error. At a software company, project managers working on bringing new products to the market receive monthly updates on how past products are selling and helping the company achieve its goals. A sales tracking report at a furniture store shows how each salesperson's daily sales help the store reach its quarterly quota.
Which of the following statements best describes Follett's theory of management?
Receptivity to the flow of ideas from all levels of the organization leads to success.
In his book, The Machine That Changed the World, Dr. James Womack of M.I.T. specified the five tenets of Lean manufacturing. These include, specifying the value of each product with precision, identifying how each product acquires its value (the value stream), and which 3 other principles?
Relentlessly pursuing perfection. Allowing customers to pull increased value from the producer. Ensuring that the value flows to the product without interruption.
Wyatt cannot understand what is going on in Cell A1 (above). You explain that the ### symbols mean that ___.
This is not an error. Cell A1 needs to be expanded in order to display the entire value.
The second of Porter's 5 forces refers to the ease with which a new competitor can enter the market. Strong to entry decrease the strength of this force
barriers
According to Professors W. Chan Kim and Renee Mauborgne, Cirque d'Soleil used a ___ ocean strategy.
blue
Porter's generic business strategies fall into two separate categories, either price leadership, or product differentiation. He showed that these two strategies could be used in which two market types?
broad markets niche markets
With the adaptive system you will learn most efficiently by ______.
completing multiple 15-30 minute study sessions
Using technology to transform a market or to create an entirely new market is called creating a Blank innovation
disruptive
Sears, which revolutionized catalog (mail order) sales, failed to make the online leap and while Amazon capitalized on this technology, Amazon successfully used ___
disruptive innovation
Data mining information from the Bureau of Labor Statistics can provide insight into regional employment figures. This illustrates how data analysis can be used to examine which factor of the PESTEL analysis?
economic
How quickly consumer demand changes with a change in price is referred to as Blank of demand.
elasticity
Chinese and Nigerian manufactures have been notably successful in adopting a strategy of, rather than creating an innovative product, offering a competing product rapidly enough so that early majority adopters have a choice when purchasing the product for the first time. This is referred to as a ___.
fast-follower strategy
If you do not see the Numbers icon on your iMac toolbar, you could go to the Launchpad to open the app. Alternatively, you could look for it through the
finder
That employees will learn from experience how to use technologies to develop a product, gaining a "head start" over any competition that attempts to enter the market is considered a ___.
first-mover advantage
In 1979, Professor Michael E. Porter published "How Competitive Forces Shape Strategy" in the Harvard Business Review. In this paper, he described factors that impact businesses. The became known as Porter's Blank forces
five
Information management systems that help to ensure that a minimal number of product touches occur from product creation to customer purchase are known as ___ systems.
inventory management
Because of its significant challenges during supply disruptions that occur during natural disasters (such as the COVID-19 pandemic), ___ has lost much of its popularity.
just-in-time manufacturing and inventory management
Principles that focus on increasing efficiencies by improving supply lines and through creating a well-trained, highly knowledgeable workforce that assertively acts to minimize waste and maximize value in every process and product are referred to as BLANK manufacturing principles
lean
Principles that focus on increasing efficiencies by improving supply lines and through creating a well-trained, highly knowledgeable workforce that assertively acts to minimize waste and maximize value in every process and product are referred to as manufacturing principles.
lean
Requiring a modern communications system, a process that actively encourages all employees to halt the manufacturing process if safety risks are observed is the __ process.
lean
Techniques that focus on continual employee training and on developing efficient supply lines and creating relationships with suppliers to continually smooth these lines to minimize excess inventory or delays as well as to minimize waste are referred to as Blank techniques
lean
The descriptions of the two lines shown at the bottom of this chart are a chart element known as a
legend
In his text, "The Human Side of Enterprise," Douglas McGregor focused on ________.
manager attitudes toward their employees
Lean manufacturing techniques seek to eliminate waste in the production process, in contrast, Six Sigma seeks to eliminate
mistakes
According to Professor Porter, a business must differentiate itself from its competitors. One method is to encourage customers to believe that an organization provides higher quality goods or better service, then the organization can charge a premium, or gain market share, or (ideally) both. For example, by placing a swoop icon on a sweatshirt, Nike is able to charge a higher price. This methodology is called ___.
monopolistic competition Reason
Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. They coined this the first- Blank advantage
mover
Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. They coined this the first- advantage
movers
When conducting a SWOT analysis, managers examine factors that impact their organization's internal strengths and weaknesses. These factors are sometimes refered to as the 5 Ps. The 5 Ps include which 3 of the following?
purse plant personnel
When competitors seek to gain competitive advantage through price leadership or by making product improvements, Professors W. Chan Kim and Renee Mauborgne would say they are using a ___.
red ocean strategy
If you are using OpenOffice Calc and wish to send your spreadsheet to a colleague who uses Microsoft Excel, use the ___ feature.
save as
With price leadership, an organization seeks to offer a product to a large market at the lowest possible price by maximizing efficiencies and using economies of
scale
During the Measure and Analyze steps of the ___ procedure, collecting data and using data analytics are essential.
six sigma
MIS tools that analysts commonly use to determing the causes of variences include scatter diagrams, histograms and Pareto charts. For this reason, MIS are critical in the implementation of ___ techniques.
six sigma
Techniques that seek to reduce variance in output to less than 3.4 errors per 1,000,000 manufacturing steps are referred to as ___.
six sigma
Modern inventory management systems help to ensure a number of critical advantages, including which 3 of the following?
stock-obsolescence minimization timely re-ordering shelf-space optimization
If McDonald's and Burger King raise prices too high, customers may switch from burgers to tacos. This illustrates Porter's force of ___.
substitution
Apple uses Corning's glass products for all its devices, such as the Gorilla Glass 6 used in the iPhone 11 series. To ensure that it continue to have a strong relationship with this glass industry leader, Apple has invested nearly $500 million toward Corning's advanced glass research division. By building up this relationship, Apple seeks to maintain some control over which of Porter's 5 forces?
suppliers
Porter's 5 Forces include existing competitors, new competitors, and which 3 of the following?
suppliers customers substitutes
During the 1950s, the United Auto Workers union (UAW) exercised considerable control over the labor ___. This meant that automobile manufacturers had little control over labor costs.
supply
Concept resources are intended to take the place of ______.
textbook pages
A PESTEL (political, economic, socio-cultural, technological, environmental, and legal) analysis provides management with a framework to evaluate its organization's external opportunities and
threat
A SWOT analysis attempts to identify, an organization's (or an individual's) internal strengths and weaknesses and examines external opportunities and
threat
A PESTEL (political, economic, socio-cultural, technological, environmental, and legal) analysis provides management with a framework to evaluate its organization's external opportunities and
threats
A SWOT analysis attempts to identify, an organization's (or an individual's) internal strengths and weaknesses and examines external opportunities and
threats
When external opportunities match with internal strengths, managers should choose an aggressive strategy, particularly when facing weak external ___.
threats
One type of storage device is a ___ .
universal serial bus (USB) drive
