Exam 4: Analyzing and Charting Financial Data

You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

The possible values for the type argument in the function above are.

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?

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.

Placing a chart in a ____ displays only the chart and no worksheet cells.

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

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. -Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Often used to show trends and changes over time

Excel supports ____________________ types of charts into 10 categories..

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. -It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

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

By default,Excel inserts a chart as an $\underline { \text { embedded } }$ chart._________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Similar to a Scatter 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 Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart $\underline { \text { Design } }$ gallery._________________________

A $\underline { \text { watermark } }$ can be inserted into the header or footer of a worksheet._________________________

Describe the some of the concepts and definitions associated with loans before using a PMT function.

Each slice in a pie chart represents a single value from a data series.