34)
The ________ is the percent by which one number increases over another during a specified time
frame.
34)
A)
percentage rate of decrease
B)
percentage rate of increase
C)
percent for new value
D)
base
Answer:
B
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
35)
A value that originates in a worksheet and is represented in a chart is called a(n) ________.
35)
Answer:
data point
36)
A movable, resizable container for text or graphics is called a(n) ________.
36)
Answer:
text box
37)
On a line chart, the x–axis is also known as the ________ axis.
37)
Answer:
category
38)
Excel allows you to ________ or pull away from the chart one or more slices of a pie chart.
38)
Answer:
explode
39)
Match the following terms to their meanings:
I. Pie chart A. displays trends over time
II. Line chart B. y–axis on a line chart
III. Category axis C. short lines that display at regular intervals
IV. Value axis D. x–axis on a line chart
V. Tick marks E. shows the relationship of each part to a whole
39)
Answer:
E, A, D, B, C
40)
The ________ is made up of the entire chart and all of its elements.
40)
Answer:
chart area
41)
The y–axis on a chart is also known as the ________ axis.
41)
Answer:
value
42)
The distance between gridlines in the plot area is determined by the ________ value.
42)
Answer:
Major unit
7
43)
Entering a value in one cell to see how formulas in other cells are affected is known as
________ analysis.
43)
Answer:
what–if
44)
Short lines that appear on an axis at regular intervals are called ________.
44)
Answer:
tick marks
45)
Excel’s ________ tool finds the input needed in one cell to achieve the desired result in
another cell.
45)
Answer:
Goal Seek
46)
If you want to view the worksheet data separately from a chart, you can place the chart on
a(n) ________ sheet.
46)
Answer:
chart
47)
Related data points that are represented by data markers are called a(n) ________.
47)
Answer:
data series
48)
The best type of chart for displaying data over time is the ________ chart.
48)
Answer:
line
49)
Match the following terms to their meanings:
I. Format as you type A. displays a list of functions that begin with the entered
letter or letters
II. Formula AutoComplete B. mathematical rules that indicate in what order
calculations are done
III. Order of operations C. determines the spacing between tick marks
IV. What–if analysis D. changing a value in one cell to see what affect it
has on other cells
V. Major unit E. typing a formatting symbol such as % causes the
cell to be displayed using that format
49)
Answer:
E, A, B, D, C
50)
Excel provides a gallery of text styles known as ________ that can be used to create
decorative effects on text.
50)
Answer:
WordArt
51)
Data is represented on a chart by a(n) ________.
51)
Answer:
data marker
8
52)
A column or bar chart can have two or more data series, but a(n) ________ chart can have
only one data series.
52)
Answer:
pie
53)
Match the following terms to their meanings:
I. Value after increase A. base percent + percent of increase
II. Percent for new value B. base * percent for new value
III. Percentage rate of increase C. data starting point
IV. Rate D. percent by which one number increases over
another number
V. Base E. amount of increase/base
53)
Answer:
B, A, D, E, C
54)
Match the following terms to their meanings:
I. 3–DA. a gallery of text styles
II. Explode B. movable, resizable container for text or graphics
III. Text box C. pull a pie slice or slices away from the other pie slices
IV. WordArt D. an image that appears to have length, width, and height
V. Legend E. identifies colors and patterns assigned to the categories of
a chart
54)
Answer:
D, C, B, A, E
55)
An image that appears to have length, width, and height is said to be 3–D or ________.
55)
Answer:
three–dimensional
56)
A(n) ________ is a line that borders the chart plot area and serves as a frame of reference
for measurement.
56)
Answer:
axis
57)
The ________ shape effect uses shading and shadows to make the edges of shapes appear
to be curved or angled.
57)
Answer:
bevel
58)
The percentage by which one number increases over another during a specified amount of
time is called the percentage ________.
58)
Answer:
rate of increase
59)
When you copy a formula that uses a(n) ________ cell reference, the reference changes
when the formula is copied based on where in the worksheet it is placed.
59)
Answer:
relative
9
60)
Match the following terms to their meanings:
I. Data marker A. determine the size of each pie slice
II. Data point B. contains only a chart
III. Data series C. each slice in a pie chart
IV. Chart sheet D. the chart and all of its elements
V. Chart area E. a value that appears in the spreadsheet and is represented
on the chart
60)
Answer:
C, E, A, B, D
61)
On a pie chart, the ________ indicates which pie slice is associated with which data series.
61)
Answer:
legend
62)
A(n) ________ cell reference refers to a cell by its fixed position in the worksheet.
62)
Answer:
absolute
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
63)
Exploding a slice of a pie chart causes it to completely disappear from the chart.
63)
Answer:
True
False
64)
A pie chart should be limited to no more than seven categories.
64)
Answer:
True
False
65)
You can select an element of a chart to format by using the Chart Elements box.
65)
Answer:
True
False
66)
If a value is changed in a cell, Excel recalculates all formulas that reference that cell.
66)
Answer:
True
False
67)
Formula AutoComplete displays the names of functions that begin with the letter or letters you
have typed in after the =.
67)
Answer:
True
False
68)
The plot area and the chart area are the two background elements of an Excel chart.
68)
Answer:
True
False
69)
Time is displayed along the y–axis on a line chart.
69)
Answer:
True
False
10
70)
Page Layout view is available for chart sheets.
70)
Answer:
True
False
71)
A pie chart can only be based on one data series.
71)
Answer:
True
False
72)
Changing values in cells to see how those changes affect the values calculated by formulas in other
cells is called doing what–if analysis.
72)
Answer:
True
False
73)
The AutoFill feature will continue a series based on the values placed in two or more consecutive
cells.
73)
Answer:
True
False
74)
The sizes of pie slices are automatically adjusted when the underlying data values are changed.
74)
Answer:
True
False
75)
The order of operations used in Excel says that consecutive operators with the same level of
precedence are done from right to left.
75)
Answer:
True
False
76)
A pie chart must have a legend.
76)
Answer:
True
False
77)
A dotted border around an object indicates that the entire object is selected.
77)
Answer:
True
False
78)
Graphics cannot be placed in a text box.
78)
Answer:
True
False
79)
Once a pie chart is created, it cannot be rotated.
79)
Answer:
True
False
80)
Deleting the contents of a cell also removes the format that has been applied to the cell.
80)
Answer:
True
False
81)
Under Paste Options you have the choice to paste the calculated values instead of the formulas.
81)
Answer:
True
False
11
82)
A relative cell reference refers to a cell by its fixed position in the worksheet.
82)
Answer:
True
False
83)
According to Excel’s order of operations, addition and subtraction are done before exponentiation.
83)
Answer:
True
False
84)
To identify which slice of pie corresponds to which set of data points, you look at the value axis.
84)
Answer:
True
False
85)
Excel’s Number format leaves a space at the right of the number for a closing parenthesis in case
the value is negative.
85)
Answer:
True
False
86)
Excel allows you to put the category names directly on the pie slices, eliminating the need for a
legend.
86)
Answer:
True
False
87)
Absolute cell references are indicated by placing a $ in front of the row and column indicators.
87)
Answer:
True
False
88)
By default, the plot area and the chart area are filled with different colors.
88)
Answer:
True
False
89)
A line chart emphasizes the distinct values of each data point.
89)
Answer:
True
False
90)
Goal Seek is an example of a what–if analysis tool.
90)
Answer:
True
False
91)
A 3–D image appears to have length, width, and depth.
91)
Answer:
True
False
12