D388 BUS 2250
Fundamentals for Spreadsheets & Data
Presentations
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following functions is used to calculate the
average of a range of cells in a spreadsheet?
- A) SUM
- B) AVERAGE
- C) COUNT
- D) MAX
- ANS: B) AVERAGE
©2024/2025
, - Rationale: The AVERAGE function is used to calculate the
average of a range of cells in a spreadsheet.
2. What is the primary purpose of using pivot tables in data
analysis?
- A) To create charts
- B) To summarize and analyze large datasets
- C) To format cells
- D) To perform calculations
- ANS: B) To summarize and analyze large datasets
- Rationale: Pivot tables are used to summarize and analyze
large datasets by organizing and aggregating data in a meaningful
way.
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
©2024/2025
, - 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.
Fill-in-the-Blank Questions
4. The __________ function is used to find the highest value in a
range of cells.
- ANS: MAX
- Rationale: The MAX function is used to find the highest
value in a range of cells in a spreadsheet.
5. In a spreadsheet, the __________ feature allows users to
apply specific formatting to cells that meet certain criteria.
- ANS: Conditional Formatting
- Rationale: Conditional Formatting allows users to apply
specific formatting to cells that meet certain criteria, making it
easier to highlight important data.
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.
©2024/2025
Fundamentals for Spreadsheets & Data
Presentations
Comprehensive FA Review (Qns & Ans)
2025
1. Which of the following functions is used to calculate the
average of a range of cells in a spreadsheet?
- A) SUM
- B) AVERAGE
- C) COUNT
- D) MAX
- ANS: B) AVERAGE
©2024/2025
, - Rationale: The AVERAGE function is used to calculate the
average of a range of cells in a spreadsheet.
2. What is the primary purpose of using pivot tables in data
analysis?
- A) To create charts
- B) To summarize and analyze large datasets
- C) To format cells
- D) To perform calculations
- ANS: B) To summarize and analyze large datasets
- Rationale: Pivot tables are used to summarize and analyze
large datasets by organizing and aggregating data in a meaningful
way.
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
©2024/2025
, - 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.
Fill-in-the-Blank Questions
4. The __________ function is used to find the highest value in a
range of cells.
- ANS: MAX
- Rationale: The MAX function is used to find the highest
value in a range of cells in a spreadsheet.
5. In a spreadsheet, the __________ feature allows users to
apply specific formatting to cells that meet certain criteria.
- ANS: Conditional Formatting
- Rationale: Conditional Formatting allows users to apply
specific formatting to cells that meet certain criteria, making it
easier to highlight important data.
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.
©2024/2025
