MSIS 2103 Glancy Final

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. Pivot Table Analyze Tab 1) Field Settings 2) Expand Field 3) Group Field 4) Refresh 5) Field List

3) Group Field

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

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 Satellite microwave Cable DSL Fiber Optics

Cellular radio

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: Abbreviate all text Reduce the font size to 8 pt Click Wrap text Delete one column

Click Wrap text

When working on WiFi, what does the router or access point use to identify you? Static IP address MAC address Dynamic IP Address Your physical location

Dynamic IP Address

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

Dynamic, Static

A manufacturing company that uses an enterprise information system will likely use a(n) ________________. ERP SCM CRM OMG

ERP

One method of keeping information secure when sent over the Internet or stored on a computer is_______. Frequency analysis Using a virtual private network Encryption Cartography

Encryption

A _________ shows the relationships between the tables in a relational database. Data dictionary Metadata table Entity Relationship Diagram SQL Diagram Key Diagram

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? PMT PV IRR FV PPMT

FV

A Router is a device that directs and sends data over the Internet. It has a dynamic IP address. True False

False

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. True False

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. True False

False

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

False

All webpages are written in hyper text markup language or HTML. Each browser has it's own transmission protocol to read the HTML. Safari because it was created by Apple uses a different transmission protocol than Google's Chrome. True False

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. True False

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. True False

False

Which of the following transmission protocols is not a wireless network protocol? Cellular radio Microwave Satellite Fiberoptics Bluetooth

Fiberoptics

Which button on the ribbon do you use to get year totals in the pivot table below? Pivot Table 1) Field Settings 2) Expand Field 3) Group Field 4) Refresh 5) Field List

Field Settings

To sort data in an Excel worksheet you can use the ______. Sort A to Z and Sort Z to A buttons Quicksort Options Sort command on the Formulas tab Any of the above

Sort A to Z and Sort Z to A buttons

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

True

A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024 megabytes. What is a petabyte? 1024 megabytes. 1024 Yottabytes 1024 Terabytes 1024 Zetabytes None of the above

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 15 seconds 30 seconds 45 seconds 1 minute

1 second

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) =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup) =VLOOKUP(lookup_value, table_array, col_index_num, value) =VLOOKUP(table_array, col_index_num, lookup_value,range_lookup)

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

A protocol is which of the following? A standard A language A resource A device

A standard

What is a Pivot Table? A table containing data that is organized horizontally. A table used to calculate financial pivot values. A tool used to summarize data. A table containing only black, grey and white formatting.

A tool used to summarize data.

Which of the following is not open source application software? Linux R Adobe Photoshop FireFox Cassandra by Facebook

Adobe Photoshop

How do businesses make money on the Internet? Selling product Paid for showing advertising Paid for content Paid for obtaining customers All of the above

All of the above

Metadata defines the _________. Format of date fields Required data fields Database business rules Number of characters in a text field All of the above

All of the above

When you use the Internet you run the risk of __________. Identity Theft Financial Theft Extortion Blackmail All of the above

All of the above

Which of the following is not a job that companies hire MIS graduates to do? Systems Analyst Business Analyst Database Administrator Information Assurance Analyst All of the above are jobs 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? Reviews of restaurants. Liking a products Facebook page. Blogging about food. Posting your location on social media. All of these provide content.

All of these provide content.

A __________ is a tool used to summarize large amounts of data. An Excel Worksheet An Excel Workbook An Excel Table An Excel Pivot Table

An Excel Pivot Table

The third tenet of the CIA is ____________. Appropriateness Awareness Availability Antecedent

Availability

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

Bandwidth

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

False

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 Paste button on the Standard toolbar. Click the arrow on the Paste button on the Standard toolbar, then click Formulas. Click the arrow on the Paste button on the Standard toolbar, then click Values. Right click on the cell and select Paste from the dropdown menu.

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

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? Create a pie chart Create a scatter plot chart Create a column chart Create a pivot chart

Create a pivot chart

What is the first step for creating a Pivot Table? Clicking on the Insert Tab and inserting a Pivot Table. Create or select data that needs to be analyzed. Deciding on which fields (column and row labels) to use to analyze the data. None of the above options are correct.

Create or select data that needs to be analyzed.

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. True False

False

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

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. True False

False

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

False

Data is information put into context. True False

False

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

False

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

False

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

False

Heuristics can lead to unpredictable biases and consistencies. True False

False

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

False

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

False

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

False

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

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. True False

False

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

False

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

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. True False

False

The DBMS is used to create application business rules. True False

False

The DBMS is used to create application business rules. True False

False

