Quiz
Exam 2 Tutorial 4
This quiz has question types that open in the usual player.
Questions in this 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.
- ATrue
- BFalse
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.
- ATrue
- BFalse
15True/False: Leader lines can be added to labels placed outside the slices to connect them to their
corresponding slices.- ATrue
- BFalse
16 True/False: Charts remain linked or connected to their data sources, even if they appear in different
worksheets.- ATrue
- BFalse
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.- ATrue
- BFalse
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.
- ATrue
- BFalse
21 True/False: A line chart is often used to show trends and changes over time.
- ATrue
- BFalse
22True/False: A line chart can be used with more than one data series.
- ATrue
- BFalse
23 True/False: The range of values, or scale, of an axis is based on the values in the data source.
- ATrue
- BFalse
24True/False: Minor tick marks identify the main units on the chart axis.
- ATrue
- BFalse
25True/False: The Select Data Source dialog box lists all of the data series displayed in the chart.
- ATrue
- BFalse
26 True/False: In a line chart, the data markers are the points connected by the line.
- ATrue
- BFalse
27 True/False: Changes to the plot area are often made in conjunction with the chart area.
- ATrue
- BFalse
28True/False: You can format the plot area by changing its fills and borders, and by adding visual
effects.- ATrue
- BFalse
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.- ATrue
- BFalse
31 True/False: You can edit the data source in the Edit Data Source dialog box.
- ATrue
- BFalse
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.
- ATrue
- BFalse
35True/False: Watermarks are only visible in Normal view.
- ATrue
- BFalse
Information
- Description
- 2610 BCIS Quiz on Exam 2 Tutorial 4, created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz