Exam 9: Analyzing and Charting Financial Data

A ____________ displays data values as columns with the height of each column based on the data value.

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

Excel supports ____________________ types of charts into 10 categories..

By default, Excel inserts a chart as an embedded chart. _________________________

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. -Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart.

You can add ___________________ to identify smaller intervals between the major tick marks.

A watermark can be inserted into the header or footer of a worksheet. _________________________

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

To compare values from several categories with a sequential order, such as dates and times occurring at evenly spaced intervals, you would use a(n) ____________________ chart.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

To add and remove chart elements, you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

To resize an embedded chart, ____.

Mya has just surveyed 100 students to get their reaction to a new textbook she is reviewing. She has one data series that she wants to represent graphically, and she needs to display her data in a way that lets her visually compate the data values and see how much contributes to the whole. -Since it's important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya?

Generally, _____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

Since scientific data is often plotting two numeric values against one another, it is oftentimes best to represent this data type with a(n) ____________________ chart.

-The columns and pie slices in the charts above are ____.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values. Often used in scientific studies and statistical analyses.

Interest is the amount added to the principal by the lender. _________________________

Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format. -Simon wants to change the chart's border. To do this, he should select the CHART TOOLS ____ tab.

A pie slice is a data marker that represents ____ from a data series.