D466 BUS 2760
Analyzing & Visualizing Data
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following best describes the primary goal of data
analysis?
- A) To reduce healthcare costs
- B) To extract meaningful insights from data
- C) To manage hospital resources
- D) To perform diagnostic tests
- ANS: B) To extract meaningful insights from data
- Rationale: The primary goal of data analysis is to extract
meaningful insights from data to inform decision-making.
©2024/2025
,2. What is the primary purpose of data visualization in data
analysis?
- 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 chart types is best suited for
displaying trends over time?
- A) Pie chart
- B) Bar chart
- C) Line chart
- D) Scatter plot
- ANS: C) Line chart
- Rationale: Line charts are best suited for displaying trends
over time as they show data points connected by lines, making it
easy to visualize changes over a period.
©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 analysis, 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
Analyzing & Visualizing Data
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following best describes the primary goal of data
analysis?
- A) To reduce healthcare costs
- B) To extract meaningful insights from data
- C) To manage hospital resources
- D) To perform diagnostic tests
- ANS: B) To extract meaningful insights from data
- Rationale: The primary goal of data analysis is to extract
meaningful insights from data to inform decision-making.
©2024/2025
,2. What is the primary purpose of data visualization in data
analysis?
- 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 chart types is best suited for
displaying trends over time?
- A) Pie chart
- B) Bar chart
- C) Line chart
- D) Scatter plot
- ANS: C) Line chart
- Rationale: Line charts are best suited for displaying trends
over time as they show data points connected by lines, making it
easy to visualize changes over a period.
©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 analysis, 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
