Excel Lesson 6
Six
By default, how many chart types buttons are offered in Charts group?
Select the cart and choose Print from the File tab
How do you print only an embedded chart?
Embedded Chart
In Excel 2010, which term refers to a chart created on the same worksheet as the data?
Chart
In Microsoft Excel 2010, which is a graphical representation of data that is created from information in a workbook?
Y-axis
In a chart, what data that appears along the vertical scale of the chart called?
X- Axis
In a chart, what is data that appears along the horizontal scale of the chart called?
Change the data on the corresponding worksheet, and the chart will automatically be updated.
Since cells in a chart are linked to the data in the worksheet, how would you update data on a chart?
New sheet or Object in
What 2 options are offered when a user elects to move a chart?
Column
What chart would be used to compare data as separate items that very over time?
Trendline
What graphically represents changes in a data series over time?
Chart Location
What is the name of the zone on the worksheet where the chart appears?
Numeric Data and Titles
What is typically included in the range of data selected to create a chart?
Insert
What ribbon contains the command for creating charts in Excel 2010?
Insert Ribbon
What ribbon contains the commands used to create a chart in Excel?
Insert ribbon
What ribbon is used to create charts in a workbook?
Exploded
What term refers to an Excel chart with offset pieces?
Pie
What type of chart would be use to show proportions of a part of a whole?
Layout
Which chart tools ribbon allows a user to insert various labels on the chart?
Design
Which chart tools ribbon tab allows a user to select from a gallery of chart styles?
Layout
Which chart tools ribbon tab enables a user to add pictures, shapes, or text boxes to a chart area?
Format
Which chart tools ribbon tab enables a user to apply a shape and Word-Art style to the selected chart?
Switch Row/Column
Which command on the chart tools ribbon do you use to swap data over the axis in a chart?
Format Chart Area
Which dialog box contains the commands to rotate the chart areas on 3-D charts?
Error Bars
Which is a graphical representation used in statistical or scientific data show the degree of uncertainty relative to each data marker in a series?
Sparkline
Which is a tiny chart that provides a visual representation of data in a worksheet cell?
Chart Tools Design
Which ribbon is available when a chart is selected and attempting to delete-chart labels?
Chart Tools Design
Which ribbon is available when a chart is selected and enables the user to customize the style and layout of the chart?
