MSIS 2103 EXAM QUESTIONS AND ANSWERS
A URL has two parts. The first part is the protocol identifier and the second is the
domain name. A URL does not need an IP address associated with it? - Answers :False
Which of the following describes how late work is handled in MSIS 2103? - Answers
:None of these are right
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. - Answers
:False
Which of the following is a way people provide content on the internet? - Answers :All of
the above
Learning objective 1 is to develop skills in using excel by applying it to solve problems?
- Answers :True
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? - Answers :Group field
Which button on the ribbon do you use to get your year totals in the pivot table? -
Answers :Field setting
Which of the following is not a job that companies hire MIS graduates to do? - Answers
:All of the above
In order to perform a skill, the knowledge must be internalized. This is called? - Answers
:Tacit knowledge
When you access your University Learning System, LMS, the LMS is where? - Answers
:Server
Cassandra, R, firefox, and linux are examples of open source software. While the
source code is available to view (first part true), anyone that wants to modify it must pay
a fee to the organization that controls the software, such as apache.org - Answers
:False
Which of the following formulas below contain the correct syntax(has to have commas)
(formula arguments) for the VLOOKUP function? - Answers :=VLOOKUP(lookup_value,
table_array, col_index_num, range_lookup)
According to the video "a packets tale" what is the total time for the request and the
webpage to be displayed? - Answers :1 second
, When you post a review on a business you are - Answers :Providing content
Moore's law states: - Answers :The number of transistors on a chip doubles every 18 to
24 months
When you sign onto a LAN through Wifi, you have a __ IP address and the LAN router
has a __ IP address - Answers :Dynamic ; Static
Through the use of apps (application software) your smartphone can access devices
that are connected to a network. What installed technology does the smart phone not
use to connect to the network? - Answers :Cellular Radio
Information is defined as facts (true), knowledge, and skills acquired by a person
through experience or education - Answers :False
Which of the following is not possible with VLOOKUP? - Answers :You can lookup
values located in a column to the left of the column that contains the vlookup value
What is a pivot table? - Answers :A tool used to summarize data
Data is information put into context - Answers :True
To sort data in an Excel worksheet you can use the ______ - Answers :Sort A to Z and
Sort Z to A buttons
The IP address defines your device whereas the Mac address defines your location on
the network? - Answers :False
TCP/IP defines how data is sent over the internet? - Answers :True
Which of the following transmission protocols is not a wireless network protocol? -
Answers :Fiberoptics
Protocol is which of the following? - Answers :A standard
Which of the following is a tactic skill in MSIS 2103? - Answers :Solving excel to solve
problems
You have a LAN at home so that all of your IoT(internet of things) devices can be
reached through the internet. All of the devices are connected by WiFi and have a Static
IP address assigned by the router. - Answers :False
Google Maps is a GIS system that utilizes a GPA system to provide information about
the physical world. - Answers :True
A URL has two parts. The first part is the protocol identifier and the second is the
domain name. A URL does not need an IP address associated with it? - Answers :False
Which of the following describes how late work is handled in MSIS 2103? - Answers
:None of these are right
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. - Answers
:False
Which of the following is a way people provide content on the internet? - Answers :All of
the above
Learning objective 1 is to develop skills in using excel by applying it to solve problems?
- Answers :True
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? - Answers :Group field
Which button on the ribbon do you use to get your year totals in the pivot table? -
Answers :Field setting
Which of the following is not a job that companies hire MIS graduates to do? - Answers
:All of the above
In order to perform a skill, the knowledge must be internalized. This is called? - Answers
:Tacit knowledge
When you access your University Learning System, LMS, the LMS is where? - Answers
:Server
Cassandra, R, firefox, and linux are examples of open source software. While the
source code is available to view (first part true), anyone that wants to modify it must pay
a fee to the organization that controls the software, such as apache.org - Answers
:False
Which of the following formulas below contain the correct syntax(has to have commas)
(formula arguments) for the VLOOKUP function? - Answers :=VLOOKUP(lookup_value,
table_array, col_index_num, range_lookup)
According to the video "a packets tale" what is the total time for the request and the
webpage to be displayed? - Answers :1 second
, When you post a review on a business you are - Answers :Providing content
Moore's law states: - Answers :The number of transistors on a chip doubles every 18 to
24 months
When you sign onto a LAN through Wifi, you have a __ IP address and the LAN router
has a __ IP address - Answers :Dynamic ; Static
Through the use of apps (application software) your smartphone can access devices
that are connected to a network. What installed technology does the smart phone not
use to connect to the network? - Answers :Cellular Radio
Information is defined as facts (true), knowledge, and skills acquired by a person
through experience or education - Answers :False
Which of the following is not possible with VLOOKUP? - Answers :You can lookup
values located in a column to the left of the column that contains the vlookup value
What is a pivot table? - Answers :A tool used to summarize data
Data is information put into context - Answers :True
To sort data in an Excel worksheet you can use the ______ - Answers :Sort A to Z and
Sort Z to A buttons
The IP address defines your device whereas the Mac address defines your location on
the network? - Answers :False
TCP/IP defines how data is sent over the internet? - Answers :True
Which of the following transmission protocols is not a wireless network protocol? -
Answers :Fiberoptics
Protocol is which of the following? - Answers :A standard
Which of the following is a tactic skill in MSIS 2103? - Answers :Solving excel to solve
problems
You have a LAN at home so that all of your IoT(internet of things) devices can be
reached through the internet. All of the devices are connected by WiFi and have a Static
IP address assigned by the router. - Answers :False
Google Maps is a GIS system that utilizes a GPA system to provide information about
the physical world. - Answers :True
