Excel Module 04: Analyzing and Charting Financial Data
A _____ contains the actual values that are ploted on the chart. a. data source b. data series c. category values d. legend
B
To add and remove chart elements, you can use the Add Chart element button in the Charts Layout group on the ____________ tab. a. CHART TOOLS LAYOUT b. CHART TOOLS DESIGNS c. INSERT d. HOME
B
A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value? true or false
False
Interest is the amount of money being loaned.
False
Line charts are best suited for representing data that follows some nonsequential order. true or false
False
Pie charts are most effective with ten or fewer slices? true or false
False
Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. true or false
False
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. true or false
False
When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. True or false
False
You can quick change the appearance of the entire chart by selecting a different chart style in the Chart Design? true or false
False
A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value. true or false
True
By default, Excel inserts a chart as an embedded chart? true or false
True
Each slice in a pie chart represents a single value from a data series. true or false
True
Every chart contains elements that can be formatted, added to the chart, or removed from the chart. true or false
True
Excel charts are either placed in their own chart sheets or embedded in a worksheet. True or false
True
In a line chart, the data markers are the points connected by the line. true or false
True
Interest is the amount added to the principal by the lender? true or false
True
You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet. true or false
True
A chart sheet can contain ____. a. only one chart b. one or two charts c. one to four charts d. one to six charts
a
A pie slice is a data marker that represents ______ from a data series. a. only one value b. at least one value c. no more than three values d. no more than five values
a
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 ______. a. select the chart b. hold down the SHIFT key c. adjust the sizing handles c. move the mouse pointer to the center of the chart
a
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, nper stands for the ____. a. total number of payment periods b. total number of payments that have already been made c. number of payments per year d. number of interest payments per year
a
Simon wants to change the chart's border. To do this, he should select the CHART TOOLS ______ tab. a. FORMAT b. EDIT c. DESIGN d. LAYOUT
a
The ______ is the only one of the following charts to compare relative values from different categories to the whole. a. pie b. column c. line d. area
a
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. a.clustered column chart b. stacked column chart c. 100 % stacked column chart d. column chart
a
The range of values or ______, of an axis is based on the values in the data source. a. scale b. defined range c. series d. length
a
To resize an embedded chart, ________. a. select the chart and drag the corner sizing handle of the selection box b. right click the chart and then click Resize on the shortcut menu c. select the chart and press Tab d. both a and b
a
When combination charts have data series with vastly different values, you can create ____ charts. a. dual axis b. secondary c. multivalued d.multiple axis
a
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. a. Change Chart Type b. New Chart c. Alter Existing Chart d. Modify Chart
a
You can choose Center, Inside End, Outside end, or Best Fit for the data label positions in the ______ pane. a. format Data Labels b. Format Legend c. Format Chart Area d. Format Axis
a
Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____. a. line chart b. exploded pie chart c. scatter chart d. banded chart
b
PMT(rate, nper, pv [, fv=0] [, type=0]) The possible values for the type argument in the function above are. a. 0 or null b. 0 or 1 c. 0,1, or 2 d.0, 1, 2, or 3
b
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 ____. a. paste her chart in as a picture. b. do nothing since charts in Excel remain linked to data sources c. manually adjust data in a chart d. create a new chart each time she modifies her data
b
Sometimes Mya might want to see information on only specific slices. Rather than crating a new chart that includes only those selections, she can _______ an existing chart. a. search b. filter c. find d. examine
b
The FV function stands for ________> a. function value b. future value c. financial value d. formulated value
b
The ______ CHART TOOLS contextual tabs appear on the Ribbon when you select a start. a. INSERT and DESIGN b. DESIGN and FORMAT c. INSERT and FORMAT d. FORMAT and PRINT
b
The amount of money being loaned is known as the ____. a. mortgage b. principal c. loan amount d. proposed principal
b
To reposition the legend to the left-hand side of a chart, click the ______ button, point to Legend, click the right arrow icon, and click Left. a. legend b. Chart elements c. Formatting d. Layout
b
Which of the following shows the correct order of steps for adding a data series to a chart? a. Select the chart, Click the Add button, Click the Select Data button, Select the range b. Select the chart, Click the Select Data button, click the Add button, Select the range c. Select the range, Click the Select Data button, click the Add button, Select the chart d. Select the range, Select the chart, Click the Select Data button, Click the Add button
b
it's difficult to read the exact scale on some of simon's data. Adding ______ would make it easier to read. a. a legend b.major tick marks c. colors d. more numbers
b
A chart that compares three set of values in a three-dimensional chart is __________. a. Stock b. Radar c. Surface d. Scatter
c
Category values are usually located in the ____ of the data source. a. first row b. first column c. either a or b d. neither a or b.
c
Mya has asked for your advise. 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? a. Resize the legend to be as tiny as possible b. Remove the data from the legend. c. Overlay the legend on a part of the chart that's empty. d. You agree with the colleague; Mya should remove the legend
c
PMT(rate, nper, pv [, fv=0] [, type=0]) In the figure above, pv stands for the _____. a. payments verified b. principal value of the loan c. present value of the loan d. primary interest rate of the loan
c
The __________ dialog box provides options for moving charts between worksheets and chart sheets. a. Insert New b. Tab c. Move Chart d. Change Chart
c
To move one slice of a pie chart away from the pie creates a(n) _____. a. spontaneous pie chart b. perfect pie chart c. exploded pie chart d. exponential pie chart
c
_____ is the amount added to the principal of a loan by the lender. a. Rate b. Simple c. Interest d. Maximum
c
________ provide descriptive text for the individual data markers, such as pie slices. a. Asset labels b. Legend values c. data labels d. Leader lines
c
Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements—chosen because they look "nice"—confuse and distract the reader. a. espionage b. clutter c. confusion d. junk
d
Excel supports all of the following types of sparklines EXCEPT ____. a. A win/loss sparkline for highlighting positive and negative values. b. A column sparkline used for column charts c. a line sparkine for highlighting trends d. a true/false sparkline for help making decisons
d
PMT(rate, nper, pv [, fv=0] [, type=0]) In the above figure fv and type are ______. a. financial functions b. required arguments c. comparison operators d. optional arguments
d
Placing a chart in a ____ displays only the chart and no worksheet cells. a. new worksheet b. tabbed view c. graph display d. chart sheet
d
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? a. Delete parts of the data b. Delete the legend c. Delete the title d. Overlay the legend in areas without data
d
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? a. bar b. column c. scatter d. pie
d
The _____ identifies which data markers are associated with each data series. a. x-axis b. y-axis c. chart area d. legend
d
To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab. a. CREATE b. VIEW c. LAYOUT d. DESIGN
d
Combination charts enable you to show three sets of data using the chart type that is best for each data set. true or false
false
In pie charts, it's best to make the slice colors as similar as possible. true or false
false
The PMT function calculates the payment required in each period to pay back the loan? true or false
true
