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