Excel Chapter 3&6
What-if analysis
Goal Seek is a ____tool in Excel
trendline
Graphically represents trends in plotted data and predicts future values
the pie slices will be automatically updated
If you edit data in a worksheet that is associated with a pie chart
Set Cell
In the Goal Seek dialog box, the ________ box must contain a formula.
TRUE about a Pie Chart
It shoes the relationship of each part to a whole
Chart Elements
Objects that make up a chart.
reporting relationships
Organization Chart depicts ______ in an organization
process
SmartArt Graphic best for timeline
solid line
To delete a box from a SmartArt organization chart, you must display a ________ border.
empty cell
When selecting the range for a line chart, you may need to include a(n) ________ to have the same number of cells in each row.
totals OR details
When you create a chart, you must first decide if you are going to plot values representing:
workbook
When you open a template from the New tab in the BackStage view, it opens as a _____
mini toolbar and home tab
Where is the format painter located?
read-only
You can view the data in the report, but you cannot change it
chart sheet
a chart and all its elements
Pie Chart
a chart that shows the relationship of a part to a whole
Templates
basis for other similar workbooks
A line chart
displays trends over time
Data Series
group of related data points represented by data markers
Data Marker
identifies the pie slices
Green Plus Sign
identify the Chart Elements button
To value
in goal seek, you enter the specific value you want to achieve in the _______ box
Labels
Column and row headings that describe the values and help the reader understand the chart.
Veritcal
Column charts present data graphically in ___columns
Ctrl
key to select A5:A8 and D5:D8
two ranges
must select on a worksheet to create a pie chart
Exploded
one or more pieces of a chart can be _____ or pulled out
360 degree
pie chart be rotated?
What-if analysis
process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
Recommended Charts
quickly analyzes a selection in a worksheet and recommends chart types based on patterns in your data
absolute cell reference
refers to a cell by its fixed position in the worksheet
x-axis
resides along the bottom of a chart
y-axis
resides along the left side of a column chart
Scale
the range of numbers in the data series. controls the min. max. values
$
the symbol used to indicate an absolute cell reference
Depth, Width, Height
three spatial dimensions of 3-D
Line
to display trends over time use a ____chart
Column Chart
to make comparisons among related data use ?
Shift: drag corner handle
to size a chart proportionately, hold down the ___key and ___
Goal Seek
tool that finds the input needed to arrive at a desired result
Standardization
uniform appearance and have the data organized in the same manner
placeholders
where you can type text into a SmartArt Graphic
absolute cell reference
A reference that does not change when the formula is copied or moved to a new location.
embedded
A chart is _____ when it is drawn on the same worksheet as the data.
Chart
A graphical representation of data
Series
A group of related data plotted in a chart
Chart Sheet
A separate sheet in a workbook that stores a chart.
Bevel
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
Chart Sheet
A sheet that contains only a chart.
Data Point
A value that originates in a worksheet cell and that is represented in a chart by a data marker
SmartArt graphic
A visual representation of information.
two or more cells
Auto fill will fill a series when you establish a pattern of?
standardization and protection
Templates are commonly used to provide ________ of data.
left
Text Pane displays to the ____ of the SmartArt diagram
Plot area
The area bounded by axes in a chart.
Chart Area
The entire chart and all its elements.
Legend
The key to a chart that explains what each data series represents.
Sparklines
Tiny charts that fit in a cell, used to visually summarize trends alongside data.
Add Shape Below
To add a shape to a lower level of an organization chart, click Add Shape, and then click: