Excel chap 3

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

true

A pie chart can only be based on one data series.

true

A pie chart must be limited to no more than seven categories.

false

A pie chart must have a legend.

absolute cell reference

A(n) ____ refers to a cell by its fixed position in the worksheet.

true

Absolute cell references are indicated by placing the dollar sign ($) in front of the row and column indicators.

Goal Seek

Excel's ____ finds the input needed in one cell for another cell to have a desired value.

category axis

On a line chart, the x-axis is also know as the:

legend

One way to determine which slice of pie on a pie chart goes with which set of data is to look at the:

base + percent of increase

Percent for new value is calculated using this formula:

what-if-analysis

Performing a ____ involves changing the value in a cell to see what effect it has on values in other cells that are calculated using that value.

plot area and chart area

The two background elements of an Excel chart are:

explode

To ____ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

rotate

To gain a different view of a pie chart, you can ____ the chart within the 360 degrees of the circle.

False

To identify which slice of pie corresponds to which set of data points, look at the value axis.

chart elements

Use the ____ button to add, remove, or change chart elements such as the chart title, the legend, and the data labels.

base * percent for new value

Value after increase is calculated by using this formula:

data point

A ____ is a value that originates in a worksheet cell and is represented in a chart.

pie chart

A ____ shows the relationship of each part of the data to the whole.

chart sheet

A workbook sheet that contains only a chart is called a(n):

axis

A(n) ____ is a line that borders the chart plot area and serves as a frame of reference for measurement.

bevel

Applying the shape effect ____ causes the edges of a shape to appear to be curved or angled.

data marker

Each pie slice displayed on a pie chart is an example of a:

panes

Excel displays various ____ on the right to enable you to format different chart elements.

what-if-analysis

Goal seek is an example of a ____ tool.

line

If you want to chart trends over time, you should use a ____ chart.

chart area

In Excel, the ____ is made up of the chart and all its elements.

x-axis

On a line chart, the area that identifies the categories of data is called the:

y-axis

On a line chart, the range of numbers for the data points are displayed on the:

chart elements

When a chart is selected, three buttons display to the right, the first of which is the ____ button.

base

When calculating the amount of increase, the ____ is the starting point for the data.

legend

The ____ identifies patterns and colors assigned to categories in the chart.

relative cell reference

A cell address used in a formula using a(n) ____ will be adjusted appropriately when the formula is copied to another cell.

false

A relative cell reference refers to a cell by its fixed position in the worksheet.

3-D

An image that appears to have length, width, and depth is said to be:

value axis

On a line chart, the y-axis is also known as the:

data series

On a pie chart, the ____ determines the size of each pie slice.

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 cast?

To emphasize the slice to the person viewing the chart

Why would you explode a slice on a pie chart?

percentage of rate increase

The ____ is the percent by which one number increases over another during a specified time frame.

amount of increase/base

The percentage rate of increase is calculated by using this formula:


Ensembles d'études connexes

Life Insurance Exam FM Washington State

View Set

Chapter 16 Lymphatic system quiz

View Set

Lección 1 | Contextos | Autoevaluacion

View Set

Time Management, Prioritization, Delegation (CH.6) Burnout (CH.13)

View Set

Are You Mastering Audience Engagement? A Fun Quiz to Find Out!

View Set

EMT - Prehospital Emergency Care: Part 6: Assessment: Chapter 13: Patient Assessment

View Set