MSIS 2103 EXAMS SCRIPT 2025/2026 QUESTIONS AND
ANSWERS RATED A+
✔✔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.
✔✔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 pivot chart
✔✔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
✔✔T/F: Because a properly designed relational database only has single data entry, it
is common to put calculated variables in the database - ✔✔False
✔✔When you take out renter's insurance, you are practicing ______. - ✔✔Risk
transference
✔✔T/F: One way to get data out of a relational database is to write a query using SQL
or structured query language. - ✔✔True
✔✔T/F: Choices involving gains are often risk averse and choices involving losses are
often risk taking. This explains the high sales of lottery tickets. - ✔✔false
✔✔Metadata defines the _______. - ✔✔All of the above
✔✔People make many decisions everyday. Most of these decisions are made using
analytical tools like excel - ✔✔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 arrow on the Paste button on the Standard
toolbar, then click Values.
✔✔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.
, ✔✔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
ANSWERS RATED A+
✔✔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.
✔✔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 pivot chart
✔✔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
✔✔T/F: Because a properly designed relational database only has single data entry, it
is common to put calculated variables in the database - ✔✔False
✔✔When you take out renter's insurance, you are practicing ______. - ✔✔Risk
transference
✔✔T/F: One way to get data out of a relational database is to write a query using SQL
or structured query language. - ✔✔True
✔✔T/F: Choices involving gains are often risk averse and choices involving losses are
often risk taking. This explains the high sales of lottery tickets. - ✔✔false
✔✔Metadata defines the _______. - ✔✔All of the above
✔✔People make many decisions everyday. Most of these decisions are made using
analytical tools like excel - ✔✔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 arrow on the Paste button on the Standard
toolbar, then click Values.
✔✔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.
, ✔✔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
