D468 BUS 2780
Discovering Data
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following best describes the primary goal of data
discovery?
- A) To reduce healthcare costs
- B) To identify patterns and insights from data
- C) To manage hospital resources
- D) To perform diagnostic tests
- ANS: B) To identify patterns and insights from data
- Rationale: The primary goal of data discovery is to identify
patterns and insights from data to inform decision-making.
©2024/2025
,2. What is the primary purpose of data visualization in data
discovery?
- A) To create charts
- B) To summarize and present data in a visual format
- C) To format cells
- D) To perform calculations
- ANS: B) To summarize and present data in a visual format
- Rationale: Data visualization is used to summarize and
present data in a visual format, making it easier to understand and
interpret.
3. Which of the following is NOT a common data visualization
technique?
- A) Line chart
- B) Bar chart
- C) Pie chart
- D) Text box
- ANS: D) Text box
- Rationale: Common data visualization techniques include
line charts, bar charts, and pie charts. A text box is not a data
visualization technique.
©2024/2025
, Fill-in-the-Blank Questions
4. The __________ function is used to find the average value in
a range of cells.
- ANS: AVERAGE
- Rationale: The AVERAGE function is used to find the
average value in a range of cells in a spreadsheet.
5. In data discovery, the __________ effect refers to the
amplification of demand variability as orders move up the supply
chain.
- ANS: Bullwhip
- Rationale: The bullwhip effect refers to the amplification of
demand variability as orders move up the supply chain, leading to
inefficiencies and increased costs.
6. The __________ chart type is used to compare the
proportions of different categories in a dataset.
- ANS: Pie
- Rationale: Pie charts are used to compare the proportions of
different categories in a dataset by displaying data as slices of a
pie.
True/False Questions
©2024/2025
, 7. True or False: The VLOOKUP function is used to search for a
value in the first column of a table and return a value in the same
row from a specified column.
- ANS: True
- Rationale: The VLOOKUP function searches for a value in
the first column of a table and returns a value in the same row
from a specified column.
8. True or False: Scatter plots are used to display the relationship
between two variables.
- ANS: True
- Rationale: Scatter plots are used to display the relationship
between two variables by plotting data points on a Cartesian
coordinate system.
9. True or False: The CONCATENATE function is used to
combine the contents of multiple cells into a single cell.
- ANS: True
- Rationale: The CONCATENATE function is used to
combine the contents of multiple cells into a single cell, allowing
users to merge text from different cells.
Multiple Response Questions
©2024/2025
Discovering Data
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following best describes the primary goal of data
discovery?
- A) To reduce healthcare costs
- B) To identify patterns and insights from data
- C) To manage hospital resources
- D) To perform diagnostic tests
- ANS: B) To identify patterns and insights from data
- Rationale: The primary goal of data discovery is to identify
patterns and insights from data to inform decision-making.
©2024/2025
,2. What is the primary purpose of data visualization in data
discovery?
- A) To create charts
- B) To summarize and present data in a visual format
- C) To format cells
- D) To perform calculations
- ANS: B) To summarize and present data in a visual format
- Rationale: Data visualization is used to summarize and
present data in a visual format, making it easier to understand and
interpret.
3. Which of the following is NOT a common data visualization
technique?
- A) Line chart
- B) Bar chart
- C) Pie chart
- D) Text box
- ANS: D) Text box
- Rationale: Common data visualization techniques include
line charts, bar charts, and pie charts. A text box is not a data
visualization technique.
©2024/2025
, Fill-in-the-Blank Questions
4. The __________ function is used to find the average value in
a range of cells.
- ANS: AVERAGE
- Rationale: The AVERAGE function is used to find the
average value in a range of cells in a spreadsheet.
5. In data discovery, the __________ effect refers to the
amplification of demand variability as orders move up the supply
chain.
- ANS: Bullwhip
- Rationale: The bullwhip effect refers to the amplification of
demand variability as orders move up the supply chain, leading to
inefficiencies and increased costs.
6. The __________ chart type is used to compare the
proportions of different categories in a dataset.
- ANS: Pie
- Rationale: Pie charts are used to compare the proportions of
different categories in a dataset by displaying data as slices of a
pie.
True/False Questions
©2024/2025
, 7. True or False: The VLOOKUP function is used to search for a
value in the first column of a table and return a value in the same
row from a specified column.
- ANS: True
- Rationale: The VLOOKUP function searches for a value in
the first column of a table and returns a value in the same row
from a specified column.
8. True or False: Scatter plots are used to display the relationship
between two variables.
- ANS: True
- Rationale: Scatter plots are used to display the relationship
between two variables by plotting data points on a Cartesian
coordinate system.
9. True or False: The CONCATENATE function is used to
combine the contents of multiple cells into a single cell.
- ANS: True
- Rationale: The CONCATENATE function is used to
combine the contents of multiple cells into a single cell, allowing
users to merge text from different cells.
Multiple Response Questions
©2024/2025
