Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

C

  -Referring to the figure above, in the column chart, the values along the left side ($200,000, $400,000, $600,000, etc.)  are ____. A)  plot markers B)  plot marks C)  data markers D)  axis labels -Referring to the figure above, in the column chart, the values along the left side ($200,000, $400,000, $600,000, etc.) are ____.


A) plot markers
B) plot marks
C) data markers
D) axis labels

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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 ____.


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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

D

____ is the amount added to the prinicpal of a loan by the lender.


A) Rate
B) Simple
C) Interest
D) Maximum

Correct Answer

verifed

verified

Consider the impact of a poorly designed chart. Explain why it is important to have a well-designed chart, and name at least four tips for creating a good chart.

Correct Answer

verifed

verified

Answers will vary. Students should cover...

View Answer

An _______ chart takes up less space than a chart sheet.

Correct Answer

verifed

verified

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.

Correct Answer

verifed

verified

A chart that compares three set of values in a three-dimensional chart is _____.


A) Stock
B) Radar
C) Surface
D) Scatter

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Interest is the amount of money being loaned.

Correct Answer

verifed

verified

You can move a chart from one worksheet to another, or you can place the chart in its own chart sheet.

Correct Answer

verifed

verified

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares a collection of values from several different data sets.


A) Scatter
B) Column
C) XY
D) Line
E) Radar
F) Pie
G) Stock
H) Bar
I) Surface
J) Area

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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 ______.


A) select the chart
B) hold down the SHIFT key
C) adjust the sizing handles
D) move the mouse pointer to the center of the chart.

Correct Answer

verifed

verified

  -In the figure above, the biggest slice is the cases of _______. A)  Riesling B)  Chardonnay C)  Pinot Grigio D)  Ruby Cabernet -In the figure above, the biggest slice is the cases of _______.


A) Riesling
B) Chardonnay
C) Pinot Grigio
D) Ruby Cabernet

Correct Answer

verifed

verified

A chart sheet can contain ____.


A) only one chart
B) one or two charts
C) one to four charts
D) one to six charts

Correct Answer

verifed

verified

A

The range of values, or ___________________, of an axis is based on the values in the data source.

Correct Answer

verifed

verified

  -Referring to the figure above, the chart title for the pie chart is ____. A)  Estimated Production B)  Projected Revenue and Expenses C)  Total Revenue D)  Production -Referring to the figure above, the chart title for the pie chart is ____.


A) Estimated Production
B) Projected Revenue and Expenses
C) Total Revenue
D) Production

Correct Answer

verifed

verified

Showing 1 - 20 of 100

Related Exams

Show Answer