MSIS Glancy Final

If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?

Click the arrow on the Paste button on the Standard toolbar, then click Values.

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

A service company that uses an enterprise information system will likely use a(n) ____________.

CRM

Through the use of apps (application software) your smart phone can access devices that are connected to a network. What technology does the smart phone use to connect to the network?

Cellular radio

When you sign onto a LAN through WiFi, you have a ______ IP address and the LAN router has a _______ IP address.

Dynamic, Static

A _________ shows the relationships between the tables in a relational database.

Entity Relationship Diagram

You are saving $200 per month for a down payment on a house. Your bank pays 2% APR interest. What function would you use to calculate the total amount in your savings account in two years?

FV

A URL has two parts. The first part is the protocol identifier, and the second is the domain name. A URL does not need to have an IP address associated with it.

False

A business gives the employees access to the data they need to do their jobs. The employees use the DBMS to access the data.

False

A relational database can have a many-to-many relationship between entities.

False

All computer devices communicate over a network using computer languages such as Python or C#.

False

An Information Assurance Analyst identifies current risks associated with software and hardware systems. They work with other security experts and employees to hack into the company to gain access to the company's digital assets for personal gain.

False

The availability heuristic is based on how easy an instance can be brought to mind. It is based on redundant input variables that are highly correlated.

False

When the company is using 85 workers and dollar-sign Baseline 750 , Baseline 000 worth of equipment, each additional worker would add about

False

You have a LAN at home so all of your IoT devices can be reached through the Internet. All of the devices are connected by WiFi and have a static IP addresses.

False

Which of the following transmission protocols is not a wireless network protocol?

Fiberoptics

When the cursor is in cell B4 in the pivot table below. What button do you use to show only years and quarters in the pivot table.

Field List

Which button on the ribbon do you use to get year totals in the pivot table below?

Field Settings

To sort data in an Excel worksheet you can use the ______.

Sort A to Z and Sort Z to A buttons

Which of the following is the common element of enterprise systems?

They have one database

A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024 megabytes. What is a petabyte?

1024 Terabytes

According to the video "A Packet's Tale" what is the total time for the request and the webpage to be displayed?

1 second

A protocol is which of the following?

A standard

What is a Pivot Table?

A tool used to summarize data.

Which of the following is not open source application software?

Adobe Photoshop

How do businesses make money on the Internet?

All of the Above

Metadata defines the _________.

All of the above

When you use the Internet you run the risk of __________.

All of the above

Which of the following is not a job that companies hire MIS graduates to do?

All of the above are jobs that companies hire MIS graduates to do.

Which of the following is a way that people provide content on the internet?

All of these provide content.

A __________ is a tool used to summarize large amounts of data.

An Excel Pivot Table

The third tenet of the CIA is ____________.

Availability

Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per second. This is the _______.

Bandwidth

When you needed to know the grade distribution in the Student Grade Excel application, you used which function?

CountIF

What is the first step for creating a Pivot Table?

Create or select data that needs to be analyzed.

When working on WiFi, what does the router or access point use to identify you?

Dynamic IP Address

Because a properly designed relational database only has single data entry, it is common to put calculated variables in the database.

False

Casandra, R, Firefox, and Linux are examples of open source software. While the source code is available to view, anyone that wants to modify it must pay a fee to the organization that controls the software, such as Apache.org.

False

Choices involving gains are often risk averse and choices involving losses are often risk taking. This explains the high sales of lottery tickets.

False

Data is information put into context.

False

Distributed File Systems or NoSQL databases are available for purchase and are closed source systems.

False

Formatting data changes the appearance of data, and it changes the data itself.

False

Google and Facebook store a very large amount of information. They use a relational database to store and manage this information.

False

Heuristics can lead to unpredictable biases and consistencies.

False

If a formula contains several nested functions, Excel starts with the innermost function and then moves outward.

False

In Excel, when you define a named range it can only be used in formulas on the same spreadsheet as the named range.

False

Information is defined as facts, knowledge, and skills acquired by a person through experience or education.

False

Information on the Internet has a limited life and is deleted after a period of time.

False

Knowledge is defined as "facts, information, and skills acquired by a person through experience or education; the theoretical or practical understanding of a subject." The key element of knowledge is that it can be written and shared with others.

False

Malware is software to protect your computer from anti-malware attacks by viruses, spying tools, ransomware, and Trojan horses.

False

People make many decisions every day. Most of these decisions are made using analytical tools like Excel.

False

The AutoSum function can be accessed through a button on both the Home tab and the Formulas tab. The AutoSum function in Excel only works on a data in a column.

False

The DBMS is used to create application business rules.

False

The IP Address defines your device whereas the Mac address defines your location on the network.

