MSIS 2103 COMPREHENSIVE EXAMS 2025/2026
QUESTIONS AND ANSWERS RATED A+
✔✔Distributed File Systems or NoSQL databases are available for purchases and are
closed source systems. - ✔✔False
✔✔When working on WiFi, what does the router or access point use to identify you? -
✔✔Dynamic IP Address
✔✔When you needed to know the grade distribution in the Student Grade Excel
application, you used which function? - ✔✔countif
✔✔A ____________ shows the relationships between the tables in a relational
database. - ✔✔Entity Relationship Diagram
✔✔A relational database can have a many to many relationship between entities. -
✔✔False
✔✔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 don't have enough information to estimate the distribution
✔✔When you use the Internet you run the risk of ________. - ✔✔All of the above
✔✔The DBMS is used to create application business rules. - ✔✔False
✔✔A ________ is a tool used to summarize large amounts of data. - ✔✔An excel pivot
table
✔✔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
✔✔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
✔✔Information on the Internet has a limited life and is deleted after a period of time. -
✔✔False
✔✔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
, ✔✔Malware is software to protect your computer from anti-malware attacks by viruses,
spying tools, ransomware, and Trojan horses. - ✔✔False
✔✔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
✔✔The "law of small numbers" says that any sample will have a distribution that is
representative of the population, regardless of sample size. The 'law of small numbers"
is valid for selecting sample size. - ✔✔False
✔✔An ERP can have a CRM module - ✔✔True
✔✔How can you recognize phishing email? - ✔✔It may have a link for you to click to
access a message
✔✔In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range - ✔✔False
✔✔Metadata defines the ________. - ✔✔All of the above
✔✔One method of keeping information secure when sent over the internet or store on a
computer is______ . - ✔✔encryption
✔✔Choices involving gains are often risk averse and choices involving losses are often
risk taking. This explains the high sales of lottery tickets . - ✔✔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
✔✔A manufacturing company that uses an enterprise information system will likely use
a(n)________. - ✔✔ERP
✔✔Heuristics can lead to unpredictable biases and consistencies. - ✔✔False
✔✔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
✔✔The third tenet of the CIA is _______. - ✔✔Availability
✔✔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
QUESTIONS AND ANSWERS RATED A+
✔✔Distributed File Systems or NoSQL databases are available for purchases and are
closed source systems. - ✔✔False
✔✔When working on WiFi, what does the router or access point use to identify you? -
✔✔Dynamic IP Address
✔✔When you needed to know the grade distribution in the Student Grade Excel
application, you used which function? - ✔✔countif
✔✔A ____________ shows the relationships between the tables in a relational
database. - ✔✔Entity Relationship Diagram
✔✔A relational database can have a many to many relationship between entities. -
✔✔False
✔✔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 don't have enough information to estimate the distribution
✔✔When you use the Internet you run the risk of ________. - ✔✔All of the above
✔✔The DBMS is used to create application business rules. - ✔✔False
✔✔A ________ is a tool used to summarize large amounts of data. - ✔✔An excel pivot
table
✔✔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
✔✔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
✔✔Information on the Internet has a limited life and is deleted after a period of time. -
✔✔False
✔✔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
, ✔✔Malware is software to protect your computer from anti-malware attacks by viruses,
spying tools, ransomware, and Trojan horses. - ✔✔False
✔✔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
✔✔The "law of small numbers" says that any sample will have a distribution that is
representative of the population, regardless of sample size. The 'law of small numbers"
is valid for selecting sample size. - ✔✔False
✔✔An ERP can have a CRM module - ✔✔True
✔✔How can you recognize phishing email? - ✔✔It may have a link for you to click to
access a message
✔✔In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range - ✔✔False
✔✔Metadata defines the ________. - ✔✔All of the above
✔✔One method of keeping information secure when sent over the internet or store on a
computer is______ . - ✔✔encryption
✔✔Choices involving gains are often risk averse and choices involving losses are often
risk taking. This explains the high sales of lottery tickets . - ✔✔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
✔✔A manufacturing company that uses an enterprise information system will likely use
a(n)________. - ✔✔ERP
✔✔Heuristics can lead to unpredictable biases and consistencies. - ✔✔False
✔✔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
✔✔The third tenet of the CIA is _______. - ✔✔Availability
✔✔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
