BUS 1350 – Chapter 4 Key Terms, Erica Ancira, 2026 – Study guide and
reference material
Area Chart (Insert Tab) - correct answer ✔✔ A chart that emphasizes the magnitude of change
over time and visually depicts trends
- The chart stacks a set of data series and colors each area that is created.
- With this chart, the X-Axis is typically a time sequence but can also show categories instead of
time
Bar Chart (Insert Tab) - correct answer ✔✔ A chart that displays data horizontally and is used for
comparison among individual items
Chart Gridlines - correct answer ✔✔ Lines that go across charts to help gauge the size of bars,
columns, or data lines
Chart Sheet (Left click chart -> Move Chart) - correct answer ✔✔ A special worksheet that is
dedicated to displaying chart objects
- A worksheet containing only the chart object
- This can make it easier to isolate and print the page
- Can also improve the overall organization of the workbook
Column Charts (Insert Tab) - correct answer ✔✔ A chart that is used to compare data across
categories and show change, sometimes over time
, - Type of chart which easily allows for grouping data
- Type of chart which are best for comparing data sets that are categorized (Especially over
time)
Combination Chart (Insert Tab) - correct answer ✔✔ A chart that displays two different types of
data by using multiple chart types in a single chart object
Data Bar (Found under Conditional Formatting Feature within the Home Tab) - correct answer
✔✔ Graphical components that are overlaid onto data in worksheet cells
- Can be applied as a One-Color solid filled cell or as a gradient fill from left to right as numerical
components get bigger
Data Point - correct answer ✔✔ An individual data value in a data series
Data Series - correct answer ✔✔ A group of related data values to be charted
Data Visualization - correct answer ✔✔ The graphical presentation of data with a focus on
qualitative understanding
Embedded Chart (Insert Tab) - correct answer ✔✔ An object located on the same worksheet
with the data
Ideas (Home Tab) - correct answer ✔✔ A feature in excel which analyzes data with visual
summaries, patterns, and trends.
reference material
Area Chart (Insert Tab) - correct answer ✔✔ A chart that emphasizes the magnitude of change
over time and visually depicts trends
- The chart stacks a set of data series and colors each area that is created.
- With this chart, the X-Axis is typically a time sequence but can also show categories instead of
time
Bar Chart (Insert Tab) - correct answer ✔✔ A chart that displays data horizontally and is used for
comparison among individual items
Chart Gridlines - correct answer ✔✔ Lines that go across charts to help gauge the size of bars,
columns, or data lines
Chart Sheet (Left click chart -> Move Chart) - correct answer ✔✔ A special worksheet that is
dedicated to displaying chart objects
- A worksheet containing only the chart object
- This can make it easier to isolate and print the page
- Can also improve the overall organization of the workbook
Column Charts (Insert Tab) - correct answer ✔✔ A chart that is used to compare data across
categories and show change, sometimes over time
, - Type of chart which easily allows for grouping data
- Type of chart which are best for comparing data sets that are categorized (Especially over
time)
Combination Chart (Insert Tab) - correct answer ✔✔ A chart that displays two different types of
data by using multiple chart types in a single chart object
Data Bar (Found under Conditional Formatting Feature within the Home Tab) - correct answer
✔✔ Graphical components that are overlaid onto data in worksheet cells
- Can be applied as a One-Color solid filled cell or as a gradient fill from left to right as numerical
components get bigger
Data Point - correct answer ✔✔ An individual data value in a data series
Data Series - correct answer ✔✔ A group of related data values to be charted
Data Visualization - correct answer ✔✔ The graphical presentation of data with a focus on
qualitative understanding
Embedded Chart (Insert Tab) - correct answer ✔✔ An object located on the same worksheet
with the data
Ideas (Home Tab) - correct answer ✔✔ A feature in excel which analyzes data with visual
summaries, patterns, and trends.
