Chapter 3 ITE 140

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

A pie chart much have a legend.

False

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

False

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

False

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

amount of increase/base.

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

base

Value after increase is calculated by using this formula:

base * percent for new value

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

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

category axis

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

chart area

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

chart elements

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

chart elements

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

chart sheet.

Goal Seek is an example of a ____ tool.

what-if analysis

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

x-axis

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

y-axis

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

panes

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

percentage rate of increase

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

pie chart

The two background elements of an excel chart are:

plot are and chart area

A cell address used in a formula using a(n) ________ 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

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

absolute cell reference

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

3-d

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

axis

Percent for new value is calculated using the formula:

base percent + percent of increase

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

bevel

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

data marker

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

data point

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

data series

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

explode

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

goal seek

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

legend

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

legend

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

line

Why would you explode a slice on a pie chart?

to emphasize the slice to the person viewing the chart

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

value axis

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.

what if analysis


Set pelajaran terkait

Finance 342 Chapter 8 Concept Questions

View Set

Physical Science Exam #2 (1D & 2D Kinematics)

View Set

Social Psychology: Chapter 6- Attitudes

View Set

MS 2 - Exam 3 Practice Questions: End of Neuro, Urinary, Renal

View Set

Chapter 1, 2: Agency relationships & issues Questions

View Set