Every table has a primary key. When the primary key of one table is in another table it is called a(n) _______ key. Unique Lost Foreign It is not allowed to use a primary key in another table.

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 ___________. What-if analysis Solver Goal Seek Scenario Manager

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 Hold down the ALT key Hold down the SHIFT key None of these. You cannot select cells that are not touching each other.

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 Hold down the SHIFT key Hold down the ALT key None of these. You cannot select cells that are not touching each other.

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? PMT PPMT IPMT IRR

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 Misconception of Chance Insensitive to predictability Insensitive to posterior probabilities Insensitive to prior probabilities

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? Insensitive to prior probabilities Illusion-correlation bias Insensitive to posterior probabilities Insensitive to predictability Misconception of Chance

Illusion-correlation bias

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 prior probabilities Insensitive to prior outcomes Insensitive to sample size considering prior possibilities Insensitive to posterior probabilities Insensitive to predictability

Insensitive to predictability

If an interviewer ignores your past history of success, he is guilty of which bias? Insensitive to prior probabilities Insensitive to prior outcomes Insensitive to sample size considering prior possibilities Insensitive to posterior probabilities

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 Insensitive to prior outcomes Insensitive to sample size considering prior possibilities Insensitive to posterior probabilities Insensitive to predictability

Insensitive to prior probabilities

Where is a Pivot Table inserted? Below the last row of data in your worksheet. Next to the last column of data in your worksheet. It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where your cursor is. Above the first row of data in your worksheet.

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 will often have perfect spelling and grammar. It will not ask for your ID and password. It will not ask for you to pay a fee. It may have a link for you to click to access a message. It will not have a threat of account closing.

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

Which of the following describes how late work is handled in MSIS 2103? A 10% deduction from the grade is for every day late. Late work is graded and 25% is deducted. Late work is graded and 50% is deducted. Late work is graded and there is no deduction. None of the answers are correct.

None of the answers are correct.

When you access your University's Learning Management System (LMS), the LMS is where? On your computer On a client On a browser On a server

On a server

When you post a review on a business you are _______. Interfacing with a business system Providing content Using an ebusiness-facing information system Using a social relationship system

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 Formula Bar Tab Backstage

Ribbon

When you take out renter's insurance, you are practicing ________. Risk Acceptance Risk Avoidance Risk Transference Risk Likelihood

Risk Transference

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

SCM

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

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 owner is going to over value the car. The first price mentioned creates the starting point in the negotiation. The owner will likely be insulted and refuse to negotiate. You just like to be first in everything.

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

Moore's law states that _______________. Computers get faster every two years. Computer memory increases every year. Computer costs decrease every year The number of transistors on a chip doubles every 18 to 24 months. The distance between people in social networks decreases every year.

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 They are all single applications with individual databases that can talk to each other. A business must have more than one of them. There is no common element.

They all have a single database supporting applications

Which of the following is the common element of enterprise systems? They have multiple relational databases They have one database They use the same programming language. They all will have the ability to do logistics.

They have one database

In a VLOOKUP formula, what does the argument "column_index_number" mean? This is the secret INDEX number that each column in an Excel worksheet has. This is the number of the column within the selected table_array where the lookup result is located. This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc. This is numbers that you assign to columns in your worksheet.

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 False

True

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

True

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

True

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

True

One way to get data out of a relational database is to write a query using SQL or structured query language. True False

True

People are the greatest threat to the security of a business's information. True False

True

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

True

Tacit knowledge requires that an individual the internalize a skill. True False

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 False

True

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

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 False

True

Which of the following is a tacit skill taught in MSIS 2103 Basic computer knowledge Understanding databases Using Excel to solve problems Understanding networks. Snowboarding

Using Excel to solve problems

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? TaBpSsOaSsB 1234567890 JeniferSsa Password1 XVG$4u5i6&n

XVG$4u5i6&n

Which of the following is NOT possible with VLOOKUP? You can lookup values located in a different worksheet. You can lookup values located in a column to the right of the column that contains the lookup value. You can lookup values located in a column to the left of the column that contains the lookup value. You can lookup values such as text, numbers or characters.

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 only use that named range on worksheet 1 You can use that named range only on worksheets 1 and 2 You can use that named range on all worksheets in the workbook If you add another worksheet to the workbook, you cannot use that named range in the new worksheet.

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

Your ISP says that you have 50 Mbs Internet speed. When you run a speed check you find that _________. Your upload speed is approximately 50 Mbs. Your download speed is higher than 50 Mbs Your download speed is lower than 50 Mbs. Your download and upload speeds are approximately 50 Mbs.

Your download speed is lower than 50 Mbs.

When you needed to know the grade distribution in the Student Grade Excel application, you used which function? sum count sumif countif sumifs

countif