BIS 245 WEEK 3 ILAB VISIO ERD PRACTICE
TEST 2026 QUESTIONS WITH ANSWERS
GRADED A+
◉ alias. Answer: The FROM clause can contain a second, a much
simpler, name for a table. This name is called a(n) ...
◉ SUM(listprice * quantity). Answer: The best aggregate function
clause to use to determine the total amount each customer spent on
shoes would be the following:
◉ entities. Answer: In our conceptual methodology we represent
real world instances as
◉ analysis of data. Answer: process of inspecting, cleaning,
transforming and modeling data with the goal of discovering useful
information, suggesting conclusions and supporting decision-
making
◉ data visualization importance. Answer: 1. Absorb information
quickly.
2. Understand your next steps.
3. Connect the dots.
,4. Hold your audience's interests longer.
5. Kick the Need for Data Scientists.
6. Share your insights with everyone.
7. Find the outliers.
8. Memorize the important insights.
9. Act on your findings quickly.
◉ visualization goals. Answer: better and easier way to present
trends, patterns, large amounts of data and idea of how things
change
◉ picture superiority effect. Answer: pictures are retained at a much
higher rate than words
◉ visualization. Answer: reduces the time to insight
◉ A1. Answer: both column and row references are "relative" and
will change when the reference is copied and pasted to other cells
◉ $A1. Answer: column reference is "absolute" (will not change
when copied & pasted) and row reference is "relative"
◉ A$1. Answer: column is "relative" & row is "absolute"
, ◉ $A$1. Answer: both column and row are absolute & will not
change when copied & pasted
◉ RATE. Answer: calculates interest rate earned
◉ EFFECT. Answer: calculates annual percentage rate
◉ NPER. Answer: calculates number of payments
◉ PMT. Answer: calculates payment amt
◉ PV. Answer: calculates present value
◉ FV. Answer: calculates FV
◉ boolean logic. Answer: -Answers a TRUE / FALSE question
-"AND" combines multiple Boolean functions to see if all combined
functions are true
TEST 2026 QUESTIONS WITH ANSWERS
GRADED A+
◉ alias. Answer: The FROM clause can contain a second, a much
simpler, name for a table. This name is called a(n) ...
◉ SUM(listprice * quantity). Answer: The best aggregate function
clause to use to determine the total amount each customer spent on
shoes would be the following:
◉ entities. Answer: In our conceptual methodology we represent
real world instances as
◉ analysis of data. Answer: process of inspecting, cleaning,
transforming and modeling data with the goal of discovering useful
information, suggesting conclusions and supporting decision-
making
◉ data visualization importance. Answer: 1. Absorb information
quickly.
2. Understand your next steps.
3. Connect the dots.
,4. Hold your audience's interests longer.
5. Kick the Need for Data Scientists.
6. Share your insights with everyone.
7. Find the outliers.
8. Memorize the important insights.
9. Act on your findings quickly.
◉ visualization goals. Answer: better and easier way to present
trends, patterns, large amounts of data and idea of how things
change
◉ picture superiority effect. Answer: pictures are retained at a much
higher rate than words
◉ visualization. Answer: reduces the time to insight
◉ A1. Answer: both column and row references are "relative" and
will change when the reference is copied and pasted to other cells
◉ $A1. Answer: column reference is "absolute" (will not change
when copied & pasted) and row reference is "relative"
◉ A$1. Answer: column is "relative" & row is "absolute"
, ◉ $A$1. Answer: both column and row are absolute & will not
change when copied & pasted
◉ RATE. Answer: calculates interest rate earned
◉ EFFECT. Answer: calculates annual percentage rate
◉ NPER. Answer: calculates number of payments
◉ PMT. Answer: calculates payment amt
◉ PV. Answer: calculates present value
◉ FV. Answer: calculates FV
◉ boolean logic. Answer: -Answers a TRUE / FALSE question
-"AND" combines multiple Boolean functions to see if all combined
functions are true
