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