DA QUIZ CH 7
d) A chart that appears as an object will print on a single sheet of paper in landscape orientation if the chart is selected before selecting File > Print.
True
f) Bar charts are useful for comparing the differences between values.
True
13. List the steps required to modify a chart to include an additional adjacent series of data.
1. Click Design > Select Data. 2. Select the data range from the worksheet. 3. Select OK
12. a) What do the axes titles describe?
The axes titles describe the data.
What does a legend correspond to?
The legend corresponds to category labels.
e) An Excel chart that is a linked object in a Word document can be edited in Word using the Design, Layout, and Format tabs.
true
c) List the steps required to size a chart proportionately.
1. Point to a corner handle. 2. Drag to size the chart proportionately.
7. a) List the steps required to print a chart that is stored on the same sheet as the charted data.
1. Select File > Print. 2. If necessary, adjust the page layout. 3. Select Print.
b) List the steps required to print a chart that is stored on the same sheet as the charted data so that only the chart is printed.
1. Select the chart. 2. Select File > Print > Print.
c) the number of full-time, part-time, and temporary employees in a company.
A bar Chart
List the two locations a chart can be placed.
A chart can be placed as an object in a worksheet as shown on the previous page or as a separate sheet in a workbook.
Explain how charts can simplify the understanding of numeric data.
A chart can enhance and simplify the understanding of numerical data in a worksheet because the relationship between data is illustrated.
10. In Excel, what is a vertical bar chart called?
A column chart.
d) Why should a corner handle be used to size a chart?
A corner handle should be used to size a chart proportionately.
11. What type of chart (bar, line, or pie) is best suited to display: a) a student's GPA over four years.
A line chart.
d) the number of books sold each day for a month at the college bookstore.
A line chart.
b) the percentage each department spent of a company's total budget.
A pie Chart
9. a) What is the difference between embedding a chart and linking a chart?
An embedded chart is static. The chart will not automatically change if the worksheet does. A linked chart will update automatically whenever the chart is updated in Excel.
b) Describe a situation where it would be advantageous to link a chart in a Word document to the Excel source chart.
Answers will vary. One situation would be when monthly update memos need to be printed and reviewed.
14. Describe the changes that will occur to a pie chart if the theme is changed from Office to Metro.
Changing the theme will change the fonts, colors, and effects associated with both the chart and the corresponding worksheet.
8. Why would a chart be included in a report?
Charts are often included in reports and other business documents to support and simplify the understanding of the text.
k) A Bubble chart compares sets of five values.
False. A Bubble chart compares sets of three values.
g) Pie charts have axes.
False. Bar and line charts have axes.
l) Pie charts have a chart wall.
False. Only certain chart types, such as column, have a chart wall.
b) Pie charts are best for showing differences of data over time.
False. Pie charts are best for charting data that is a percentage of a whole.
c) The data range for a chart always includes all of the data on the worksheet.
False. The data range can include any range of data on a worksheet.
m) The vertical axis on a column chart must start at the value zero.
False. The vertical axis can be changed to start at a specified value.
How will a chart be affected if a value in a data range is changed on the worksheet?
If a value or label in the data range is changed, the chart automatically updates.
b) How are the vertical axis labels calculated?
The vertical axis labels are calculated by Excel based on the maximum value in the data.
How many categories are in the data charted on the first page of this chapter?
There are six categories in the data charted on the first page of this chapter.
Explain how to change data labels from actual values to percentages.
To change the labels to percentages, select the data labels and click Layout > Format Selection. The Format Data Labels dialog box is displayed. Select the Percentage check box and clear the Value check box.
b) How is a chart moved on a worksheet?
To move a chart, drag a chart border.
15. a) If a value in a data series changes, the corresponding chart will automatically update.
True
h) A chart in a report should contain formatting that complements the report.
True
i) Each chart type has at least one sub-type.
True
j) A Surface chart shows trends in values.
True
n) Sparklines are displayed in a single cell.
True
6. a) What happens to the corresponding data series and labels when a chart is selected?
When a chart is selected, the corresponding data series and labels are outlined in color on the worksheet.