tech exam 3
rate
amount of incrase/base
the percentage rate of increase is calculated by using its formula
amount of increase/base
3-D
an inmage that appears to have length, width, and height
when calculating the amount on increase, the ___ is the starting point for the data
base
value after increase
base * percent for new value
on a line chart the x-axis is also known as the
category
on a line chart, the x-axis is also known as the
category axis
what if analysis
chaning a value in one cell to see what affect it has on other cells
if you want to view the worksheet data separately from a chart, you can place a chart on a
chart
in excel, the ___ is made up of the chart and all of its elements
chart area
the ___ is made up of the entire chart and all of its elements
chart area
when a chart is selected, three buttons display to the right, the first of which is the ___ buttom
chart element
use the ___ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels
chart elements
a workbook sheet that contains only a chart is called a
chart sheet
chart sheet
contains only a chart
a line chart emphasizes the distinct values of each data point
false
a pie chart must have a legend
false
a relative cell reference refers to a cell by its fixed position in the worksheet
false
according to excel's order of operations, addtion and subtraction are done before exponentitaion
false
after a pie chart is created, it cannot be rotated
false
by default, the plot area and chart area are filled with different colors
false
deleting the contents of a cell also removes the format that has been applied to the cell
false
exploding a slice of a pie chart causes it to completely disappear from the chart
false
the goal seek command can be found on the DATA tab, in the Get External Data group
false
the order of operations used in excels says that consecutive operations with the same level of precedence are done from right to left
false
time is displayed along the y-axis on a line chart
false
to identify which slice of pie corresponds to which set of data points, look at the value axis
false
when writing a formula in ecel, use quotation marks to specify the order in which the operations should occur
false
you cannot explode all the pie slices in a pie chart
false
you cannot use a picture as the fill for the chart area of a line chart
false
a 3-D image appears to have length, width, and depth
true
a pie chart can only be based on one data series
true
a pie chart should be limited to no more than seven categories
true
absolute cell references are indicated by placing a dollar sign ($) in front of the row and column indicators
true
changing values in cells to see how those changes affect the values calculated by formulas in other
true
excel enables you to put the category names directly on the pie slice, eliminating the need for a legend
true
formula autocomplete displays the name of functions that begin with the letter or letters you have typed in after the equal sign
true
goal seek is an example of a what if analysis tool
true
if a value is changed in a cell, excel recalculates all formulas that reference that cell
true
the autofill feature will continue a series based on the values placed in two or more consecutive cells
true
the plot area and teh chart area are the two background elements of an excel chart
true
the sizes of pie slices are automatically adjusted when the underlying data values are changed
true
under paste options you have the choice to paste the calculated values instead of the formulas
true
you can select an element of a chart to format by using the chart elements button to the right of a selected chart
true
entering a value in one cell to see how formulas in other cells are affected is known as ___ analysis
what-if
the order in which the data series in pie charts are plotted in excel is determined by the order of the data on the
worksheet
category axis
x axis
on a line chart, the area that identifies the categories of data is called
x-axis
value axis
y axis
on a line chart, the range of numbers for the data points are displayed on the
y-axis
the distance between gridlines in the plot area is determined by the
major unit
enterprise fund
municipal government fund that reports income and expenditures for services
explode
pulls a pie slice or slices away from the other pie slices
the percentage by which one number increasees over another during a specified amount of time is called percentage
rate of increase
excel displays various ___ on the right to enable you to format different chart elements
panes
percentage rate of increase
percent by which one number increases over another number
is the percent by which one number increases over another during a specified time frame
percentage rate increase
a column or bar chart can have two or more data series, but a ___ chart can have only on data series
pie
shows the relationship of each part of the data to the whole
pie chart
which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes case
pie chart
the two background elements of an excel chart are
plot area and chart area
when you copy a formula that uses a ___ cell reference the reference changes when the formula is copied based on wehre it is placed in the worksheet
relative
a cell address used in a formula using a ___ will be adjusted appropriately when the formula is copied to another cell
relative cell reference
to gain a different view of a pie chart, you can ___ the chart within the 360 degrees of the circle
rotate
bevel
shape effect to make edge of a shape apear curved or angled
a ___ cell reference referes to a cell by its fixed position in the worksheet
absolute
refers to a cell by its fixed position in the worksheet
absolute cell reference
goal seek is an example of a __ tool
what if analysis tool
an image that appears to have length, width, and depth is
3-D
fund
a sum of money set aside for a specific purpose
data point
a value that appears in the spreadsheet and is represented on the chart
to rotate a pie chart, you change the ___ of the first slice
angle
a ___ is a line that borders the chart plot area and serves as a frame of references for measurement
axis
is a line that borders the chart plot area and serves as a frame of reference for measurement
axis
percent for new value
base percent + percent of increase
percent for new value is calculated using this formula
base percent + percent of increase
value after increase is calculated by using this formula ___
base*percent for new value
applying the shape effect __ causes the edges of the shape to appear to be curved or angled
bevel
the ___ shape effect uses shading and shadows to make th edges of shapes appear to be curved or angled
bevel
data is represented on a chart by a
data marker
each pie slice displayed on a pie chart is an example of a
data marker
a value that originates in a worksheet and is represented in a chart is called
data point
is a value that originates in a worksheet cell and is represented in a chart
data point
a set of related data points that are represented by data markers is called
data series
on a pie chart, the ___ determines the size of each pie slice
data series
base
data starting point
data series
determines the size of each pie slice
major unit
determines the spcing between the gridlines
line chart
displays a trend over time
data marker
each slice in a pie chart
excel allows you to ___ or pull away from the chart, on or more slices of a pie chart
explode
one or more slices on a pie chart means to pull the slices away form the rest of the chart
explode
goal seek
finds the input needed in one cell to arrive at the desired result in another cell
excel's ___ finds the input needed in one cell for another cell to have desired value
goal seek
excel's ___ tool finds the input needed in one cell to achieve the desired result in another
goal seek
identifies patterns and colors assigned to categories in the chart
legend
on a pie chart, the ___ indicates which pie slice is associated with which data series
legend
one way to determine which slice of pie on a pie chart goes with which set of data is to look at the
legend
if you want to chart trends over time, you should use a ___ chart
line
the best type of chart for dispalying data over time is
line
formula auto complete
list of functions that displays after typing =
order of operations
mathematical rules that indicate in what order calculations are done
pie chart
shows the relationship of each part to a whole
chart area
the chart and all of its elements
3-d
three dimensional
an image that appears to have length, width, and height is said to be 3-d or
three dimensional
why would you explode a slice on a pie chart
to emphasize the slice to the person viewing the chart
in a line chart, the curve and direction of the line make ___ obvious to the reader
trends
on a line chart, the y-axis is also known as the
value
the y axis is also known as
value axis
performing a ___ involves chaning the value in a cell to see what effect it has on values in other cells that are calulated using the value
what if analysis