False

Every table has a primary key. When the primary key of one table is in another table it is called a(n) _______ key.

Foreign

You are working on an Excel spreadsheet and have discovered that your method of solving a problem has created a circular reference. Excel has a solution to this problem. You need to use ___________.

Goal Seek

In Excel, to select several cells or ranges that are not touching each other, you would _____ while selecting.

Hold down the CTRL key

To select several cells or ranges that are not touching each other, you would _____ while selecting

Hold down the CTRL key

You want to calculate how much interest you are going to pay on a 60-month car loan. Which Excel function would you use in the amortization schedule?

IPMT

Someone is quiet and appears aloof. You predict that they would not have a successful career as a comedian. What bias would potentially invalidate your prediction?

Illusion of Validity

You always take exams wearing the same shirt, because when you wear that shirt you make a good grade on the exam. This is an example of what bias?

Illusion-correlation bias

Which of the following describes how late work is handled in MSIS 2103?

None of the answers are correct.

You are being asked to join an organization. You are told that the members are very friendly and everyone has a great time at events the organization holds. You conclude that joining this organization will help you raise your GPA. Of what bias are you possibly guilty?

Insensitive to predictability

If an interviewer ignores your past history of success, he is guilty of which bias?

Insensitive to prior outcomes

Twenty percent of the students at your university are in a sorority or fraternity. You see that many of the students in your class of 200 students are wearing shirts with Greek letters on them. You conclude that half of the students are in a fraternity or sorority. Of what bias are you possibly guilty?

Insensitive to prior probabilities

Where is a Pivot Table inserted?

It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is.

How can you recognize phishing email?

It may have a link for you to click to access a message.

When you access your University's Learning Management System (LMS), the LMS is where?

On a server

You have a lot of data in a spreadsheet, thousands of rows and over 100 columns. You have been asked to summarize the data for a presentation. What do you do?

Pivot Chart

When you post a review on a business you are _______.

Providing content

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?

Ribbon

When you take out renter's insurance, you are practicing ________.

Risk Transference

A retailer such as Walmart that uses an enterprise information system will likely use a(n) ____________.

SCM

In order to perform a skill, the knowledge must be internalized. This is called ________ knowledge.

Tacit

If you are negotiating the price of a used car with the owner, you always want to make an offer before asking the owner's selling price. Why?

The first price mentioned creates the starting point in the negotiation.

Moore's law states that _______________.

The number of transistors on a chip doubles every 18 to 24 months.

What is a common element between an ERP, a CRM, and an SCM?

They all have a single database supporting applications

In a VLOOKUP formula, what does the argument "column_index_number" mean?

This is the number of the column within the selected table_array where the lookup result is located.

An ERP can have a CRM module.

True

Google Maps is a GIS system that utilizes a GPS system to provide information about the physical world.

True

In Excel, you can trace all of the cells referenced in a formula through the trace precedents function.

True

Learning objective one is to develop skill in using Excel by applying it to solve problems.

True

Risk is the probability of a bad thing happening multiplied by the impact of its occurrence.

True

TCP/IP defines how data is sent over the Internet.

True

Tacit knowledge requires that an individual the internalize a skill.

True

The representative heuristic is one of the reasons that first impressions on meeting someone are so important.

True

There are three main types of enterprise systems. They are supply chain management (SCM), enterprise resource planning (ERP), and customer relationship management (CRM). All of these information systems support the business by automating routine tasks, providing routine reports, and providing all employees the data and information needed to do their jobs.

True

When you use a credit card, you are using several different companies' information systems.

True

You just posted a review on the web site Tripadvisor.com. You provided free content that Tripadvisor.com can use to make money through click-based advertising. Click-based advertising is one method that online businesses use to make money.

True

Which of the following is a tacit skill taught in MSIS 2103

Using Excel to solve problems

If you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:

Wrap Text

Integrity means keeping information secure from unauthorized changes. You can do this by using a hard to guess password. Which of the following is the best password?

XVG$4u5i6&n

Which of the following is NOT possible with VLOOKUP?

You can lookup values located in a column to the left of the column that contains the lookup value.

Your Excel workbook has four sheets. You name a range on sheet 1. Which of the following is true.

You can use that named range on all worksheets in the workbook

You draw a marble from a bag of 100 marbles. The bag may contain both red and white marbles. You repeat this draw 7 times putting the marble back after each draw. Each marble you draw is red. What is your estimate of the distribution of marbles in the bag?

You do not have enough information to estimate the distribution

Your ISP says that you have 50 Mbs Internet speed. When you run a speed check you find that _________.

Your download speed is lower than 50 Mbs.

Which part of a URL identifies the protocol

https