MSIS 2103 EXAM EVALUATION UPDATED QUESTIONS AND
SOLUTIONS RATED A+
✔✔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: - ✔✔Click Wrap text
✔✔What is the first step for creating a pivot table? - ✔✔create or select data that needs
to be analyzed.
✔✔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
✔✔Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per
second. This is the _______ - ✔✔bandwidth
✔✔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
✔✔When you post a review on a business you are _______. - ✔✔providing content
✔✔Learning objective one is to develop skill in using Excel by applying it to solve
problems. - ✔✔true
✔✔When you use a credit card, you are using several different companies' information
systems. - ✔✔True
✔✔Google Maps is a GIS system that utilizes a GPS system to provide information
about the physical world. - ✔✔True
✔✔Data is information put into context. - ✔✔False
✔✔In order to perform a skill, the knowledge must be internalized. This is called
________ knowledge. - ✔✔Tacit
✔✔Moore's law states that _______________. - ✔✔The number of transistors on a chip
doubles every 18 to 24 months.
✔✔A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024
megabytes. What is a petabyte? - ✔✔1024 Terabytes
✔✔What is not an open source application software? - ✔✔Adobe Photoshop
, ✔✔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
✔✔Formatting data changes the appearance of data, and it changes the data itself. -
✔✔False
✔✔All computer devices communicate over a network using computer languages such
as Python or C#. - ✔✔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
✔✔To sort data in an Excel worksheet you can use the ______. - ✔✔Sort A to Z and
Sort Z to a buttons
✔✔When you access your University's Learning Management System (LMS), the LMS
is where? - ✔✔on a server
✔✔What is a protocol? - ✔✔a standard
✔✔TCP/IP defines how data is sent over the Internet. - ✔✔True
✔✔According to the video "A Packet's Tale" what is the total time for the request and
the webpage to be displayed? - ✔✔1 second
✔✔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.
✔✔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)
✔✔Which of the following describes how late work is handled in MSIS 2103? - ✔✔Late
work is not graded
✔✔Which of the following is a tacit skill taught in MSIS 2103 - ✔✔Using Excel to solve
problems
SOLUTIONS RATED A+
✔✔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: - ✔✔Click Wrap text
✔✔What is the first step for creating a pivot table? - ✔✔create or select data that needs
to be analyzed.
✔✔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
✔✔Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per
second. This is the _______ - ✔✔bandwidth
✔✔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
✔✔When you post a review on a business you are _______. - ✔✔providing content
✔✔Learning objective one is to develop skill in using Excel by applying it to solve
problems. - ✔✔true
✔✔When you use a credit card, you are using several different companies' information
systems. - ✔✔True
✔✔Google Maps is a GIS system that utilizes a GPS system to provide information
about the physical world. - ✔✔True
✔✔Data is information put into context. - ✔✔False
✔✔In order to perform a skill, the knowledge must be internalized. This is called
________ knowledge. - ✔✔Tacit
✔✔Moore's law states that _______________. - ✔✔The number of transistors on a chip
doubles every 18 to 24 months.
✔✔A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024
megabytes. What is a petabyte? - ✔✔1024 Terabytes
✔✔What is not an open source application software? - ✔✔Adobe Photoshop
, ✔✔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
✔✔Formatting data changes the appearance of data, and it changes the data itself. -
✔✔False
✔✔All computer devices communicate over a network using computer languages such
as Python or C#. - ✔✔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
✔✔To sort data in an Excel worksheet you can use the ______. - ✔✔Sort A to Z and
Sort Z to a buttons
✔✔When you access your University's Learning Management System (LMS), the LMS
is where? - ✔✔on a server
✔✔What is a protocol? - ✔✔a standard
✔✔TCP/IP defines how data is sent over the Internet. - ✔✔True
✔✔According to the video "A Packet's Tale" what is the total time for the request and
the webpage to be displayed? - ✔✔1 second
✔✔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.
✔✔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)
✔✔Which of the following describes how late work is handled in MSIS 2103? - ✔✔Late
work is not graded
✔✔Which of the following is a tacit skill taught in MSIS 2103 - ✔✔Using Excel to solve
problems
