Exam 4: Analyzing and Charting Financial Data

Case 4-2 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 has asked for your advice.A colleague told her to remove the legend from her pie chart because it takes up too much space.What would be a better piece of advice to give Mya? 

Case 4-2 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? _____ 

Case 4-1 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 has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data? 

The cell with the largest value contains a data marker that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

To resize an embedded chart,____.

Each value from a data series is represented by a ________.

Case 4-1 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.

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

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.

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

When combination charts have data series with vastly different values,you can create ____ charts.

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

Case 4-2 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 has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.___________ 

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

The FV function stands for ____.

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

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.

A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.___________