This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
Explanation:
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
Explanation:
36)
A movable, resizable container for text or graphics is called a(n) ________.
36)
Answer:
text box
Explanation:
37)
On a line chart, the x-axis is also known as the ________ axis.
37)
Answer:
category
Explanation:
38)
Excel allows you to ________ or pull away from the chart one or more slices of a pie chart.
38)
Answer:
explode
Explanation:
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
Explanation:
40)
The ________ is made up of the entire chart and all of its elements.
40)
Answer:
chart area
Explanation:
41)
The y-axis on a chart is also known as the ________ axis.
41)
Answer:
value
Explanation:
42)
The distance between gridlines in the plot area is determined by the ________ value.
42)
Answer:
Major unit
Explanation:
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
Explanation:
44)
Short lines that appear on an axis at regular intervals are called ________.
44)
Answer:
tick marks
Explanation:
45)
Excel's ________ tool finds the input needed in one cell to achieve the desired result in
another cell.
45)
Answer:
Goal Seek
Explanation:
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
Explanation:
47)
Related data points that are represented by data markers are called a(n) ________.
47)
Answer:
data series
Explanation:
48)
The best type of chart for displaying data over time is the ________ chart.
48)
Answer:
line
Explanation:
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
Explanation:
50)
Excel provides a gallery of text styles known as ________ that can be used to create
decorative effects on text.
50)
Answer:
WordArt
Explanation:
51)
Data is represented on a chart by a(n) ________.
51)
Answer:
data marker
Explanation:
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
Explanation:
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
Explanation:
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
Explanation:
55)
An image that appears to have length, width, and height is said to be 3-D or ________.
55)
Answer:
three-dimensional
Explanation:
56)
A(n) ________ is a line that borders the chart plot area and serves as a frame of reference
for measurement.
56)
Answer:
axis
Explanation:
57)
The ________ shape effect uses shading and shadows to make the edges of shapes appear
to be curved or angled.
57)
Answer:
bevel
Explanation:
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
Explanation:
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
Explanation:
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
Explanation:
61)
On a pie chart, the ________ indicates which pie slice is associated with which data series.
61)
Answer:
legend
Explanation:
62)
A(n) ________ cell reference refers to a cell by its fixed position in the worksheet.
62)
Answer:
absolute
Explanation:
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
Explanation:
64)
A pie chart should be limited to no more than seven categories.
64)
Answer:
True
False
Explanation:
65)
You can select an element of a chart to format by using the Chart Elements box.
65)
Answer:
True
False
Explanation:
66)
If a value is changed in a cell, Excel recalculates all formulas that reference that cell.
66)
Answer:
True
False
Explanation:
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
Explanation:
68)
The plot area and the chart area are the two background elements of an Excel chart.
68)
Answer:
True
False
Explanation:
69)
Time is displayed along the y-axis on a line chart.
69)
Answer:
True
False
Explanation:
10
70)
Page Layout view is available for chart sheets.
70)
Answer:
True
False
Explanation:
71)
A pie chart can only be based on one data series.
71)
Answer:
True
False
Explanation:
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
Explanation:
73)
The AutoFill feature will continue a series based on the values placed in two or more consecutive
cells.
73)
Answer:
True
False
Explanation:
74)
The sizes of pie slices are automatically adjusted when the underlying data values are changed.
74)
Answer:
True
False
Explanation:
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
Explanation:
76)
A pie chart must have a legend.
76)
Answer:
True
False
Explanation:
77)
A dotted border around an object indicates that the entire object is selected.
77)
Answer:
True
False
Explanation:
78)
Graphics cannot be placed in a text box.
78)
Answer:
True
False
Explanation:
79)
Once a pie chart is created, it cannot be rotated.
79)
Answer:
True
False
Explanation:
80)
Deleting the contents of a cell also removes the format that has been applied to the cell.
80)
Answer:
True
False
Explanation:
81)
Under Paste Options you have the choice to paste the calculated values instead of the formulas.
81)
Answer:
True
False
Explanation:
11
82)
A relative cell reference refers to a cell by its fixed position in the worksheet.
82)
Answer:
True
False
Explanation:
83)
According to Excel's order of operations, addition and subtraction are done before exponentiation.
83)
Answer:
True
False
Explanation:
84)
To identify which slice of pie corresponds to which set of data points, you look at the value axis.
84)
Answer:
True
False
Explanation:
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
Explanation:
86)
Excel allows you to put the category names directly on the pie slices, eliminating the need for a
legend.
86)
Answer:
True
False
Explanation:
87)
Absolute cell references are indicated by placing a $ in front of the row and column indicators.
87)
Answer:
True
False
Explanation:
88)
By default, the plot area and the chart area are filled with different colors.
88)
Answer:
True
False
Explanation:
89)
A line chart emphasizes the distinct values of each data point.
89)
Answer:
True
False
Explanation:
90)
Goal Seek is an example of a what-if analysis tool.
90)
Answer:
True
False
Explanation:
91)
A 3-D image appears to have length, width, and depth.
91)
Answer:
True
False
Explanation:
12
Trusted by Thousands of
Students
Here are what students say about us.
Resources
Company
Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.