Chpt. 3 (Comp)

¡Supera tus tareas y exámenes ahora con Quizwiz!

Consecutive operators with the same level of precedence are calculated from right to left

False

Only one piece of the pie can be exploded

False

The chart area is the background and surrounding border of a chart

False

Use the F1 key to cancel a moving border after you have copied and pasted

False

When you select the data range for a pie chart, you should be sure to include the total cell on a worksheet

False

To what extent can a pie chart be rotated

Up to 360 degrees

_______ is a group of related data points represented by data markers

a data series

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

absolute cell reference

A chart and all of its elements is known as the _______

chart area

A __________ in a pie chart identifies the pie slices

data label

You must select ________ on a worksheet to create a pie chart

Two ranges

Which symbol represents that a cell is an absolute cell reference in a function or formula

$

If B4 contains the formula =$F$5 and you copy and paste B4 into D8, what will the formula be in D8?

$F$5

If you edit data in a worksheet that is associated with a pie chart _________

the pie slices will be automatically updated

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as _____

what-if analysis

AutoFill will fill a series when you establish a pattern _________.

with two or more cells

A chart sheet contains only a chart and the data used to generate that chart

False

A data marker is a value that originates in a worksheet cell and that is represented in a chart

False

A location chart compares values and shows categories across geographical regions

False

All Excel charts have a minimum of three background elements

False

Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be straight or diagonal

False

A Major unit value in a line chart determines the range of numbers in the value axis

False

Which of the following displays trends over time

A line chart

Use the ______ key to select A5:A8 and D5:D8

Ctrl

Which of the following is the second order of operation

Exponentiation

Which of the following is the first order of operation

Expressions within parantheses

__________ is an Excel tool that find the input needed to arrive at a desired result

Goal Seek

Which of the following is not one of the three spatial dimensions of #-D?

Height

How can you identify the Chart Elements button when you select a chart

It is a green plus sign

When you print a chart sheet, how is it automatically formatted

It is centered on the page

Which of the following is true about a pie chart

It shows the relationship of each part to the whole

Where is the Format Painter button located

On the mini toolbar and the Home tab

In Goal Seek, the __________ box contains the formula that calculates the information you seek

Set cell

In a line chart, which of the following resides along the bottom of the chart

The x-axis

Which of the following resides along the left side of a column chart

The y-axis

3-D is short for three-dimensional

True

A funnel chart is named that way because the values decrease gradually, allowing the bars to resemble a funnel

True

A graphic image can be inserted into the background of a chart

True

A legend is a chart element that identifies the patterns or colors assigned to each category of a chart

True

A pie chart should be considered when you have just one data series to plot

True

Every Excel formula starts with an equal sign (=)

True

Formula AutoComplete displays a list of function names that match the letter or two that you type

True

Funnel charts show values across the stages in a process

True

Goal Seek is a what-if analysis tool

True

If you change the value in a cell referenced in a formula, the result of the formula will automatically recalculate

True

In Excel, you should use parentheses in order to specify the order in which operations needs to occur

True

In a map chart, each region displays shading to indicate the values in the data series

True

Numbers that display with E + a number are an exponential notation

True

Rate = amount of increase/base is the mathematical formula to calculate a rate of increase

True

Rotating the chart can provide a better perspective to the chart

True

The Chart Elements button allows you to add, remove, or change chart elements

True

The base is considered the starting point

True

The plot area of a chart is bounded by the axes, including all the data series

True

The y-axis of a chart is also referred to as the value axis

True

Value after increase = base x percent for new value is the formula for calculating the value after an increase by multiplying the original value by the percent for a new value

True

When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references

True

You can edit the data or label in a cell by double-clicking the cell and then positioning the insertion point within the cell

True


Conjuntos de estudio relacionados

Lesson 6.4: Competition in the Long Run

View Set

ExamFX Guaranteed Exam Missed/Wrong Answers part 3

View Set

Chapter 13: The Rise of Mass Democracy

View Set

"A Sound of Thunder" Bradbury Vocabulary

View Set

lesson 1: The importance and impact of ethics

View Set

RN Pharmacology Online Practice 2016 B

View Set

Chapter 8 Body Organization and Structure

View Set