Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
The percentage rate of increase is calculated by using this formula: ________.
1)
A)
base/amount of increase
B)
base * amount of increase
C)
amount of increase * base percent
D)
amount of increase/base
Answer:
D
Explanation:
A)
B)
C)
D)
2)
An image that appears to have length, width, and depth is said to be
2)
A)
charted.
B)
3-D.
C)
exploded.
D)
beveled.
Answer:
B
Explanation:
A)
B)
C)
D)
3)
A(n) ________ refers to a cell by its fixed position in the worksheet.
3)
A)
general cell reference
B)
base cell reference
C)
absolute cell reference
D)
relative cell reference
Answer:
C
Explanation:
A)
B)
C)
D)
4)
Value after increase is calculated by using this formula: ________.
4)
A)
base * percent for new value
B)
base / percent for new value
C)
base percent * percent of increase
D)
base percent + percent of increase
Answer:
A
Explanation:
A)
B)
C)
D)
5)
Each pie slice displayed on a pie chart is an example of a
5)
A)
data marker.
B)
legend.
C)
data point.
D)
chart sheet.
Answer:
A
Explanation:
A)
B)
C)
D)
1
6)
A movable, resizable container where text or graphics can be placed is called a
6)
A)
plot area.
B)
text box.
C)
bevel.
D)
chart area.
Answer:
B
Explanation:
A)
B)
C)
D)
7)
Goal Seek is an example of a ________ tool.
7)
A)
what-if analysis
B)
function
C)
plotting
D)
charting
Answer:
A
Explanation:
A)
B)
C)
D)
8)
Changing a value in a cell to see what effect it has on values in other cells that are calculated using
the value is said to be doing a
8)
A)
what-if analysis.
B)
data point analysis.
C)
3-D analysis.
D)
why analysis.
Answer:
A
Explanation:
A)
B)
C)
D)
9)
Applying the shape effect ________ causes the edges of a shape to appear to be curved or angled.
9)
A)
bevel
B)
basing
C)
ticking
D)
explosion
Answer:
A
Explanation:
A)
B)
C)
D)
10)
________ are short lines that appear on an axis at regular intervals.
10)
A)
Tick marks
B)
Data markers
C)
Degends
D)
Data points
Answer:
A
Explanation:
A)
B)
C)
D)
2
11)
Why would you explode a slice on a pie chart?
11)
A)
To change the color of the slice.
B)
To increase the size of the slice.
C)
To remove it completely from the chart.
D)
To emphasize the slice to the person viewing the chart.
Answer:
D
Explanation:
A)
B)
C)
D)
12)
On a line chart, the x-axis is also known as the
12)
A)
legend axis.
B)
category axis.
C)
base axis.
D)
value axis.
Answer:
B
Explanation:
A)
B)
C)
D)
13)
The ________ identifies patterns and colors assigned to categories in the chart.
13)
A)
data point
B)
legend
C)
chart sheet
D)
data series
Answer:
B
Explanation:
A)
B)
C)
D)
14)
On a line chart, the area that identifies the categories of data is called the
14)
A)
x-axis.
B)
y-axis.
C)
bevel axis.
D)
value axis.
Answer:
A
Explanation:
A)
B)
C)
D)
15)
When calculating the amount of increase, the ________ is the starting point for the data.
15)
A)
goal
B)
rate
C)
base
D)
axis
Answer:
C
Explanation:
A)
B)
C)
D)
16)
A workbook sheet that contains only a chart is called a(n)
16)
A)
legend.
B)
data marker.
C)
chart sheet.
D)
axis.
Answer:
C
Explanation:
A)
B)
C)
D)
3
17)
One way to tell which slice of pie on a pie chart goes with which set of data is to look at the
17)
A)
category axis.
B)
base.
C)
value axis.
D)
legend.
Answer:
D
Explanation:
A)
B)
C)
D)
18)
On a line chart, the range of numbers for the data points are displayed on the
18)
A)
x-axis.
B)
category axis.
C)
bevel axis.
D)
y-axis.
Answer:
D
Explanation:
A)
B)
C)
D)
19)
Excel's ________ finds the input needed in one cell for another cell to have a desired value.
19)
A)
order of operations
B)
Goal Seek
C)
chart area
D)
plot area
Answer:
B
Explanation:
A)
B)
C)
D)
20)
On a line chart, the y-axis is also known as the
20)
A)
legend axis.
B)
value axis.
C)
base axis.
D)
category axis.
Answer:
B
Explanation:
A)
B)
C)
D)
21)
Percent for new value is calculated using this formula: ________.
21)
A)
base * percent for new value
B)
base percent * percent of increase
C)
base / percent for new value
D)
base percent + percent of increase
Answer:
D
Explanation:
A)
B)
C)
D)
22)
A(n) ________ is a line that borders the chart plot area and serves as a frame of reference for
measurement.
22)
A)
base
B)
data marker
C)
legend
D)
axis
Answer:
D
Explanation:
A)
B)
C)
D)
4
23)
A cell address used in a formula using a(n) ________ will be adjusted appropriately when the
formula is copied to another cell.
23)
A)
relative cell reference
B)
base cell reference
C)
general cell reference
D)
absolute cell reference
Answer:
A
Explanation:
A)
B)
C)
D)
24)
The spacing between tick marks is determined by the ________.
24)
A)
base value
B)
rate of increase
C)
Major unit value
D)
data marker
Answer:
C
Explanation:
A)
B)
C)
D)
25)
To ________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the
chart.
25)
A)
explode
B)
bevel
C)
tick
D)
base
Answer:
A
Explanation:
A)
B)
C)
D)
26)
On a pie chart, the ________ determines the size of each pie slice.
26)
A)
data marker
B)
legend
C)
chart sheet
D)
data series
Answer:
D
Explanation:
A)
B)
C)
D)
27)
A ________ is a value that originates in a worksheet cell and is represented in a chart.
27)
A)
legend
B)
data point
C)
chart sheet
D)
data marker
Answer:
B
Explanation:
A)
B)
C)
D)
5
28)
Which type of chart would be the best to chart the number of votes each candidate received
compared to the total number of votes cast?
28)
A)
line chart
B)
column chart
C)
bar chart
D)
pie chart
Answer:
D
Explanation:
A)
B)
C)
D)
29)
A gallery of text styles that can be used to apply decorative effects to text is
29)
A)
WordArt.
B)
TextArt.
C)
3-D Art.
D)
ItemArt.
Answer:
A
Explanation:
A)
B)
C)
D)
30)
A ________ shows the relationship of each part of the data to the whole.
30)
A)
line chart
B)
bar chart
C)
column chart
D)
pie chart
Answer:
D
Explanation:
A)
B)
C)
D)
31)
Excel's ________ allows you to select a chart element so that you can format it.
31)
A)
Chart Elements box
B)
Chart Terms box
C)
Chart Items box
D)
Chart Sheet box
Answer:
A
Explanation:
A)
B)
C)
D)
32)
If you want to chart trends over time, you should use a ________ chart.
32)
A)
line
B)
scatter
C)
pie
D)
bar
Answer:
A
Explanation:
A)
B)
C)
D)
33)
In Excel, the ________ is made up of the chart and all of its elements.
33)
A)
data marker
B)
plot area
C)
data point
D)
chart area
Answer:
D
Explanation:
A)
B)
C)
D)
6
