MIS Exam 1

Cloud computing can best be described as

using the Internet to store and access resources.

According to Henri Fayol, productivity and efficiency are increased when

workers specialize and become proficient in their assigned tasks.

What is the purpose of saving an Excel file as a .cvs (comma-separated format) file?

to share data with other spreadsheet users regardless of which spreadsheet program is being used

In an Excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the Enter key is pressed?

#VALUE!

You just had a great lunch at a nice restaurant and decide to leave a 15% tip on your $18 meal. What will be the total charge on your debit card?

$20.70

If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

27

The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?

27

Every time you go to the gas station you're amazed by how much prices have increased. At this time last year the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?

= ((4.25 - 3.20) / 3.20) * 100

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.

= (25 + 50 + 75) / 3

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 3, 2, 6, and 8.

= (3 + 2 + 6 + 8) / 4

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.

= (4 + 2 + 5 + 5) / 4

What was Weber's view on the use of physical force?

A police force overseen by a local government enforces laws within a community

Which is the best description of the relationship between "green computing" and management information systems (MIS)?

Advances in MIS technology will help make "green computing" easier and more widespread.

How might a professor use an LMS to keep track of attendance in a class that is held face to face?

At the beginning of each class period, students are required to use clickers to take a brief multiple-choice test to indicate they are present.

The acronym for a database administrator is ________.

DBA

The acronym for Data Governance is ________.

DG

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table.

Data

________ involves identifying errors in data sets and removing/correcting these errors to ensure the data is accurate.

Data scrubbing

What type of system is used to assist with processes that rely on a large number of inputs that frequently change?

Decision support system

Who espoused "Theory X" and "Theory Y"?

Douglas McGregor

What was the driving principle behind McGregor's Theory Y?

Employees are capable of working without constant supervision.

Which is the best description of a typical flextime policy?

Employees create their own work schedules: they can change when they start and stop their workday.

A marketing manager requests and receives a report on consumers who use a competing brand of laundry detergent. Included in this report is demographic information such as age, gender, and geographic location; frequency with which the product is purchased; estimated amount of revenue generated by this product per geographic location; and qualities that consumers rank as important to their purchasing decision. These reports represent what function of a marketing information system (MKIS)?

Gathering marketing data

To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ________ function.

IF

How are managers' jobs expected to change as management information system (MIS) technology and tools improve?

Managers will be freed from tasks performed by online services or staff using collaboration tools.

________ is software with processing capabilities outside of what the operating system of the consumer provides.

Middlewear

OLAP software allows users to perform multidimensional analysis of a wide range of business data, complex calculations, and trend analysis, as well as data modeling. What does OLEP stand for?

Online Analytical Processing

What did Peter Drucker mean by "decentralization"?

Organizations work at what they do best and have a comparative advantage and outsource the work at which they have no advantage.

Which three of the following refer to the amount of money owed on a loan when it is first borrowed (excluding any origination fees).

Principal Balance Present Value (PV)

One of the most popular query languages is ________.

SQL

What is a main proposition or argument of John Locke's labor theory of property?

Since people own their own labor, they naturally own the products of their labor.

What is a main proposition or argument of John Locke's labor theory of property? Multiple ChoiceLaboring on natural resources does not make this shared property personal property.Since people own their own labor, they naturally own the products of their labor.CorrectProtecting personal property or wealth is the responsibility or job of the owner.People can only accumulate property or wealth by laboring together as a group.

Since people own their own labor, they naturally own the products of their labor.

Which system is able to create purchase orders, manage inventory, and forecast future inventory needs?

Supply chain management system

A manager wants to accurately predict how many light-up three-wheeled scooters they'll need to meet holiday demand. Which component of supply chain management would the manager be using to determine the appropriate number to produce?

Supply chain planning

What is one major distinction between telecommuting and flextime arrangements?

Telecommuters often must work during regular business hours.

Which of the following statements most clearly describes Mary Parker Follett's contribution to management theory?

The most important elements of an organization are relationships, informal processes, and communications.

Which of the following statements most clearly describes Mary Parker Follett's contribution to management theory? Organizational processes and societal processes can be studied through a common lens.Incorrect Resolution of conflict is best carried out by employees themselves, before involving managers. The most important elements of an organization are relationships, informal processes, and communications.Correct The true sources of power within an organization are planning and training.

The most important elements of an organization are relationships, informal processes, and communications.

What function of a micro-networked POS systems is responsible for increased accuracy of employees when ringing up customer purchases?

