BUS 1350 ANCIRA EXAM 2 QUESTIONS &
ACCURATE COMPLETE SOLUTIONS
1. Data Visualiza- The graphical presentation of data with a focus on qualitative understanding.
tion
2. Data Series a group of related values to be charted
3. Data Point individual data value in a data series
4. Embedded Chart exists as an object located on the same worksheet with the data
5. Chart Sheet A special worksheet that is dedicated to displaying chart objects
6. Quick Analysis This tool appears when you slect data in a worksheet and otters single-click
access to formatting, charts, formulas, PivotTables, and sparklines.
7. Recommende feature quickly analyzes a selection in a worksheet and recommends
d Charts
chart types that best fit the data.
8. Analyze Data A feature in Excel that analyzes data with visual summaries, patterns, and
trends.
9. Column Charts used to compare data across categories and show change, sometimes
over time.
10. Pie Chart displays a comparison of each value to a total
11. Line Charts help to convey change in data over time
12. Bar Charts Display data horizontally and are used for comparison among individual
items
13. Stacked Be useful when you want to see how the individual parts add up to
Bar Charts
create the entire length of each bar
14. Scatter Chart Also called XY (scatter), is a chart that conveys the relationship between two
numeric variables
15. Area Chart a variation of a stacked line chart that emphasizes the magnitude of
change over time and visually depicts a trend.
1/
12
,BUS 1350 ANCIRA EXAM 2 QUESTIONS &
ACCURATE COMPLETE SOLUTIONS
16. Combinatio Displays two ditterent types of data by using multiple chart types in a single
n Chart
chart object.
17. Sunburst Chart can be used to display hierarchical data
18. Number Format data as currency, date, time, and so on
19. Fill Fill the background of an element with a color, picture, or pattern
20. Shape Outline Set the color and thickness of the chart border
21. Shape effects Add shadowing, reflections, glow, soft edges, bevel, and 3-D rotations to
chart
elements
22. Alignment Align Text direction for a component, such as left, top, vertical, or horizontal
23. Legend is an index within a chart that provides information about the data
24. Chart Gridlines the lines that go across charts to help gauge the size of the bars, columns,
or data lines
25. Trendline a line that uses current data to show a trend or general direction of the
data.
26. Linear adds or sets a linear trendline for the selected chart series
27. Exponential adds or sets a curved exponential trendline for the selected chart series
28. Linear Forecast Adds or sets a linear trendline with a two-period forecast for the selected
chart
series
29. Two-period Mov- Adds or sets a two-period moving average trendline fro the selected chart
ing Average
series
30. Sparklines small charts embedded into cells on a spreadsheet, providing a way to
graphically summarize a row or column of data in a single cell with a
2/
12
ACCURATE COMPLETE SOLUTIONS
1. Data Visualiza- The graphical presentation of data with a focus on qualitative understanding.
tion
2. Data Series a group of related values to be charted
3. Data Point individual data value in a data series
4. Embedded Chart exists as an object located on the same worksheet with the data
5. Chart Sheet A special worksheet that is dedicated to displaying chart objects
6. Quick Analysis This tool appears when you slect data in a worksheet and otters single-click
access to formatting, charts, formulas, PivotTables, and sparklines.
7. Recommende feature quickly analyzes a selection in a worksheet and recommends
d Charts
chart types that best fit the data.
8. Analyze Data A feature in Excel that analyzes data with visual summaries, patterns, and
trends.
9. Column Charts used to compare data across categories and show change, sometimes
over time.
10. Pie Chart displays a comparison of each value to a total
11. Line Charts help to convey change in data over time
12. Bar Charts Display data horizontally and are used for comparison among individual
items
13. Stacked Be useful when you want to see how the individual parts add up to
Bar Charts
create the entire length of each bar
14. Scatter Chart Also called XY (scatter), is a chart that conveys the relationship between two
numeric variables
15. Area Chart a variation of a stacked line chart that emphasizes the magnitude of
change over time and visually depicts a trend.
1/
12
,BUS 1350 ANCIRA EXAM 2 QUESTIONS &
ACCURATE COMPLETE SOLUTIONS
16. Combinatio Displays two ditterent types of data by using multiple chart types in a single
n Chart
chart object.
17. Sunburst Chart can be used to display hierarchical data
18. Number Format data as currency, date, time, and so on
19. Fill Fill the background of an element with a color, picture, or pattern
20. Shape Outline Set the color and thickness of the chart border
21. Shape effects Add shadowing, reflections, glow, soft edges, bevel, and 3-D rotations to
chart
elements
22. Alignment Align Text direction for a component, such as left, top, vertical, or horizontal
23. Legend is an index within a chart that provides information about the data
24. Chart Gridlines the lines that go across charts to help gauge the size of the bars, columns,
or data lines
25. Trendline a line that uses current data to show a trend or general direction of the
data.
26. Linear adds or sets a linear trendline for the selected chart series
27. Exponential adds or sets a curved exponential trendline for the selected chart series
28. Linear Forecast Adds or sets a linear trendline with a two-period forecast for the selected
chart
series
29. Two-period Mov- Adds or sets a two-period moving average trendline fro the selected chart
ing Average
series
30. Sparklines small charts embedded into cells on a spreadsheet, providing a way to
graphically summarize a row or column of data in a single cell with a
2/
12
