MSIS 2103 COMPREHENSIVE EXAM UPDATED QUESTIONS
AND SOLUTIONS RATED A+
✔✔T/F: Knowledge is defined as "facts, information, and skills acquired by a person
through experience or education; the theoretical or practical understanding of a subject."
The key element of knowledge is that it can be written and shared with others. -
✔✔false
✔✔T/F: In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range. - ✔✔False
✔✔You are saving $200 per month for a down payment on a house. Your bank pays
2% APR interest. What function would you use to calculate the total amount in your
savings account in two years? - ✔✔FV
✔✔Your ISP says that you have 50 Mbs Internet speed. When you run a speed check
you find that _________. - ✔✔your download speed is lower than 50 Mbs.
✔✔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
✔✔If an interviewer ignores your past history of success, he is guilty of which bias? -
✔✔Insensitive to prior outcomes
✔✔When you needed to know the grade distribution in the Student Grade Excel
application, you used which function? - ✔✔Count if
✔✔A _________ shows the relationships between the tables in a relational database -
✔✔Entity Relationship Diagram
✔✔T/F: Risk is the probability of a bad thing happening multiplied by the impact of its
occurrence. - ✔✔True
✔✔T/F: Heuristics can lead to unpredictable biases and consistencies. - ✔✔false
✔✔T/F: Malware is software to protect your computer from anti-malware attacks by
viruses, spying tools, ransomware, and Trojan horse - ✔✔False
✔✔T/F: 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
, ✔✔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
AND SOLUTIONS RATED A+
✔✔T/F: Knowledge is defined as "facts, information, and skills acquired by a person
through experience or education; the theoretical or practical understanding of a subject."
The key element of knowledge is that it can be written and shared with others. -
✔✔false
✔✔T/F: In Excel, when you define a named range it can only be used in formulas on the
same spreadsheet as the named range. - ✔✔False
✔✔You are saving $200 per month for a down payment on a house. Your bank pays
2% APR interest. What function would you use to calculate the total amount in your
savings account in two years? - ✔✔FV
✔✔Your ISP says that you have 50 Mbs Internet speed. When you run a speed check
you find that _________. - ✔✔your download speed is lower than 50 Mbs.
✔✔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
✔✔If an interviewer ignores your past history of success, he is guilty of which bias? -
✔✔Insensitive to prior outcomes
✔✔When you needed to know the grade distribution in the Student Grade Excel
application, you used which function? - ✔✔Count if
✔✔A _________ shows the relationships between the tables in a relational database -
✔✔Entity Relationship Diagram
✔✔T/F: Risk is the probability of a bad thing happening multiplied by the impact of its
occurrence. - ✔✔True
✔✔T/F: Heuristics can lead to unpredictable biases and consistencies. - ✔✔false
✔✔T/F: Malware is software to protect your computer from anti-malware attacks by
viruses, spying tools, ransomware, and Trojan horse - ✔✔False
✔✔T/F: 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
, ✔✔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