The total button which automatically added up the amount owed for items purchased`

Max Weber believed that organizations were best supported by which of the following strategies?

The use of specialization among employees.

Max Weber believed that organizations were best supported by which of the following strategies? Specific rules on behavior that allow little room for employees to work their own way.Incorrect The use of specialization among employees.Correct Frequent recruiting for senior level positions from outside the organization. Lack of discipline to encourage creativity.

The use of specialization among employees.

Why did Max Weber believe that personal responsibility, ethical behavior, and charity were fundamental to capitalism?

These are the basic principles of Protestantism.

A company uses an HR management system with artificial intelligence to deliver badges to the employees who have received the best scores in annual online training modules and let managers know which employees have not completed it as the deadline approaches. What function is this HR management system helping the company perform?

Training

Choose a phrase from below that pinpoints when in-person meetings may be a better choice than video conferencing.

a meeting's content is sensitive

To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ________ reference.

absolute

A marketing manager wants to determine which marketing campaign for a specific product was the most successful as determined by the amount of revenue generated. She uses the company's MKIS to determine how much revenue was generated for each of the three major campaigns run that year to determine revenue generated as compared to the cost of the campaign. This is an example of using an MKIS to

assist with cost-benefit analysis.

In addition to advancements in computer hardware, what drove improvements to POS (point-of-sale) systems in the 1990s?

an increasingly diverse group of users and their needs

An enterprise resource planning (ERP) system is

an integrated MIS system for agility and a competitive edge.

Data marts assist with the ________ of what data a user needs rather than focusing on existing data.

analysis

Data mining is a means of ________ data that can help organizations find patterns and relationships within data sets.

analyzing

A common, basic condition for most flextime policies is the requirement that employees must

be able to fulfill their work responsibilities, including attending certain meetings or events in-person.

A videoconference may be a better choice than a voice conference call because it allows

better communication through nonverbal cues.

Select two common uses of spreadsheets.

budgeting finance

Who are the users of an executive support systems (ESS)?

business leaders in charge of several functions or separate enterprises

Saving a spreadsheet file in .cvs format only saves the

cell values.

When data is stored in one place, it means it is ________.

centralized

To create a relationship between two tables, you must use a ________ field that is present in both tables.

common

Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of ________ discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis.

data

When creating a field in a database, the field type specifies the type of ________ in the field.

data

A search engine continually adjusts its algorithms as more data enter its servers. This is an example of the use of

data analytics

A database management system (DBMS) is a computer program that is used to create, process, and administer a ________.

database

Using multiple lists and data sources can lead to a(n) ________ in data integrity.

decrease

When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign.

equal

The Rule of 72 states that dividing 72 by the interest rate approximates the time for the investment to double. This calculates the ________ of the investment.

future value (FV)

To retain a row or column, but remove it from view, right-click on the row or column heading and select

hide

Database Management Systems (DBMS) assign users different access rules to protect the data and users from ________, data leaks, and the misuse of data.

identity theft

John Locke's labor theory of property is applied to modern management theory because

it explains what motivates people to work: the desire to become personally wealthier.

Computing is considered "green" or environmentally responsible when

it reduces the consumption of natural resources and the associated environmental impact.

What are the two most common spreadsheet charts?

line graphs pie graphs

Relational databases use ________ called relationships between tables.

links

According to Frederick Taylor, the purpose of management is to

make the business as prosperous as possible.

In his text, "The Human Side of Enterprise," Douglas McGregor focused on

manager attitudes toward their employees.

Database administrators ________ and troubleshoot the database (if needed) to ensure it is stable and usable when needed.

monitor

Employee monitoring software

observes computer use of all employees from a central location.

Fayol's principles for structuring organizational roles and authority emphasize

order and unity, so that employees understand their role and report to only one person.

Traditional file systems use ________, files, and documents.

paper

RAM storage and ________ processing are two main in-memory computing components.

parallel

Each loan payment is referred to as a(n)

period

A long-standing company is expanding their existing workforce. What, in all likelihood, will they invest in terms of computing capabilities?

personal computers

Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's

present value (PV)

A ________ key must contain a unique value.

primary

To set a primary key field in a database table, you must click the ________ key button.

primary

Mainframes were originally developed for their

reliability of handling transactions.

One reason to create database policies is to specify the ________ used in database design (how the data is structured)

rules

Peter Drucker felt the most important responsibility of a corporation is to

serve its customers.

Peter Drucker felt the most important responsibility of a corporation is to serve its customers diversify its portfolio. make a profit hire from within.

serve its customers.

Because they make it easy to arrange, display, and calculate numerical data, ________ programs are commonly used in nearly every business setting.

spreadsheet

Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.

spreadsheets

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets.

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the ________ language for relational database management systems.

standard

Structured Query Language (SQL)-specific queries use specific SQL ________ to execute the query.

statements

Mary Parker Follett's theory of management is based on the principle that

success depends on the flow of ideas from all levels of an organization.

Data governance involves the staff, procedures, and technologies needed to ________ and protect the data and data properties of an entity.

supervise

When creating a relationship in a relational database management system (DBMS), which object is used?

table

Relational databases organize data into ________ based on structured data groupings.

tables

What is Frederick Taylor's four principles of scientific management?

task measurement, employee development, worker-manager collaboration, and management training

The development and growing popularity of flextime arrangements can largely be attributed to

the spread of high-speed Internet and technologies such as telecommuting and teleconferencing.

What does the General Data Protection Regulation (GDPR) strive to achieve?

to ensure EU companies protect the privacy and personal data of EU citizens

A legend shows which items are being identified by the different colors, lines, bars, or pie segments.

true

In Apple iWork's Numbers the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the ________ menu.

view

One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.

when