BUS 1350 Ancira Exam 2 | Baylor University | UPDATED
Questions with 100% Verified Answers
Q1: Data Visualization
A: The graphical presentation of data with a focus on qualitative understanding.
Q2: Data Series
A: a group of related values to be charted
Q3: Data Point
A: individual data value in a data series
Q4: Embedded Chart
A: exists as an object located on the same worksheet with the data
Q5: Chart Sheet
A: A special worksheet that is dedicated to displaying chart objects
Q6: Quick Analysis
A: This tool appears when you slect data in a worksheet and offers single-click access to
formatting, charts, formulas, PivotTables, and sparklines.
Q7: Recommended Charts
A: feature quickly analyzes a selection in a worksheet and recommends chart types that
best fit the data.
Q8: Analyze Data
A: A feature in Excel that analyzes data with visual summaries, patterns, and trends.
Q9: Column Charts
A: used to compare data across categories and show change, sometimes over time.
Q10: Pie Chart
A: displays a comparison of each value to a total
Q11: Line Charts
A: help to convey change in data over time
Q12: Bar Charts
, A: Display data horizontally and are used for comparison among individual items
Q13: Stacked Bar Charts
A: Be useful when you want to see how the individual parts add up to create the entire
length of each bar
Q14: Scatter Chart
A: Also called XY (scatter), is a chart that conveys the relationship between two numeric
variables
Q15: Area Chart
A: a variation of a stacked line chart that emphasizes the magnitude of change over time
and visually depicts a trend.
Q16: Combination Chart
A: Displays two different types of data by using multiple chart types in a single chart object.
Q17: Sunburst Chart
A: can be used to display hierarchical data
Q18: Number
A: Format data as currency, date, time, and so on
Q19: Fill
A: Fill the background of an element with a color, picture, or pattern
Q20: Shape Outline
A: Set the color and thickness of the chart border
Q21: Shape effects
A: Add shadowing, reflections, glow, soft edges, bevel, and 3-D rotations to chart elements
Q22: Alignment
A: Align Text direction for a component, such as left, top, vertical, or horizontal
Q23: Legend
A: is an index within a chart that provides information about the data
Q24: Chart Gridlines
A: the lines that go across charts to help gauge the size of the bars, columns, or data lines
Questions with 100% Verified Answers
Q1: Data Visualization
A: The graphical presentation of data with a focus on qualitative understanding.
Q2: Data Series
A: a group of related values to be charted
Q3: Data Point
A: individual data value in a data series
Q4: Embedded Chart
A: exists as an object located on the same worksheet with the data
Q5: Chart Sheet
A: A special worksheet that is dedicated to displaying chart objects
Q6: Quick Analysis
A: This tool appears when you slect data in a worksheet and offers single-click access to
formatting, charts, formulas, PivotTables, and sparklines.
Q7: Recommended Charts
A: feature quickly analyzes a selection in a worksheet and recommends chart types that
best fit the data.
Q8: Analyze Data
A: A feature in Excel that analyzes data with visual summaries, patterns, and trends.
Q9: Column Charts
A: used to compare data across categories and show change, sometimes over time.
Q10: Pie Chart
A: displays a comparison of each value to a total
Q11: Line Charts
A: help to convey change in data over time
Q12: Bar Charts
, A: Display data horizontally and are used for comparison among individual items
Q13: Stacked Bar Charts
A: Be useful when you want to see how the individual parts add up to create the entire
length of each bar
Q14: Scatter Chart
A: Also called XY (scatter), is a chart that conveys the relationship between two numeric
variables
Q15: Area Chart
A: a variation of a stacked line chart that emphasizes the magnitude of change over time
and visually depicts a trend.
Q16: Combination Chart
A: Displays two different types of data by using multiple chart types in a single chart object.
Q17: Sunburst Chart
A: can be used to display hierarchical data
Q18: Number
A: Format data as currency, date, time, and so on
Q19: Fill
A: Fill the background of an element with a color, picture, or pattern
Q20: Shape Outline
A: Set the color and thickness of the chart border
Q21: Shape effects
A: Add shadowing, reflections, glow, soft edges, bevel, and 3-D rotations to chart elements
Q22: Alignment
A: Align Text direction for a component, such as left, top, vertical, or horizontal
Q23: Legend
A: is an index within a chart that provides information about the data
Q24: Chart Gridlines
A: the lines that go across charts to help gauge the size of the bars, columns, or data lines
