MSIS 2103 FINAL EXAM QUESTIONS & ANSWERS
To sort data in an Excel worksheet you can use the _____
A. sort A to Z and Sort Z to A buttons
B. Quicksort Options
C. Sort command one the Formulas tab
D. Any of the above - Answers :A. Sort A to Z and Sort Z to A buttons
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:
A. Abbreviate all text
B. Reduce the font to size to 8pt
C. Click Wrap Text
D. Delete one Column - Answers :C. Wrap Text
A kilobyte is 1024 bytes. A megabyte is 1024 Kilobytes. A gigabyte is 1024 megabytes.
What is a petabyte?
A. 1024 megabytes
B. 1024 Yottabytes
C. 1024 Terabytes
D. 1024 Zetabytes
E. None of the above. - Answers :C. 1024 terabytes
There are three main types of enterprise systems. They are supply chain management
(SCM), enterprise resource planning (ERP), and customer relationships 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.
A. True
B. False - Answers :A. True.
When you sign onto a LAN through WiFi, you have a_____ IP address and the LAN
router has a ______ IP address.
A. Static, Moving
B.Dynamic, Stationary
C. Dynamic, Static
D. Moving, Stationary - Answers :C. Dynamic, Static
Learning objective one is to develop skill in using Excel by applying it to solve problems.
A. True
B. False - Answers :A. True
How do businesses make money on the Internet?
A. selling product
B. Paid for showing advertising
,C. Paid for content
D. Paid for obtaining customers.
E. All of the above - Answers :E. All of the above
Which button on the ribbon do you use to get year totals in the pivot table?
A. Field Settings
B. Expand Field
C. Group Field
D. Refresh
E. Field List - Answers :A. Field Settings
When you post a review on a business you are ________.
A. Interfacing with a business system
B. Providing content
C. Using an business-facing information system
D. Using a social relationship system - Answers :B. Providing content
Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per
second. This is the _______?
A. Latency
B. Bandwidth
C. Throughput
D. Processing Power - Answers :B. Bandwidth
You have a Lan at home so all of your loT devices can be reached through the Internet.
All of the devices are connected by WiFi and have a static IP addresses.
A. True
B. False - Answers :B. False
TCP/IP defines how stat is sent over the Internet.
A. True
B. False - Answers :A. True
Your Excel workbook has four sheets. You name a range on sheet 1. Which of the
following is true.
A. You can only use that named range on worksheet 1.
B. You can use that named range only on worksheet 1 and 2.
C. You can use that named range on all worksheets in the workbook
D. If you add another worksheet to the workbook, you cannot use that named range. -
Answers :C. You can use that named range on all worksheets in the workbook.
A URL has to parts. The first art is the protocol identifier, and the second is the domain
name. A URL does not need to have an IP address associated with it.
A. True
B. False - Answers :B. False
, Data is information put into context.
A. True
B. False - Answers :B. False
Formatting data changes the appearance of data, and changes the data itself.
A. True
B. False - Answers :B. False
In a VLOOKUP formula, what does the argument "column_index_number" mean?
A. This is the secret INDEX number that each column in an Excel worksheet has.
B. This is the number of the column within the selected table_array where the lookup
result is located.
C. This is a numerical representation of the letters at the top of a worksheet. For
example, A=1, B=2, etc.
D. This is numbers that you assign to columns in your worksheet - Answers :B. This is
the number of the column within the selected table_array where the lookup result is
located.
Metadata defines the _______.
A. Format of Data fields
B. Required data fields
C. database business rules
D. Number of characters in a text field.
E. All of the above - Answers :E. All of the above.
In order to perform a skill, the knowledge must be internalized. This is called _______
knowledge.
A. Implicit
B. Explicit
C. Tacit
D. Externalized - Answers :c. Tacit
Which of the following is a tacit skill in MSIS 2103.
A. Basic computer knowledge
B. Understanding databases
C. Using Excel to solve problems
D. Understanding networks
E. Snowboarding - Answers :C. Using Excel to solve problems
Which of the following is not open source application software?
A. Linux
B. R
C. Adobe Photoshop
D. FireFox
E. Cassandra by Facebook - Answers :C. Adobe Photoshop.
To sort data in an Excel worksheet you can use the _____
A. sort A to Z and Sort Z to A buttons
B. Quicksort Options
C. Sort command one the Formulas tab
D. Any of the above - Answers :A. Sort A to Z and Sort Z to A buttons
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:
A. Abbreviate all text
B. Reduce the font to size to 8pt
C. Click Wrap Text
D. Delete one Column - Answers :C. Wrap Text
A kilobyte is 1024 bytes. A megabyte is 1024 Kilobytes. A gigabyte is 1024 megabytes.
What is a petabyte?
A. 1024 megabytes
B. 1024 Yottabytes
C. 1024 Terabytes
D. 1024 Zetabytes
E. None of the above. - Answers :C. 1024 terabytes
There are three main types of enterprise systems. They are supply chain management
(SCM), enterprise resource planning (ERP), and customer relationships 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.
A. True
B. False - Answers :A. True.
When you sign onto a LAN through WiFi, you have a_____ IP address and the LAN
router has a ______ IP address.
A. Static, Moving
B.Dynamic, Stationary
C. Dynamic, Static
D. Moving, Stationary - Answers :C. Dynamic, Static
Learning objective one is to develop skill in using Excel by applying it to solve problems.
A. True
B. False - Answers :A. True
How do businesses make money on the Internet?
A. selling product
B. Paid for showing advertising
,C. Paid for content
D. Paid for obtaining customers.
E. All of the above - Answers :E. All of the above
Which button on the ribbon do you use to get year totals in the pivot table?
A. Field Settings
B. Expand Field
C. Group Field
D. Refresh
E. Field List - Answers :A. Field Settings
When you post a review on a business you are ________.
A. Interfacing with a business system
B. Providing content
C. Using an business-facing information system
D. Using a social relationship system - Answers :B. Providing content
Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per
second. This is the _______?
A. Latency
B. Bandwidth
C. Throughput
D. Processing Power - Answers :B. Bandwidth
You have a Lan at home so all of your loT devices can be reached through the Internet.
All of the devices are connected by WiFi and have a static IP addresses.
A. True
B. False - Answers :B. False
TCP/IP defines how stat is sent over the Internet.
A. True
B. False - Answers :A. True
Your Excel workbook has four sheets. You name a range on sheet 1. Which of the
following is true.
A. You can only use that named range on worksheet 1.
B. You can use that named range only on worksheet 1 and 2.
C. You can use that named range on all worksheets in the workbook
D. If you add another worksheet to the workbook, you cannot use that named range. -
Answers :C. You can use that named range on all worksheets in the workbook.
A URL has to parts. The first art is the protocol identifier, and the second is the domain
name. A URL does not need to have an IP address associated with it.
A. True
B. False - Answers :B. False
, Data is information put into context.
A. True
B. False - Answers :B. False
Formatting data changes the appearance of data, and changes the data itself.
A. True
B. False - Answers :B. False
In a VLOOKUP formula, what does the argument "column_index_number" mean?
A. This is the secret INDEX number that each column in an Excel worksheet has.
B. This is the number of the column within the selected table_array where the lookup
result is located.
C. This is a numerical representation of the letters at the top of a worksheet. For
example, A=1, B=2, etc.
D. This is numbers that you assign to columns in your worksheet - Answers :B. This is
the number of the column within the selected table_array where the lookup result is
located.
Metadata defines the _______.
A. Format of Data fields
B. Required data fields
C. database business rules
D. Number of characters in a text field.
E. All of the above - Answers :E. All of the above.
In order to perform a skill, the knowledge must be internalized. This is called _______
knowledge.
A. Implicit
B. Explicit
C. Tacit
D. Externalized - Answers :c. Tacit
Which of the following is a tacit skill in MSIS 2103.
A. Basic computer knowledge
B. Understanding databases
C. Using Excel to solve problems
D. Understanding networks
E. Snowboarding - Answers :C. Using Excel to solve problems
Which of the following is not open source application software?
A. Linux
B. R
C. Adobe Photoshop
D. FireFox
E. Cassandra by Facebook - Answers :C. Adobe Photoshop.
