WorksheetsWorking with Charts in Excel (Chapter 7)
Total questions: 83
Worksheet time: 42mins
What does the graphic feature of Excel allow you to do?
Delete data
Display workbook information in an easy-to-interpret format
Print documents
Save files
What do charts summarize?
File names
The essence of data to focus on general patterns and trends
Printer settings
User preferences
What is a chart sometimes referred to as?
A table
A graph
A formula
A function
What is a chart a picture of?
Text data
Numeric data
Images
Videos
What does Excel use to create charts?
Random data
Data you select
External files
Templates only
What can guide you through creating a chart step-by-step?
Chart Helper
Chart Assistant
Chart Wizard
Chart Guide
What determines which cells are used for the category axis?
File size
The orientation of the data
The number of worksheets
The font size
Where are category axis labels typically located?
At the top
Along the bottom or x-axis
On the right side
In the center
What can you do if Excel's automatic chart rules don't fit your data?
Cannot create a chart
Manually change the chart by specifying your own parameters
Restart Excel
Delete the data
Where can charts be embedded?
Only in a worksheet
Only in a separate file
In a worksheet or its own chart sheet
Only in the formula bar
What happens to a chart when the data from which it was created changes?
The chart is deleted
The chart remains unchanged
The chart is automatically updated
The chart must be recreated
What is a data series?
A single cell
A collection of data points
A chart title
A worksheet name
What is a legend in a chart?
A title
A guide that explains symbols, patterns, or colors used to differentiate data series
A data point
An axis
What is used as a legend title?
The worksheet name
The file name
The name of each data series
The date
What is a marker in a chart?
A label
An object that represents a data point
A title
A formula
What are examples of markers?
Formulas and functions
Bars, symbols, and colors
Worksheets and workbooks
Files and folders
What appears when you move your mouse over an object in a chart?
An error message
A tip that identifies the chart object
A menu
A dialog box
What do axes form in a chart?
The title
The legend
The boundaries of the chart
The data points
What does an axis contain?
Colors
The scale against which data plots
Text only
Images
What does the Chart Wizard button do?
Deletes charts
Starts the Chart Wizard to guide you through chart creation
Prints charts
Saves charts
What is a data point?
A collection of data
A single piece of data, such as sales for one year
A chart title
A worksheet
What is the plot area?
The entire worksheet
The rectangular area bounded by the two axes
The legend
The title
What is a series formula?
A regular formula
An external formula that tells Excel where to find data for a chart
A function
A calculation
What is a tick mark?
A chart title
A division mark along the axes
A data point
A legend
How many standard chart types does Excel have?
10
11
12
14
What do many chart types have?
Only 2-D versions
3-D sub-types
No variations
Only one format
Why are 3-D sub-types used?
To save space
To add visual depth and impact to data presentation
To reduce file size
To hide data
What type of data can be plotted in a column chart?
Only text data
Data arranged in columns or rows on a worksheet
Only dates
Only formulas
What are column charts useful for?
Deleting data
Showing data changes over time or comparisons among items
Printing documents
Saving files
In column charts, where are categories typically organized?
Along the vertical axis
Along the horizontal axis
In the legend
In the title
In column charts, where are values organized?
Along the horizontal axis
Along the vertical axis
In the title
Outside the chart
What do clustered column charts compare?
Files
Values across categories
Worksheets
Formulas
How do clustered column charts display values?
In horizontal bars
In 2-D vertical rectangles
In circles
In lines
What do stacked column charts show?
Individual values only
The relationship of individual items to the whole
Text data
File names
When is a stacked column chart more useful?
With single data series
With multiple data series when emphasizing the total
With no data
With text only
What do 100% stacked column charts compare?
File sizes
The percentage each value contributes to a total
Worksheet names
Cell addresses
When should you use a 100% stacked column chart?
With one data series
With three or more data series
With no data
With text only
What shapes can cylinder, cone, and pyramid charts display?
Only rectangles
Cylinder, cone, and pyramid shapes
Circles
Triangles
What type of data can be plotted in a line chart?
Only single values
Data arranged in columns or rows on a worksheet
Only text
Only dates
What can line charts display?
Static data
Continuous data over time
Text only
Images
What are line charts best for?
Comparing individual items
Showing trends in data at equal intervals
Displaying percentages
Showing text data
How is data distributed in a line chart?
Randomly
Category and value data are distributed evenly along axes
Only vertically
Only horizontally
When should you use a line chart?
For random data
When category labels represent evenly spaced values
For text data only
Never
What are examples of evenly spaced values for line charts?
Random numbers
Days, months, quarters, or years
Names
Colors
Can line charts be displayed with markers?
No, never
Yes, with or without markers
Only with markers
Only without markers
When should markers not be used in line charts?
Always use markers
When there are many categories or values are approximate
When there is one data point
Never avoid markers
What do stacked line charts show?
Individual values only
The trend of contribution of each value over time
Text data
File names
What do 100% stacked line charts show?
Absolute values
The trend of the percentage each value contributes over time
Text only
File sizes
What do 3-D line charts show?
Flat lines
Each row or column of data as a 3-D ribbon
Text data
Single points
How much data can be plotted in a pie chart?
Multiple columns or rows
Only one column or row on a worksheet
What do pie charts show?
Trends over time
The size of items in one data series
Multiple series comparisons
Text data
How are data points displayed in a pie chart?
As absolute values
As a percentage of the whole pie
As text
As dates
What do pie charts display?
Multiple series
The contribution of each value to a total
Trends over time
Comparisons among many items
What are pie of pie charts useful for?
Showing many large values
Making small slices in the main pie easier to see
Displaying text
Comparing time periods
What can be done to wedges in pie charts?
Nothing
They can be "exploded" or pulled out from the pie
They can be deleted only
They can be hidden only
Why would you explode a slice in a pie chart?
To delete it
To emphasize the data point it represents
To hide it
To print it
How do you select an individual slice in a pie chart?
Single-click only
Click once to select the whole chart, then click again for individual slice
Double-click
Right-click only
What type of data can be plotted in a bar chart?
Only single values
Data arranged in columns or rows
Text only
Images only
What do bar charts show?
Trends over time
Comparisons among individual items
Percentages only
Text data
What type of data can be plotted in an area chart?
Single values only
Data arranged in columns or rows
Text only
No data
What do area charts highlight?
Individual values
The magnitude of change over time
Text differences
File names
What do area charts draw attention to?
Individual points
The total value across a trend
Labels only
Colors only
What can be plotted in an XY (scatter) chart?
Only text
Data arranged in columns and rows
Images
No data
What do scatter charts show?
Text relationships
Relationships among numeric values in several data series
File sizes
Worksheet names
How many value axes does a scatter chart generally have?
One
Two
Three
Four
What types of data are scatter charts commonly used for?
Text data
Scientific, statistical, and engineering data
Images
Audio files
When should you consider using a scatter chart?
When values are evenly spaced
When values for horizontal axis are not evenly spaced
For text data
Never
When else should you use a scatter chart?
For few data points
When there are many data points on the horizontal axis
For text only
For single values
How should you arrange data for a scatter chart?
Randomly
Place x values in one row or column, y values in adjacent rows or columns
All in one cell
In separate worksheets
What is similar to a pie chart but can show more than one data series?
Bar chart
Doughnut chart
Line chart
Column chart
What are other types of charts available in Excel?
Circle and square charts
Radar and surface charts
Triangle charts
Diamond charts
What other chart types are available?
Text charts
Bubble and stock charts
Image charts
Audio charts
What is the first step in creating a chart?
Save the file
Select the data you want to chart
Print the worksheet
Close other files
What should you include when selecting data for a chart?
Only numbers
Row and column headings if you want them in the chart
Only text
Nothing
After selecting data, which tab do you choose?
Home
Insert
View
File
Where is the chart selection located?
In the Editing group
In the Chart group
In the Font group
In the Alignment group
What key creates a chart automatically?
F1
F11
F12
F10
What is the alternative key if you don't have F11?
Ctrl+F1
Alt+F1
Shift+F1
Alt+F11
What is the default chart type Excel uses?
Pie chart
2-D column chart
Line chart
Bar chart
When does Excel assume category labels run across the top row?
Always
If selection is square or wider than tall
If selection is taller than wide
Never
When does Excel assume category labels run down the left column?
Always
If selection is taller than wide
If selection is square
Never
When is a chart automatically updated?
Never
When a worksheet value is changed
Only when manually updated
Only when printed
When might you need to change graph settings?
Never
When X and/or Y axis data range is increased or decreased
Every time you open the file
Only on Mondays
