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: