Quiz
Exam 2 Tutorial 4
Dieses Quiz enthält Fragetypen, die sich im gewohnten Player öffnen.
Fragen in diesem Quiz (35)
1The [blank_start]PMT[blank_end] function can be used to calculate the payment schedule required to completely repay a
mortgage or other type of loan.- APMT
2 _______ is the amount of money being loaned?
- AA. Principal
- BB. Interest
- CC. Future value
- DD. Payment
3Each chart must have a(n) [blank_start]data source[blank_end].
- Adata source
4Which chart compares relative values of different categories to the whole?
- Aa. Column chart
- Bb. Pie chart
- Cc. Bar chart
- Dd. Line chart
5What is an embedded chart? What are the advantages and disadvantages of the embedded chart?
(Answer: By default, [blank_start]a chart is inserted as an embedded chart[blank_end], which means the chart is placed in a
worksheet next to its data source. The advantage of an embedded chart is that you can display the chart
alongside any text or figures that can explain the chart’s meaning and purpose. A disadvantage is that an
embedded chart covers worksheet cells, which might contain data and formulas.)- Aa chart is inserted as an embedded chart
6What is a chart style? (Answer: A chart style is [blank_start]similar to a cell style or a table style[blank_end] in that it formats
several chart elements at one time. You can change the color and appearance of the slices by selecting a
different chart style from the Chart Styles gallery on the Chart Tools Design tab.)- Asimilar to a cell style or a table style
7The ____ provides a description of the chart.
- AA. chart legend
- BB. chart title
- CC. data labels
- DD. chart location
8A pie slice is an example of a _______.
- AA. legend
- BB. chart title
- CC. data marker
- DD. data label
9True/False: The color of pie slices can be changed.
- ARichtig
- BFalsch
10The ____ specifies the worksheet cells that contain the data on which the chart will be based.
- Aa. chart type
- Bb. chart options
- Cc. chart source data
- Dd. chart location
11One type of what-if analysis that limits the data to a subset of the original values is a process called
[blank_start]filtering[blank_end].- Afiltering
12 Excel uses [blank_start]chart animation[blank_end] to slow down the effect of changing data source values, making it easier to see
how changing one value affects the chart.- Achart animation
13 A column chart turned on its side is called a(n) [blank_start]bar chart[blank_end].
- Abar chart
14True/False: The process for creating a column chart is the same as for creating a pie chart.
- ARichtig
- BFalsch
15True/False: Leader lines can be added to labels placed outside the slices to connect them to their
corresponding slices.- ARichtig
- BFalsch
16 True/False: Charts remain linked or connected to their data sources, even if they appear in different
worksheets.- ARichtig
- BFalsch
17 True/False: If you change any values or labels in the data source, the chart must be manually updated
to show the new content.- ARichtig
- BFalsch
18 The [blank_start]vertical[blank_end], or value, axis displays the values associated with the heights of each column.
- Avertical
19 The [blank_start]horizontal[blank_end], or category, axis displays the categories associated with each data value.
- Ahorizontal
20 True/False: A bar chart compares values from different categories.
- ARichtig
- BFalsch
21 True/False: A line chart is often used to show trends and changes over time.
- ARichtig
- BFalsch
22True/False: A line chart can be used with more than one data series.
- ARichtig
- BFalsch
23 True/False: The range of values, or scale, of an axis is based on the values in the data source.
- ARichtig
- BFalsch
24True/False: Minor tick marks identify the main units on the chart axis.
- ARichtig
- BFalsch
25True/False: The Select Data Source dialog box lists all of the data series displayed in the chart.
- ARichtig
- BFalsch
26 True/False: In a line chart, the data markers are the points connected by the line.
- ARichtig
- BFalsch
27 True/False: Changes to the plot area are often made in conjunction with the chart area.
- ARichtig
- BFalsch
28True/False: You can format the plot area by changing its fills and borders, and by adding visual
effects.- ARichtig
- BFalsch
29A(n) [blank_start]axis title[blank_end] is descriptive text that appears next to the axis.
- Aaxis title
30 True/False: You can modify the data source to specify which ranges should be treated as category
values and which ranges should be treated as data values.- ARichtig
- BFalsch
31 True/False: You can edit the data source in the Edit Data Source dialog box.
- ARichtig
- BFalsch
32A [blank_start]sparkline[blank_end] is a mini chart that is displayed within a worksheet cell.
- Asparkline
33 A [blank_start]data bar[blank_end] is a conditional format that adds a horizontal bar to the background of a cell containing a
numeric value.- Adata bar
34True/False: A watermark is text or an image that appears in front of other content.
- ARichtig
- BFalsch
35True/False: Watermarks are only visible in Normal view.
- ARichtig
- BFalsch
Informationen
- Beschreibung
- 2610 BCIS Quiz am Exam 2 Tutorial 4, erstellt von Chris Serrano am 30/10/2015.
- Autor
- Chris Serrano
- Sprache
- English
- Aufrufe
- 0
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz